On Sun, Sep 16, 2012 at 1:53 AM, Domingo Alcaraz-Segura <txoming...@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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
