Daily Archives: April 12, 2018

Urban Highway Data

Last November, the Antiplanner noted that the Federal Highway Administration had posted many of the tables for the 2016 Highway Statistics. However, two tables that had not then been posted dealt with highways and driving by urban area. Table HM71 shows miles and daily vehicles miles driven by type of road. Table HM72 shows miles of roads, freeways, and freeway lane miles as well as other characteristics such as land area and population density for each urban area.

When I downloaded the data, the first thing I noted was that the numbers for Los Angeles are wrong. The tables say that Los Angeles, an urban area of 12.5 million people, has just 813 miles of roads, 8 of them being freeways. Alphabetizing the list revealed that most of the data (other than population and land area) for urban areas from Lee’s Summit to Los Lunas had been pushed up one urban area. So I moved them all down one urban area, and took the data for Los Lunas and put them in the row for Lee’s Summit. I’m pretty certain this is right for all of the areas except Lee’s Summit; the 2015 spreadsheet for that area was all zeros.

To do this, I had to rearrange the spreadsheets. For some reason, the Federal Highway Administration breaks up the table into nine different worksheets, with about 70 urban areas per sheet. I find this annoying because it makes it difficult to find and compare many of the smaller urban areas. Continue reading

Share