Re: [gdal-dev] FileGDB Driver coordinate system support
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@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.sm...@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 haileyeckstr...@gmail.com Date: Wednesday, August 7, 2013 6:09 PM To: gdal-dev@lists.osgeo.org gdal-dev@lists.osgeo.org Subject: [gdal-dev] FileGDB Driver coordinate system support Resent-From: Michael Smith michael.sm...@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] FileGDB Driver coordinate system support
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 haileyeckstr...@gmail.commailto:haileyeckstr...@gmail.com Date: Wednesday, August 7, 2013 6:09 PM To: gdal-dev@lists.osgeo.orgmailto:gdal-dev@lists.osgeo.org gdal-dev@lists.osgeo.orgmailto:gdal-dev@lists.osgeo.org Subject: [gdal-dev] FileGDB Driver coordinate system support Resent-From: Michael Smith michael.sm...@usace.army.milmailto:michael.sm...@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] FileGDB Driver coordinate system support
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.sm...@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 haileyeckstr...@gmail.com Date: Wednesday, August 7, 2013 6:09 PM To: gdal-dev@lists.osgeo.org gdal-dev@lists.osgeo.org Subject: [gdal-dev] FileGDB Driver coordinate system support Resent-From: Michael Smith michael.sm...@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev