fields with domains only display codes

[gregbunce]

The problem

The MSSQL Enterprise Geodatabase has the concept of domains where data is stored as a code but the value is displayed in the software.

The reason

The Open SGID is not an enterprise geodatabase and the esri domains do not transfer in our extract transfer load process.

The workaround

Currently, there is no workaround. AGRC is in the process of updating every domain in the SGID to make the domain equal the value where possible. This will replace the nebulous codes with the descriptive values in the future.

This is a large effort, for the time being we will export lookup tables and store them in the Open SGID. Users will need to create a query that joins this table with the data they are interested in.

Examples

// TODO