LEHD data for

bagimpertinentUrban and Civil

Nov 16, 2013 (3 years and 8 months ago)

122 views

0

presented to

Model Task Force Meeting



presented by

Vidya Mysore, FDOT Central Office

Krishnan Viswanathan, Cambridge Systematics, Inc.



12/12/06

LEHD data for
FSUTMS!!!

1

Agenda


Objective


Longitudinal Employer Household Dynamics
(LEHD) Description


Data Analysis


Future Directions

2

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


3

Agenda


Objective


LEHD Description


Data Analysis


Future Directions

4

The LEHD Concept

Longitudinal Employer
-
Household Dynamics Program

(LEHD)

Surveys

Administrative

Records

Censuses

Local

Employment

Dynamics

Local

Transportation

Dynamics

Local

Immigration

Dynamics

5

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

6

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

7

LEHD Origin Destination
Database

Home Block

(U/I Wage Data)

Workplace Block

(QCEW Data)

# of Workers (primary job) and # of Jobs

Home Profile


block group



# workers



Worker distribution



age



earnings



industry

Work Profile


block group



# establishments



# workers



Worker distribution



age



earnings



industry



Demand/ Growth Indicators



Job creation/loss



Hires/separations



Earnings hires/separations


Acknowledgments : US Census Bureau

8

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

9

LEHD Example

Where South Duval residents work

10

Who was sampled?

11

When & how were they
sampled?

12

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

13

LEHD OD with ACS

Home Block

(U/I Wage Data)

Workplace Block

(QCEW Data)

# of Workers (primary job) and # of Jobs

Home Profile


block group



# workers



Worker distribution



age



earnings



industry

Work Profile


block group



# establishments



# workers



Worker distribution



age



earnings



industry



Demand/ Growth Indicators



Job creation/loss



Hires/separations



Earnings hires/separations


ACS Data



Trip Time



Mode



Distance


Acknowledgments : US Census Bureau

14

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

15

LEHD and QCEW Data
Availability


Available at no cost from AWI


Non Disclosure Agreement with AWI


16

Agenda


Objective


LEHD Description


Data Analysis


Future Directions

17

Data Analysis


Models Used


QCEW Data Analysis


Comparison between InfoUSA and QCEW data


Results

18

Models Used

2005 NERPM CF Model

2000 Polk TPO Model

19

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

20

Comparison between InfoUSA
and QCEW Data

NERPM

QCEW

InfoUSA

Model

MAN. INDUSTRIAL


113,003

89,318

54,903

OTHER INDUSTRIAL


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

POLK

QCEW

InfoUSA


Model
(2000)

INDUSTRIAL


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

21

Study Results

Model HBW Trips


LEHD Primary Jobs


22

Study Results

Model HBW Trips


CTPP JTW Trips


23

Study Results

Model HBW Trips


LEHD Primary Jobs


24

Study Results

Model HBW Trips


CTPP JTW Trips


25

Agenda


Objective


LEHD Description


Data Analysis


Future Directions

26

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 @
vidya.mysore@dot.state.fl.us

(850
-
414
-
4924)


Krishnan @
kviswanathan@camsys.com

(850
-
219
-
6388)