You rent a
Uhaul truck in New York to move to a new job in Texas. UHaul will be left with a truck in Texas. If people really want to go New York -> Texas but less so Texas-> New York they will reduce the price of the Texas -> New York. If you get all the prices to move one way between all the cities in the US you end up with a good idea of where people are moving. And as people usually move for jobs where the jobs are.
The idea I saw first in Marginal Revolution. This blogpost seems to be where the whole UHaul weighted graph idea came from. Dan Armstrong and Páll Hilmarsson
I took a list of the 34 most populous US cities (all over 500,000) from wikipedia. This is 1122 links in total. The 294 cities is 86142 total links. You only seem to be able to get containers not trucks from Honolulu, Hawaii.
This is a Complete graph where each edge has a length and a weight/capacity (price). some cities are really cheap to leave because enough people are moving (sinking) there that UHaul want to get the trucks back to the cities people are leaving (source)
The extreme costing trips are
Source |
Destination |
Price |
San Jose, CA |
Washington, DC |
4237 |
San Francisco, CA |
Baltimore, MD |
4188 |
San Jose, CA |
Baltimore, MD |
4181 |
San Jose, CA |
Washington, DC |
4132 |
Baltimore, MD |
Washington, DC |
74 |
Washington, DC |
Baltimore, MD |
79 |
You can get the spreadsheet with all
1122 trips here
The trips with the biggest difference between one way and another are
by price
Source |
Destination |
Round dif |
Round ratio |
San Jose, CA |
Washington, DC |
2404 |
2.3 |
San Francisco, CA |
Washington, DC |
2345 |
2.3 |
Philadelphia, PA |
Portland, OR |
2213 |
3 |
and by ratio
Source |
Destination |
Round dif |
Round ratio |
San Jose, CA |
Las Vegas, NV |
580 |
4.1 |
San Francisco, CA Las Vegas, NV 608 4.1
San Francisco, CA |
Las Vegas, NV |
608 |
4.1 |
Philadelphia, PA |
Jacksonville, FL |
1301 |
3.9 |
The spreadsheet with these calculation is
here. the code to work all this out is pretty raw but it is
here.
I will come back to this later and work out
Eigenvalue Centrality and maybe how distance relates to prices. Also it would be interesting to see if some places are summer sinks and some winter sinks in a few months time.