I need to break a shapefile (TIGER roads data) into multiple shapefiles based on an attribute field. I need to break the shapefile up into ~100 separate shapefiles, so I would prefer to do this iteratively in ModelBuilder or if necessary with Python script. Can anyone help me figure out the most efficient way to do this?
Thanks,
Erik
Use arcpy.Frequency_analysis to get the unique value of your attributes into a table
Use cursor to read these unique values from this table
Inside this cursor use
arcpy.FeatureClassToFeatureClass_conversion with unique value as in where clause
Use Split Layers by Attributes make sure your shapefile resides in a folder and not a geodatabase
I have used Dan's tool Split Layers by Attriubtes, and it works quite well.