Skip to main content
  • EN

I've been asked to see if its possible to maintain values in a coded domain on an ESRI Geodatabase. I would need to insert, update, and delete code/description combination records in the domain. I've found this article:

https://knowledge.safe.com/articles/886/working-wi...

but it's referring to updating a table that uses a domain, not the actual domain.

I know FME can call a python script like this from within FME...

arcpy.AddCodedValueToDomain_management(in_workspace="H:/MyDocs/geodbs/inspections/Inspections.gdb",domain_name="Structure_No",code="ABC-123",code_description="STRUCTURE 123")

But can FME do it directly?

Thanks,

Sarah

I guess I asked this question in the old Google Discussion Group, FMETalk.

https://groups.google.com/forum/#!topic/fmetalk/KTO4vfQvT6k

Any updated information since then? Any new capabilities in FME 2015 or 2016?

We highly recommend that you use ArcGIS in order to create/define/alter your geodatabase domain definitions. But you can get at the domain definitions by reading in a geodatabase feature class that contains the domains you wish to alter using a FeatureReader. This would give you access to the underlying schema of the geodatabase where you could then try to make adjustments to domain definitions.

The syntax you would look for within the schema looks like this - coded_domain(<DomainName>:<DataType>:code:value:code:value:.....).

An example domain for street types might look like this - coded_domain(StreetType:char:A:Arterial:S:Secondary:R:Residential)

Again, this is not necessarily a technique we recommend given the complex nature of domains.

Thank you @HeatherAtSafe, I understand the recommendation. I don't particularly want to risk corruption to our geodatabase, so I will explain this to the requestor.

Sarah

Reply


Community Stats

30,351
Posts
115,343
Replies
38,086
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.