topic Is there a way to update a domain, when a Feature Class is updated? in ArcGIS Pro Questions

Is there a way to update a domain, when a Feature Class is updated?

CharlesQuadrini — Tue, 19 Feb 2019 16:55:59 GMT

I have create a Feature class, of shape polyline. I have then used the geoprocessing tool "Table to Domain" to take this list of polylines and allow it to be consumed by another table or feature class in my gdb as a domain value.

The challenge I now have, is when a new polyline is added to the original or source feature class, how do I get the domain to update with this new value? Is there a setting I forgot to check when creating the domain originally? A python script I need to write? Workflow manager? Or just not doable?

Thanks,

Charles

Re: Is there a way to update a domain, when a Feature Class is updated?

ChristianWells — Tue, 19 Feb 2019 18:54:35 GMT

Charles Quadrini‌ this should be possible through the field settings if you are looking for the fields to automatically populate upon creation. Associating default values and domains with tables and feature classes—ArcGIS Help | ArcGIS Desktop

After re-reading your question, I wasn't sure if you are looking for the field to be updated automatically or the domain list to be updated automatically?

Re: Is there a way to update a domain, when a Feature Class is updated?

CharlesQuadrini — Tue, 19 Feb 2019 19:22:17 GMT

Hi Christian,

I am looking for the domain to be updated automatically when a new row is added to the feature class by drawing a new polyline.

Is that clearer?

Charles

Re: Is there a way to update a domain, when a Feature Class is updated?

ChristianWells — Wed, 20 Feb 2019 00:26:45 GMT

That helps to clarify, however, I don't know of a way to make it automatically update domain without running a script to check for new values and update the domain as needed. Once the 'Table to Domain' tool is ran, the Geodatabase stores the values as metadata and is no longer connected to the original table/feature class used to create the domain.

If you're looking for an automated method, one way could be to set up a Python file through Windows Task Scheduler. You could have it run during off hours to avoid creating Geodatabase locks. Here's a breakdown of how you could do this via Python:

Connect to the Geodatabase and query the domain using the 'Domain to Table' tool
1. Domain To Table—Data Management toolbox | ArcGIS Desktop
Find all of the current values in the domain and store as a Python list or iterate through the rows
1. SearchCursor—Help | ArcGIS Desktop
Connect to the polyline table and query the field used by the domain
Find all of the current values in the field and store as a Python list
1. SearchCursor—Help | ArcGIS Desktop
Compare the lists via Python and find the new values from the polyline
Use the appropriate (Coded Value vs Range) geoprocessing tool to update the domain values
1. Add Coded Value To Domain—Data Management toolbox | ArcGIS Desktop
2. Set Value For Range Domain—Data Management toolbox | ArcGIS Desktop

I hope you find this helpful.

Re: Is there a way to update a domain, when a Feature Class is updated?

TamerAssaf — Wed, 31 Jan 2024 22:41:56 GMT

Hi @CharlesQuadrini ,

Did you find the solution?
If you find the solution, what is the solution?

Re: Is there a way to update a domain, when a Feature Class is updated?

Bud — Wed, 31 Jan 2024 23:38:30 GMT

This isn’t my area of expertise, but you could look into web hooks.

What kind of geodatabase? If you are using an enterprise GDB (or maybe a mobile GDB) the you could query using SQL to compare the FC values against the domain values. But you’d still need to use most of @ChristianWells steps above, like a scheduled task and Python to insert a new value into the domain.

Related ideas: