I have a layer with several polygons and a road map. I need to take each polygon and use it to clip the road map, dissolve all of the road records into one, and then merge the polygons into one shapefile. The goal is to have a shapefile with each polygon as one record that contains the total roads within that polygon.
I know the easiest solution would be to dissolve the roads layer before hand and then clip using the polygons but I'm working on a continental scale and my computer keeps running out of memory for that. If I clip the road map and then dissolve everything is fine, the issue is the merge. Using row iterator the model only spits out one shapefile at a time after running a clip and dissolve on it. How do I collect all of those outputs and merge them?
Current Model: I'm using row iterator to select out each polygon, then use the clip tool to clip the road map, then using the dissolve tool to dissolve all of the roads inside that polygon into one record. Now I'm stuck on how to merge it all back together.