gisinternals.org has Gdal for Windows with file geodatabase support<br><br>It works fine <br>Fuad <div class="quote" style="line-height: 1.5"><br><br>-------- Original Message --------<br>Subject: Re: [gdal-dev] compiling gdal with esri file gdb<br>From: Damian Dixon <damian.dixon@gmail.com><br>To: Richard Greenwood <richard.greenwood@gmail.com><br>CC: GDAL List <gdal-dev@lists.osgeo.org><br><br><br type="attribution"><blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif">Have you tried OpenFileGDB? (you will need GDAL 2.2 or newer for curve geometries).</div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif">See: <a href="http://www.gdal.org/drv_openfilegdb.html">http://www.gdal.org/drv_openfilegdb.html</a></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif">We have switched to OpenFileGDB because ESRI don't have their library available on Windows built against VS2015. Which also means we did not bother with the ESRI libraries on Linux either.</div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif">The other option is to use GDAL on Windows to convert the file. The way shared libraries work on Windows means that the proj4 issue you are seeing on Linux should not occur.</div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif">I don't know where you would get a Windows build of GDAL with FileGDB enabled. Someone on the list probably does.</div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif"><br></div><div class="gmail_default" style="font-family:"trebuchet ms",sans-serif"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 11 March 2017 at 00:05, Richard Greenwood <span dir="ltr"><<a href="mailto:richard.greenwood@gmail.com" target="_blank">richard.greenwood@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">If any of you can share any pointers on how to even get it to compile I'd appreciate it. I just need to access a esri file geodatabase that has curves and see if I can get them into postgis. If I have to have a separate build of gdal just for that I don't care. But I'm not too good with compiling gdal with 3rd party libraries.<div><br></div><div>Thanks,</div><div>Rich</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Fri, Mar 10, 2017 at 10:16 AM, Even Rouault <span dir="ltr"><<a href="mailto:even.rouault@spatialys.com" target="_blank">even.rouault@spatialys.com</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"><u></u>
<div style="font-family:'Sans Serif';font-size:9pt;font-weight:400;font-style:normal"><span>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">On vendredi 10 mars 2017 12:57:05 CET Robert Coup wrote:</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> Hi Even,</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> On 9 March 2017 at 23:03, Even Rouault <<a href="mailto:even.rouault@spatialys.com" target="_blank">even.rouault@spatialys.com</a>> wrote:</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> > For those, at least on Linux, and which use GDAL compiled *without*</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> > --with-static-proj, you may get strange projection related failures at</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> > runtime. This is due to libFileGDBAPI.so embedding a copy of proj.4</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> > (without symbol hidding or renaming !!!), which conflicts with the proj.4</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> > that GDAL will load dlopen(). Typical error emitted is about "unknown</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> > ellipsoid".</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> I presume there's no workaround apart from --with-static-proj that doesn't</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">> require ESRI to change their build process?</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"> </p>
</span><p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">Hi Rob,</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"> </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">Yeah, I'm not even sure if --with-static-proj (which contrary to what its name my suggst will link against libproj.so if found) is completely safe, but it did work for me.</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"> </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">Strangely, even without --with-static-proj, it worked for me at first, but then failed when I probably reordered paths in my LD_LIBRARY_PATH. But I'm not so surprised: clashing symbols issues tend to be not predictable.</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"> </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">In fact, libFileGDBAPI.so doesn't seem to embed all public proj.4 symbols. The functions are missing. But 5 or 6 global array structures, like the list of datums (pj_datums) are exposed in the data read-only section. The issue is that pj_datums doesn't seem to have the same structure: 2 columns per record in the ESRI version whereas official proj.4 expects 4 columns</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"> </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">$ objdump -T /home/even/FileGDB_API-64gcc51<wbr>/lib/libFileGDBAPI.so | grep pj_</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">00000000010dc880 g DO .<a href="http://data.rel.ro" target="_blank">data.rel.ro</a> 00000000000000b0 Base pj_datums</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">0000000001294080 g DO .<a href="http://data.rel.ro" target="_blank">data.rel.ro</a> 0000000000000570 Base pj_projections</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">00000000010dbd20 g DO .<a href="http://data.rel.ro" target="_blank">data.rel.ro</a> 0000000000000500 Base pj_pids</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">00000000010dc7a0 g DO .<a href="http://data.rel.ro" target="_blank">data.rel.ro</a> 00000000000000e0 Base pj_primems</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">00000000010dc380 g DO .<a href="http://data.rel.ro" target="_blank">data.rel.ro</a> 0000000000000420 Base pj_ellipses</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">00000000010dc220 g DO .<a href="http://data.rel.ro" target="_blank">data.rel.ro</a> 0000000000000160 Base pj_linunits</p><span>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"> </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">Even</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"> </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"> </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">-- </p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">Spatialys - Geospatial professional services</p>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px"><a href="http://www.spatialys.com" target="_blank">http://www.spatialys.com</a></p></span></div><br></div></div><span class="">______________________________<wbr>_________________<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="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/gdal-dev</a><br></span></blockquote></div><br><br clear="all"><span class=""><div><br></div>-- <br><div class="m_3924046650249669756gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">Richard W. Greenwood, PLS<br><a href="http://www.greenwoodmap.com" target="_blank">www.greenwoodmap.com</a></div></div>
</span></div>
<br>______________________________<wbr>_________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/gdal-dev</a><br></blockquote></div><br></div>
</blockquote></div>