search

bcgov / harvest-restrictions

Extract data from provincial inventories to quantify how much of British Columbia's provincially administered forested land is under some type of forest harvest management regime
Apache License 2.0
0 stars 0 forks source link

add overlay script #3

Open smnorris opened 1 month ago

smnorris commented 1 month ago

Existing general postgis overlay sql can be from pulled designatedlands, but given the minimal data volume for this job, it may not require tiling or even use of postgis.

Investigate whether the overlay can be done by:

smnorris commented 3 weeks ago

@franTarkenton Any thoughts on how valuable a working geopandas example of this would be? The existing postgis method should work fine. duckdb would be really interesting and should work now using the same sql as the postgis method - but I'm thinking I'd prefer to hold off on playing with that a bit longer - waiting until full geoparquet support has landed. I think primary advantage of a geopandas method would be for easier local development setup (no postgres or docker install required) But maybe there are others?