I am currently using ArcMap 10.3's ModelBuilder. Having created a feature class of 300 zones, I would like to filter these to the 15 zones above 200 hectares in size, the model is shown below:

End of the model

I have tried to use the following SQL Code to achieve this, but it never has an effect when running the model.

SQL code

  • "Shape_Length" < 2000000 is everything less than 200 hectares, not everything greater than 200
    – Midavalo
    Feb 18, 2016 at 23:16
  • Ah apologies, that was left from a previous attempt to delete the selected data and leave what I wanted, the code does not work either way.
    – Unencoded
    Feb 18, 2016 at 23:17
  • Can you confirm that Shape_Length is the correct field? Hectares is an area value so I would expect a field called Shape_Area or similar.
    – Midavalo
    Feb 18, 2016 at 23:23
  • You are of course correct, I assure you I have been using Shape_Area, I just mis-clicked when setting up that screenshot. Previously when clicking "Get unique values" I was not presented with any data, however this has since changed and I don't know why... I will update if I find out why....
    – Unencoded
    Feb 18, 2016 at 23:32
  • I can't see your entire model - is there a Join in there at all? in the past I have found that I can't select by the Shape length/area fields if the layer is joined to another table.
    – Midavalo
    Feb 18, 2016 at 23:56

1 Answer 1


Sequence of Tools

This sequence of tools successfully selected the right areas. While setting up the "Select" tool, the "Get Unique Values" button for "Shape_Area" still did not get any values (as the Feature Class does not exist before the model is run), however this sequence of tools meant that entering the correct expression gave the correct result.

In a nutshell the problem was in the processing before selection, not the selection itself.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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