fgdb2postgis 0.1.6

Installation

This package should be installed only on windows systems because of ArcGIS (Arcpy) limitation.

Install required packages:

pip install numpy>=1.12.0
pip install psycopg2>=2.6.2
pip install pyyaml>=3.12
pip install archook==1.1.0

Install fgdb2postgis:

pip install fgdb2postgis

Note:

It does not automatically install GDAL/OGR libraries or ESRI ArcGIS in your system. You can install GDAL/OGR from OSGeo4W or use the installation of QGIS

Usage

Create a yaml file mapping the file geodatabase’s feature datasets, feature classes and tables to postgresql’s schemas. It is required that the yaml file have the same name with the file geodatabase with the extension .yaml

Example:

filegdb: sample.gdb
   yaml: sample.gdb.yaml

Note:

The Yaml file should be located in the same folder with the file geodatabase.

Yaml file example:

Schemas:
  - Administrative
  - Epidemiology
  - Radioactivity
  - Seismic
FeatureDatasets:
  Epidemiology:
    - Epidemiology
  Radioactivity:
    - Radioactivity
  Seismic:
    - Seismic
FeatureClasses:
  Administrative:
    - sectors
    - governorates
    - sub_sectors
Tables:
  Epidemiology:
    - EpidemiologyTS
    - EpidemiologyTST
  Radioactivity:
    - RadiationTS
    - RadiationTST
  Seismic:
    - EarthquakeTS
    - SeismicTST

Schemas:

The schemas to be created in the target postgis database.

FeatureDatasets:

Maps the feature datasets of the geodatabase to the schemas of the target postgis database

FeatureClasses:

Maps the feature classes of the geodatabase that do not belong to any feature dataset to the schemas of the target postgis database

Tables:

Maps the tables of the geodatabase to the schemas of target postgis database

Command line options:

fgdb2postgis -h
fgdb2postgis -f filegdb
             -p postgis
             --host=host
             --port=port
             --user=user
             --password=password

Restrictions

• DO NOT apply this tool in a production postgis database!

• The target postgis database should exists and be EMPTY.

• The tool will OVERWRITE any tables having the same name with the tables in the file geodatabase.

Note

Special thanks goes to James Ramm who kindly developed and shared the archook package.