topic Re: gp.select_analysis(row,output) iternation, possible or not? in Geoprocessing Questions

gp.select_analysis(row,output) iternation, possible or not?

JianLiu2 — Wed, 24 Nov 2010 19:31:25 GMT

how to iterate a function as:

rows=gp.SearchCursor(featureclass)
row=rows.Next()

while row:
gp.select_analysis(row,output)
row=rows.Next()

so that I would be able to select a feature record from row1 to row n in a featurecalss seperately. But clearly, "select_analysis" doesn't accept "row" as a leagal input... SO any alternatives?

I was thinking of SQL in {where clause}, but how to write the SQL codes (it seems SQL dosen't allow an iterating variable either, like {where i=range(1,100), "OBJECTID=i"} ?)

thanks indeed!!

Re: gp.select_analysis(row,output) iternation, possible or not?

ChrisSnyder — Sat, 11 Dec 2021 09:16:49 GMT

Yes, all you need to use the OBJECTID value (BTW, not always called OBJECTID). For example:

myFC = r"C:\temp\test.shp"
oidFieldName = gp.describe(myFC).oidfieldname
searchRows = gp.searchcursor(myFC)
searchRow = searchRows.next()
while searchRow:
   oidFieldValue = searchRow.getvalue(oidFieldName)
   outputFC = r"C:\temp\output_" + str(oidFieldValue) + ".shp"
   gp.Select(myFC, outputFC, oidFieldName + " = " + str(oidFieldValue)
   searchRow = searchRows.next()

Re: gp.select_analysis(row,output) iternation, possible or not?

JianLiu2 — Wed, 24 Nov 2010 20:03:42 GMT

thanks! try it right away!!:D

Re: gp.select_analysis(row,output) iternation, possible or not?

JianLiu2 — Wed, 24 Nov 2010 20:53:12 GMT

it perfectly works, thanks!

I think my problem is the SQL sentence .., such as {OIDFieldName + "= " + str(OIDFieldValue)}.

I didn't know the expression: + " = " + ...

Any suggestions on manuals/references for SQL writing?

best

Jian

Re: gp.select_analysis(row,output) iternation, possible or not?

ChrisSnyder — Wed, 24 Nov 2010 20:55:22 GMT

For ESRI-comliant SQL:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s500000033000000.htm