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 <[email protected]> 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 < > [email protected]> 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 <[email protected]> >> Date: Wednesday, August 7, 2013 6:09 PM >> To: "[email protected]" <[email protected]> >> Subject: [gdal-dev] FileGDB Driver coordinate system support >> Resent-From: Michael Smith <[email protected]> >> >> 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 >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/gdal-dev >> > >
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
