search

OpenDRR / opendrr-data-store

Repo for storing PostGIS/PostgreSQL database creation, query scripts and related works.
MIT License
2 stars 2 forks source link

Verify geometry in PostGIS. #20

Closed jvanulde closed 4 years ago

jvanulde commented 4 years ago

Please validate the geometry in PostGIS is valid, comparing with raw geometry (from StatsCan???).

jvanulde commented 4 years ago

As @wkhchow suggested, the following script needs to be run against the database:

UPDATE boundaries."Geometry SAUID" SET geom = ST_MakeValid(geom);