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 Cursor not updating field with value

RoyHewitt

I'm writing a script for field staff that clips all wetlands in a watershed, calculates area (hectares) and multiples by a sampling factor to see how many hectares need to be sample

Here is a sample of the update cursor part of the code:

         rows = arcpy.UpdateCursor(newWetland) row = rows.next()  while row:      if row.getValue(wetlandTypeField) == 'Estuarine and Marine Wetland':           totalHectares = row.getValue(areaField)           sampleArea = (totalHectares * .25) # Sample 25% of this type           row.setValue(sampleField, sampleArea)           rows.updateRow(row)           row = rows.next()      elif row.getValue(wetlandTypeField) == 'Freshwater Emergent Wetland':           totalHectares = row.getValue(areaField)           sampleArea = (totalHectares * .25) # Sample 25% of this type           row.setValue(sampleField, sampleArea)           rows.updateRow(row)           row = rows.next()

There are several more elif blocks for each wetland type in the dataset.

When I type in the python window:

print sampleArea

I get the correct area, however, it does not update the row. The help files indicate that the second parameter of the row.setValue() method is supposed to be an object. Could that be the problem?

Any help would be appreciated.
Roy

Trouver plus de publications taguées avec

Accepted answers

DanPatterson_Retired

have you tried to use the "for row in rows:" syntax as shown in the online help for updaterow?
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002z0000001q000000

All comments

DanPatterson_Retired

The table doesn't get refreshed. Run scripts etc, then open the table, don't expect updates unless you are using the field calculator directly.

RoyHewitt

I rewrote the code to use the for loop. I got the same problem at first (all null values in the attribute table), I went into field calculator and closed it without entering any code and VOILA, the correct values were in the table.

I'm not sure if they would have been had I gone into the field calculator after running the while loop or not, but success none the less.

Is there any "refresh" method that would fix this??

Thanks again!

DanPatterson_Retired

have you tried to use the "for row in rows:" syntax as shown in the online help for updaterow?
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002z0000001q000000

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.