I have a polygon shapefile (with 4000 records in it) that I want to group into different regions by doing a "select by attribute". I need to do this about 164 times because of the different selection ranges I use in the expression (eg nr >= 1000 AND nr <= 1119). For each new selection I need to calculate the Fieldname(Region) to the name of the new region (again 164 times) How can I achieve this in modelbuilder?
You state you already know that you have 164 expressions to run, which would give you 164 regions, but each expression varies slightly. So you must have knowledge or a list of the ranges each region will be?
You could use Excel to create a column where each row contains the sql expression you intend to run in the select by attribute tool and save this off as a dbase file where the region number is implied by the row number.
If you are using ArcGIS 10 then you could use a for iterator to step through your dbase and using the field (which would be a string field) to be the expression for the select by attribute and the value to be the region number to assign to the selected fields