topic Re: SearchCursor row methods missing? in Python Questions

SearchCursor row methods missing?

mmann1123 — Wed, 14 Sep 2022 13:59:44 GMT

Using arcpy 3.0 - all the row methods described here appear to be missing for a feature layer in a file geodatabase??

For instance the only printed methods for the following

with arcpy.da.SearchCursor(in_table="Crashes_in_DC", field_names="Tot_PedBik",) as cursor: for row in cursor: print(dir(row))

are

'count', 'index'

with arcpy.da.SearchCursor(in_table="Crashes_in_DC", field_names="Tot_PedBik",) as cursor: for row in cursor: print(row.getValue('Tot_PedBik'))

returns:

AttributeError: 'tuple' object has no attribute 'getValue'

Re: SearchCursor row methods missing?

mmann1123 — Wed, 14 Sep 2022 14:55:39 GMT

How do you open a bug report for this kind of stuff?

Re: SearchCursor row methods missing?

BlakeTerhune — Wed, 14 Sep 2022 14:59:53 GMT

That documentation is referring to the legacy cursor, but your code sample is using the new "data access" cursor. I'm surprised the legacy cursor documentation isn't more clearly identified here. The new "da" cursors returns the row data as a Python tuple (instead of a row object), which only has the methods built in for a tuple. To access data in a particular field, use the index of the field.

with arcpy.da.SearchCursor(in_table="Crashes_in_DC", field_names=["Tot_PedBik"]) as cursor: for row in cursor: print(row[0])

Here, it's using index 0 because that's the index of Tot_PedBik in the field_names parameter (which should be a list, even with one field).

Re: SearchCursor row methods missing?

mmann1123 — Wed, 14 Sep 2022 15:54:56 GMT

Ha... Yeah that's totally unclear from the docs but makes sense.

Re: SearchCursor row methods missing?

BlakeTerhune — Wed, 14 Sep 2022 16:12:58 GMT

There's a feedback option at the bottom of all documentation pages. I already submitted my feedback on this, but you're welcome to submit your feedback too.

Re: SearchCursor row methods missing?

Luke_Pinner — Fri, 16 Sep 2022 09:00:10 GMT

If you want to use field names to refer to row values instead of tuple indexes, you can convert the row to a dict:

with arcpy.da.SearchCursor(feature_class, ["list", "of", "field", "names"]) as rows: fields = rows.fields for row in rows: row = dict(zip(fields, row)) print(row['SOMEFIELD'], row["ANOTHERFIELD"])