[gdal-dev] FileGDB Driver coordinate system support

[Hailey Eckstrand]

Thank you Michael and Donavan for pointing me in the correct direction.
I've found out why my 3005 file GDB would not work.
I had previously downloaded data from the BC province and so when I
transformed the data from 4326 to 3005, I just used the projection in my
Favorites, which was the province's BC Albers projection. It turns out that
the province's BC Albers has a different projection name that ESRI's
definition of BC Albers.  The projection parameters are identical, but the
province's projection name is PCS_Albers, whereas ESRI's accepted BC Albers
is called NAD 1983 CSRS BC Environmental Albers (Projected Coordinate
System > National Grids > Canada > NAD 1983 CSRS BC Environmental Albers).
Once I redefined the projection to be that of the accepted ESRI's BC
Albers, the geodatabase imported successfully.
Thank you for your help,
Hailey


On Wed, Aug 7, 2013 at 8:02 PM, Saulteau Don <sault.don at gmail.com> wrote:

> 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/20130808/4b4bb2c1/attachment.html>