Source: https://bitbucket.org/natureserve/biotics/src/dev-postgres/Util/bat/loadSpatialCalcLayer.bat
:: This script loads spatial calculation layers from a file geodatabase into a
:: Postgres database using ogr2ogr. Layers are loaded into tables in the ext
:: schema that share the same name as the layer. Tables are created if they
:: don't already exist and are truncated and reloaded if they already exist.
:: The table's geometry column will always be named 'shape'.
Prerequisite: Your command shell set up to run gdal command line tools.
To load a new Spatial Attribute Layer in Biotics 6, use the attached script
- Change the connection information in lines 10 - 13.
- Update lines 15 and/or 16, referencing the name of the layer to load.
- If only loading one layer, comment out line 16 using ::
- If more than two layers to load, copy and paste line 16 to add another layer
- See comments starting at line 32 for instructions on how to deal with custom projections. NOTE: Custom projection files for Illinois (910001.prj) and Pennsylvania (910002.prj) are attached.