• Blog posts

    Bio

    By David Crowther 

    65.png

    Question:

    I would like to import the tables within an ESRI Geodatabase into my PostGIS database, what are the best steps to do this?

    Answer:

    In the blogs below, I start to discuss using the GDAL – Ogr2Ogr – tool to import and export between common spatial formats. With Part 2 concentrating on working with PostGIS.

    Part One - https://www.cadlinecommunity.co.uk/hc/en-us/articles/115003496349-Utilising-Ogr2Ogr-Part-One

    Part Two - https://www.cadlinecommunity.co.uk/hc/en-us/articles/115003798085-Utilising-Ogr2Ogr-Part-Two-PostGIS-

    Below is an Ogr2Ogr statement that will load your ESRI Geodatabase tables into PostGIS.

    ogr2ogr -f "PostgreSQL" PG:"host=servername port=5432 user='username' password='password' dbname='PostGISDBName'" D:/TEMP/geodb/parcels.gdb -overwrite -progress --config PG_USE_COPY YES

    66.jpgThe above script will copy the tables within the parcels.gdb into the chosen PostGIS Database, so that it can be accessible using QGIS.

    67.jpg