SQL problem in extractbyattribut

paul-antoinecastel — Thu, 23 May 2013 07:01:21 GMT

Hello,
I have a problem with the fonction extractbyattribut:
I try to have just the minimale raster value as a layer.
So i tried that:

           distresult = arcpy.GetRasterProperties_management(extractbymaskflow, "MINIMUM")

           accumax = distresult.getOutput(0)

           valaccu=int(accumax)
           inSQLClause = "VALUE = valaccu"
           attExtract = ExtractByAttributes(extractbymaskflow, inSQLClause)
           attExtract.save("attExtract")

The problem seems to be "VALUE = valaccu"
I also tried with "VALUE=" +str(valaccu) for the same results.

I don't have error message with this method but the result is a raster with the size of the intial extractbymask with one value eqal to 0.

sorry if there is some faults but english is not my first language.

Thanks to read and answer me

Re: SQL problem in extractbyattribut

ChristineDartiguenave — Fri, 24 May 2013 15:23:20 GMT

"VALUE=" + str(valaccu) is correct.

You are asking for the minimum value in your grid ("MINIMUM") so accumax probably comes back as 0. This is why you end up with the final grid containing only 0. If you want the maximum value in your grid, change the parameter to "MAXIMUM".

Christine Dartiguenave
Esri Water Resources Team

topic SQL problem in extractbyattribut in Water Resources Questions

SQL problem in extractbyattribut

Re: SQL problem in extractbyattribut