last updated Jan 17, 2023

Repo for storage of PostgreSQL sql scripts, data exports and related works for testing and development for the OpenDRR PostgreSQL database. Scripts in this repo are run and tested on a local desktop/host and modified accordingly in order to support model_factory repo for successful implementation in a docker instance.

Temporary location of spreadsheets and csv files to support development of various indicators.

PostgreSQL scripts, data export scripts for local development and testing.

Bat scripts for exporting, zipping various PostgreSQL tables to GeoPackage format using GDAL OGR2OGR.

https://gdal.org/

https://gdal.org/programs/ogr2ogr.html

https://www.7-zip.org/

ER Diagram of OpenDRR database in draw.io format. Diagrams are still a work in progress and not completed yet.

https://www.diagrams.net/

Scripts for testing, development, and generating various indicators.

• 1.0 Human Settlement
  • 1.1 Physical Exposure
  • 1.2 Multi-Hazard Risk
  • 1.3 Social Fabric
  • 1.4 Risk Dynamics
• 2.0 Seismic Risk (PSRA)
• 3.0 Earthquake Scenario Risk (DSRA)
• 4.0 Multi-Hazard Risk

Scripts for testing, development, loading and transforming the source data tables to generating the indicators.

• Boundaries
• Census
• DSRA
• Exposure
• GHSL
• LUT
• MH
• PSRA
• SoVi