We have several file gdb's and would like to convert these to Postgres / PostGIS. We've used ogr2ogr to transfer these files; however, some of the fields are stored as coded domains and the fields are not decoded in the transfer. Coded domains are stored in a separate table.
For example, a column design quality could belong to the general domain quality. Quality could then be coded as '1=low, 2=medium, 3=high'. This is to enforce that only certain values are used, for instance in a survey. Ogr2ogr reads the values 1, 2, and 3, but not the accompanying text.
Would anybody know how to include these domains in the transfer from gdb to Postgres / PostGIS?
We could convert to file gdb's to an ArcSDE database if this is easier; however shapefiles are not preferred due to column truncation.
This question was posted earlier here on StackOverflow.