Introduction
We'll start this chapter with a basic question. What are cursors? Cursors are in-memory objects containing one or more rows of data from a table or feature class. Each row contains the attributes from each field in the data source, along with the geometry for each feature. Cursors allow you to search, add, insert, update, and delete data from tables and feature classes.
The ArcPy Data Access module or arcpy.da
is new to ArcGIS 10.1 and contains methods that allow you to iterate through each row in a cursor. Various types of cursors can be created. For example, search cursors can be created to read values from rows. Update cursors can be created to update values in rows or delete rows, and insert cursors can be created to insert new rows.
There are a number of cursor improvements that have been introduced with the ArcPy Data Access module. Prior to ArcGIS 10.1, cursor performance had been notoriously slow. Now, cursors are significantly faster. Esri has estimated that search...