nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Importing domains from Excel

MagnusPersson

Hi,

I am building a geodatabase which is supposed to contain A LOT of domains to be used in ArcGIS online and Collector.

Soo, i want to import all domains, 30-40 of them, to ArcMap instead of typing them in which would take forever.

Do you guys have an indea of how to do that?

Finde mehr Beiträge mit dem Tag

Accepted answers

BugPie

I've found the table to domain tool very useful!! saved me days of mis-typing all these entries.

For the Pro users: https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/table-to-domain.htm

All comments

BugPie

I've found the table to domain tool very useful!! saved me days of mis-typing all these entries.

For the Pro users: https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/table-to-domain.htm

AndresCastillo

"The worksheets for domains should have at least two columns (CODE and DESCRIPTION), but other related columns could be added. If the domain is being used to track employee activities, the domain code can link to the employee table and provide access to related information. "

Hi Randy, I don't understand why someone would add more than just code and description fields to the excel, when the other columns are not used in the code, such as:

arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>AddField_management

arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>TableToDomain_management
arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>SortCodedValueDomain_management<CODE>arcpy<SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN>CreateTable_management

arcpy.AddCodedValueToDomain_management
<CODE>arcpy.CreateDomain_management

How can the domain code link to the employees table and provide access to related information?

A join?

By the way, beautiful code.

HannahHutchins1

Hey Randy,

Thank you for getting back to me!

Your descriptions help but unfortunately due to my lack in Python skills, I can't seem to produce anything. All I did to your first script was change the geoDB and excelWB environments to my working documents.

When I run your first script, I get this error (see graphic below) and all it produces is one table in my geodatabase called "Domain1", which isn't correct.

I know I'm missing something - I'm guessing I have to change something more in your script but I can't figure out where.

I have my Excel document with domains attached.

Any insight would be helpful!

Thanks

Parks_Domains.xlsx

RandyBurton

These scripts are a couple from a series that I use to create features /tables and maintain a geodatabase. I like MySQL’s SHOW CREATE TABLE and wanted to do a similar workflow with arcpy. The scripts above use arcpy’s CreateTable and TableToDomain tools with the xlrd module to create and populate a domain.

I use a list of lists for my field definitions which makes it easy to change field types, aliases, etc. I maintain an Excel workbook for my domains. By naming the worksheet tabs with the domain name, additional data can be stored in the workbook and not cause problems with the process.

The worksheets for domains should have at least two columns (CODE and DESCRIPTION), but other related columns could be added. If the domain is being used to track employee activities, the domain code can link to the employee table and provide access to related information. I’ve attached a sample workbook.

The first script uses the field name lists to create a table. Then it reads the workbook tab with the domain name and populates the table.

The second script reads specific tables (named in a list) and converts them into a coded value domain.

Hope this helps.

workbook.xlsx

HannahHutchins1

Hi Randy,

I came across your two scripts here and was wondering if you could help me out a bit. I'm fairly new to working with python and am having a hard time understanding exactly what you have here.

I understand that I need to put in my own geoDB and excelWB, but do I need to name the individual sheets in the workbook inside the script somewhere?

RandyBurton

When I create domains, I start with an Excel workbook with one domain per tab. I then run a python script to create a table in a file geodatabase for each domain and import the data from the spreadsheet. A second python script converts the table to a domain. I will use a third script, similar to the first, to create my feature layers.

To create the tables:

<SPAN class="comment token"># Description:&nbsp; Add fields and datato a table</SPAN>

<SPAN class="keyword token">import</SPAN> xlrd
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env

<SPAN class="comment token"># name of geodatabase</SPAN>
geoDB <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Path\To\filedb.gdb"</SPAN>

<SPAN class="comment token"># name of excel workbook</SPAN>
excelWB <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Path\To\workbook.xlsx"</SPAN>

<SPAN class="comment token"># set environment settings</SPAN>
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> geoDB

