search

OpenDRR / boundaries

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

Geometry_CDUID.gpkg column rename, fix geometry on all layers #9

Closed wkhchow closed 3 years ago

wkhchow commented 3 years ago

Noticed as I am working through DSRA master aggregation to different level of geometries the columns for CDUID for some reason has the prefix 'FIRST_'. ie (FIRST_CDUID, FIRST_CDNAME, FIRST_CDTYPE, etc). It should conform to the rest of the other boundaries and the columns will have to be renamed.

Run fix geometry in qgis on the geopackages to fix any possible issues. Check all geopackage CRS and reproject to 4326 if needed. Right now it is a mix of 3587/4326 but gets reprojected in ogr2ogr before input into postgressql. Fixing all these issues at source instead of reprojecting crs and fixing issues in postresql will save build time.

wkhchow commented 3 years ago

Fixed and db compacted.

wkhchow commented 3 years ago

edits in new branch update_CDUID. Need to update opendrr-boundaries.sql before PR to master.