Thanks. This is apparently the reason - we have a difference of about 1.4%. Anyone found a VB Script that will work with ARCGIS to map flows like Nanda suggested with TransCAD? Thanks. -viplav -----Original Message----- From: Don Burrell [mailto:DBURRELL@oki.org] Sent: Thursday, March 06, 2003 2:58 PM To: Putta, Viplava; Srinivasan, Nanda; ctpp-news(a)chrispy.net Subject: RE: [CTPP] new data release? I got stuck on this difference the last time around (1990) and, with Bureau help, determined that the difference is due to employed workers who were not at work during the reference week, that is they were on vacation, sick leave or strike, and thus did not make work trips. I built in a 2% expansion factor into the county to county commuting data to compensate for this for our transportation modeling and for consistency purposes. Another anomaly are the REALLY long commuting trips where workers were working out of town, like thousands of miles away, for the reference week. Don Burrell, AICP, Senior Planner Bicycle / Pedestrian Coordinator (formerly demog-person) OKI Regional Council of Governments 801-B West Eighth St. Suite 400 Cincinnati, OH 45203-1607 513-621-6300 513-621-9325 - fax dburrell(a)oki.org <mailto:dburrell@oki.org> <A bicycle is an instrument for playing the road> -----Original Message----- From: Putta, Viplava [mailto:vputta@incog.org] Sent: Thursday, March 06, 2003 11:56 AM To: Srinivasan, Nanda; ctpp-news(a)chrispy.net Subject: RE: [CTPP] new data release? Thanks Nanda for the link. I just have one question though: The data is for Commuting to work employees in each county. Total employees who reported as commuters to work does not equal the total number employed in respective counties. Is this because of estimates resulting from sampling? Just to illustrate: for Tulsa County in Oklahoma, in 2000 - Total Employed in 2000 : 275,856 Commuting to Work (age 16 and over) : 271,055* *Employees who 'worked at home' are included in commuting to work for each county (271,055 is broken down by means of transportation to work that includes worked at home) Missing is about 4,801 (1.7%) - is this because of long-form sampling? Similar numbers are missing from other counties in our MSA. Thanks. Viplav Putta INCOG -----Original Message----- From: Srinivasan, Nanda [mailto:Nanda.Srinivasan@fhwa.dot.gov] Subject: RE: [CTPP] new data release? (http://www.census.gov/population/www/socdemo/journey.html) Nanda Srinivasan