Transcript Using QCEW Database as the primary source of Employment

Using Quarterly Census of Employment and Wages
(QCEW) Database as the Employment Data Source
presented to
MTF Data Committee
presented by
Capton Siluvairajan
Cambridge Systematics, Inc.
Date: 10/17/2008
Transportation leadership you can trust.
Purpose of this study
Using QCEW Database as the
main source of Employment Data
for Planning / Modelling
1
Why QCEW Data
FREE from the Agency for Workforce Innovation (AWI)
Updated Quarterly
Usage Restrictions - Can be obtained under single contract
between SPO and AWI and distributed statewide
“Using LEHD Data for Travel Demand Models : The Florida
Experience” - Krishnan, Cambridge Systematics
• Review of QCEW
• Comparison between InfoUSA and QCEW data (2004) for
NERPM and POLK
• Conclusion – “QCEW data good source for employment data”
2
Obectives
Research source / methodology that is being used by
others – District 7
Feasibility of coming up with uniform methodology for
whole state using QCEW
Research any QCEW data related issues currently missed
by users
Explore GIS driven tools to extract QCEW data
3
District 7
Uses InfoUSA, BEA and QCEW as data sources
1. Preparation of control totals - QCEW
2. Base year employment estimates into 20 categories
3. InfoUSA numbers adjusted for these 20 categories’ control
totals
4
District 7
5
1.
Agriculture, Forestry, Fishing & Hunting
15.
Office, Professional & Other Services
2.
Mining
16.
Employment Services (employee leasing, temps, staffing)
3.
Construction
17.
Postal Service
4.
Manufacturing
18.
Banking
5.
Freight, Transportation & Warehousing
19.
Personal Services
6.
Wholesale Trade
20.
Educational Services
7.
Comparative Retail
8.
Convenience Retail
9.
Air Transportation
10.
Utilities, Repair & Maintenance
11.
Health Care & Social Services
12.
Government Services
13.
Military
14.
(d) Accommodations
District 7
QCEW (by NAICS)
District 7
BEA Local Area Annual Estimates, Table CA-25
Total Employment by Industry
Year 2001 to 2005 Extrapolated to 2006 using
Average Annual Growth Rate.
District 7
QCEW (by NAICS)
"Making The North American Industrial
Classification System (NAICS) Work For
Transportation“ – AASHTO Study
District 7
QCEW (by NAICS)
Total Non-Farm (BEA) x Category % From AASHTO study
District 7
Use these control totals to expand InfoUSA
10
QCEW Data – Things to note
Employers that report Statewide Employment Numbers
Coded as County 995 & 999
Redistributed using ratio of NAICS category to Statewide total
Example:
Statewide NAICS 4234
= 48,000 (employment)
County 995 + County 999 NAICS 4234
= 4,500 (employment)
County 086 NAICS 4234
= 8,000 (employment)
8,000 / 48,000
= 16.7 percent
4,500 * .167
= 752
So we would add 752 jobs to County 086 NAICS 4234
11
QCEW Data - Data Distribution
GIS Tool for Data Distribution
Encrypts QCEW Data so anybody can use without having
to sign agreement with AWI
Easy to extract using TAZ of County Geography
Automated Geo-coding using built-in TeleAtlas Network
Automated TAZ assignment of Employment data
Prototype already developed and tested
12
QCEW Data - Data Distribution
13