SQL and output syntax for Extract by Attributes

AnneRiddle — Tue, 03 Apr 2012 17:13:32 GMT

Hi all,

I have a couple of questions related to the syntax for Extract by Attributes, related to the code block below (part of a larger script):

for raster in arcpy.ListRasters: 
    outpoint = workspace + raster + "af"
    sqlclause = "VALUE" = 6 OR "VALUE" = 8
    extract = arcpy.ExtractbyAttributes (raster, sqlclause)
    extract.save (outpoint)

My understanding is that extract.save is the only way to save the output of Extract by Attributes. Do I need to create a full file pathname for this, or does it automatically save in the current workspace? (i.e., can I drop "workspace" from outpoint or is it understood to save within the current workspace?). Sorry if this is an obvious question, but I can't seem to find any documentation on this syntax.

Also, I'm copying the syntax from the online example for the SQL query, but it looks totally incorrect; does it need to be enclosed in square brackets?

Thanks.

Re: SQL and output syntax for Extract by Attributes

DarrenWiens2 — Tue, 03 Apr 2012 18:20:19 GMT

As far as the SQL is concerned, look at the examples in the 'where clause' section on this page (basically, enclose it in quotes in your favourite manner).

I don't know about the workspace question, but just try it one way and if it doesn't work, try it the other (takes less time than waiting for an answer).

topic Re: SQL and output syntax for Extract by Attributes in Python Questions

SQL and output syntax for Extract by Attributes

Re: SQL and output syntax for Extract by Attributes