I need to find duplicates by comparing to fields. I am not sure how to accomplish this so any help would be appreciated. I have two fields that i need to compare, Account and Acres1 fields. if there is not duplicate then put a "0" in the duplicate field for that record. The end scenario i need something like this. Account Acres Duplicate D54963 12.43 0 D54963 12.43 1 ( duplicate ) D54963 12.43 2 ( duplicate ) D45879 26.32 0 ( no duplicate ) D45879 17.32 0 ( no duplicate ) D36540 17.51 0 D36540 17.51 1 ( duplicate ) D36540 17.51 2 ( duplicate ) D36540 17.51 3 ( duplicate ) I have the following code but it only checks one field (Account) and it add a number to all attributes if there is a double not exactly what i need. import arcpy infeature = "C:/Temp/Test_FINAL_Erase" field_in = "Account" field_out = "COUNT_" + field_in #create the field for the count values arcpy . AddField_management ( infeature , field_out , "SHORT" ) #creating the list with all the values in the field, including duplicates lista = [ ] cursor1 = arcpy . SearchCursor ( infeature ) for row in cursor1 : i = row . getValue ( field_in ) lista . append ( i ) del cursor1 , row #updating the count field with the number on occurrences of field_in values #in the previously created list cursor2 = arcpy . UpdateCursor ( infeature ) for row in cursor2 : i = row . getValue ( field_in ) occ = lista . count ( i ) row . setValue ( field_out , occ ) cursor2 . updateRow ( row ) del cursor2 , row print ( "Done." )

Does the following work: from collections import defaultdict fc = # path to feature class dups = defaultdict ( int ) with arcpy . da . UpdateCursor ( fc , [ "Account" , "Acres" , "Duplicate" ] , sql_clause = ( None , "ORDER BY Account, Acres" ) ) as cur : for acct , acres , _ in cur : dups [ ( acct , acres ) ] += 1 cnt = dups [ ( acct , acres ) ] - 1 cur . updateRow ( [ acct , acres , cnt ] )

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

Find duplicate by comparing two fields.

CCWeedcontrol

I need to find duplicates by comparing to fields. I am not sure how to accomplish this so any help would be appreciated.

I have two fields that i need to compare, Account and Acres1 fields. if there is not duplicate then put a "0" in the duplicate field for that record.

The end scenario i need something like this.

Account&nbsp;&nbsp;&nbsp; Acres&nbsp;&nbsp; Duplicate
D54963&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">12.43</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">0</SPAN>
D54963&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">12.43</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">1</SPAN> <SPAN class="punctuation token">(</SPAN>duplicate<SPAN class="punctuation token">)</SPAN>
D54963&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">12.43</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">2</SPAN> <SPAN class="punctuation token">(</SPAN>duplicate<SPAN class="punctuation token">)</SPAN>

D45879&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">26.32</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">(</SPAN>no duplicate<SPAN class="punctuation token">)</SPAN>
D45879&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">17.32</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">0</SPAN> <SPAN class="punctuation token">(</SPAN>no duplicate<SPAN class="punctuation token">)</SPAN>

