I 'm trying to run my script but I get this error message. Here is the code. * import arcpy * from arcpy import env * env.workspace = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp' * crbuff = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp\CRojaPBuff' * insumo = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp\Insumo' * * # Add field to insumo. * arcpy.AddField_management(insumo, "test", "TEXT", "", "", "50", "", "NULLABLE", "NON_REQUIRED", "") * * # Make a layer from crbuff to get the select by location works. * arcpy.MakeFeatureLayer_management (crbuff, 'crbuff_layer') * arcpy.MakeFeatureLayer_management (insumo, 'insumo_layer') * * # loop with cursor * cursor = arcpy.SearchCursor(crbuff) * field = "Lab" # Specify the field in the loop. * for row in cursor: * print (row.getValue(field)) * arcpy.SelectLayerByLocation_management('insumo_layer', "HAVE_THEIR_CENTER_IN", 'crbuff_layer', "", "NEW_SELECTION", "NOT_INVERT") * # Process: Calculate Field. * cursorIn = arcpy.UpdateCursor('insumo_layer') * for row in cursorIn: * row.setValue("test", (row.getValue(field)) * cursorIn.updateRow(row) * * # Process: Summary Statistics. * intable = r'D:\Eric\Ejercicio\shp\Insumo.shp' * outtable = r'D:\Eric\Ejercicio\shp' * arcpy.Statistics_analysis(intable, outtable + "stats.dbf", "POB1 SUM;POB8 SUM;POB11 SUM;POB14 SUM;POB15 SUM;POB16 SUM;POB24 SUM;POB31 SUM;POB57 SUM;MIG7 SUM;INDI1 SUM;DISC1 SUM;DISC4 SUM;DISC5 SUM;DISC6 SUM;ECO1 SUM;ECO4 SUM;ECO25 SUM;ECO28 SUM;SALUD1 SUM;SALUD2 SUM;SALUD3 SUM;SALUD4 SUM;SALUD5 SUM;SALUD6 SUM", "test") I need help ...

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

I get invalid syntax

G__EricCastillo_Morales

I 'm trying to run my script but I get this error message.

Here is the code.

import arcpy
from arcpy import env
env.workspace = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp'
crbuff = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp\CRojaPBuff'
insumo = r'D:\Eric\Ejercicio\shp\ejercicioTest.gdb\shp\Insumo'
# Add field to insumo.
arcpy.AddField_management(insumo, "test", "TEXT", "", "", "50", "", "NULLABLE", "NON_REQUIRED", "")
# Make a layer from crbuff to get the select by location works.
arcpy.MakeFeatureLayer_management (crbuff, 'crbuff_layer')
arcpy.MakeFeatureLayer_management (insumo, 'insumo_layer')
# loop with cursor
cursor = arcpy.SearchCursor(crbuff)
field = "Lab" # Specify the field in the loop.
for row in cursor:
print (row.getValue(field))
arcpy.SelectLayerByLocation_management('insumo_layer', "HAVE_THEIR_CENTER_IN", 'crbuff_layer', "", "NEW_SELECTION", "NOT_INVERT")
# Process: Calculate Field.
cursorIn = arcpy.UpdateCursor('insumo_layer')
for row in cursorIn:
row.setValue("test", (row.getValue(field))
cursorIn.updateRow(row)
# Process: Summary Statistics.
intable = r'D:\Eric\Ejercicio\shp\Insumo.shp'
outtable = r'D:\Eric\Ejercicio\shp'
arcpy.Statistics_analysis(intable, outtable + "stats.dbf", "POB1 SUM;POB8 SUM;POB11 SUM;POB14 SUM;POB15 SUM;POB16 SUM;POB24 SUM;POB31 SUM;POB57 SUM;MIG7 SUM;INDI1 SUM;DISC1 SUM;DISC4 SUM;DISC5 SUM;DISC6 SUM;ECO1 SUM;ECO4 SUM;ECO25 SUM;ECO28 SUM;SALUD1 SUM;SALUD2 SUM;SALUD3 SUM;SALUD4 SUM;SALUD5 SUM;SALUD6 SUM", "test")

I need help ...

Vind meer berichten getagd met

Accepted answers

Luke_Pinner

Extra bracket in 23.

row.setValue("test", (row.getValue(field))

Change it to: row.setValue("test", row.getValue(field))

Also, consider using arcpy.da.Search/InsertCursor instead of arcpy.Search/InsertCursor, the new (at 10.1) cursors are much faster and have easier and more "pythonic" syntax.

All comments

G__EricCastillo_Morales

I decided to put this in another question. Thanks.

G__EricCastillo_Morales

I'm trying to write in test field from some layer based on iterate feature selction. I get succes using model builder but I'm fail when I try with my own code.

The process with MB.

The code and error.

Any suggestions?

G__EricCastillo_Morales

Thanks Luke. That corrects the syntax problem. Now I get a new problem.

Traceback (most recent call last):

File "D:\Eric\Ejercicio\script\again.py", line 23, in <module>

row.setValue("test", row.getValue(field))

File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\arcobjects\arcobjects.py", line 1096, in getValue

return convertArcObjectToPythonObject(self._arc_object.GetValue(*gp_fixargs(args)))

RuntimeError: ERROR 999999: Error executing function.

I'm trying to write in "test" field from insumo layer the value field from the select by location features loop of crbuff layer.

XanderBakker

In most cases I would recommend using the da cursors, since they are much faster. I can only think of a few use cases for the "old" cursors like accessing the attribute table of the integer raster data set or when using ArcGIS 10.0. There is some more info here: Accessing data using cursors—Help | ArcGIS for Desktop

AdrianWelsh

Luke, nice catch. Also, how do you know when to use arcpy.da.SearchCursor versus using arcpy.SearchCursor?

Luke_Pinner

Extra bracket in 23.

row.setValue("test", (row.getValue(field))

Change it to: row.setValue("test", row.getValue(field))

Also, consider using arcpy.da.Search/InsertCursor instead of arcpy.Search/InsertCursor, the new (at 10.1) cursors are much faster and have easier and more "pythonic" syntax.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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