Programming ArcGIS with Python Cookbook - Second Edition

Filtering records with a where clause

By default, SearchCursor will contain all rows in a table or feature class. However, in many cases, you will want to restrict the number of rows returned by some sort of criteria. Applying a filter through the use of a where clause limits the records returned.

Getting ready

By default, all rows from a table or feature class will be returned when you create a SearchCursor object. However, in many cases, you will want to restrict the records returned. You can do this by creating a query and passing it as a where clause parameter when calling the SearchCursor() function. In this recipe, you'll build on the script you created in the previous recipe by adding a where clause that restricts the records returned.

How ...