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 drake
- Clone the repository and create the file
acs2postgres/default_profile
by specifying PostgreSQL credentials and the desired U.S. State in the following template:
PGHOST=
PGDATABASE=
PGUSER=
PGPASSWORD=
STATE=Illinois
STATE_ABBREV=il
If the state name has multiple words, remove the space: e.g. for North Carolina use STATE=NorthCarolina
.
- Change to the
acs2postgres
directory and rundrake
.
drake -w Drakefile
- Consult the census-postgres documentation for full technical details. See also the census documentation for each dataset, especially the:
- Appendix (e.g. 2015) for information about census tables, and the
- Sequence Number and Table Number Lookup (e.g. 2015) for information about variables.
- Expand to Decennial and ACS 1yr and 3yr
- Rename folders per state