Transcript CHAS DATA - University of California, Berkeley

CHAS DATA
Todd Richardson
U.S. Department of Housing and
Urban Development
Office of Policy Development &
Research
Presentation Summary
Accessing the data
 Downloading the data
 Understanding the data
 Using the data

Accessing the data

State of the Cities Data System
 http://socds.huduser.org/scripts/odbic.exe
/chas/index.htm?

HUDUSER - data sets - consolidated plan
 http://www.huduser.org/datasets/cp.html
State of the Cities

Housing Problems Table
 1990 Data
 All Households, White-nh, Black-nh,
Hispanic
 2000 Data
 All Households, White-nh, Black-nh,
Hispanic, Asian-nh, Native American-nh,
Pacific Islander-nh, Mobility and Self-Care
Limitation
State of the Cities

Affordability Mismatch
 2000 Data
 Occupancy, age, and vacancy rate of
units affordable to persons in different
income categories
Other helpful data at SOCDS







http://socds.huduser.org/index.html
Data from the 1970, 1980, 1990, and 2000
Census
Current Employment Statistics for City
Residents
Special City Extracts from County Business
Patterns
FBI Crime Data
Building Permits Database
Urban Public Finance Data
HUDUSER - Data Sets Consolidated Plan



Detailed Tables
 59 tables
Multiple Geographic Levels
 State, County, Place, Consolidated City, Tract
(part), a few tables at Block Group level
Different Ways to Download
 By State (DBF files only)
 Nationally (SAS, SPSS, DBF Files)
Detailed Tables




Example Table to Download:
 A1A040.DBF - Table, Geographic Summary
Level, Data Format
A Tables
 General CHAS data tables at six geographies
mentioned
B Tables
 Less disaggregated CHAS data at Block Group
level
F Tables
 Tables created for running various formulas
Detailed Table Tips



Also download the data dictionary, files are highly
disaggregated
Use the highest level geography that makes sense
 Rounding issue with special tabulation data
Mapping with Tract and Block Group Data
 The tract (part) and block group (part) data split
at place boundaries requiring non-standard GIS
shape files which HUD has created and can also
be downloaded.
Downloading the Data


SOCDS data tables downloadable in Excel File
 VERY IMPORTANT - USE NON-FRAMES
VERSION OF SOCDS IN ORDER TO
DOWNLOAD
HUDUSER data files are in zipped files.
 The State Downloads, which most people will
likely use, have data for every table and every
geography all zipped into a single file. This
allows the user to be selective about what they
want to extract.
Understanding the Data
These data are largely built around HUD’s
Low/Mod area definitions 30%, 50%, and
80% of HUD Area Median Family Income
(HAMFI)
 HAMFI is calculated based on the median
income for a metropolitan area, assuming
that is income for 4-person HH.
 HAMFI is adjusted for family size

HAMFI vs. Poverty



On average, households at less than 30% of
HAMFI equate to households at the poverty level.
However, in high cost/high income markets, the %
of households less than 30% is much higher than
poverty rate. Similarly in low cost/low income
markets, the % of households less than 30% is
much lower than poverty rate.
We use HAMFI as a proxy to account for different
costs of living.
Example of 1999 HAMFI
Oakland MSA (Pre 2003 Definition)
1999 Median Area Family Income:
$69,186
Household
Size
1
2
3
4
5
6
7
8
80%
Median
$35,035
$40,040
$45,045
$50,050
$54,054
$58,058
$62,062
$66,066
Poverty
$8,501
$10,869
$13,290
$17,029
$20,127
$22,727
$25,912
$28,967
30%
Median
$14,525
$16,600
$18,675
$20,750
$22,410
$24,070
$25,730
$27,390
50%
Median
$24,220
$27,680
$31,140
$34,600
$37,368
$40,136
$42,904
$45,672
Based on U.S. Census 2000 Data.
Do not confuse CHAS data with
CDBG Low/Mod Area Data

CDBG Low/Mod Area Data are NOT based
on the special tabulation data. They are
created using a routine that extrapolates
from SF3 data. You can download CDBG
Low/Mod Area Data from:
http://www.hud.gov/offices/cpd/systems/cen
sus/lowmod/index.cfm
Housing Needs - CHAS


