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 &Location affordability data is available from the census via data.gov on three different levels:
- core-based-statistical-area (like a Designated Market Area (DMA))
- county
- 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 |
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' |
| ... | ... |
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' |
| ... | ... |
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' |
| ... | ... |
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 gdalcd cb_2013_us_cbsa_5m/
ogr2ogr -f GeoJSON -t_srs crs:84 cb_2013_us_cbsa_5m.geojson cb_2013_us_cbsa_5m.shpcd cb_2013_us_county_5m/
ogr2ogr -f GeoJSON -t_srs crs:84 cb_2013_us_county_5m.geojson cb_2013_us_county_5m.shpResources:
- 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).