Skip to main content
Question

How to dynamically create Arcsde Feature Class with domains and dynamic feature class names?

  • December 20, 2019
  • 4 replies
  • 37 views

arekpierchala
Contributor
Forum|alt.badge.img+1

Hi

I need to create in dynamic way ESRI Feature Class with domains fields. Feature Class names are dynamic so there is a problem to use XML schema template which defines only one, static feature class.

I cant also import schema to Writer because FME do not import domains field definitions (am I right?) so when FME create new FC I don't get domain fields.

Thanks for any suggestions

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

Forum|alt.badge.img+2
  • December 20, 2019

@arekpierchala I don't think FME can do this on it's own. My guess would be that you'll have to develop some arcpy to create the domains after you have written the data. Possibly a combination of FeatureWriter and PythonCaller. You'll have to accumulate a list of the unique values for each domain attribute using the DuplicateFilter & Aggregator (Attributes to Concatenate)


runneals
Supporter
Forum|alt.badge.img+29
  • Supporter
  • December 20, 2019

Maybe @mmccart might have an idea?


arekpierchala
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • December 23, 2019

@arekpierchala I don't think FME can do this on it's own. My guess would be that you'll have to develop some arcpy to create the domains after you have written the data. Possibly a combination of FeatureWriter and PythonCaller. You'll have to accumulate a list of the unique values for each domain attribute using the DuplicateFilter & Aggregator (Attributes to Concatenate)

I've done some tests with XML template of FC definition. Its simple Python to replace FC name in XML, but there is a problem to replace Coordinate System definition in XML. In my outputs each different feature class need to have different coord sys :(


chrisatsafe
Contributor
Forum|alt.badge.img+2
  • Contributor
  • December 27, 2019

I've done some tests with XML template of FC definition. Its simple Python to replace FC name in XML, but there is a problem to replace Coordinate System definition in XML. In my outputs each different feature class need to have different coord sys :(

Not sure if this would make it less dynamic, but have you tried handling the coordinate system portion using Conditional Values in the CoordinateSystemSetter (or Reprojector if you are reprojecting)?