Housing Quality
 Census Data weak measure on housing quality
 Without complete kitchen or complete
plumbing
Overcrowding
 Greater than 1.01 persons per room
 Severe Crowding GT 1.51 persons per room
 Increased over past decade
Housing Needs (cont)

Affordability
 Cost Burden - greater than 30% of
income for housing
 Severe Cost Burden - greater than 50% of
income for housing
Using the Data: Example
A3B. HOUSEHOLD INCOME IN 1999 BY HOUSING UNIT PROBLEM
SEVERITY (35)
Universe: Renter occupied housing units
Household income less than or equal to 30.0% of HAMFI
Lacking complete plumbing facilities or lacking complete kitchen facilities
With 1.51 or more person per room, none of the needs above
With 1.01 to 1.50 persons per room, none of the needs above
Housing cost burden over 50.0 percent, none of the needs above
Housing cost burden 30.1 to 50 percent, none of the needs above
Zero income
No housing unit problems
Household income 30.1% to 50.0% of HAMFI
(Repeat HOUSING UNIT PROBLEM SEVERITY )
Household income 50.1% to 80.0% of HAMFI
(Repeat HOUSING UNIT PROBLEM SEVERITY )
Household income 80.1% to 95.0% of HAMFI
(Repeat HOUSING UNIT PROBLEM SEVERITY )
Household income above 95.0% of HAMFI
(Repeat HOUSING UNIT PROBLEM SEVERITY )
U.S. Renter Housing Problems 2000
72.4%
80%
22.7%
60%
40%
20%
34.7%
5.8%
6.6%
Moderate Cost Burden
Severe Cost Burden
Moderate Crowding
Severe Crowding
Without complete kitchen and/or plumbing
23.2%
10.8%
4.7%
4.9%
0%
LE 50% HAMFI (N=14.3
million)
GT 50% HAMFI (N=21.7
million)
Source: Table
A3B040r Census
2000 CHAS
Special Tabs
California Renter Housing Problems 2000
84.1%
Moderate Cost Burden
Severe Cost Burden
Moderate Crowding
90%
80%
16.2%
Without complete kitchen and/or plumbing
70%
60%
Severe Crowding
35.3%
38.6%
50%
40%
30%
20%
10%
9.5%
19.1%
14.6%
7.7%
12.2%
3.9%
0%
LE 50% HAMFI (N=1.8 million)
GT 50% HAMFI (N=3.1 million)
Source: Table
A3B040r Census
2000 CHAS
Special Tabs
Other Favorite Tables
The F5 Tables:




HOUSING UNIT PROBLEMS AND COST
BURDEN BY HOUSEHOLD INCOME IN
1999 BY HOUSEHOLD TYPE
F5A – Owners with a mortgage
F5B – Owners without a mortgage
F5C – Renters of Single Family Homes
F5D – Renters of Multifamily Units
Other Favorite Tables
Mobility and Self-Care Limitations by
housing needs and age of household
members – Tables A7A, A7B, A7C
 Housing Need by Income Breaks of 20%,
30%, 40%, 50%, 60%, 65%, 80%, 95%,
100%, 115%, 120% and 140% of HAMFI –
Tables A6A & A6B

Other Favorite Tables
Poverty Rates with and without college
students – Table A13
 Income and Age of Housing for Families
with Children Age 6 and Under – Tables
A14A and A14B

GIS – Shape Files for Census
Tract (part) and Block Group
(part) files

Shape files for Summary Levels 080, 090,
and 091 are not standard products so HUD
created them. You can download at:
http://www.huduser.org/geo/summarylevel.a
sp
www.huduser.org/geo/summarylevel.asp
Select a Summary Level
Select a State
Select a County
Join CHAS or CDBG Low/Mod Data to Boundary File
For CDBG Low/Mod Use common LOGRECNO field
For CHAS Tables, join on SUM080 (for Tract) or SUM091 (for Block Group)
Example: Map Low/Mod Areas
with Local Projects
Questions or Comments

Todd Richardson
 Phone: (202) 708-3700 x 5706
 Email:
[email protected]