I am trying to find the difference of 11 feet or more between two fields (Both are Double types). For example, I have a field called shape_length and another field called station_length and I want to see if there are any differences of 11 feet or more between the two, and select those differences. I think it's a simple SQL statement in the "Select By Attributes dialog in ArcGIS but I can't figure it out.


In your Select by Attributes you could enter something like

abs(shape_length - station_length) > 11

which will select any feature where the difference between the two values is greater than 11. The abs is for "absolute value" so makes it a positive value for assessing against the 11.

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.