This post is similar to my previous post: a quick visualization of a large geospatial dataset provided by the City of Austin.
This time I’m looking at Austin’s permit data over the last 38 years.
You can download the dataset here, it has nearly 2 million rows and 68 columns.
You can find the script I used to generate the visualizations in this post here.
We’re only really interested in the latitude, longitude, year, and permit type, so we read in the data from the CSV file we download and extract the relevant columns:
Now we loop through all years and plot all new permits (permits issued for new buildings) before the given year, colored by year:
Converting all images into a single gif using the ImageMagick bash command:
and performing some optimizations to reduce the file size, results in the following:
New permits by year
We see that Austin’s borders have expanded significantly in the last nearly 40 years, commonly referred to as urban sprawl.
The plots using all permits tells a similar story as the plots using only new permits: below shows plots for all permits in 1981 compared to 2018:
All permits issued in 1981 vs. 2018
The data is all consistent with this New York Times story, which shows that Austin is among the worst cities in terms of urban sprawl; between 2010 and 2017 Austin decreased in average neighborhood density by 5% despite growing by nearly 20% over the same time period.
My name is Tristan Lee, I'm a data science with a background in computational physics. This is my blog that I use to share simulations, visualizations, and analyses. My focus areas include right-wing extremism, social network analysis, and high-performance computing.