Dear John –
Here is my 2007 document about LEHD On the Map.
We have not had time to re-evaluate new data (QCEW 2005 and 2006 ) released in the last couple of months from On the Map.
It is VERY important to understand that the LEHD On the Map includes “covered” employment only. This means workers who are covered by unemployment insurance.
To answer John’s specific questions:
1. The workplace location is taken
from the QCEW (aka ES 202 files). The quality of the workplace location
relies on the quality of the QCEW files that EACH States provides to the CB,
particularly the quality and completeness of voluntary Multiple Site B
2. Residence location is taken from
federal administrative records, and then moved slightly to protect
confidentiality. Most residences are kept within the same cens
3. Social Security Number (SSN) is the variable that ties the different datasets together, but the SSN is not kept on the files. The actual SSN is changed into a unique ID. And the data when reported in On the Map is not for a microdata record, but is grouped as synthetic block data.
Here is the link to the Cens
The paper I relied on earlier was:
"LEHD Infrastructure Files and the Creation of the Quarterly Workforce Indicators" by J. Abowd; B.E. Stephens, L. Vilhuber, F. Andersson, K.L. McKinney, M. Roemer, and S. Woodcock, dated December 5, 2005
There is an NCHRP 08-36 project, task 81 which is a small (“Quick Response”) research project to examine how ACS and LEHD On the Map could potentially be combined. Cambridge Systematics is conducting the research, and the NCHRP contact is Nanda Srinivasan.
I don’t know why the word
“synthetic” is raising so many red flags. Transportation
planners have long
I don’t think that synthetic data
can summarily be called GOOD nor BAD. Data
Hope this helps.
FHWA Office of Planning (
Behalf Of John Hodges-Copple
Sent: Monday, October 06, 2008 5:39 AM
Subject: [CTPP] seeking guidance on worker flows from the local employmentdynamics On The Map data
Does anyone have a short, "plain English"
explanation of the residence-to-workplace flows from this data and how it
compares to the old long-form commuting data from the 2000 and earlier cens
Any guidance would be appreciated; my brief hunting through the documentation didn't give me the clear specifics I was hoping.
----- Original Message -----
From: Paddock, Bob
Sent: Thursday, October 02, 2008 11:36 AM
Subject: RE: [CTPP] Need your thoughts on CTPP products
using ACS standardtables
The tables currently found in the ACS have been sufficient for my needs and concerns. The idea expressed by Nathan is intriguing (if I understand it correctly); by “multiple geographic units”, do we mean vario usMCDs, TAZs or the 20,000 population areas?
Concerning the “Journey to Work Trends”, I made use of that data primarily as comparative analysis for the Twin Cities region to other MSAs and as a template for a more detailed look at Minneapolis-St.Paul. However, given the workload that appears to exists, I don’t believe that updating the report to include the 2005-07 information would be useful enough to spend additional time and resources ….at least for my specific needs and wants.
<hr size=2 width="100%" align=center tabIndex=-1>
From: firstname.lastname@example.org [mailto:email@example.com] On Behalf OfMurakami, Elaine
Sent:Wednesday, October 01, 2008 4:18 PM
Subject:[CTPP] Need your thoughts on CTPP products using ACS standard tables
Hi Everyone –
I bet you have a lot of questions about CTPP ing the first 3 years of ACS and us TAZs, but unfortunately, I can’t answer them yet!
Given the current uncertainty of the next CTPP (“c
ustom tabulation”) using the ACS, we are moving forward to develop products using standard ACS products. Some of you will recall that we created a series using the first 2005 ACS data products. They are posted on both the FHWA web http://www.fhwa.dot.gov/planning/census/2005tpoverview.htm and on the AASHTO web
On December 9, 2008, the Cens
usBureau plans to release the first 3-year ACS products (surveys completed in 2005, 2006 and 2007). The minimum population threshold is 20,000 for the 3-year products, compared to 65,000 population for the ACS 1-year products. So, while the data is still “swiss cheese,” that is, geographic coverage has holes, a lot more geographic units will be available. The results are still subject to the Cens usBureau rules of “collapsing and filtering” which means that sometimes the data have been suppressed and you will see an "N".
We are now designing new profile sheets, in which we plan to include data from 2000 ( using Cens usSummary File 3 and CTPP2000) and from 2005-2007 ACS. Please let me know if you have any recommendations for specific tables to include (the data m ust be available in both 2000 and from the 2005-2007 ACS). One recommendation from Nathan Erlbaum (NYS DOT) is to create a spreadsheet macro that will sum up multiple geographic units and re-calculate the Margin of Error ( using the materials on Page 96-98 in NCHRP Report 588).
Also, I am wondering if there is any interest in an updated “Journey to Work Trends” report to include the 2005-2007 ACS results. http://www.fhwa.dot.gov/ctpp/jtw/index.htm This report was limited to metropolitan areas with population over 1 million, but had trend data including 1960, 1980, 1990 and 2000. Beca use of redefinitions of metropolitan areas by OMB, the data need to be accumulated from county records for historical comparability, which makes for quite a bit of work. The last report used the 1999 definition, but the 2005-2007 ACS data will be reported using the 2007 OMB definitions (I think). My question for you is: is this report useful enough to spend time and resources on?
Thanks in advance for your opinions.
FHWA Office of Planning ( DC) Wash
206-220-4460 (in ) Seattle
<hr size=2 width="100%" align=center>
ctpp-news mailing list