<div dir="ltr">Thank you Michael and Donavan for pointing me in the correct direction. I've found out why my 3005 file GDB would not work. <div>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.</div>
<div>Thank you for your help,</div><div>Hailey</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Aug 7, 2013 at 8:02 PM, Saulteau Don <span dir="ltr"><<a href="mailto:sault.don@gmail.com" target="_blank">sault.don@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">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.<div>
<br></div><div>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...</div>
<div><br></div><div>So I checked out your test4326.gdb and that works and so did the output file I was able to reproject using:</div><div><br></div><div>ogr2ogr -f "FileGDB" new3005.gdb -s_srs EPSG:4326 -t_srs EPSG:3005 dir4326/test4326.gdb upcheak_landapp4326</div>
<div><br></div><div>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.</div>
<div><br></div><div><br></div><div>Donovan</div></div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div class="h5">On Wed, Aug 7, 2013 at 4:15 PM, Smith, Michael ERDC-RDE-CRREL-NH <span dir="ltr"><<a href="mailto:Michael.Smith@erdc.dren.mil" target="_blank">Michael.Smith@erdc.dren.mil</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">
<div style="font-size:14px;font-family:Calibri,sans-serif;word-wrap:break-word">
<div>The ESRI FileGDB api only supports certain projections, BC Albers (epsg:3005) is evidently not one of them. Its in ESRI API issue.</div>
<div><br>
</div>
<div>Mike</div><span><font color="#888888">
<div><br>
</div>
<div>
<div>
<div>
<div>-- </div>
<div>Michael Smith</div>
</div>
<div>US Army Corps</div>
<div>Remote Sensing GIS/Center</div>
</div>
</div>
<div><br>
</div>
</font></span><span><span><font color="#888888">
<div style="border-right:medium none;padding-right:0in;padding-left:0in;padding-top:3pt;text-align:left;font-size:11pt;border-bottom:medium none;font-family:Calibri;border-top:#b5c4df 1pt solid;padding-bottom:0in;border-left:medium none">
<span style="font-weight:bold">From: </span>Hailey Eckstrand <<a href="mailto:haileyeckstrand@gmail.com" target="_blank">haileyeckstrand@gmail.com</a>><br>
<span style="font-weight:bold">Date: </span>Wednesday, August 7, 2013 6:09 PM<br>
<span style="font-weight:bold">To: </span>"<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a>" <<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a>><br>
<span style="font-weight:bold">Subject: </span>[gdal-dev] FileGDB Driver coordinate system support<br>
<span style="font-weight:bold">Resent-From: </span>Michael Smith <<a href="mailto:michael.smith@usace.army.mil" target="_blank">michael.smith@usace.army.mil</a>><br>
</div></font></span><div><div>
<div><br>
</div>
<div>
<div>
<div dir="ltr">
<div>
<div style="font-family:arial,sans-serif;font-size:13px">Hello,</div>
<div style="font-family:arial,sans-serif;font-size:13px">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.</div>
<div style="font-family:arial,sans-serif;font-size:13px">ogr2ogr -f PostgreSQL PG:dbname=fgdb_test dir4326/test4326.gdb<br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">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:</div>
<div style="font-family:arial,sans-serif;font-size:13px">ogr2ogr -f PostgreSQL PG:dbname=fgdb_test dir3005/test3005.gdb<br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">ogr2ogr -f PostgreSQL -s_srs EPSG:3005 PG:dbname=fgdb_test dir3005/test3005.gdb<br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">ogr2ogr -f PostgreSQL -t_srs EPSG:3005 PG:dbname=fgdb_test dir3005/test3005.gdb<br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">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.</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">I am testing using Ubuntu 12.04</div>
<div style="font-family:arial,sans-serif;font-size:13px">GDAL 1.9.2</div>
<div style="font-family:arial,sans-serif;font-size:13px">FileGDB_API_1_3-64<br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">Also, here is the output from ogrinfo:</div>
<div style="font-family:arial,sans-serif;font-size:13px">
<div>$ogrinfo dir4326/test4326.gdb/</div>
<div>INFO: Open of `dir4326/test4326.gdb/'</div>
<div> using driver `FileGDB' successful.</div>
<div>1: upcheak_landapp4326 (3D Multi Polygon)</div>
</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">
<div>$ogrinfo -al dir3005/test3005.gdb/</div>
<div>INFO: Open of `dir3005/test3005.gdb/'</div>
<div> using driver `FileGDB' successful.</div>
</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:13px">Thank you,</div>
<div style="font-family:arial,sans-serif;font-size:13px">Hailey</div>
</div>
<div><br>
</div>
<div><span style="font-size:13px;font-family:arial,sans-serif">Links to the 2 zip files of my 2 test geodatabases:</span><br>
</div>
<a href="http://filebin.ca/qjmBMOaH0cR/dir4326.zip" target="_blank">http://filebin.ca/qjmBMOaH0cR/dir4326.zip</a><br>
<div><a href="http://filebin.ca/qjmPiqEAsJ6/dir3005.zip" target="_blank">http://filebin.ca/qjmPiqEAsJ6/dir3005.zip</a><br>
</div>
</div>
</div>
</div>
</div></div></span>
</div>
<br></div></div>_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br></blockquote></div><br></div>
</blockquote></div><br></div>