SearchCursor where clause

[TonyAlmeida]

I a script that selections by location, but after that i need it to search the selected in the "Year" field anything >= to 2009, then copy those features out. Any help would be very appreciated.

Her is what i currently have but i am getting an error of nameerror: name 'rows is not defined.

arcpy.SelectLayerByLocation_management(CCP, "WITHIN_A_DISTANCE", SP2, "1 MILE", "NEW_SELECTION")
if int(arcpy.GetCount_management("CURRENT_CUPS").getOutput(0)) > 0:
    rows.arcpy.SearchCursor(CCP, "YEAR >=2009", "", "YEAR", "YEAR A")
    for row in rows:
        arcpy.CopyFeatures_management("CURRENT_CUPS", "CUPS")


Thanks.

[MathewCoyle]

Are you wanting to copy every feature selected as its own feature class?

[TonyAlmeida]

No just into one, into "CUPS".

[MathewCoyle]

Then you don't need to bother with a cursor at all.

arcpy.SelectLayerByLocation_management(CCP, "WITHIN_A_DISTANCE", SP2, "1 MILE", "NEW_SELECTION")
if int(arcpy.GetCount_management(CCP).getOutput(0)) > 0:
    arcpy.CopyFeatures_management(CCP, "CUPS")

[TonyAlmeida]

my previous code was before;

arcpy.SelectLayerByLocation_management(CCP, "WITHIN_A_DISTANCE", SP2, "1 MILE", "NEW_SELECTION")
if int(arcpy.GetCount_management("CURRENT_CUPS").getOutput(0)) > 0:
    arcpy.CopyFeatures_management("CURRENT_CUPS", "CUPS")

i need to selected layer by location  which is i did here

 arcpy.SelectLayerByLocation_management(CCP, "WITHIN_A_DISTANCE", SP2, "1 MILE", "NEW_SELECTION")
if int(arcpy.GetCount_management("CURRENT_CUPS").getOutput(0)) > 0:
    arcpy.CopyFeatures_management("CURRENT_CUPS", "CUPS") 

but then i need to select from that selection all the features that are 2009 and up from the "Years" field.


Thanks.

[MathewCoyle · Accepted solution]

You can just use feature class to feature class with an expression.

arcpy.SelectLayerByLocation_management(CCP, "WITHIN_A_DISTANCE", SP2, "1 MILE", "NEW_SELECTION") if int(arcpy.GetCount_management(CCP).getOutput(0)) > 0:     expression = "YEAR >=2009"     arcpy.FeatureClassToFeatureClass_conversion(CCP, out_workspace, "CUPS", expression)