dssg/acs2pgsql

Name: acs2pgsql

Owner: Data Science for Social Good

Description: Download American Community Survey data and put it into a Postgres database

Created: 2016-06-29 14:41:15.0

Updated: 2018-02-23 23:05:49.0

Pushed: 2018-03-07 17:38:37.0

Homepage: null

Size: 1270

Language: Shell

GitHub Committers

User	Most Recent Commit	# Commits

Other Committers

User	Email	Most Recent Commit	# Commits

README

acs2pgsql

This repository imports American Community Survey (ACS) data into PostgreSQL. The hard work has already been done by Census Reporter. We add the following features:

• Make the state (e.g. Illinois, California) a variable
• Fix issues with the 2009 ACS 5-year data
• Run the workflow using docker or drake

Usage

1. Clone the repository and create the file acs2pgsql/default_profile by specifying PostgreSQL credentials and the desired U.S. State in the following template:

   ST=
   TABASE=
   ER=
   SSWORD=
   
   E=Illinois
   E_ABBREV=il
   

   If the state name has multiple words, remove the space: e.g. for North Carolina use STATE=NorthCarolina.

2. Change to the acs2pgsql directory. To use docker, run docker build -t "image_tag" .. Docker will create an image and then extract, transform, and load the ACS data into your PostgreSQL database. To use drake, run drake.

3. Consult the census-postgres documentation for full technical details. See also the census documentation for each dataset, especially the:

4. Appendix (e.g. 2015) for information about census tables, and the

5. Sequence Number and Table Number Lookup (e.g. 2015) for information about variables.

TODO

• Expand to Decennial and ACS 1yr and 3yr
• Rename folders per state