D36540&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">17.51</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">0</SPAN>
D36540&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">17.51</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">1</SPAN> <SPAN class="punctuation token">(</SPAN>duplicate<SPAN class="punctuation token">)</SPAN>
D36540&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">17.51</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">2</SPAN> <SPAN class="punctuation token">(</SPAN>duplicate<SPAN class="punctuation token">)</SPAN>
D36540&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="number token">17.51</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="number token">3</SPAN>‍‍‍‍‍‍‍‍‍ <SPAN class="punctuation token">(</SPAN>duplicate<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>

I have the following code but it only checks one field (Account) and it add a number to all attributes if there is a double not exactly what i need.

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


infeature <SPAN class="operator token">=</SPAN><SPAN class="string token">"C:/Temp/Test_FINAL_Erase"</SPAN>
field_in <SPAN class="operator token">=</SPAN><SPAN class="string token">"Account"</SPAN>
field_out <SPAN class="operator token">=</SPAN><SPAN class="string token">"COUNT_"</SPAN><SPAN class="operator token">+</SPAN>field_in

<SPAN class="comment token">#create the field for the count values</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>infeature<SPAN class="punctuation token">,</SPAN>field_out<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"SHORT"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#creating the list with all the values in the field, including duplicates</SPAN>
lista<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
cursor1<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>infeature<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor1<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; i<SPAN class="operator token">=</SPAN>row<SPAN class="punctuation token">.</SPAN>getValue<SPAN class="punctuation token">(</SPAN>field_in<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; lista<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> cursor1<SPAN class="punctuation token">,</SPAN> row

<SPAN class="comment token">#updating the count field with the number on occurrences of field_in values</SPAN>
<SPAN class="comment token">#in the previously created list</SPAN>
cursor2<SPAN class="operator token">=</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>infeature<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor2<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; i<SPAN class="operator token">=</SPAN>row<SPAN class="punctuation token">.</SPAN>getValue<SPAN class="punctuation token">(</SPAN>field_in<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; occ<SPAN class="operator token">=</SPAN>lista<SPAN class="punctuation token">.</SPAN>count<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN>field_out<SPAN class="punctuation token">,</SPAN>occ<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; cursor2<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> cursor2<SPAN class="punctuation token">,</SPAN> row
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Done."</SPAN><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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Trouver plus de publications taguées avec

Accepted answers

bixb0012

Does the following work:

<SPAN class="keyword token">from</SPAN> collections <SPAN class="keyword token">import</SPAN> defaultdict

fc <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to feature class</SPAN>

dups <SPAN class="operator token">=</SPAN> defaultdict<SPAN class="punctuation token">(</SPAN>int<SPAN class="punctuation token">)</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>
&nbsp;&nbsp;&nbsp; fc<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Account"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Acres"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Duplicate"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; sql_clause<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ORDER BY Account, Acres"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> acct<SPAN class="punctuation token">,</SPAN> acres<SPAN class="punctuation token">,</SPAN> _ <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dups<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN>acct<SPAN class="punctuation token">,</SPAN> acres<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt <SPAN class="operator token">=</SPAN> dups<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN>acct<SPAN class="punctuation token">,</SPAN> acres<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">-</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cur<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>acct<SPAN class="punctuation token">,</SPAN> acres<SPAN class="punctuation token">,</SPAN> cnt<SPAN class="punctuation token">]</SPAN><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>

All comments

CCWeedcontrol

Joshua,

Ya i think it worked. Thank you, you saved me a lot of time!

Thanks!

bixb0012

Does the following work:

<SPAN class="keyword token">from</SPAN> collections <SPAN class="keyword token">import</SPAN> defaultdict

fc <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to feature class</SPAN>

dups <SPAN class="operator token">=</SPAN> defaultdict<SPAN class="punctuation token">(</SPAN>int<SPAN class="punctuation token">)</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>
&nbsp;&nbsp;&nbsp; fc<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Account"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Acres"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Duplicate"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp; sql_clause<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ORDER BY Account, Acres"</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> acct<SPAN class="punctuation token">,</SPAN> acres<SPAN class="punctuation token">,</SPAN> _ <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dups<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN>acct<SPAN class="punctuation token">,</SPAN> acres<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cnt <SPAN class="operator token">=</SPAN> dups<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">(</SPAN>acct<SPAN class="punctuation token">,</SPAN> acres<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">-</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cur<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>acct<SPAN class="punctuation token">,</SPAN> acres<SPAN class="punctuation token">,</SPAN> cnt<SPAN class="punctuation token">]</SPAN><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>

JamesCrandall

Not a complete solution but might be something to look into. numpy and pandas have much better grouping functions. Challenge is to get the result back into your arcpy.da cursor and update the desired column.

nparr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>FeatureClassToNumPyArray<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Account"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Acres"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
pdarr <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN>nparr<SPAN class="punctuation token">)</SPAN>
counts <SPAN class="operator token">=</SPAN> pdarr<SPAN class="punctuation token">.</SPAN>groupby<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"Account"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Acres"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>size<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
pddups <SPAN class="operator token">=</SPAN> pd<SPAN class="punctuation token">.</SPAN>DataFrame<SPAN class="punctuation token">(</SPAN>counts<SPAN class="punctuation token">,</SPAN> columns <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'size'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
pddups <SPAN class="operator token">=</SPAN> pddups<SPAN class="punctuation token">[</SPAN>pddups<SPAN class="punctuation token">.</SPAN>size<SPAN class="operator token">></SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">print</SPAN> pddups<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RandyBurton

In your code in line 11:

&nbsp;&nbsp; <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> <SPAN class="string token">"Count"</SPAN><SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> ucur<SPAN class="punctuation token">:</SPAN>
‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

"Count" is an SQL reserved word and should not be used as a field/column name.

CCWeedcontrol

Actually i thought it was your code that that Count_Acres1 but it wasn't. The code you posted ran but did not don't do anything.

What i have

<SPAN class="comment token"># Import the arcpy module&nbsp; </SPAN>
<SPAN class="keyword token">import</SPAN> arcpy&nbsp; 
&nbsp; 

fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:Temp/Test_Erase'</SPAN>
fields<SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ACCOUNT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Acres1"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fields<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>
&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="operator token">==</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"OBJECTID="</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp; <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> <SPAN class="string token">"Count"</SPAN><SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> ucur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> urow <SPAN class="keyword token">in</SPAN> ucur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; urow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN><SPAN class="number token">0</SPAN>
&nbsp;&nbsp;&nbsp; ucur<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>urow<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Done."</SPAN><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>

Dup.png

CCWeedcontrol

Joshua yes that is a possibility. Sorry i should have mentioned that.

JamesCrandall

fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'H:\Documents\ArcGIS\Default.gdb\MyFeatureClass'</SPAN>
fields<SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Field1"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Field2"</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fields<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>
&nbsp; <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="operator token">==</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp; sql <SPAN class="operator token">=</SPAN> <SPAN class="string token">"OBJECTID="</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp; <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> <SPAN class="string token">"Field3"</SPAN><SPAN class="punctuation token">,</SPAN> sql<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> ucur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> urow <SPAN class="keyword token">in</SPAN> ucur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; urow<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN><SPAN class="number token">0</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; ucur<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>urow<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>

JayantaPoddar

Not an answer to your question, but sometimes the floating values might to be difficult to select using "=" operator, because

ArcGIS might interpret a floating value of 12.43 as 12.429999 or 12.430001.

bixb0012

Is it possible for a given account number to have multiple, different acre values? For example, could D54963 have 12.43 acres and some other acre value?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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