Transcript MTF LEHD Presentation

LEHD data for
FSUTMS!!!
presented to
Model Task Force Meeting
presented by
Vidya Mysore, FDOT Central Office
Krishnan Viswanathan, Cambridge Systematics, Inc.
12/12/06
0
Agenda




Objective
Longitudinal Employer Household Dynamics
(LEHD) Description
Data Analysis
Future Directions
1
Objective
Possible use of LEHD and Employment data
for travel demand modeling



Current and future directions of Census and other
available data sources for transportation
NHTS Add-on
Review of QCEW [Quarterly Census of Employment and
Wages] (Employment data from AWI, state agency) and
LEHD Data
2
Agenda




Objective
LEHD Description
Data Analysis
Future Directions
3
The LEHD Concept
Surveys
Censuses
Administrative
Records
Longitudinal Employer-Household Dynamics Program
(LEHD)
Local
Transportation
Dynamics
Local
Employment
Dynamics
Local
Immigration
Dynamics
4
LEHD Description


LEHD combines federal and state administrative data on
employers and employees with core Census Bureau
censuses and surveys
Local Employment Dynamics (LED) is a voluntary
partnership between state labor market information
agencies and the U.S. Census Bureau to develop new
information about local labor market conditions
5
LEHD Description




The data for LEHD will be based on Quarterly Census of
Employment and Wages (QCEW/ES-202)
Number of people employed and the wages paid to the
employees each quarter
Multi-establishment employers also provide individual
worksite data
Preliminary annual data are available in June and final
annual data are available in October of each year.
Quarterly data are available six months after the end of
each quarter
6
LEHD Origin Destination
Database
Home Block
Workplace Block
(U/I Wage Data)
(QCEW Data)
# of Workers (primary job) and # of Jobs
Home Profile – block group
• # workers
• Worker distribution
• age
• earnings
• industry
Acknowledgments : US Census Bureau
Work Profile – block group
• # establishments
• # workers
• Worker distribution
• age
• earnings
• industry
• Demand/ Growth Indicators
• Job creation/loss
• Hires/separations
• Earnings hires/separations
7
LEHD Origin Destination
Database
Year
h_geocodefull
w_geocodefull
jobs_all
jobs_prim
jobs_priv_all
jobs_priv_prim
Year YYYY
FIPS state, FIPS county; Census tract, Census block; home
FIPS state, FIPS county; Census tract, Census block; work
Number of jobs to which workers made this trip
Number of primary jobs to which workers made this trip
Number of private sector jobs to which workers made this trip
Number of private sector primary jobs to which workers made
this trip
8
LEHD Example
Where South Duval residents work
9
Who was sampled?
10
When & how were they
sampled?
11
Comparisons
CTPP
ACS
LEHD
Frame
HH and GQs
HH and GQs
UI
Workers/Firms
Sample Rate
~ 1 in 6
per 10 years
~ 1 in 8
per 5 years
~ 1 in 1
4 times a year
Release
Frequency
Decennial
Annual
Quarterly
Coverage
Nationwide
Nationwide
41 States
Reference
Period
Week
Week
Quarter
Availability
No
Yes
Yes
Acknowledgments : US Census Bureau
12
LEHD OD with ACS
Home Block
(U/I Wage Data)
ACS Data
• Trip Time
• Mode
• Distance
Workplace Block
(QCEW Data)
# of Workers (primary job) and # of Jobs
Home Profile – block group
• # workers
• Worker distribution
• age
• earnings
• industry
Acknowledgments : US Census Bureau
Work Profile – block group
• # establishments
• # workers
• Worker distribution
• age
• earnings
• industry
• Demand/ Growth Indicators
• Job creation/loss
• Hires/separations
• Earnings hires/separations
13
Travel Demand Models
Applications




LEHD/LED data can be used get complete information
workers and place of employment
LEHD data can be enhanced with ACS data
Small area OD pairs can be tabulated
Data available on a quarterly basis
14
LEHD and QCEW Data
Availability


Available at no cost from AWI
Non Disclosure Agreement with AWI
15
Agenda




Objective
LEHD Description
Data Analysis
Future Directions
16
Data Analysis




Models Used
QCEW Data Analysis
Comparison between InfoUSA and QCEW data
Results
17
Models Used
2005 NERPM CF Model
2000 Polk TPO Model
18
QCEW (ES202) Data Analysis




December 2004 data used for analysis
Data overlaid to TAZ
Geocoded the data for address matching
ZDATA2 data developed from QCEW Data
Model
Total QCEW
Employment
Lat/Long
Information
Available
Geocoded
to Model
TAZ
Address
Matched to
TAZ
NERPM
728,044
487,954
468,755
176,957
Polk
438,190
182,675
169,771
167,370
19
Comparison between InfoUSA
and QCEW Data
POLK
INDUSTRIAL
QCEW
InfoUSA
Model
(2000)
41,133
35,761
41,684
COMMERCIAL
179,468
58,486
59,775
SERVICE
116,540
99,418
105,611
TOTAL
337,141
193,665
207,070
NERPM
MAN. INDUSTRIAL
QCEW
InfoUSA
Model
113,003
89,318
54,903
34,699
42,644
137,255
COMMERCIAL
145,355
126,640
182,157
SERVICE
352,655
274,766
420,058
TOTAL
645,712
533,368
794,373
OTHER INDUSTRIAL
20
Study Results
Model HBW Trips
LEHD Primary Jobs
21
Study Results
Model HBW Trips
CTPP JTW Trips
22
Study Results
Model HBW Trips
LEHD Primary Jobs
23
Study Results
Model HBW Trips
CTPP JTW Trips
24
Agenda




Objective
LEHD Description
Data Analysis
Future Directions
25
Future Directions

Potential data source for FSUTMS






ES 202 – Employment Data
LEHD – Model Calibration
Coordination effort for data aggregation
Work with Census Bureau to produce LEHD for Florida
model
Variability of data over time
Stay tuned


Vidya @ [email protected] (850-414-4924)
Krishnan @ [email protected] (850-219-6388)
26