1 / 20

LEHD OnTheMap Data

LEHD OnTheMap Data. 2011 GIS in Public Transportation Tampa, FL. Bruce Spear. September 15, 2011. Acknowledgements. Findings from NCHRP 8-36, Task 98 Improving Employment Data for Transportation Planning Sponsored by AASHTO Standing Committee on Planning

kristen-jacobs
Download Presentation

LEHD OnTheMap Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LEHD OnTheMap Data 2011 GIS in Public Transportation Tampa, FL Bruce Spear September 15, 2011

  2. Acknowledgements Findings from NCHRP 8-36, Task 98 Improving Employment Data for TransportationPlanning • Sponsored by AASHTO Standing Committee on Planning • Final Report posted at http://onlinepubs.trb.org/onlinepubs/nchrp/docs/NCHRP08-36(98)_FR.pdf

  3. What is LEHD? Longitudinal Employment Household Dynamics • Program to generate new information on workers and employers from existing data sources • Developed by U.S. Census Bureau in coordination with state partners • Based on administrative records • Includes all employment subject to state unemployment insurance (UI) laws

  4. LEHD Data Products • Quarterly Workforce Indicators (QWI) • Quarterly data on employment dynamics (total employment, job creation, wages, and worker turnover) • LEHD Origin-Destination Employment Statistics (LODES) • Annual data on locations and characteristics of workers by residence and workplace, and home-to-work flows

  5. LEHD - OnTheMap • Web-based mapping and reporting application http://lehdmap.did.census.gov/ • Supports multiple analyses involving workplace and worker residence locations • Queries supported atmultiple levels of geography (Census Blocks, Tracts, zip codes, places, urbanized areas, counties, states) • Worker characteristics include: industry type, age, income, race, ethnicity, and education

  6. LODES Data Files • Residence Area Characteristics (RAC) Number and characteristics of workers summarized by residence geography and reporting year • Workplace Area Characteristics (WAC) Number and characteristics of workers summarized by workplace geography and reporting year • Origin-Destination Flows (OD) Number and summary characteristics of workers who reside in one location and work in another location

  7. LODES Data Sources • Employer Characteristics Quarterly Census of Employment & Wages (QCEW) • Reported quarterly by employers to State employment security agencies (SESA) (formerly known as ES-202 data) • Funded and managed by BLS (data quality and integrity) • Enhanced employer files contain data on total monthly employment and total wages by quarter • Multiple Workplace Reports (MWR) provide workplace employment data for employers with multiple worksites.

  8. Data Sources (continued) • Worker Characteristics Personal Characteristics File (PCF) • Derived from Social Security Application File (Numident) • Gender, DOB, Race, Citizenship Composite Person Record (CPR) • Derived from multiple sources (IRS, Medicare, HUD) • Based on worker’s SSN • Worker place of residence Wage Records • List individual employees by social Security Number (SSN) • Provide key link between workers and employers

  9. LEHD Processing Steps

  10. LODES Data Limitations • Excludes some employment categories • Self-employed & Sole Proprietors (6% - 17%) • Federal/Military/Railroad Workers (1% - 20%) • Employment exempt from UI laws (0% - 2%) • Data not currently produced for all States • States missing data include: DC, MA, NH, PR, VI

  11. LODES Data Issues • Multiple Worksite Employers • Some multi-worksite employers refuse to file multiple worksite reports (MWR) • Employers with multiple worksites may show all employees located at primary employer address • MWR non-compliance affects about 5% of all employment, nationwide: • Rates vary significantly from state to state • Lower in States with mandatory MWR reporting • Highest non-compliance among local government agencies

  12. LODES vs. CTPP • LODES is NOT a substitute for CTPP • No trip characteristics in LODES (mode, travel time, departure time) • Public sources of employment data for transportation planning: • Residence/Workplace locations • Origin-destination flows for work trips

  13. LODES vs. CTPP (3-Year)Summary Characteristics

  14. LODES vs. CTPP (3-Year)County Level Findings • Both LODES and CTPP under report total employment by 15 – 17 %, nationally and by state • LEHD – excluded employer categories & non-LED states • CTPP – secondary work trips and suppressed data • CTPP (3-Year) produces significantly higher OD trip rates than LODES, but distributes them over many fewer county pairs.

  15. LODES vs. CTPP (2000)Tract Level Findings • CTPP (2000) produced higher OD trip rates than LODES, but distributed them over many fewer Tract-to-Tract pairs. • Differences in flow rates between common Tracts were much smaller • Differences in employment for individual Tracts could generally be attributed to: • Missing employment categories in LODES • New development occurring after 2000 • i

  16. Work Trip Length Distributions

  17. General Findings • LODES is a good source of data on the distribution of home-to-work flows • More comprehensive and current than CTPP • LODES data should be used carefully and supplemented with local knowledge • Missing employment categories • Multiple worksite employers

More Related