topic Re: SearchCursor where clause in Python Questions

SearchCursor where clause

TonyAlmeida — Tue, 19 Mar 2013 15:51:17 GMT

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.

Re: SearchCursor where clause

MathewCoyle — Tue, 19 Mar 2013 16:59:00 GMT

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

Re: SearchCursor where clause

TonyAlmeida — Tue, 19 Mar 2013 18:31:22 GMT

No just into one, into "CUPS".

Re: SearchCursor where clause

MathewCoyle — Sat, 11 Dec 2021 15:26:34 GMT

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")

Re: SearchCursor where clause

TonyAlmeida — Sat, 11 Dec 2021 15:26:37 GMT

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.

Re: SearchCursor where clause

MathewCoyle — Tue, 19 Mar 2013 20:43:03 GMT

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)