sysid,site_id,site_name,sensor_id,obs_date_time,avg_speed,avg_headway,normal_vol,long_vol,occupancy,Sensor_position_name,Lane_id 512,0,Adair (I-80),0,2013-06-17 18:30:18.000,66.48659,65535.00000,19.00000,11.00000,8.00000,I-80 EB Driving Lane,0 512,0,Adair (I-80),0,2013-06-17 18:30:18.000,70.83618,65535.00000,8.00000,2.00000,2.00000,I-80 EB Passing Lane,1 512,0,Adair (I-80),0,2013-06-17 18:30:18.000,75.80714,65535.00000,4.00000,2.00000,1.00000,I-80 WB Passing Lane,2 512,0,Adair (I-80),0,2013-06-17 18:30:18.000,68.97207,65535.00000,14.00000,5.00000,4.00000,I-80 WB Driving Lane,3 512,1,Algona (US 18),0,2013-06-17 18:28:20.000,54.68056,65535.00000,2.00000,1.00000,,IA-18 EB,0 512,1,Algona (US 18),0,2013-06-17 18:28:20.000,56.54467,65535.00000,8.00000,4.00000,3.00000,IA-18 WB,1 512,2,Alton,0,2013-06-17 18:31:17.000,57.78741,65535.00000,5.00000,1.00000,1.00000,IA-10 WB,0 512,2,Alton,0,2013-06-17 18:31:17.000,57.78741,65535.00000,4.00000,,,IA-10 EB,1 512,4,Ames (I-35/13th St),0,2013-06-17 17:54:24.000,72.70029,65535.00000,7.00000,2.00000,1.00000,I-35 S/B Pass Lane,2 512,4,Ames (I-35/13th St),0,2013-06-17 17:54:24.000,69.59344,65535.00000,17.00000,8.00000,7.00000,I-35 S/B Drive Lane,3 512,4,Ames (I-35/13th St),0,2013-06-17 17:54:24.000,69.59344,65535.00000,18.00000,6.00000,5.00000,I-35 N/B Drive Lane,0 512,4,Ames (I-35/13th St),0,2013-06-17 17:54:24.000,75.80714,65535.00000,8.00000,,1.00000,I-35 N/B Pass Lane,1 512,6,Avoca (I-80),0,2013-06-17 18:32:04.000,72.70029,65535.00000,9.00000,5.00000,4.00000,I-80 EB Driving,0 512,6,Avoca (I-80),0,2013-06-17 18:32:04.000,71.45755,65535.00000,6.00000,1.00000,1.00000,I-80 EB Passing,1 512,6,Avoca (I-80),0,2013-06-17 18:32:04.000,73.94303,65535.00000,9.00000,1.00000,2.00000,I-80 WB Passing,2 512,6,Avoca (I-80),0,2013-06-17 18:32:04.000,67.72933,65535.00000,14.00000,6.00000,5.00000,I-80 WB Driving,3 512,7,Burlington (US 34),0,2013-06-17 18:30:53.000,68.97207,65535.00000,1.00000,1.00000,,US-34 WB DL,0 512,7,Burlington (US 34),0,2013-06-17 18:30:53.000,55.92330,65535.00000,6.00000,2.00000,2.00000,US-34 WB PL,1 512,7,Burlington (US 34),0,2013-06-17 18:30:53.000,58.40878,65535.00000,3.00000,1.00000,1.00000,US-34 EB PL,2 512,7,Burlington (US 34),0,2013-06-17 18:30:53.000,54.68056,65535.00000,13.00000,4.00000,4.00000,US-34 EB DL,3 512,8,Carroll (US-30),0,2013-06-17 18:31:10.000,53.43782,65535.00000,5.00000,,1.00000,US-30 WB DL,0 512,8,Carroll (US-30),0,2013-06-17 18:31:10.000,50.95234,65535.00000,3.00000,2.00000,1.00000,US-30 WB PL,1 512,8,Carroll (US-30),0,2013-06-17 18:31:10.000,72.70029,65535.00000,2.00000,2.00000,,US-30 EB PL,2 512,8,Carroll (US-30),0,2013-06-17 18:31:10.000,57.78741,65535.00000,5.00000,3.00000,1.00000,US-30 EB DL,3 512,9,Cedar Rapids (I-380),0,2013-03-24 00:20:44.000,42.87453,65535.00000,9.00000,,2.00000,I-380 NB Ramp,0 512,9,Cedar Rapids (I-380),0,2013-03-24 00:20:44.000,43.49590,65535.00000,7.00000,,1.00000,I-380 NB DL,1 512,9,Cedar Rapids (I-380),0,2013-03-24 00:20:44.000,50.95234,65535.00000,13.00000,1.00000,3.00000,I-380 NB ML,2 512,9,Cedar Rapids (I-380),0,2013-03-24 00:20:44.000,50.95234,65535.00000,2.00000,,,I-380 NB PL,3 512,9,Cedar Rapids (I-380),0,2013-03-24 00:20:44.000,46.60275,65535.00000,,,,I-380 SB PL,4 512,9,Cedar Rapids (I-380),0,2013-03-24 00:20:44.000,45.98138,65535.00000,,,,I-380 SB ML,5 512,9,Cedar Rapids (I-380),0,2013-03-24 00:20:44.000,41.63179,65535.00000,,,,I-380 SB DL,6 512,9,Cedar Rapids (I-380),0,2013-03-24 00:20:44.000,39.76768,65535.00000,,,,I-380 SB Ramp,7 512,10,Cedar Rapids (US 30),0,2013-06-17 18:35:03.000,64.62248,65535.00000,21.00000,6.00000,6.00000,US-30 EB DL,0 512,10,Cedar Rapids (US 30),0,2013-06-17 18:35:03.000,68.97207,65535.00000,8.00000,1.00000,2.00000,US-30 EB PL,1 512,10,Cedar Rapids (US 30),0,2013-06-17 18:35:03.000,60.89426,65535.00000,8.00000,2.00000,2.00000,US-30 WB PL,2 512,10,Cedar Rapids (US 30),0,2013-06-17 18:35:03.000,58.40878,65535.00000,15.00000,6.00000,5.00000,US-30 WB DL,3 512,11,Centerville (IA 2),0,2013-06-17 17:52:55.000,57.78741,65535.00000,4.00000,1.00000,1.00000,IA-2 WB,0 512,11,Centerville (IA 2),0,2013-06-17 17:52:55.000,63.37974,65535.00000,1.00000,1.00000,,IA-2 EB,1 512,13,Creston (US 34),0,2013-06-14 15:20:57.000,54.68056,65535.00000,,,,IA-34 EB,0 512,13,Creston (US 34),0,2013-06-14 15:20:57.000,50.95234,65535.00000,,,,IA-34 WB,1 512,14,Davenport (I-80/I-280),0,2013-06-17 18:24:57.000,71.45755,65535.00000,36.00000,31.00000,6.00000,I-80 EB Driving,0 512,14,Davenport (I-80/I-280),0,2013-06-17 18:24:57.000,74.56440,65535.00000,27.00000,19.00000,2.00000,I-80 EB Passing,1 512,15,Decorah (IA 9),0,2013-06-17 18:27:09.000,56.54467,65535.00000,3.00000,,,IA-9 WB,0 512,15,Decorah (IA 9),0,2013-06-17 18:27:09.000,55.92330,65535.00000,3.00000,,,IA-9 EB,1 512,19,De Witt (US 30/US 61),0,2013-06-17 18:32:08.000,40.38905,65535.00000,6.00000,1.00000,2.00000,US-61 SB Ramp,0 512,19,De Witt (US 30/US 61),0,2013-06-17 18:32:08.000,56.54467,65535.00000,7.00000,4.00000,2.00000,US-61 SB DL,1 512,19,De Witt (US 30/US 61),0,2013-06-17 18:32:08.000,72.70029,65535.00000,,,,US-61 SB PL,2 512,19,De Witt (US 30/US 61),0,2013-06-17 18:32:08.000,62.75837,65535.00000,1.00000,,,US-61 NB PL,3 512,19,De Witt (US 30/US 61),0,2013-06-17 18:32:08.000,67.72933,65535.00000,9.00000,7.00000,4.00000,US-61 NB DL,4 512,20,Dubuque (US 20),0,2013-06-17 18:25:04.000,37.90357,65535.00000,20.00000,1.00000,7.00000,US20 EB DL,0 512,20,Dubuque (US 20),0,2013-06-17 18:25:04.000,42.87453,65535.00000,20.00000,3.00000,7.00000,US20 EB PL,1 512,20,Dubuque (US 20),0,2013-06-17 18:25:04.000,33.55398,65535.00000,4.00000,4.00000,2.00000,US20 WB Exit Left 1,2 512,20,Dubuque (US 20),0,2013-06-17 18:25:04.000,26.71891,65535.00000,4.00000,4.00000,2.00000,US20 WB Exit Left 2,3 512,20,Dubuque (US 20),0,2013-06-17 18:25:04.000,42.87453,65535.00000,14.00000,8.00000,6.00000,US20 WB PL,4 512,20,Dubuque (US 20),0,2013-06-17 18:25:04.000,34.79672,65535.00000,18.00000,9.00000,11.00000,US20 WB DL,5 512,25,Jefferson (IA 4),0,2013-06-17 18:33:41.000,60.89426,65535.00000,3.00000,,,IA-4 SB,0 512,25,Jefferson (IA 4),0,2013-06-17 18:33:41.000,49.70960,65535.00000,3.00000,1.00000,1.00000,IA-4 NB,1 512,27,Manchester (US 20),0,2013-06-17 18:27:57.000,68.97207,65535.00000,7.00000,,1.00000,US-20 WB DL,0 512,27,Manchester (US 20),0,2013-06-17 18:27:57.000,67.72933,65535.00000,3.00000,,,US-20 WB PL,1 512,27,Manchester (US 20),0,2013-06-17 18:27:57.000,69.59344,65535.00000,,,,US-20 EB PL,2 512,27,Manchester (US 20),0,2013-06-17 18:27:57.000,69.59344,65535.00000,5.00000,4.00000,1.00000,US-20 EB DL,3 512,30,Mason City (I-35),0,2013-06-17 18:29:35.000,68.97207,65535.00000,21.00000,9.00000,3.00000,I-35 NB Drive Lane,0 512,30,Mason City (I-35),0,2013-06-17 18:29:35.000,73.94303,65535.00000,7.00000,,,I-35 NB Passing Lane,1 512,30,Mason City (I-35),0,2013-06-17 18:29:35.000,74.56440,65535.00000,19.00000,,1.00000,I-35 SB Passing Lane,2 512,30,Mason City (I-35),0,2013-06-17 18:29:35.000,69.59344,65535.00000,38.00000,11.00000,4.00000,I-35 SB Drive Lane,3 512,31,Missouri Valley (I-29),0,2013-06-17 18:28:29.000,,65535.00000,,,,I-29 NB,0 512,31,Missouri Valley (I-29),1,2013-06-17 18:27:18.000,73.94303,65535.00000,10.00000,2.00000,2.00000,I-29 SB PL,1 512,33,New Hampton (US 18),0,2013-06-17 18:24:42.000,51.57371,65535.00000,5.00000,1.00000,2.00000,US-18 WB,0 512,33,New Hampton (US 18),0,2013-06-17 18:24:42.000,56.54467,65535.00000,1.00000,,,US-18 EB,1 512,34,Onawa (I-29),0,2013-06-17 18:28:36.000,75.80714,65535.00000,9.00000,5.00000,3.00000,I-29 SB Driving,0 512,34,Onawa (I-29),0,2013-06-17 18:28:36.000,73.94303,65535.00000,3.00000,,,I-29 SB Passing,1 512,34,Onawa (I-29),0,2013-06-17 18:28:36.000,72.70029,65535.00000,4.00000,1.00000,1.00000,I-29 NB Passing,2 512,34,Onawa (I-29),0,2013-06-17 18:28:36.000,67.72933,65535.00000,10.00000,3.00000,3.00000,I-29 NB Driving,3 512,35,Osceola (I-35),0,2013-06-17 18:28:05.000,37.90357,65535.00000,,,,I-35 N/B Ramp,0 512,35,Osceola (I-35),0,2013-06-17 18:28:05.000,66.48659,65535.00000,,,,I-35 N/B Drive Lane,1 512,35,Osceola (I-35),0,2013-06-17 18:28:05.000,66.48659,65535.00000,,,,I-35 N/B Pass Lane,2 512,35,Osceola (I-35),0,2013-06-17 18:28:05.000,58.40878,65535.00000,,,,I-35 S/B Pass Lane,3 512,35,Osceola (I-35),0,2013-06-17 18:28:05.000,67.72933,65535.00000,,,,I-35 S/B Drive Lane,4 512,36,Ottumwa (US 63),0,2013-06-17 18:29:51.000,40.38905,65535.00000,18.00000,4.00000,7.00000,US-63 NB DL,0 512,36,Ottumwa (US 63),0,2013-06-17 18:29:51.000,42.87453,65535.00000,5.00000,1.00000,1.00000,US-63 NB PL,1 512,36,Ottumwa (US 63),0,2013-06-17 18:29:51.000,41.63179,65535.00000,19.00000,4.00000,6.00000,US-63 SB PL,2 512,36,Ottumwa (US 63),0,2013-06-17 18:29:51.000,48.46686,65535.00000,6.00000,1.00000,2.00000,US-63 SB DL,3 512,37,Pella (IA 163),0,2013-06-17 18:30:19.000,67.72933,65535.00000,6.00000,2.00000,2.00000,IA-163 WB DL,0 512,37,Pella (IA 163),0,2013-06-17 18:30:19.000,68.97207,65535.00000,1.00000,,,IA-163 WB PL,1 512,37,Pella (IA 163),0,2013-06-17 18:30:19.000,76.42851,65535.00000,1.00000,,,IA-163 EB PL,2 512,37,Pella (IA 163),0,2013-06-17 18:30:19.000,67.72933,65535.00000,12.00000,2.00000,2.00000,IA-163 EB DL,3 512,40,Sigourney (IA 92),0,2013-06-17 18:28:20.000,60.89426,65535.00000,,,,East Bound,0 512,40,Sigourney (IA 92),0,2013-06-17 18:28:20.000,59.65152,65535.00000,3.00000,2.00000,1.00000,West Bound,1 512,41,Moville (US 20),0,2013-06-17 18:28:30.000,48.46686,65535.00000,6.00000,,1.00000,US-20 WB DL,0 512,41,Moville (US 20),0,2013-06-17 18:28:30.000,52.81645,65535.00000,1.00000,,,US-20 WB PL,1 512,41,Moville (US 20),0,2013-06-17 18:28:30.000,50.95234,65535.00000,4.00000,,,US-20 EB PL,2 512,41,Moville (US 20),0,2013-06-17 18:28:30.000,55.92330,65535.00000,2.00000,,,US-20 EB DL,3 512,42,Spencer (US 18),0,2013-06-17 18:21:28.000,60.89426,65535.00000,4.00000,2.00000,1.00000,US-18 EB,0 512,42,Spencer (US 18),0,2013-06-17 18:21:28.000,54.68056,65535.00000,8.00000,1.00000,2.00000,US-18 WB,1 512,43,Storm Lake (US 71/IA 3),0,2013-05-29 20:26:49.000,40.38905,65535.00000,5.00000,1.00000,2.00000,IA-71 SB,0 512,43,Storm Lake (US 71/IA 3),0,2013-05-29 20:26:49.000,32.93261,65535.00000,7.00000,2.00000,4.00000,IA-71 NB,1 512,44,Tipton (I-80),0,2013-06-17 18:28:19.000,67.72933,65535.00000,16.00000,10.00000,6.00000,I80 EB DL,0 512,44,Tipton (I-80),0,2013-06-17 18:28:19.000,70.83618,65535.00000,6.00000,1.00000,1.00000,I80 EB PL,1 512,44,Tipton (I-80),0,2013-06-17 18:28:19.000,69.59344,65535.00000,10.00000,2.00000,2.00000,I80 WB PL,2 512,44,Tipton (I-80),0,2013-06-17 18:28:19.000,69.59344,65535.00000,19.00000,10.00000,6.00000,I80 WB DL,3 512,46,Waterloo (US 20),0,2013-06-17 18:26:55.000,61.51563,65535.00000,9.00000,2.00000,2.00000,US20 WB DL,0 512,46,Waterloo (US 20),0,2013-06-17 18:26:55.000,64.62248,65535.00000,1.00000,,,US20 WB PL,1 512,46,Waterloo (US 20),0,2013-06-17 18:26:55.000,55.92330,65535.00000,15.00000,6.00000,5.00000,US20 EB PL,2 512,46,Waterloo (US 20),0,2013-06-17 18:26:55.000,55.92330,65535.00000,,,,US20 EB DL,3 512,47,Williams (I-35),0,2013-06-17 18:32:13.000,68.97207,65535.00000,12.00000,4.00000,4.00000,SB Driving,0 512,47,Williams (I-35),0,2013-06-17 18:32:13.000,73.94303,65535.00000,1.00000,,,SB Passing,1 512,47,Williams (I-35),0,2013-06-17 18:32:13.000,68.97207,65535.00000,4.00000,,,NB Passing,2 512,47,Williams (I-35),0,2013-06-17 18:32:13.000,67.72933,65535.00000,9.00000,3.00000,3.00000,NB Driving,3 512,48,Williamsburg (I-80),0,2013-06-17 18:32:25.000,68.97207,65535.00000,33.00000,32.00000,4.00000,I-80 WB Driving,0 512,48,Williamsburg (I-80),0,2013-06-17 18:32:25.000,74.56440,65535.00000,31.00000,31.00000,3.00000,I-80 WB Passing,1 512,48,Williamsburg (I-80),0,2013-06-17 18:32:25.000,71.45755,65535.00000,24.00000,9.00000,1.00000,I-80 EB Passing,2 512,48,Williamsburg (I-80),0,2013-06-17 18:32:25.000,64.62248,65535.00000,42.00000,38.00000,7.00000,I-80 EB Driving,3 512,49,Hanlontown (I-35),0,2013-06-17 18:35:03.000,67.72933,65535.00000,11.00000,3.00000,3.00000,I-35 SB Driving,0 512,49,Hanlontown (I-35),0,2013-06-17 18:35:03.000,68.97207,65535.00000,12.00000,2.00000,3.00000,I-35 SB Passing,1 512,49,Hanlontown (I-35),0,2013-06-17 18:35:03.000,58.40878,65535.00000,22.00000,8.00000,8.00000,I-35 NB Passing,2 512,49,Hanlontown (I-35),0,2013-06-17 18:35:03.000,50.95234,65535.00000,,,,I-35 NB Driving,3 512,50,Steamboat Rock (US20),0,2013-06-17 18:16:24.000,69.59344,65535.00000,7.00000,1.00000,1.00000,US-20 WB DL,0 512,50,Steamboat Rock (US20),0,2013-06-17 18:16:24.000,68.97207,65535.00000,2.00000,,,US-20 WB PL,1 512,50,Steamboat Rock (US20),0,2013-06-17 18:16:24.000,70.83618,65535.00000,2.00000,,,US-20 EB PL,2 512,50,Steamboat Rock (US20),0,2013-06-17 18:16:24.000,67.72933,65535.00000,10.00000,4.00000,3.00000,US-20 EB DL,3 512,51,Ida Grove,0,2013-06-17 18:31:31.000,37.90357,65535.00000,6.00000,1.00000,3.00000,IA-175 WB,0 512,51,Ida Grove,0,2013-06-17 18:31:31.000,51.57371,65535.00000,2.00000,1.00000,,IA-175 EB,1 512,52,Anamosa (US 151),0,2013-06-17 18:30:44.000,65.86522,65535.00000,8.00000,2.00000,2.00000,HWY 151 WB Driving ,0 512,52,Anamosa (US 151),0,2013-06-17 18:30:44.000,69.59344,65535.00000,3.00000,,,HWY 151 WB Passing,1 512,52,Anamosa (US 151),0,2013-06-17 18:30:44.000,72.70029,65535.00000,7.00000,1.00000,1.00000,HWY 151 EB Passing,2 512,52,Anamosa (US 151),0,2013-06-17 18:30:44.000,68.97207,65535.00000,13.00000,2.00000,2.00000,HWY 151 EB Driving,3 512,52,Anamosa (US 151),0,2013-06-17 18:30:44.000,46.60275,65535.00000,6.00000,3.00000,2.00000,HWY 151 EB Exit Ramp,4 512,53,Colfax,0,2013-06-17 18:31:34.000,70.83618,65535.00000,21.00000,11.00000,8.00000,I-80 EB Driving Lane,0 512,53,Colfax,0,2013-06-17 18:31:34.000,75.80714,65535.00000,10.00000,1.00000,2.00000,I-80 EB Passing Lane,1 512,53,Colfax,0,2013-06-17 18:31:34.000,,65535.00000,8.00000,1.00000,1.00000,I-80 WB Passing Lane,2 512,53,Colfax,0,2013-06-17 18:31:34.000,72.70029,65535.00000,25.00000,14.00000,9.00000,I-80 WB Driving Lane,3 512,55,Bedford,0,2013-06-17 18:35:05.000,62.75837,65535.00000,1.00000,,,IA-2 WB,0 512,55,Bedford,0,2013-06-17 18:35:05.000,61.51563,65535.00000,2.00000,,,IA-2 EB,1 512,57,Tama,0,2013-06-17 18:25:50.000,55.92330,65535.00000,5.00000,2.00000,1.00000,Hwy 30 WB,0 512,57,Tama,0,2013-06-17 18:25:50.000,37.90357,65535.00000,3.00000,3.00000,3.00000,Hwy 30 EB,1 512,57,Tama,0,2013-06-17 18:25:50.000,32.93261,65535.00000,1.00000,1.00000,,Hwy 30 Right Turn,2 512,58,Plainfield,0,2013-06-17 18:32:31.000,66.48659,65535.00000,13.00000,4.00000,3.00000,US-218 SB DL,0 512,58,Plainfield,0,2013-06-17 18:32:31.000,62.75837,65535.00000,3.00000,1.00000,,US-218 SB PL,1 512,58,Plainfield,0,2013-06-17 18:32:31.000,70.83618,65535.00000,2.00000,1.00000,,US-218 NB PL,2 512,58,Plainfield,0,2013-06-17 18:32:31.000,68.97207,65535.00000,12.00000,3.00000,3.00000,US-218 NB DL,3 512,59,Cantril,0,2013-06-17 18:33:44.000,59.65152,65535.00000,3.00000,,,IA-2 EB,0 512,59,Cantril,0,2013-06-17 18:33:44.000,56.54467,65535.00000,1.00000,,,IA-2 WB,1 512,60,Denison,0,2013-06-17 18:29:32.000,60.89426,65535.00000,6.00000,,1.00000,IA-59 SB,0 512,60,Denison,0,2013-06-17 18:29:32.000,55.92330,65535.00000,4.00000,1.00000,1.00000,IA-59 NB,1