search

OpenDRR / boundaries

Boundary geometries for model results in Geopackage format.
Other
0 stars 5 forks source link

Generate opendrr-boundaries.dump (was opendrr-boundaries.sql) on PR #10

Closed jvanulde closed 3 years ago

jvanulde commented 3 years ago

When a PR is merged into this repo we need to generate the opendrr-boundaries.sql script. This script will be loaded into the stack on build eventually. So, on merge we spin up virtual machine, load the data, process the data, and export the .sql file.

jvanulde commented 3 years ago

Last update wasn't via PR, but rather a commit. Can we initiate an Action on commit as well as PR?

wkhchow commented 3 years ago

@jvanulde I just noticed the - opendrr-boundaries.sql. Let me uncommit and branch/pr.

wkhchow commented 3 years ago

Reverted the commits in master and created new branch update_CDUID. Will need to update opendrr-boundaries.sql in current branch.

https://github.com/OpenDRR/boundaries/issues/9

anthonyfok commented 3 years ago

Hi @wkhchow and @jvanulde, When you have time, could you please share with me the steps to generate opendrr-boundaries.sql? Is it from the "Importing Census Boundaries" step in add_data.sh , i.e. where the GeoPackage data are imported via ogr2ogr to PostgreSQL, and opendrr-boundaries.sql being the the PostgreSQL dump of that data? If this task is relatively urgent, I can try having a go at it tonight.

wkhchow commented 3 years ago

@anthonyfok not urgent. I can connect with you tomorrow on how I did it f needed. I already generated the sql this time around via PGAdmin.

anthonyfok commented 3 years ago

Thanks @wkhchow! No worries, Joost told me more details, and it turns out to be the same process found in opendrr-api/python/add_data.sh.