I have tested variations with and without query, please see the code for query version, and final measured results below: query_features(feature_class, query):Ĭount = len(list(i for i in arcpy.da.SearchCursor(feature_class,, query)))Īrcpy.AddMessage("Method 1 finished in features". Opposite to results in other answer, my times for arcpy.MakeTableView_management and arcpy.da.SearchCursor within ArcMap are same same. I have tested solution from answer above and on my real world data the difference is negligible. I am looking to rebuild some of our function definitions with this module as it is more flexible than a MakeTableView + GetCount methodology. I am not at all dissatisfied with the results, however, the DataAccess module is being used extensively in our GIS development circle. The SearchCursor will indefinitely crawl. Print "Finished in %s seconds" % (EndTime2 - StartTime2) This is semantically equivalent to casting obj to Cursor. The key is to use list comprehension for a nice one liner with the cursor to make your list. Construct a Cursor using a reference to such an object returned from ArcGIS Engine or Server. Print "Finished in %s seconds" % (EndTime - StartTime)Īrcpy.MakeTableView_management("RandomPoints", "myTableView")Ĭount = int(arcpy.GetCount_management("myTableView").getOutput(0)) The cursor creates an iterator, which you cant find the length of. With arcpy.da.SearchCursor("RandomPoints", ) as cursor: ArcGIS Server - ArcObjects Java 9.3. Time.sleep(5) # Let the cpu/ram calm before proceeding! Here is some code to get us started: import time PAv.I am using an example with 1 million randomly generated points inside of a filegeodatabase. ' Loop through the cursor and count number of selected features.
Set pFCursor = pFClass.Search(pSF, False) If pLayer.Name = "Layer1" Or pLayer.Name = "Layer2" Then '?MULITI CUR
Casting to this class from the return value of a method will not work, as this class represents an abstract class in ArcObjects. Set pLayer = pEnumLayer.Next Do Until pLayer Is Nothing Cursor public Cursor(Object obj) throws IOException Construct a Cursor using a reference to such an object returned from ArcGIS Engine or Server. To delete a row retrieved from a search cursor, call IRow.Delete on the row itself.
ARCOBJECTS ICURSOR COUNT UPDATE
This should only be called on update cursors. The cursor must be initialized to a row (with the NextRow method) before this method can be successfully called. Set pEnumLayer = pMap.Layers Dim pFLayer As IFeatureLayer Delete the existing Row in the database corresponding to the current position of the cursor. PSF.SpatialRel = esriSpatialRelIntersects Hi Bob, My guess is its something with your cursor that is placing a lock. If pLayer.Name = "Layer1" Or pLayer.Name = "Layer2" UpdateCursor cannot acquire lock if attribute table is opened in ArcGIS Pro. The code works fine with one layer but when I add a second or third layer with an "OR" operator I only get the count of 0 because one layer may be visible within the extent but the others are not.Į.g. The following code example shows how a query cursor can be used to read the rows of a SQL join: C // Construct an SQL query. setSampleRate void setSampleRate(int maxRecords) throws java.io. AutomationException- If the ArcObject component throws an exception. 9.2.2 Cursor A cursor is a data-access object that allows the programmer to step through each row of a table for such purposes as counting and editing. Parameters: rhs1- A reference to a .ICursor(in) Throws: java.io.IOException- If there are interop problems. ArcGIS Server - ArcObjects Java 9.3.1 I want to get the number of rows in the IFeatureCursor, after appying a ISpatialFilter to a IFeatureClass Can I get the row count without the need for rowcountFeatureLayer, then assigning it the ifeatLayer I feel like this is an uneeded step, but I can't seem to figure out an easier way. I would like to get a total count of multiple layer features (defined) within the ArcMap view extent. Creating a query cursor To create a query cursor, pass an SQL query into the ISqlWorkspace.OpenQuer圜ursor method the cursor is returned. The cursor which will generate the statistics.
0 kommentar(er)
