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

arcpy search/update cursor not working

MarkWisniewski

Im running my script in ArcGIS 10.2 and the dialog window says completed, but the empty fields in the 'SoilsType' row of the 'mSoils' Feature Class aren't getting populated with the values from the 'SoilsType' field from the 'mLanduse' Feature Class.

<SPAN class="pln">cur </SPAN><SPAN class="pun">=</SPAN><SPAN class="pln"> arcpy</SPAN><SPAN class="pun">.</SPAN><SPAN class="pln">da</SPAN><SPAN class="pun">.</SPAN><SPAN class="typ">SearchCursor</SPAN><SPAN class="pun">(</SPAN><SPAN class="pln">mLanduse</SPAN><SPAN class="pun">,</SPAN><SPAN class="pln"> lField</SPAN><SPAN class="pun">)</SPAN><SPAN class="pln">
</SPAN><SPAN class="kwd">for</SPAN><SPAN class="pln"> row </SPAN><SPAN class="kwd">in</SPAN><SPAN class="pln"> cur</SPAN><SPAN class="pun">:</SPAN><SPAN class="pln">
 cur2 </SPAN><SPAN class="pun">=</SPAN><SPAN class="pln"> arcpy</SPAN><SPAN class="pun">.</SPAN><SPAN class="pln">da</SPAN><SPAN class="pun">.</SPAN><SPAN class="typ">UpdateCursor</SPAN><SPAN class="pun">(</SPAN><SPAN class="pln">mSoils</SPAN><SPAN class="pun">,</SPAN><SPAN class="pln"> sField</SPAN><SPAN class="pun">)</SPAN><SPAN class="pln">
 </SPAN><SPAN class="kwd">for</SPAN><SPAN class="pln"> row2 </SPAN><SPAN class="kwd">in</SPAN><SPAN class="pln"> cur2</SPAN><SPAN class="pun">:</SPAN><SPAN class="pln">
&nbsp;&nbsp; </SPAN><SPAN class="kwd">if</SPAN><SPAN class="pln"> row2</SPAN><SPAN class="pun">[</SPAN><SPAN class="lit">0</SPAN><SPAN class="pun">]</SPAN><SPAN class="pln"> </SPAN><SPAN class="pun">==</SPAN><SPAN class="pln"> </SPAN><SPAN class="str">''</SPAN><SPAN class="pln"> </SPAN><SPAN class="kwd">or</SPAN><SPAN class="pln"> row2</SPAN><SPAN class="pun">[</SPAN><SPAN class="lit">0</SPAN><SPAN class="pun">]</SPAN><SPAN class="pln"> </SPAN><SPAN class="kwd">is</SPAN><SPAN class="pln"> </SPAN><SPAN class="kwd">None</SPAN><SPAN class="pun">:</SPAN><SPAN class="pln">
&nbsp; row2</SPAN><SPAN class="pun">[</SPAN><SPAN class="lit">0</SPAN><SPAN class="pun">]</SPAN><SPAN class="pln"> </SPAN><SPAN class="pun">=</SPAN><SPAN class="pln"> lField
&nbsp; cur2</SPAN><SPAN class="pun">.</SPAN><SPAN class="pln">updateRow</SPAN><SPAN class="pun">(</SPAN><SPAN class="pln">row2</SPAN><SPAN class="pun">)</SPAN>

Najděte více příspěvků označených jako

Accepted answers

jskinner

Hi Ernst,

It looks like you are trying to update the Soils feature class that have no value for the SoilType with values from a LandUse polygon. Instead of using an updateCursor, I would recommend using the Spatial Join tool. You can then join the output from this tool to the Soils feature class, and update the empty rows using the Field Calculator.

All comments

MarkWisniewski

Isn't this the spatial overlay? ;

# Make a layer and select soils which fall within the Landuse polygon  arcpy.SelectLayerByLocation_management('Soils_lyr', 'within', Landuse)

I have ArcGIS Advanced, but I would like to do this in python. I have been referring to this website;

3.2.4 Retrieving records using a spatial query | GEOG 485: GIS Programming and Automation

curtvprice

The issue I'm seeing here is you seem to be trying to transfer land use variables over to your blank soil polygons, but you're not doing any spatial overlay in your script, unless I'm missing something. That's what Jake was getting at by suggesting the Join By Location tool.

If you have an ArcGIS Advanced ("ArcInfo") license you could probably solve this problem best with the Identity tool followed by some field calculations.

MarkWisniewski

Curtis,

I am not seeing any NULL values, and when I do a Definition Query and select Get Unique values '' is the first option, so only blank fields are present.

I am not currently populating the LandUse variable, do I need another MakeFeatureLayer for this?

curtvprice

Are you sure your soil types contain blanks or null? (The geodatabase supports null values, unlike shapefiles.)

This query would select both blanks and those that have null values:

query = "SoilType = '' or SoilType IS NULL"

But I think your workflow is wrong, including your use of arcpy.UpdateCursor, the construct you are using with row[0] etc. is what you would use with arcpy.da.UpdateCursor, not the old (10.0) arcpy.UpdateCursor method. Where is the variable LandUse being populated?

I would go with Jake's suggestion.

MarkWisniewski

Hi Jake,

You are correct with my workflow, except the SoilType Field has values in the Landuse Polygon. My query is trying to retrieve just the blank fields in the SoilType Field in the Soils Polygon. Is my workflow wrong?

jskinner

Hi Ernst,

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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