ACS SQL Import Routines

Up one level

SQL scripts for importing of American Community Survey data.

ACS 2009 5yr Geoheader PostgreSQL Script, v 1.0 — by Lee Hachadoorian — last modified March 23, 2011

PURPOSE: This SQL script creates the geoheader table and imports data for the US Census American Community Survey 2009 5-year summary files. See <http://www.census.gov/acs/www/> for more information about the data, including data dictionaries and usage notes. This script is designed for use with PostgreSQL. It *may* work in other SQL-compliant databases, but has not been tested in any database other than PostgreSQL.

ACS 2009 5yr Table Shell PostgreSQL Script, v 1.0 — by Lee Hachadoorian — last modified March 23, 2011

PURPOSE: This SQL script creates table shells for the US Census American Community Survey 2009 5-year summary files. See <http://www.census.gov/acs/www/> for more information about the data, including data dictionaries and usage notes. This script is designed for use with PostgreSQL. It *may* work in other SQL-compliant databases, but has not been tested in any database other than PostgreSQL.

ACS 2009 5yr Data Import PostgreSQL Script, v 1.1 — by Lee Hachadoorian — last modified July 06, 2011

PURPOSE: This SQL script imports data from the American Community Survey 2009 5-year summary files sequence files into table shells created by the Table Shell Script. See <http://www.census.gov/acs/www/> for more information about the data, including data dictionaries and usage notes. This script is designed for use with PostgreSQL. It *may* work in other SQL-compliant databases, but has not been tested in any database other than PostgreSQL.

ACS 2009 5yr Import Sequence Files SQL Constructor — by Lee Hachadoorian — last modified March 23, 2011

This spreadsheet constructs COPY statements for use in importing American Community Survey data in a PostgreSQL import routine. It should be used with the script 'ACS 2009 5yr import sequence files.sql'.

ACS 2008 3yr Geoheader PostgreSQL Script, v 1.0 — by Lee Hachadoorian — last modified March 23, 2011

PURPOSE: This SQL script creates the geoheader table and imports data for the US Census American Community Survey 2008 3-year summary files. See <http://www.census.gov/acs/www/> for more information about the data, including data dictionaries and usage notes. This script is designed for use with PostgreSQL. It *may* work in other SQL-compliant databases, but has not been tested in any database other than PostgreSQL.

ACS 2008 3yr Table Shell PostgreSQL Script, v 1.0 — by Lee Hachadoorian — last modified March 23, 2011

PURPOSE: This SQL script creates table shells for the US Census American Community Survey 2008 3-year summary files. See <http://www.census.gov/acs/www/> for more information about the data, including data dictionaries and usage notes. This script is designed for use with PostgreSQL. It *may* work in other SQL-compliant databases, but has not been tested in any database other than PostgreSQL.

ACS 2008 3yr Data Import PostgreSQL Script, v 1.0 — by Lee Hachadoorian — last modified March 23, 2011

PURPOSE: This SQL script imports data from the American Community Survey 2008 3-year summary files sequence files into table shells created by the Table Shell Script. See <http://www.census.gov/acs/www/> for more information about the data, including data dictionaries and usage notes. This script is designed for use with PostgreSQL. It *may* work in other SQL-compliant databases, but has not been tested in any database other than PostgreSQL.

ACS 2009 5yr Table Shell PostgreSQL Script, v 1.1 — by Lee Hachadoorian — last modified July 06, 2011

PURPOSE: This SQL script creates table shells for the US Census American Community Survey 2009 5-year summary files. See <http://www.census.gov/acs/www/> for more information about the data, including data dictionaries and usage notes. This script is designed for use with PostgreSQL. It *may* work in other SQL-compliant databases, but has not been tested in any database other than PostgreSQL.

ACS 2009 5yr Data Import PostgreSQL Script, v 1.0 — by Lee Hachadoorian — last modified March 23, 2011

PURPOSE: This SQL script imports data from the American Community Survey 2009 5-year summary files sequence files into table shells created by the Table Shell Script. See <http://www.census.gov/acs/www/> for more information about the data, including data dictionaries and usage notes. This script is designed for use with PostgreSQL. It *may* work in other SQL-compliant databases, but has not been tested in any database other than PostgreSQL.