[Qgis-user] Lookup Tables in File GDB?

[Eric Goddard]

You're correct, the feature class is using a lookup table (domains in
ArcGIS) that the ogr drivers can't access as far as I know. If you can load
the gdb in ArcMap, you can use the Domain to Table tool (
http://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/domain-to-table.htm)
to export the lookup codes/values for loading into a Postgres table.

Hope that helps!
Eric

On Mon, Jun 6, 2016 at 10: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/3fb50cd6/attachment.html>