[postgis-users] Migrating ESRI File Geodatabase to PostGIS

[Paolo Corti]

On Sun, Sep 16, 2012 at 1:53 AM, Domingo Alcaraz-Segura
<txomingo99 at gmail.com> wrote:
>
> Dear guys,
>
> I saw that you included some previous posts on how to read/write ESRI File
> Geodatabase in PostGIS. I need to read the atribute table of a 4 GByte
> File_GDB from 64-bit R (language for statistical computing). I am trying to
> migrate the ESRI File Geodatabase into PostGIS and then read the PostGIS
> file from R. I have NO expirence with PostGIS. Could you give me a hand with
> which are the steps and libraries needed to move from the ESRI FGDB file to
> a PostGIS file?

You can use GDAL, in particular the ogr2ogr [1] command, using the
PostgreSQL [2] and File GDB [3] drivers. For example, this will
convert the "YourFeatureClass" in the "yourGDB.gdb" file gdb to a
PostGIS spatial table:

ogr2ogr -f "PostgreSQL" PG:"host=myhost user=myuser dbname=mydb
password=mypass" "C:\somefolder\yourGDB.gdb" "YourFeatureClass"

Remember that GDAL must be compiled with the FileGDB support:
basically you have to download the Esri FileGDB API, and compile GDAL
with the   --with-fgdb GDAL configuration option

regards
p

[1] http://www.gdal.org/ogr2ogr.html
[2] http://www.gdal.org/ogr/drv_pg.html
[3] http://www.gdal.org/ogr/drv_filegdb.html

-- 
Paolo Corti
Geospatial software developer
web: http://www.paolocorti.net
twitter: @capooti
skype: capooti