datamade/just-spaces

Create import pipeline for static ACS data

Closed this issue · 2 comments

While we may eventually want to allow admin users to dynamically import ACS data for custom geographies, most of the data should be statically loaded into the database ahead of time. This includes data at the following resolutions:

  • National
  • State (PA)
  • County (Philadelphia)
  • Municipal (Philadelphia)
  • Census tract (within Philly)
  • Census block (within Philly)

Create an import pipeline for the data outlined in #51 (comment) using:

  • GNU Make for extract/transform
  • Census API Python client for retrieving ACS tables
  • Django management command for loading the data into the database

Can we have chat with @hancush and me about this before you do it. We've been thinking on import_data scripts.

That sounds like a great idea @fgregg @hancush. I dropped a short call on the calendar for Monday.