SQL Table to Domain

vijaybadugu · ‎08-22-2023

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?

MarceloMarques · ‎08-22-2023

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 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

MarceloMarques · ‎08-22-2023

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 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 |

vijaybadugu · ‎08-22-2023

Table to domain tool is not accessing SQL tables ?

clt_cabq · ‎08-22-2023

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.

vijaybadugu · ‎08-24-2023

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