[gdal-dev] FileGDB Driver coordinate system support

[Saulteau Don]

I've imported data from a FileGDB to PostGIS when it was stored using EPSG
3005 so it definitely works and is supported by the FileGDB API.

I tested your data and got the same result on the test3005.gdb, no layers
in the output - the file GDB may be corrupt because QGIS won't even open it
and complains about it being an unrecognised data source or it's just
empty...

So I checked out your test4326.gdb and that works and so did the output
file I was able to reproject using:

ogr2ogr -f "FileGDB" new3005.gdb -s_srs EPSG:4326 -t_srs EPSG:3005
dir4326/test4326.gdb upcheak_landapp4326

Notice how at the very end I've told it what layer in the FileGDB to look
for when re-projecting and not just the input FileGDB. Maybe you were just
missing the input layer? But the file you get from running that command
should work for importing to postgis.


Donovan


On Wed, Aug 7, 2013 at 4:15 PM, Smith, Michael ERDC-RDE-CRREL-NH <
Michael.Smith at erdc.dren.mil> wrote:

>  The ESRI FileGDB api only supports certain projections, BC Albers
> (epsg:3005) is evidently not one of them. Its in ESRI API issue.
>
>  Mike
>
>   --
> Michael Smith
>  US Army Corps
> Remote Sensing GIS/Center
>
>   From: Hailey Eckstrand <haileyeckstrand at gmail.com>
> Date: Wednesday, August 7, 2013 6:09 PM
> To: "gdal-dev at lists.osgeo.org" <gdal-dev at lists.osgeo.org>
> Subject: [gdal-dev] FileGDB Driver coordinate system support
> Resent-From: Michael Smith <michael.smith at usace.army.mil>
>
>    Hello,
> I am trying to import a feature class from a file geodatabase (version 10
> or greater) into PostGIS. After installing the FileGDB driver, I was able
> to successfully import a feature class which was in the EPSG 4326 spatial
> reference system.
> ogr2ogr -f PostgreSQL PG:dbname=fgdb_test dir4326/test4326.gdb
>
>  However, I created another file geodatabase and reprojected the feature
> class to the BC Albers projection (EPSG: 3005) and then attempted to import
> the new fgdb again and it failed with no error. My attempts:
> ogr2ogr -f PostgreSQL PG:dbname=fgdb_test dir3005/test3005.gdb
>  ogr2ogr -f PostgreSQL -s_srs EPSG:3005 PG:dbname=fgdb_test
> dir3005/test3005.gdb
>  ogr2ogr -f PostgreSQL -t_srs EPSG:3005 PG:dbname=fgdb_test
> dir3005/test3005.gdb
>
>  All failed with no errors. I am not trying to transform while
> importing.. I would just like to import a feature class in a projected
> coordinate system.
>
>  I am testing using Ubuntu 12.04
> GDAL 1.9.2
> FileGDB_API_1_3-64
>
>  Also, here is the output from ogrinfo:
>  $ogrinfo dir4326/test4326.gdb/
> INFO: Open of `dir4326/test4326.gdb/'
>       using driver `FileGDB' successful.
> 1: upcheak_landapp4326 (3D Multi Polygon)
>
>
>  $ogrinfo -al dir3005/test3005.gdb/
> INFO: Open of `dir3005/test3005.gdb/'
>       using driver `FileGDB' successful.
>
>  Thank you,
> Hailey
>
>  Links to the 2 zip files of my 2 test geodatabases:
>  http://filebin.ca/qjmBMOaH0cR/dir4326.zip
> http://filebin.ca/qjmPiqEAsJ6/dir3005.zip
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20130807/16bfd3eb/attachment-0001.html>