I am trying to select by attributes from a polygon shapefile. I need to select areas with a temperature greater than 10 oC and lower than 15oC using gridcode but I can't seem to work out the correct formula.

Can anyone help?

The process so far has been Geoprocessing, selection by attributes,

"GRIDCODE"=  >10, <15 

to which an error window comes up stating invalid SQL statement.

I am using ArcMap 10.3


I think you need to use the following instead:


You need to switch the => operators and specify again the attribute field for the second term (i.e. < 15).

| improve this answer | |
  • @TheoBlundell please mark this answer as correct if it helped you out. It may help someone else as well. – cl3 Mar 31 '16 at 21:15

You can also use:

"GRIDCODE" IN ('10', '11', '12', '13', '14')

If the data type for the field is String rather than a numeric type. Otherwise use the method described by Joseph.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.