7,649
edits
Changes
Jump to navigation
Jump to search
1) ssh researcher@128The zip file from AFF was downloaded and extracted to E:\projects\agglomeration\ACS\AFFFiles There are 13 files entitled ACS_17_5YR_table_with_ann.csv, where table is S1501, etc. The files have two header lines and are CSV, with quoted strings of the format "Abanda CDP, Alabama" for the display label. There are 5 columns:*Geo.id e.g., 1600000US0100100*GEO.id2 e.g., 0100100*GEO.42display-label e.44g.181 on terminal, "Abanda CDP, Alabama" 2*HD01_VD01 (Estimate; Total) cd /bulke.g., 174*HD02_VD01 (Margin of Error; Total) 3) psql tigerteste.g., 158 Geo.id2 appears to match our Geoids. Note the leading zero, so these fields should be loaded as varchars. To view all tablesChecking Geo.id2 of 0103076: \dtSELECT * from Tigerplaces WHERE geoid='0103076'; statecode statename gid statefp placefp placens geoid name namelsad lsad classfp pcicbsa pcinecta mtfcc funcstat aland awater intptlat intptlon geom To view contents of a table:AL Alabama 380 01 03076 02403132 0103076 Auburn Auburn city 25 C1 Y N G4110 A 152375113 2646161 +32.6077220 -085.4895446 \d (Table Name)1600000US0103076,0103076,"Auburn city, Alabama",61462,65
American Community Survey (ACS) Data (view source)
Revision as of 18:07, 14 October 2019
, 18:07, 14 October 2019no edit summary
*Educational Attainment are based on population of age 25 years or higher (except for years 2010, 2011, and 2012 - that's why there are fewer entries in those tables)
=To Access Downloaded TablesLoading to a Dbase=
