Skip to main content
Question

How to Create Subdomain or Domain in GDB Using FME Form?

  • February 26, 2024
  • 8 replies
  • 352 views

vishnunv2696
Contributor
Forum|alt.badge.img+4

Hello FME Community,

I'm currently working on a project that involves a large number of subdomains and domains, and I have my data available in table format. I'm looking for guidance on how to organize this data into a geodatabase (GDB) using FME, while adhering to domain conventions.

Specifically, I would like to know:

  1. How can I create subdomains within a GDB using FME?
  2. What steps are involved in defining domains for attributes within the GDB?
  3. Are there any best practices or recommended workflows for organizing subdomains and domains efficiently?

Any insights, tips, or examples would be greatly appreciated. Thank you in advance for your help!

Best regards,

Vishnu N V

8 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

Have a look at the article Working with Geodatabase Subtypes: Writing A Subtype

You can find this and other articles when you search the Knowledge Base.


vishnunv2696
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • February 26, 2024

Thank you for your reply. I've already been watching, But my requirement is to create a new subtype domain from scratch. I don't have any sample subtype domain geodatabase available; I only have table data.


hkingsbury
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • February 26, 2024

I don’t think FME can natively create a new Domain or Subtype (someone correct me if i’m wrong).

I’d suggest you use ArcPy in a PythonCaller to create them

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/create-domain.htm
https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-subtype.htm


vishnunv2696
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • February 27, 2024

Thank you for your reply. I don't have any experience with arcpy or PythonCaller. Do you have any ideas on how to manage and implement the code in PythonCaller?. My current requirement is to create 10,000 subtypes for a list of corresponding 1,500 types in a single or multiple geodatabases.


nielsgerrits
VIP
Forum|alt.badge.img+54
vishnunv2696 wrote:

Thank you for your reply. I don't have any experience with arcpy or PythonCaller. Do you have any ideas on how to manage and implement the code in PythonCaller?. My current requirement is to create 10,000 subtypes for a list of corresponding 1,500 types in a single or multiple geodatabases.

There is nothing out of the box to create file geodatabases with domains and subtypes. You will have to study the esri documentation and learn to implement that in a workbench using PythonCallers.

I found a workspace template on the FME hub which creates a file geodatabase with domains from excel input, but no subtypes. It also is from 2017… What you want to do might be complex to build, not something I would advise to start with learning FME.


nielsgerrits
VIP
Forum|alt.badge.img+54
vishnunv2696 wrote:

Thank you for your reply. I don't have any experience with arcpy or PythonCaller. Do you have any ideas on how to manage and implement the code in PythonCaller?. My current requirement is to create 10,000 subtypes for a list of corresponding 1,500 types in a single or multiple geodatabases.

There is nothing out of the box to create file geodatabases with domains and subtypes. You will have to study the esri documentation and learn to implement that in a workbench using PythonCallers. This is may easier nowadays with ChatGPT / AI assistant in FME.

I found a workspace template on the FME hub which creates a file geodatabase with domains from excel input, but no subtypes. It also is from 2017… What you want to do might be complex to build, not something I would advise to start with learning FME.

I cannot link to the FME hub, but you can google it. Search “for Create_empty_FGDB” + FME hub


hkingsbury
Celebrity
Forum|alt.badge.img+51
  • Celebrity
  • February 27, 2024

nielsgerrits
VIP
Forum|alt.badge.img+54
hkingsbury wrote:

Also, in FME 2023, in the PythonCaller, you can ask the AI assistant to generate PythonCaller implemented code to create a new file geodatabase. You can just work from there, creating a featureclass, creating attributes, creating domains and subtypes, assign these to the attributes. It is a lot of work, but is now easier than ever before.


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