Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a point data set where each point has a unique operator associated with it. I'd like to select by attribute = operator name and generate a new shapefile for each operator containing only the points associated with that operator name. Doing this by hand for each operator is simple but I've been having trouble trying to build a model in ModelBuilder that will automate it.

I've tried using the Select Layer by Attribute tool but I can't figure out how to iterate it such that the SQL expression will run through each operator name. ModelBuilder will not let me attach any inputs onto the expression term. The gist of what I think I'm trying to do here:

enter image description here

share|improve this question

Have a look at Dan Patterson's Split Layer by Attributes tool. I think it will work well for this purpose.

share|improve this answer

If you Group By the field containing your operator names in the iterator, it will select all the features with each unique operator name. You can then use those selected features I_Well_Locations_operator as input into the Copy Features tool, which will create a new shapefile for each group of features. You can also use Value as an inline variable for the output shapefiles so that each shapefile will have the unique operator name.

share|improve this answer

I would suggest trying the SELECT tool. It is available at all license levels.

From the online help:

Extracts features from an input feature class or input feature layer, typically using a select or Structured Query Language (SQL) expression and stores them in an output feature class.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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