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 <[email protected]> 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
> [email protected]
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to