[Qgis-user] Lookup Tables in File GDB?

Michael Treglia mtreglia at gmail.com
Mon Jun 6 09:34:39 PDT 2016


Thanks all for the quick feedback! I'll give these things a try and will
report back. And for what it's worth, same issue with using both
openFileGDB and ESRI FileGDB drivers.
Cheers,
mike

On Mon, Jun 6, 2016 at 12:12 PM, Justin Robinson <jdr at spatialbias.com>
wrote:

> Hi Michael,
>
> That's probably GDAL's openFileGDB driver and it's interaction with Esri's
> Coded Domains, there's an open ticket at
> https://trac.osgeo.org/gdal/ticket/5741
>
> It doesn't sound like there was any resolution to it based on other
> threads (
> http://osgeo-org.1560.x6.nabble.com/gdal-dev-OGR-How-to-access-Coded-Value-Domains-in-File-Geodatabases-td5180262.html
> ) either, it's in a GDB_Items table in the geodatabase and isn't easy to
> access without some amount of work.
>
> Not exactly an answer, but more info, cheers,
>
> Justin
>
> On Mon, Jun 6, 2016 at 8:59 AM, Michael Treglia <mtreglia at gmail.com>
> wrote:
>
>> Hi All,
>>
>> I'm trying to work with a planimetric dataset available here:
>> https://data.cityofnewyork.us/Transportation/NYC-Planimetrics/wt4d-p43d,
>> which is available in a FileGDB format.
>>
>> When I load the layers from the gdb in QGIS, some fields are field with
>> numeric values (e.g., entries in the PARK layer, for the FEATURE_CODE
>> column are integers). However, when I load the gdb in Arc, FEATURE_CODE is
>> filled with string entries (e.g,  'Park Boundary'). Thus, it seems like
>> ESRI uses a lookup table or something on this. Does anybody have experience
>> in dealing with this type of issue? Is there a good way to deal with this
>> via QGIS or OGR? (I'm ultimately wanting to import the data to PostGIS,
>> where the same issue is occurring, using org2ogr)
>>
>> Thanks!
>> Mike
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160606/1f3329a4/attachment.html>


More information about the Qgis-user mailing list