Select to view content in your preferred language

SQL Table to Domain

912
4
Jump to solution
08-22-2023 02:38 PM
vijaybadugu
Frequent Contributor

We have plenty of Non Spatial SQL Tables with two fields one is code and other is description with unique 100s of records. which is used in other applications. Is there any way to use same table as domain and assign them to fields in ArcGIS Pro? 

1 Solution

Accepted Solutions
MarceloMarques
Esri Regular Contributor

You need to convert your table into a Geodatabase Domain.
Table To Domain (Data Management)—ArcGIS Pro | Documentation

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |

View solution in original post

0 Kudos
4 Replies
MarceloMarques
Esri Regular Contributor

You need to convert your table into a Geodatabase Domain.
Table To Domain (Data Management)—ArcGIS Pro | Documentation

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |
0 Kudos
vijaybadugu
Frequent Contributor

Table to domain tool is not accessing SQL tables ?

0 Kudos
clt_cabq
Frequent Contributor

in ArcGIS Pro search for Table to Domain in the geoprocessing tools, this should do what you are wanting. This will create a domain in your geodatabase that you can then assign to the appropriate table/field. You may have to work with your GIS data to make sure the existing values correspond exactly to what is in your new domain. 

0 Kudos
vijaybadugu
Frequent Contributor

Thanks a lot for your answers. I just did converting table to csv and used same tool to convent to domain

0 Kudos