<SPAN class="comment token"># work happens here</SPAN>
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">new_table</SPAN><SPAN class="punctuation token">(</SPAN>dbTable<SPAN class="punctuation token">,</SPAN> dbFields<SPAN class="punctuation token">,</SPAN> geoDB<SPAN class="punctuation token">,</SPAN> excelWB<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># create the table</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"\nCreating table: "</SPAN> <SPAN class="operator token">+</SPAN> dbTable

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># set local variables</SPAN>
&nbsp;&nbsp;&nbsp; template <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
&nbsp;&nbsp;&nbsp; config_keyword <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Execute CreateTable</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>CreateTable_management<SPAN class="punctuation token">(</SPAN>geoDB<SPAN class="punctuation token">,</SPAN> dbTable<SPAN class="punctuation token">,</SPAN> template<SPAN class="punctuation token">,</SPAN> config_keyword<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># add the fields</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Adding fields: "</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> new_field <SPAN class="keyword token">in</SPAN> dbFields<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># add new field</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"\t"</SPAN> <SPAN class="operator token">+</SPAN> new_field<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># all fields using domains are non-nullable</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>new_field<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">==</SPAN> "<SPAN class="comment token">#"):</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nullable <SPAN class="operator token">=</SPAN> <SPAN class="string token">"NULLABLE"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; nullable <SPAN class="operator token">=</SPAN> <SPAN class="string token">"NON_NULLABLE"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># AddField_management (in_table, field_name, field_type, {field_precision}, {field_scale},</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {field_length}, {field_alias}, {field_is_nullable}, {field_is_required}, {field_domain})</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>dbTable<SPAN class="punctuation token">,</SPAN>new_field<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>new_field<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>"<SPAN class="comment token">#","#",</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; new_field<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>new_field<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>nullable<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"NON_REQUIRED"</SPAN><SPAN class="punctuation token">,</SPAN>new_field<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># read Excel workbook</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Adding data from Excel"</SPAN>
&nbsp;&nbsp;&nbsp; workbook <SPAN class="operator token">=</SPAN> xlrd<SPAN class="punctuation token">.</SPAN>open_workbook<SPAN class="punctuation token">(</SPAN>excelWB<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; worksheet <SPAN class="operator token">=</SPAN> workbook<SPAN class="punctuation token">.</SPAN>sheet_by_name<SPAN class="punctuation token">(</SPAN>dbTable<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; num_rows <SPAN class="operator token">=</SPAN> worksheet<SPAN class="punctuation token">.</SPAN>nrows <SPAN class="operator token">-</SPAN> <SPAN class="number token">1</SPAN>

&nbsp;&nbsp;&nbsp; fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>t<SPAN class="punctuation token">.</SPAN>encode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'utf8'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> t <SPAN class="keyword token">in</SPAN> worksheet<SPAN class="punctuation token">.</SPAN>row_values<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Open an InsertCursor</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Since workspace defined as geoDB, should only need table name</SPAN>
&nbsp;&nbsp;&nbsp; cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>dbTable<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; curr_row <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">while</SPAN> curr_row <SPAN class="operator token"><</SPAN> num_rows<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; curr_row <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># use standard encoding, not Unicode</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>dbTable <SPAN class="operator token">==</SPAN> <SPAN class="string token">"Domain2"</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># For issues with null fields in Excel, this seems to work</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; encoded <SPAN class="operator token">=</SPAN> worksheet<SPAN class="punctuation token">.</SPAN>row_values<SPAN class="punctuation token">(</SPAN>curr_row<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN> <SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; encoded <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>t<SPAN class="punctuation token">.</SPAN>encode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'utf8'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> t <SPAN class="keyword token">in</SPAN> worksheet<SPAN class="punctuation token">.</SPAN>row_values<SPAN class="punctuation token">(</SPAN>curr_row<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>encoded<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Delete cursor object</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> cursor


<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">"__main__"</SPAN><SPAN class="punctuation token">:</SPAN> 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># fields: [ 0:Name, 1:Type, 2:Size, 3:Alias, 4:Domain ]&nbsp; use "#" for blanks</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Use this for a simple domain</SPAN>
&nbsp;&nbsp;&nbsp; dbTable <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Domain1"</SPAN>
&nbsp;&nbsp;&nbsp; dbFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"CODE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"TEXT"</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="string token">"1"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CODE"</SPAN><SPAN class="punctuation token">,</SPAN> "<SPAN class="comment token">#"],</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"DESCRIPTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"TEXT"</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="string token">"4"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DESCRIPTION"</SPAN><SPAN class="punctuation token">,</SPAN> "<SPAN class="comment token">#"]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; new_table<SPAN class="punctuation token">(</SPAN>dbTable<SPAN class="punctuation token">,</SPAN>dbFields<SPAN class="punctuation token">,</SPAN>geoDB<SPAN class="punctuation token">,</SPAN>excelWB<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Use this format to add other fields to table</SPAN>
&nbsp;&nbsp;&nbsp; dbTable <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Domain2"</SPAN>
&nbsp;&nbsp;&nbsp; dbFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"CODE"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"TEXT"</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="string token">"4"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CODE"</SPAN><SPAN class="punctuation token">,</SPAN> "<SPAN class="comment token">#"],</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"DESCRIPTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"TEXT"</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; <SPAN class="string token">"8"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DESCRIPTION"</SPAN><SPAN class="punctuation token">,</SPAN> "<SPAN class="comment token">#"],</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"MyInt"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SMALLINTEGER"</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; "<SPAN class="comment token">#", "My Int", "#"],</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"MyDate"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"DATE"</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; "<SPAN class="comment token">#", "My Date", "#"],</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="punctuation token">[</SPAN><SPAN class="string token">"MyLong"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"INTEGER"</SPAN><SPAN class="punctuation token">,</SPAN>&nbsp; "<SPAN class="comment token">#", "My Long", "#"],</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; new_table<SPAN class="punctuation token">(</SPAN>dbTable<SPAN class="punctuation token">,</SPAN>dbFields<SPAN class="punctuation token">,</SPAN>geoDB<SPAN class="punctuation token">,</SPAN>excelWB<SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># ISSUES with MyInt and MyDate fields being null in Excel</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp;&nbsp; [u'?', u'?', u'', u'', '', u'', '']</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp;&nbsp; [u'?', u'?', u'', u'', 0.0, u'', 36892.0]</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Processing complete."</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

And to convert the tables to domains:

<SPAN class="comment token"># Description: Convert tables to domains</SPAN>

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env

<SPAN class="comment token"># Set the current workspace</SPAN>
geoDB <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Path\To\filedb.gdb"</SPAN> 

env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> geoDB

domains <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN> <SPAN class="string token">'Domain1'</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'Domain2'</SPAN> <SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># ONLY IF ALL TABLES ARE DOMAINS</SPAN>
<SPAN class="comment token"># domains = arcpy.ListTables()</SPAN>

<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Processing Domains:"</SPAN>

<SPAN class="keyword token">for</SPAN> domain <SPAN class="keyword token">in</SPAN> domains<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">"\t"</SPAN> <SPAN class="operator token">+</SPAN> domain
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># create domain</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># TableToDomain_management (in_table, code_field, description_field, in_workspace,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; domain_name, {domain_description}, {update_option REPLACE/APPEND})</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableToDomain_management<SPAN class="punctuation token">(</SPAN>domain<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"CODE"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"DESCRIPTION"</SPAN><SPAN class="punctuation token">,</SPAN>geoDB<SPAN class="punctuation token">,</SPAN>domain<SPAN class="punctuation token">,</SPAN>domain<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"REPLACE"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># resort domain list by CODE not DESCRIPTION</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># SortCodedValueDomain_management (in_workspace, domain_name, sort_by, sort_order)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SortCodedValueDomain_management<SPAN class="punctuation token">(</SPAN>geoDB<SPAN class="punctuation token">,</SPAN>domain<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"CODE"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"ASCENDING"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> <SPAN class="string token">"Done."</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Just another way among many, I suppose.

DanaNolan

Agreed; I have a file gdb called something like domainHelp, but I add/update some domains to this with Domain to table tool, and never use my Excel tables after bringing in domains. Although, occasionally we export domains to Excel tables so users can fill in attribute data with the domain as an Excel dropdown/validation list. Having domains in a database makes it easier to view, report, compare, and join to domains.

RebeccaStrauch__GISP

Nice tips.

Additional tip re: the _1. If you are archiving a copy into a different GDB where the domains differ, pay attention to the popup that show which domains will get the _1 added....then exit before the copy and change rename the current domains in the archive gdb first.

For example, when archiving, it says domain1 will be domain1_1, domain2 will be domain2_1 for those domains that changed. So I go into the archive gdb and rename the domains to domain1_2016, domain2_2017. (an archive before the new changes). This will adjust all the FCs that use those domains. Then the copy will not add the _1. Yes, you will have more domains but you also have a record of modifications thru the years, if necessary.

I hope that makes sense.

DanaNolan

Some tips from someone who has done a lot of this for SDSFIE. Make the code and description fields have the same names for all the tables; then you can use Geoprocessing Results to re-do each import with minimal changes. In Excel, you can make each domain a named range, with the name you will be using for the domain. This will make viewing and adding domains easier.

When you have the domains in, don't export feature classes into the database; import or copy/paste may avoid the domain getting a "_1" appended to the end of the domain, which creates 2 duplicates in your database. If the fields in the feature classes don't have domains assigned to them yet, this should not be a problem. Also, if you are using user names to access your database, choose a generic owner of the domains so they don't end up belonging to someone who leaves.

RebeccaStrauch__GISP

I use the table-to-domain command that pan_gis mentions, in a python script frequently (monthly or more) to create or update my ~90 domains. Although Excel will work and is easier sometimes to edit/modify on the user end, if you will need to be modifying the domains often, I highly recommend converting you Excel files and maintaining in a file GDB.

PanGIS

Hi,

have a look at this link

http://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/table-to-domain.htm

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.