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

Update Fields by Matching Fields

DevinUnderwood2

I want to know what is the best way via arcpy to update a feature field by referencing another features field.

I don't know if it is possible to use a updatecursor for 2 different features.

Would I just perform a temporary join and use arcpy like field calculator.

My Example of my cursor attempt.

searchcursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"BASE.ROADS_SG_ESC"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
updatecursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"escroads"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> searchcursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; RD20NAME <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">.</SPAN>getValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"RD20NAME"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> updatecursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">.</SPAN>getValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"NAME"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAME <SPAN class="operator token">=</SPAN> RD20NAME&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updatecursor<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>

Encontre mais publicações marcadas com

Accepted answers

All comments

ChadBunn1

Is it possible to modify this script so that a source field and an update field could have different field types if the values are the still the same? For example if my source and update fields have a value of '1234', but the source field is an integer and the update field is a string, can they still be used with list comprehension somehow? Or would it be better to just add a corresponding field with the matching field type to my update layer?

DevinUnderwood2

I would like to post it after I modify the code some more to use ListFields rather than manually hardcode the field names.

Also, one last section of tying in the max() value to the auto increment () function, which I haven't had a chance to test yet, but soon.

CCWeedcontrol

Can you post your modified code please.

DevinUnderwood2

This worked perfect. I only need to modify to only update features that have a RecID = 0

I used this and added code to generate a zipfile.

DevinUnderwood2

Thank you, I will try this out. My unique will be roadsegid

CCWeedcontrol

Here is a code i use for similar situations.

You need to have a uniqueID for both features layers.

from time import strftime&nbsp; 
print "Start script: " + strftime("%Y-%m-%d %H:%M:%S")&nbsp; 
import arcpy

#Transfer of Multiple Field Values between Feature Classes where there is a 1:1 Match between Field Sets
&nbsp; 
sourceFC = "Parcels"

#change OID@ to your uniqueID 
sourceFieldsList = ['OID@', 'Field_1','Field_2', 'Field_3','Field_4']&nbsp; # Your Source fields&nbsp; 
&nbsp; 
# Use list comprehension to build a dictionary from a da SearchCursor&nbsp; 
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)}&nbsp; 
&nbsp; 
updateFC = "Points"&nbsp; 
&nbsp; 
updateFieldsList = ['OID@', 'Field1', 'Field2', 'Field3', 'Field4']&nbsp; # your updateFC fields
&nbsp; 
with arcpy.da.UpdateCursor(updateFC, updateFieldsList) as updateRows:&nbsp; 
&nbsp;&nbsp;&nbsp; for updateRow in updateRows:&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # store the Join value of the row being updated in a keyValue variable&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keyValue = updateRow[0]&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # verify that the keyValue is in the Dictionary&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if keyValue in valueDict:&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # transfer the values stored under the keyValue from the dictionary to the updated fields.&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for n in range (1,len(sourceFieldsList)):&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updateRow<N> = valueDict[keyValue][n-1]&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updateRows.updateRow(updateRow)&nbsp; 
&nbsp; 
del valueDict&nbsp; 
&nbsp; 
print "Finished script: " + strftime("%Y-%m-%d %H:%M:%S")&nbsp; 
print "Finished script: " + strftime("%Y-%m-%d %H:%M:%S")
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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></N>

DevinUnderwood2

Thank you for the suggestions.

I will look into the Data Access module as an alternative to old cursors.

Good advice on Calculate field tool and a join.

I will see what works for me. As I am trying to copy attributes from one field of a feature class to another feature class.

However, I need to match the feature classes fields that have different field names. All of this done via a python script.

JoshuaBixby

For starters, look into using the Data Access (What is the data access module?—Help | ArcGIS Desktop ) cursors instead of the original/old cursors. The DA cursors perform much better and are a bit more Pythonic.

Your code snippet confuses me more than helps me understand what you are trying to do. Code aside, what are you trying to do?

DanPatterson_Retired

you could join, then update a field... you could do this with cursors, but most people ignore simple field calculations can be accessed through the Calculate Field tool and its associated script code at the bottom

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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