cs-10

Case Study 10: Building the past

Background

You have been asked to support a story for the local paper (that has a web presence) that looks back on the housing collapse and the early effects of residential construction. You have data on residential building permits from 1980 through 2010 for each county in the United States. Your colleague that is writing the article would like a few maps and graphics that highlight the single family building permit patterns across your state as well as the patterns in the US.

Remember the big story is the collapse of new building permits at the initial stages of the mortgage crisis. Make sure your graphics highlight the collapse in a clear and honest manner.

• Back or Course Website

Reading

This reading will help you complete the tasks below.

• o Plotly Choropleth Maps

Tasks

• Read in the permits.rda data provided using pyreadr and clean it for spatial visualization needs
  • Install pyreadr using UV - uv add pyreadr
  • You will need to merge it with the spatial data so it will require some column mutation
• Use pl.read_json("https://raw.githubusercontent.com/plotly/datasets/master/geojson-counties-fips.json") to get the spatial maps for the US
  • You will need to use the ID on the spatial data to merge on FIPS numbers with the permit data
• Create state level totals from the county level data to show general patterns across the US over time
• Create a marimo notebook with 1-2 paragraphs summarizing your graphics and the choices you made in your visualization to address the reporter’s needs
• Export your notebook to .html and have both the notebook and HTML into your git repository
• Find two other student’s files in their repository and provide feedback using the issues feature in GitHub (If they already have three issues find a different student to critique)
• Address 1-2 of the issues posted on your project and push the updates to GitHub