[CTPP] Re: ctpp-news Digest, Vol 33, Issue 10

For those of you who didn't already know, the US Dept of Education maintains a national geo-codable database of K-12 schools at http://nces.ed.gov/ccd/ (go to Data Resources>Build A Table), where you can select a particular geographic area and fields include both school lat/lon and geocodable street address. I've used this site on several occasions to supplement ES202 data to geocode education employment throughout the state of Ohio and for multi-state metro areas. FYI, our ES202 employment agency in this state beginning in 2005 switched from coding all public K-12 employment to the district administrative offices to the individual schools. Sam Granato Ohio DOT, Office of Technical Services 1980 W. Broad Street, Columbus, OH 43223 Phone: 614-644-6796, Fax: 614-752-8646 "You can observe a lot just by watching." - Yogi Berra Dear CTPP listserv: As some of you are aware, the Census Bureau has been working with Department of Labor QCEW (formerly known as ES-202) files, combined with federal administrative records, to synthesize home-to-work flow tabulations for small geography. The first phase which used QCEW for 2002 and 2003 included 12 states: CA, CO, FL, ID, IL, MN, MO, NC, OR, PA, VA and WA. Cross-state commuting was addressed ONLY for MO and IL in a test. In the last 10 months, Ed Christopher and I have held several teleconferences to work together with State DOTs and State Employment Departments to work out data sharing agreements, and to discuss the possibility of improving feedback mechanisms to improve the quality of the data. In the past, when State Employment Departments shared their data, when a State DOT or MPO made "corrections" to the file for using the data in a transportation application, there was no mechanism to recommend that someone in the Employment Department check the original data to make a correction. Most often, this has to do with establishments with multiple sites, where all the employment is coded to one location, rather than multiple locations. Most recently, on the lehd-ltd listserv (see below on how to sign up), there was a discussion about the lack of specific school locations and the assignment of school employment to a district or school board headquarters office location. But, no dataset is perfect. This link includes some materials from a transportation perspective on the LEHD http://www.fhwa.dot.gov/planning/census/lehd.htm Because the LEHD holds promise as a source for annual home-to-work flow tabulation for small geography, we would like to encourage you to examine the data, and to discuss your findings with the transportation data community. We will have a session at the TRB Transportation Planning Application conference in Daytona Beach in May 2007 to discuss some of the work done so far. The Census Bureau now has a new project in place covering 43 states and QCEW data for 2004. In this project, cross-state commuting will be addressed for all states, and the 2002 and 2003 data will be updated to account for cross-state commuting. To sign-up for the lehd-ltd listserv, http://lists.census.gov/mailman/listinfo/lehd-ltd/ Please read Jeremy Wu's email below regarding the Cornell site with access to data from Oregon and Texas, after you register as a user. If my email has any mistakes, I hope that Jeremy will send corrections! Elaine Murakami FHWA Office of Planning 206-220-4460 -----Original Message----- From: lehd-ltd-admin(a)lists.census.gov [mailto:lehd-ltd-admin@lists.census.gov] On Behalf Of jeremy.s.wu(a)census.gov Sent: Tuesday, October 24, 2006 10:30 AM To: lehd-ltd(a)lists.census.gov Subject: [lehd-ltd] On The Map Data Available from Cornell University Oregon and Texas data for On The Map are now available through the Census Bureau's partnership with the Cornell Institute for Social and Economic Research (CISER) at Cornell University. On The Map went live on the Internet in February, and it has grown to 16 states with Georgia to be added in November. On The Map is the first synthetic data product released by the Census Bureau. Ten (10) distinct copies, known as implicates, are produced; one of them is used for the current implementation of On The Map . The CISER site provides an Internet-accessible computing environment dedicated to the exploration and development of synthetic data. Data for the state of Washington are being loaded at this time, and data for other states will be added over time, pending the interests of the states and the users. See attached update for more details or visit http://lehd.dsd.census.gov. (See attached file: OnTheMap Update 061019.pdf)