Developerweek Accelerate Hackathon (view map live at http://bl.ocks.org/s2t2/raw/cd45dfd8007fcf83fef7/)

README.md

Income and Affordability by United States Geography

Usage

View at http://bl.ocks.org/s2t2/raw/cd45dfd8007fcf83fef7/.

Or develop locally at http://localhost:8888/.

git clone git@gist.github.com:/cd45dfd8007fcf83fef7.git
cd cd45dfd8007fcf83fef7/
python -m SimpleHTTPServer 8888 &

Notes

Affordability Data

Location affordability data is available from the census via data.gov on three different levels:

1. core-based-statistical-area (like a Designated Market Area (DMA))
2. county
3. place

The Location Affordability Index Data Dictionary applies to each of the three datasets.

It defines eight types of households.

COLUMN PREFIX	HOUSEHOLD TYPE	SIZE OF HH	INCOME	# COMMUTERS
hh_type1_	Median-Income	Family	4 Median Income for Region	2
hh_type2_	Very Low-Income	Individual	1 National Poverty Line	1
hh_type3_	Working Individual	1	50% of Median Income for Region	1
hh_type4_	Single Professional	1	135% of Median Income for Region	1
hh_type5_	Retired Couple	2	80% of Median Income for Region	0
hh_type6_	Single-Parent Family	3	50% of Median Income for Region	1
hh_type7_	Moderate-Income Family	3	80% of Median Income for Region	1
hh_type8_	Dual-Professional Family	4	150% of Median Income for Region	2

It defines at least the following metrics for each type of household, and provides measures of each.

COLUMN SUFFIX	DESCRIPTION
income_min	The minimum income for the geography as defined for the household above.
income_max	The maximum income for the geography as defined for the household above.
income	The income for the geography as defined for the household above.
size	The household size for geography as defined for the household above.
workers	The number of commuters for the geography as defined for the household above.
ht	The modeled housing and transportation costs as a percent of income.
h	The modeled housing costs as a percent of income.
t	The modeled transportation costs as a percent of income.
...	... and more

1. Location Affordability Index: All Core Based Statistical Areas (CBSAs)

There are 943 CBSAs with identifiers ranging from '10020' to '49780'.

cbsa	cbsa_name
'10020'	'Abbeville, LA'
'10100'	'Aberdeen, SD'
'10140'	'Aberdeen, WA'
'10180'	'Abilene, TX'
'10220'	'Ada, OK'
'10300'	'Adrian, MI'
'10420'	'Akron, OH'
'10460'	'Alamogordo, NM'
'10500'	'Albany, GA'
'10540'	'Albany-Lebanon, OR'
'10580'	'Albany-Schenectady-Troy, NY'
'10620'	'Albemarle, NC'
'10660'	'Albert Lea, MN'
'10700'	'Albertville, AL'
'10740'	'Albuquerque, NM'
'10760'	'Alexander City, AL'
'10780'	'Alexandria, LA'
...	...

2. Location Affordability Index: All Census Counties

There are 3,144 counties with identifiers ranging from '01001' to '56045'.

county	county_name
'01001'	'Autauga'
'01003'	'Baldwin'
'01005'	'Barbour'
'01007'	'Bibb'
'01009'	'Blount'
'01011'	'Bullock'
'01013'	'Butler'
'01015'	'Calhoun'
'01017'	'Chambers'
'01019'	'Cherokee'
'01021'	'Chilton'
'01023'	'Choctaw'
'01025'	'Clarke'
'01027'	'Clay'
'01029'	'Cleburne'
'01031'	'Coffee'
...	...

3. Location Affordability Index: All Census Places

There are 24,011 places with identifiers ranging from '0100100' to '5686737'.

place	place_name
'0100100'	'Abanda'
'0100124'	'Abbeville'
'0100460'	'Adamsville'
'0100484'	'Addison'
'0100820'	'Alabaster'
'0100988'	'Albertville'
'0101132'	'Alexander City'
'0101180'	'Alexandria'
'0101228'	'Aliceville'
'0101396'	'Allgood'
'0101660'	'Altoona'
'0101708'	'Andalusia'
'0101756'	'Anderson'
'0101852'	'Anniston'
'0102116'	'Arab'
'0102260'	'Ardmore'
...	...

Geography Data

Resources:

• CSA Shapes
• CBSA Shapes
• https://www.census.gov/geo/maps-data/data/tiger-cart-boundary.html
• Cartographic Boundary Shapefiles - Metropolitan and Micropolitan Statistical Areas and Related Statistical Areas -- 500k, 5m, 20m
• Cartographic Boundary Shapefiles - Counties -- 500k, 5m, 20m
• Cartographic Boundary Shapefiles - Places (Incorporated Places and Census Designated Places) -- state by state datasets
• http://ben.balter.com/2013/06/26/how-to-convert-shapefiles-to-geojson-for-use-on-github/
• https://github.com/censusreporter/census-api
• http://www.census.gov/data/developers/data-sets.html
• http://www.census.gov/data/developers/data-sets/TIGERweb-map-service.html

Shapefile to GeoJSON conversion process:

brew install gdal

cd cb_2013_us_cbsa_5m/
ogr2ogr -f GeoJSON -t_srs crs:84 cb_2013_us_cbsa_5m.geojson cb_2013_us_cbsa_5m.shp

cd cb_2013_us_county_5m/
ogr2ogr -f GeoJSON -t_srs crs:84 cb_2013_us_county_5m.geojson cb_2013_us_county_5m.shp

Mapping

Resources:

• http://gis.stackexchange.com/a/70557
• http://bsumm.net/2013/03/31/analyzing-mbostocks-queue-js.html
• https://github.com/mbostock/queue
• http://bl.ocks.org/mbostock/4060606
• https://github.com/mbostock/d3/wiki/Arrays#d3_map

NOTE: It is not methodologically sound to aggregate measures across household types (i.e. to calculate the mean or median of all household types within a given geography).

cb_2013_us_county_5m.geojson

index.html

lai_data_cbsas.csv

lai_data_us_counties.csv

cb_2013_us_cbsa_5m.geojson