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

remove pgdata dependency #73

Open smnorris opened 3 years ago

smnorris commented 3 years ago

I would like to retire this package. Much of the db interaction can now be done with psycopy2 built in methods. Not a priority at the moment though.

smnorris commented 2 years ago

Note that loading complex data can bail due to https://github.com/smnorris/pgdata/issues/21. Easy fix but I'd prefer to retire the package. If data load fails due to presence of multisurface records, manually run the ogr2ogr command, something like this:

    ogr2ogr \
        -f PostgreSQL \
        PG:"host=localhost port=5433 user=postgres dbname=designatedlands password=postgres" \
        -lco OVERWRITE=YES \
        -overwrite \
        -lco SCHEMA=public \
        -nlt PROMOTE_TO_MULTI \
        -nlt CONVERT_TO_LINEAR \
        -nln cef_human_disturbance \
        -sql "SELECT * FROM BC_CEF_Human_Disturb_BTM_2021_merge WHERE CEF_DISTURB_GROUP_RANK IN (1,2,3,4,5,6,7,8,9,10)" \
        source_data/BC_CEF_Human_Disturbance_2021.gdb