AnsweredAssumed Answered

Evaluate Where Clause

Question asked by jborgion on Sep 20, 2017
Latest reply on Sep 20, 2017 by jborgion

A new day, a new question...

 

Working with arcpy.da.SearchCursor, I can select features based on a given where statement.  However, rather than selecting records, I just want to see if the where statement evaluates to 'true', and if so, update a field in the row of the cursor.  Currently, for a selection I use:

where = "FullStreet = ('{}') AND inthousenum BETWEEN MinRange and MaxRange)".format(street)
arcpy.SelectLayerByAttribute_management ("AddressPoints","ADD_TO_SELECTION",where)

 

So rather than select by attribute, I want to set a variable to 1 or 0 (or what ever) to indicate the success of the where statement, and take the appropriate action based on that value.

 

Curtis Price Dan Patterson Darren Wiens

Outcomes