Hello! I need to add unique ID's to a specific field in multiple feature classes that are inside a geodatabase. I have created the code below but it is not working. When I run, it I get the following error message: Traceback (most recent call last): File "D:/APRX_MXDS/USA_Parcels_2019_Project/Scripts/UniqueID_2.py", line 15, in for row in cursor: RuntimeError: A column was specified that does not exist. Process finished with exit code 1 The error is referring to a column that does not exist. Is column the same as field? The field "UNIQUE_ID_PYTHON" was created before running the code, and so it should run. import arcpy import uuid # Script to add unique Id's featureGDB = r "D:\APRX_MXDS\USA_Parcels_2019_Project\test_featureclasses.gdb" arcpy . env . workspace = featureGDB arcpy . env . overwriteOutput = True List_fc = arcpy . ListFeatureClasses ( "*single" ) # get a list of feature classes that end with the word single. List = [ "UNIQUE_ID_PYTHON" ] # Field where I want to add the unique ids for fc in List_fc : # loop through each feature class in the list and add unique ID to the specified field. with arcpy . da . UpdateCursor ( fc , List ) as cursor : for row in cursor : row [ 0 ] = '{' + str ( uuid . uuid4 ( ) ) + '}' cursor . updateRow ( row ) Not sure how to fix this. Can somebody guide me ? Thank you

Is column the same as field? Yes. To verify the existence of a given field in your feature class, use the arcpy.ListFields() method. Just be aware that this method returns a list of field objects so as you iterate through the list you'll need to access the particular object property: for field in arcpy . ListFields ( yourFeatureClass ) : print ( f '{field.name} {field.type}' ) Another couple of questions: when you added the field Unique_ID_Python did you add it as a guid type? Also, are you sure you want to use a guid as the id and not something else? For example: Create Database Sequence—Data Management toolbox | Documentation Also, not sure what you are trying to get done with this line: row [ 0 ] = '{' + str ( uuid . uuid4 ( ) ) + '}'

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

Add unique id's to multiple feature classes using update cursor

NataliaGutierrez1

Hello!

I need to add unique ID's to a specific field in multiple feature classes that are inside a geodatabase.

I have created the code below but it is not working.

When I run, it I get the following error message:
            Traceback (most recent call last):
            File "D:/APRX_MXDS/USA_Parcels_2019_Project/Scripts/UniqueID_2.py", line 15, in <module>
            for row in cursor:
            RuntimeError: A column was specified that does not exist.

Process finished with exit code 1

The error is referring to a column that does not exist.

Is column the same as field?

The field "UNIQUE_ID_PYTHON" was created before running the code, and so it should run.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> uuid

<SPAN class="comment token"># Script to add unique Id's</SPAN>
featureGDB <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"D:\APRX_MXDS\USA_Parcels_2019_Project\test_featureclasses.gdb"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> featureGDB
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

List_fc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"*single"</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># get a list of feature classes that end with the word single.</SPAN>
List <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"UNIQUE_ID_PYTHON"</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># Field where I want to add the unique ids </SPAN>

<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> List_fc<SPAN class="punctuation token">:</SPAN>  <SPAN class="comment token"># loop through each feature class in the list and add unique ID to the specified field.</SPAN>
    <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> List<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>  
        <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
              row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'{'</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>uuid<SPAN class="punctuation token">.</SPAN>uuid4<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'}'</SPAN>
              cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</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>

Not sure how to fix this.

Can somebody guide me ?

Thank you

Encuentra más publicaciones etiquetadas con

Accepted answers

JoeBorgione

Is column the same as field? Yes.

To verify the existence of a given field in your feature class, use the arcpy.ListFields() method. Just be aware that this method returns a list of field objects so as you iterate through the list you'll need to access the particular object property:

<SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>yourFeatureClass<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
   <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>f<SPAN class="string token">'{field.name}  {field.type}'</SPAN><SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Another couple of questions: when you added the field Unique_ID_Python did you add it as a guid type? Also, are you sure you want to use a guid as the id and not something else? For example: Create Database Sequence—Data Management toolbox | Documentation

Also, not sure what you are trying to get done with this line:

row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'{'</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>uuid<SPAN class="punctuation token">.</SPAN>uuid4<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'}'</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

NataliaGutierrez1

thank you for the explanation!

JoeBorgione

There is a significant difference in a guid type of field and adding Global IDs; the former is like any other attribute, where you have control over the value. Where as the latter are maintained by the geodatabase. Your guid fields should transfer between databases just fine but you need to jump through a hoop or two to transfer/preserve Global IDs....

NataliaGutierrez1

Thank you Joe!

The problem was with the data type of my field.

I did not know that I had to set it as GUID.

Once I changed it my code ran without errors.

JoeBorgione

Just took a look at How To: Calculate unique identifier values similar to Global IDs so that is what your line 15 is doing. May I suggest that rather than an update cursor, just use the calculate field method instead

JoeBorgione

Is column the same as field? Yes.

<SPAN class="keyword token">for</SPAN> field <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>yourFeatureClass<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
   <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>f<SPAN class="string token">'{field.name}  {field.type}'</SPAN><SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Also, not sure what you are trying to get done with this line:

row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'{'</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>uuid<SPAN class="punctuation token">.</SPAN>uuid4<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'}'</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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