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

  1. Change the connection information in lines 10 - 13.
  2. Update lines 15 and/or 16, referencing the name of the layer to load.
    1. If only loading one layer, comment out line 16 using :: 
    2. If more than two layers to load, copy and paste line 16 to add another layer
  3. 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.