bcgov / designatedlands

Python script to combine conservation related spatial data from many sources to create a single 'Designated Lands' layer for British Columbia
Apache License 2.0
9 stars 4 forks source link

complex polygons can be lost in overlay #85

Closed smnorris closed 2 years ago

smnorris commented 2 years ago

https://github.com/bcgov/designatedlands/blob/master/sql/create_designations_planarized.sql#L22

Current query just extracts the exterior ring when planarizing the features. This means complex features will be lost. As per blog post here, dump the rings first https://blog.cleverelephant.ca/2019/07/postgis-overlays.html