AnsweredAssumed Answered

Rounding SHAPE_AREA in SQL Statement

Question asked by BrokenLegMike on Jan 6, 2012
Latest reply on Jan 7, 2012 by rfairhur24
Hello everyone,

I am trying to build a select statement in the Query Builder for the definition Query tab in the layer properties dialogue box. I want to select certain records by shape area, but it doesn't allow this and I believe it is because of rounding. It doesn't pick up the shape area because either the Unique Values are rounded or the actual SHAPE_AREA is rounded and the select statement is having issues trying to pick up the value I want. Can someone suggest a way to round the numbers in SHAPE_AREA first and them do a select based on that, or maybe even suggest another, more robust way to select based on SHAPE_AREA?

I've attached a screenshot of my Query to show what I am doing and the error message I am getting. It says it won't return any records, but I did a simple select based on the unique values that are in the attribute table.