I'm in a bit of a pickle. I'm trying to create a map detailing all possible county-to-county migrations using 5-Year ACS data; however, in order for me to do so I have to tie the attributable migration info shared between two counties inclusive of inflow, outflow and gross migration to each possible combination of county-to-county moves throughout the US. That being said, I'll have to tie the attributable moving data to the US Census Tiger polygons for the 2012 year for the info to be tied to the shapes so that when selected in the final version of the map will have the start county, end county and the move data between the two counties.
I've been thinking through the possible methods for achieving this and I've come to the following conclusions; however, I could be way off:
1) I'll have to create this in ModelBuilder to automate the process.
2) I believe that the correct manner for doing so would be to convert single-part polygons to multi-part based upon the inflow/outflow/gross migration data as well as attaching this information to each combination of two parcels.
3) I'm sure that I'll run into the challenge given the nightmarish amount of possible combinations of moves throughout the time period.
If someone could help me in (1) determining the best way to go about this and (2) helping to come up with the model then I'd be greatly appreciative.