I've imported a table into ArcGIS which I'd like to split into multiple shapefiles. The splits would occur between groups of records separated by any of 3 columns. In other words, col1, col2, and col3 together create a unique identifier. I'm thinking it would require the following elements but I can't quite put it together:
- Use ModelBuilder
- Use SQL Statement to sort table records by 3 column identifier
- Iterate through table records and write each group to new shapefile (possibly using 'Select by Attributes')
- Create each shapefile name based upon combined col1, col2, col3 names
What I've tried already:
- Used 'Split by Attribute' tool by Fox Tools to split table. Works great on smaller tables, not so well on this one with 4000+ records and multiple attribute fields to examine for splitting.
Any thoughts?