Regarding the inclusion of federal employment...this only applies to federal civilian employees, not uniformed military since the Dept of Defense will not share military employment records with Census Bureau for the LEHD project. So if you have one, or two or (as in our region's case) three military bases, plus others in reasonable commuting distance (e.g. Pentagon, Fort Belvoir, Fort Myer, etc. in Northern Virginia) the data is still incomplete for the complete commutershed picture. Kevin F Byrnes, AICP Director of Regional Planning and Regional Demographer George Washington Regional Commission 406 Princess Anne St Fredericksburg, VA 22401 Ph (540) 373-2890, x. 18 ________________________________________ From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] On Behalf Of Elaine.Murakami(a)dot.gov [Elaine.Murakami(a)dot.gov] Sent: Wednesday, June 06, 2012 4:59 PM To: ctpp-news(a)chrispy.net; ctpp-news(a)ryoko.chrispy.net Subject: Re: [CTPP] ACS/CTPP vs LEHD Hello Nick – Your results are not unusual, and the CTPP listserv has had discussions about this in the past. You can search the archives. http://www.chrispy.net/pipermail/ctpp-news/ You might want to read the article from Jan 2011 CTPP Status report by Nathan Erbaum (recently deceased). http://www.fhwa.dot.gov/planning/census_issues/ctpp/status_report/sr0111.cfm Also, Bruce Spear from Cambridge Systematics completed the NCHRP project mentioned in Nathan’s article. http://onlinepubs.trb.org/onlinepubs/nchrp/docs/NCHRP08-36(98)_FR.pdf Bruce recently did a webinar for the Census Bureau and perhaps he can share the link to the recording (I assume it was recorded). Finally, just last week, the LEHD project said they had added FEDERAL employment to their database, but I have not checked it yet to see if it makes sense. Previous to this latest release, federal employment was NOT included. I hope that several of you on the CTPP listserv will be taking the time to examine specific locations in your own area, e.g. major federal office buildings, major military installations, that have impacted the utility of the LEHD without requiring a lot of edits and corrections. Also, as you know, the LEHD uses state QCEW and MWR reports, so it does not include self-employed. Self-employed are estimated to be nearly 10 percent of workers, and more likely to work from home (which accounts for shorter commute trip length). We have found in the past that school districts and other local governmental agencies may not distribute their workers to actual worksites and often report only one main address. This occurred in Illinois, where all state workers were assigned to Springfield as their workplace location, but this was a long time ago, and may have been subsequently corrected. There is a separate listserv for LEHD which you could try to post your query. This page, which I have not updated in a long time, include a link to the listserv. http://www.fhwa.dot.gov/planning/census_issues/lehd/ Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle) From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Lindeman, Nicholas (MPO) Sent: Wednesday, June 06, 2012 1:22 PM To: &#39;ctpp-news(a)ryoko.chrispy.net&#39; Subject: [CTPP] ACS/CTPP vs LEHD I’ve sent the following query to both the ACS and CTPP but have not (yet) received a response. I was hoping someone on the mailing list might be able to provide assistance. I’ve been working with Longitudinal Employer-Household Dynamics (LEHD)in On the Map. Specifically worker inflow/outflow analysis at the county level. I’ve discovered that there is a significant difference between the LEHD data and ACS Place of Work data from the 2008-10 3-Year ACS product. I've found that for the Middle Tennessee (Nashville) region the % of workers residing outside their home county is nearly 17 percentage points higher in the LEHD data than in the ACS data. Please see the attached table. I've been tasked with determining the reason(s) for this difference. Any assistance you can provide would be greatly appreciated Thank you, Nick Lindeman Nicholas Lindeman Economic & Systems Data Analyst Nashville Area MPO 800 2nd Ave. S. P.O. Box 196300 Nashville, TN 37219-6300 (615) 862-7198 lindeman@nashvillempo.org<mailto:lindeman@nashvillempo.org> http://www.nashvillempo.org<http://www.nashvillempo.org/>

I will use the current acronym LODES, which stands for LEHD Origin Destination Employment Statistics. The workplace location is NOT moved. The link between a workplace and a residence is Social Security Number which has been changed into a consistent different number. The residence location (which is taken from IRS tax forms) may be moved to protect confidentiality, but in a large majority of cases is kept within the same census tract. No one that I know of, has looked a WHAT address people use on their IRS tax form, but we know that college age students and several other young adults are likely to retain a parent's address, because they are moving their residence too often, or their parent's address is considered their permanent address. Or maybe there are some other tax (?) reasons that people prefer to use one address as their IRS address instead of another. Maybe they have two residences but they prefer to use one for IRS because one state does not have income tax/ Other sources for residence address in LODES include federal benefits such as Medicare, Social Security, Veteran's benefits, but I believe that the vast majority comes from IRS records. The quality of the Multiple Worksite Reports (MWR is inconsistent, because it is up to each State on how much effort is used to clean these up, and it is mandatory only in some states. Also, the method to link an individual worker to a specific worksite is IMPUTED. Only in Minnesota are employers required to report a specific workplace location for MWR. In the ACS, "strange" results can also arise. Some who lives in Arizona may report that they took a subway to work "last week" because they were working in New York City. The ACS is a sample of housing unit addresses. Workplace location is self-reported and geocoded by the Census Bureau. Nearly 25 percent need some level of imputation. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle) From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Graham, Todd Sent: Wednesday, June 06, 2012 2:11 PM To: &#39;ctpp-news(a)chrispy.net&#39;net'; &#39;lindeman(a)nashvillempo.org&#39; Subject: Re: [CTPP] ACS/CTPP vs LEHD Reading the documentation of the two data resources: always a good place to start. At regional or state level of summary, totally different data frames is your main issue: a. Census ACS counts workers through a household survey, relying on individually-provided info on work. Many kinds of work are counted, including self-employment and occasional casual work. b. Meanwhile, the LED uses the data frame of BLS QCEW, counting wage & salary jobs that are "covered" by the Unemployment Insurance system. In Minnesota, over 20% of BEA-counted jobs (a broader employment concept) are outside of this frame, are *not* covered, and thus not counted in LED. At local level, there are still other issues: a. How well can Census ACS represent job locations? b. And does the LED program move its workplace locations around on the map, in order to obscure exact location? Hope that helps. Good luck. Todd Graham | Principal Forecaster Metropolitan Council | 390 North Robert Street | Saint Paul, MN 55101 tel: 1+651-602-1322 | fax: 1+651-602-1674 | e: todd.graham@metc.state.mn.us<mailto:todd.graham@metc.state.mn.us> in: www.linkedin.com/in/toddgraham<http://www.linkedin.com/in/toddgraham> Visit www.metrocouncil.org/data<http://www.metrocouncil.org/data> for the latest in regional information. From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Lindeman, Nicholas (MPO) Sent: Wednesday, June 06, 2012 3:22 PM To: &#39;ctpp-news(a)ryoko.chrispy.net&#39; Subject: [CTPP] ACS/CTPP vs LEHD I've sent the following query to both the ACS and CTPP but have not (yet) received a response. I was hoping someone on the mailing list might be able to provide assistance. I've been working with Longitudinal Employer-Household Dynamics (LEHD)in On the Map. Specifically worker inflow/outflow analysis at the county level. I've discovered that there is a significant difference between the LEHD data and ACS Place of Work data from the 2008-10 3-Year ACS product. I've found that for the Middle Tennessee (Nashville) region the % of workers residing outside their home county is nearly 17 percentage points higher in the LEHD data than in the ACS data. Please see the attached table. I've been tasked with determining the reason(s) for this difference. Any assistance you can provide would be greatly appreciated Thank you, Nick Lindeman Nicholas Lindeman Economic & Systems Data Analyst Nashville Area MPO 800 2nd Ave. S. P.O. Box 196300 Nashville, TN 37219-6300 (615) 862-7198 lindeman@nashvillempo.org<mailto:lindeman@nashvillempo.org> http://www.nashvillempo.org<http://www.nashvillempo.org/> ________________________________ This email is intended to be read only by the intended recipient. This email may be legally privileged or protected from disclosure by law. If you are not the intended recipient, any dissemination of this email or any attachments is strictly prohibited, and you should refrain from reading this email or examining any attachments. If you received this email in error, please notify the sender immediately and delete this email and any attachments.

I wanted to thank everyone who took the time to explain the ACS/CTPP vs. LEHD (LODES) question I submitted earlier this week. Your responses were of great assistance to us. Nick Lindeman Nicholas Lindeman Economic & Systems Data Analyst Nashville Area MPO 800 2nd Ave. S. P.O. Box 196300 Nashville, TN 37219-6300 (615) 862-7198 lindeman@nashvillempo.org<mailto:lindeman@nashvillempo.org> http://www.nashvillempo.org<http://www.nashvillempo.org/> From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Frank Lenk Sent: Thursday, June 07, 2012 8:24 AM To: ctpp-news(a)chrispy.net Subject: Re: [CTPP] ACS/CTPP vs LEHD Elaine - thank you for the concise and precise summary of key differences in the designation of home and work locations between the two data sets. I found this very helpful and informative. Frank Frank Lenk Director of Research Services Mid-America Regional Council 600 Broadway, Suite 200 Kansas City, MO 64105 www.marc.org<http://www.marc.org> 816.474.4240 flenk@marc.org<mailto:flenk@marc.org> 816.701.8237 From: ctpp-news-bounces@chrispy.net<mailto:ctpp-news-bounces@chrispy.net> [mailto:ctpp-news-bounces@chrispy.net]<mailto:[mailto:ctpp-news-bounces@chrispy.net]> On Behalf Of Elaine.Murakami@dot.gov<mailto:Elaine.Murakami@dot.gov> Sent: Wednesday, June 06, 2012 4:38 PM To: ctpp-news@chrispy.net<mailto:ctpp-news@chrispy.net> Subject: Re: [CTPP] ACS/CTPP vs LEHD I will use the current acronym LODES, which stands for LEHD Origin Destination Employment Statistics. The workplace location is NOT moved. The link between a workplace and a residence is Social Security Number which has been changed into a consistent different number. The residence location (which is taken from IRS tax forms) may be moved to protect confidentiality, but in a large majority of cases is kept within the same census tract. No one that I know of, has looked a WHAT address people use on their IRS tax form, but we know that college age students and several other young adults are likely to retain a parent's address, because they are moving their residence too often, or their parent's address is considered their permanent address. Or maybe there are some other tax (?) reasons that people prefer to use one address as their IRS address instead of another. Maybe they have two residences but they prefer to use one for IRS because one state does not have income tax/ Other sources for residence address in LODES include federal benefits such as Medicare, Social Security, Veteran's benefits, but I believe that the vast majority comes from IRS records. The quality of the Multiple Worksite Reports (MWR is inconsistent, because it is up to each State on how much effort is used to clean these up, and it is mandatory only in some states. Also, the method to link an individual worker to a specific worksite is IMPUTED. Only in Minnesota are employers required to report a specific workplace location for MWR. In the ACS, "strange" results can also arise. Some who lives in Arizona may report that they took a subway to work "last week" because they were working in New York City. The ACS is a sample of housing unit addresses. Workplace location is self-reported and geocoded by the Census Bureau. Nearly 25 percent need some level of imputation. Elaine Murakami FHWA Office of Planning 206-220-4460 (in Seattle) From: ctpp-news-bounces@chrispy.net<mailto:ctpp-news-bounces@chrispy.net> [mailto:ctpp-news-bounces@chrispy.net]<mailto:[mailto:ctpp-news-bounces@chrispy.net]> On Behalf Of Graham, Todd Sent: Wednesday, June 06, 2012 2:11 PM To: &#39;ctpp-news(a)chrispy.net&#39;net'; &#39;lindeman(a)nashvillempo.org&#39; Subject: Re: [CTPP] ACS/CTPP vs LEHD Reading the documentation of the two data resources: always a good place to start. At regional or state level of summary, totally different data frames is your main issue: a. Census ACS counts workers through a household survey, relying on individually-provided info on work. Many kinds of work are counted, including self-employment and occasional casual work. b. Meanwhile, the LED uses the data frame of BLS QCEW, counting wage & salary jobs that are "covered" by the Unemployment Insurance system. In Minnesota, over 20% of BEA-counted jobs (a broader employment concept) are outside of this frame, are *not* covered, and thus not counted in LED. At local level, there are still other issues: a. How well can Census ACS represent job locations? b. And does the LED program move its workplace locations around on the map, in order to obscure exact location? Hope that helps. Good luck. Todd Graham | Principal Forecaster Metropolitan Council | 390 North Robert Street | Saint Paul, MN 55101 tel: 1+651-602-1322 | fax: 1+651-602-1674 | e: todd.graham@metc.state.mn.us<mailto:todd.graham@metc.state.mn.us> in: www.linkedin.com/in/toddgraham<http://www.linkedin.com/in/toddgraham> Visit www.metrocouncil.org/data<http://www.metrocouncil.org/data> for the latest in regional information. From: ctpp-news-bounces@chrispy.net<mailto:ctpp-news-bounces@chrispy.net> [mailto:ctpp-news-bounces@chrispy.net]<mailto:[mailto:ctpp-news-bounces@chrispy.net]> On Behalf Of Lindeman, Nicholas (MPO) Sent: Wednesday, June 06, 2012 3:22 PM To: &#39;ctpp-news(a)ryoko.chrispy.net&#39; Subject: [CTPP] ACS/CTPP vs LEHD I've sent the following query to both the ACS and CTPP but have not (yet) received a response. I was hoping someone on the mailing list might be able to provide assistance. I've been working with Longitudinal Employer-Household Dynamics (LEHD)in On the Map. Specifically worker inflow/outflow analysis at the county level. I've discovered that there is a significant difference between the LEHD data and ACS Place of Work data from the 2008-10 3-Year ACS product. I've found that for the Middle Tennessee (Nashville) region the % of workers residing outside their home county is nearly 17 percentage points higher in the LEHD data than in the ACS data. Please see the attached table. I've been tasked with determining the reason(s) for this difference. Any assistance you can provide would be greatly appreciated Thank you, Nick Lindeman Nicholas Lindeman Economic & Systems Data Analyst Nashville Area MPO 800 2nd Ave. S. P.O. Box 196300 Nashville, TN 37219-6300 (615) 862-7198 lindeman@nashvillempo.org<mailto:lindeman@nashvillempo.org> http://www.nashvillempo.org<http://www.nashvillempo.org/> ________________________________ This email is intended to be read only by the intended recipient. This email may be legally privileged or protected from disclosure by law. If you are not the intended recipient, any dissemination of this email or any attachments is strictly prohibited, and you should refrain from reading this email or examining any attachments. If you received this email in error, please notify the sender immediately and delete this email and any attachments.