So I am looking for a way to sort a water main layer in a map by pipe diameter size, and then map import each pipe size .shp into AutoCAD so that I can create unique line types that show pipe diameter size in an AutoCAD drawing. Is there a quicker way to do this than having to use 'select by attributes' in the water main layer, and sort by unique value (Pipe diameter) and export for each size? This could take awhile as there are more than a dozen diameter sizes to sort through. Is there a geoprocessing method or python script that could break down this process and make it quicker? Any insight into this would be appreciated.
If you have an advanced license http://desktop.arcgis.com/en/arcmap/latest/tools/analysis-toolbox/split.htm
Or if you don't.... https://www.arcgis.com/home/item.html?id=15ca63aebb4647a4b07bc94f3d051da5
You can do the 'to cad' part after you have the shapefiles
I have never used this tool before, and it was MUCH more efficient than other methods I would have tried. Thank you for the insight to help me practice using a new tool.