Skip to main content
Open

Warn when resolving ArcGIS Domains if code (value) not found in Domain (FGDB/Arc

Related products:Integrations

tim_wood
Contributor

***Note from Migration:***

Original Title was: Warn when resolving ArcGIS Domains if code (value) not found in Domain (FGDB/ArcSDE)


For example when reading a File Geodatabase or ArcSDE layer.

It is possible for a field in a layer to contain a value that doesn't match a code (value in FME speak) in the Domain. For example your Domain has:

1 = Car

2 = Bus

3 = Train

But the Vehicle field for some features in your layer have the value "4" in the actual data. Even worse, the value in the data might be "Car" which makes it almost impossible to figure out that ArcGIS is showing the raw data and not displaying "Car" by looking up "1" in the Domain.

When you read the data into FME (whether you use the FGDB Open API Reader or the ArcGIS Reader), you will get an empty string for any values such as "4" that aren't in the Domain. This is because FME will look up the actual value from the data and not find it in the Domain.

I would like to suggest that if this happens, the Log file should record a Warning or Error to say something like "WARN: code '4' not found in Domain 'Vehicle_type'".

3 replies

sammy
Supporter
Forum|alt.badge.img+16
  • Supporter
  • January 18, 2024

This would be especially helpful now with the Utility Network. Has any functionality been added that would facilitate flagging records where domain code not found?


sammy
Supporter
Forum|alt.badge.img+16
  • Supporter
  • March 6, 2024

It would also be great to have the option of just putting the unresolved code in the _resolved field (maybe along with the warning)


sammy
Supporter
Forum|alt.badge.img+16
  • Supporter
  • March 7, 2024

I put in a new idea suggestion to include the option in addition to a warning. Not sure if that is redundant? But here is the link to upvote:

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings