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

Fastest way to get number of rows in a da.SearchCursor

JohnDye

Anyone know of a quick way to count the number of records returned by a da.SearchCursor with a where_clause applied?

with arcpy.da.SearchCursor(MyLayer, "SHAPE@", SuperDuperAwesomeQuery) as rows:
    # how do I figured out how many records are in rows without iterating through rows???

Finde mehr Beiträge mit dem Tag

Accepted answers

JamesCrandall

arcgis desktop - Fastest way to count the number of features in a feature class? - Geographic Information Systems Stack …

All comments

JamesCrandall

arcgis desktop - Fastest way to count the number of features in a feature class? - Geographic Information Systems Stack …

JamesCrandall

Alternative method (I don't know it this is faster):

sql = "ObjectId=1"
_dfsource = r'H:\Documents\ArcGIS\Default.gdb\L8_Parcel'
_numparr = arcpy.da.FeatureClassToNumPyArray(_dfsource, ["ObjectId"], sql)
rowcount = len(_numparr)
print rowcount

JohnDye

Thanks James,

I was trying to avoid making a query table but it seems that's the the quickest approach that doesn't require iterating. However using the MakeQueryTable tool did require spinning up the geoprocessor which took some time so in the end I actually found it was still faster to just iterate and count the rows.

with arcpy.da.SearchCursor(FeatureLayer, "SHAPE@", SuperDuperAwesomeQuery) as rows:
    rowCount = 0
    for row in rows:
        rowCount = rowCount + 1
    print rowCount
    del rows

ChrisPedrezuela

row count = len(list(i for i in arcpy.da.SearchCursor(fc, fields, query)))

JohnDye

Niiice. So obvious once I saw it. Sorry, I already gave the answer to James.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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