Using integer variable in where clause of ArcPy script?

Question

I'm trying to include an integer variable in the SQL where-clause of a tool like this (ArcGIS 10 Python script):

newR = ExtractByAttributes(inR, '"IntField">=2508')

where inR is an integer raster, IntField is an integer field in its attribute table.

The above works, but how can I substitute an integer variable instead of 2508?

I've tried all kinds of different quotes and concatenation, but have not been able to.

Derek Swingley · Accepted Answer · 2011-03-03 23:28:22Z

8

How about:

val = 2508
newR = ExtractByAttributes(inR, '"IntField">=%d' % val)

Read up on string formatting with python.

edited Mar 3, 2011 at 23:28

answered Mar 3, 2011 at 22:38

Derek Swingley

14.5k2 gold badges46 silver badges63 bronze badges

Add a comment |

Nathanus · Accepted Answer · 2011-03-03 23:20:51Z

4

I have found ArcGIS to be very finnicky when it comes to multiple parameters. For example, use of double quotes tends to signify the end of a parameter. One method I use is string concatenation after changing the variable to a string.

intstr = str(intvar) #Converts integer variable to a string newR = ExtractByAttributes(inR, "IntField>= "+intstr)

answered Mar 3, 2011 at 23:20

Nathanus

4,3281 gold badge34 silver badges47 bronze badges

Add a comment |

Stack Exchange Network

Using integer variable in where clause of ArcPy script?

2 Answers 2

Your Answer

Hot Network Questions

Using integer variable in where clause of ArcPy script?

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions