1 / 40

DATA COLLECTION/APPLICATION METHODS FOR PCD AND SUPPORTING DOCUMENTATION PROCEDURES

8 REMOTE SITES. 1. DATA COLLECTION/APPLICATION METHODS FOR PCD AND SUPPORTING DOCUMENTATION PROCEDURES. 2. 4. 1. Indianapolis. 1. ASC /3 Traffic Signal Data - SQL Data Ingestion Probe Vehicle Travel Time - SQL Data Ingestion NWS Doppler Radar Maps

kael
Download Presentation

DATA COLLECTION/APPLICATION METHODS FOR PCD AND SUPPORTING DOCUMENTATION PROCEDURES

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 8 REMOTE SITES 1 DATA COLLECTION/APPLICATION METHODS FOR PCD AND SUPPORTING DOCUMENTATION PROCEDURES 2 4 1 Indianapolis 1 • ASC/3 Traffic Signal Data • - SQL Data Ingestion • Probe Vehicle Travel Time • - SQL Data Ingestion • NWS Doppler Radar Maps • - Harvesting/Archiving Weather Maps/Info 2 3

  2. 4 DATA COLLECTION/APPLICATION METHODS FOR PCD AND SUPPORTING DOCUMENTATION PROCEDURES • Winter Weather Operation • Equipment Failure • - Master Controller Down (Cycle Times Off) • Daylight Savings Shift 5 Broken Platoons 6 Clock Manually Updated

  3. 1 FTP Harvesting and SQL Database Ingestion Raw Transport to Purdue Ingest to SQL to Archive INTERNET 8 Remote Indiana ASC/3 Locations Purdue Traffic Lab: Scheduled FTP of High Resolution Traffic Controller Data RAW *.dat Files Downloaded into Temp Folder RAW *.dat Files Processed and ingested into SQL Database Unique Traffic Signal Event Records ingested into SQL 2007 Database *.DAT successfully ingested into SQL are moved from TEMP to ARCHIVE folder

  4. 1 ASC/3 SQL Stats (12/06/2009 to 3/31/2010) • STATISTICS: • SQL Database • Total Records = 186,771,808 • Database Size = 14 GB • Total number of collection sites = 8 • Archived Raw *.DAT Files • SQL 2007 Server (Located on PC) • PROCESSOR: Intel Core 2-Duo CP E8200 2.66 GHz • RAM: 3.0 GB • OS: Microsoft Windows XP e.g. PERFORMANCE MEASURES CYCLE LENGTHS VEHICLE COUNTS BY CYCLE PCDs Unique Traffic Signal Event Records ingested into SQL 2007 Database Flow Profiles

  5. 2 Probe Vehicle Harvesting and Database Ingestion Transmission of MAC Address to SQL database via commercial cellular network SQLDatabase: INDOT Server FIXED SENSOR MOBILE SENSOR Query for Travel Times along Corridor WEB Assembled by Jay Wasson, INDOT EXCEL

  6. 3 Doppler Weather Map Harvesting National Weather Service Maps Regional NWS Doppler Maps Harvested and Archived ever 10 minutes Located on INDOT Server INTERNET Doppler Map Corresponding to Event is obtained from Archive Crash or Weather Event is Observed + Assembled by Jay Wasson, INDOT

  7. 4 WINTER EVENT ANALYSIS OF THE SR 37 CORRIDOR BETWEEN (SR 32 & GREENFIELD): Noblesville, IN SR32/SR37 • Weather Tracking • Doppler Radar Mapping • Intersection Travel Time (Bluetooth Analysis) • PCD Generation • Platoon Dispersion • Platoon Shift • Cumulative Travel Times (15 second bins) • Volume Counts (Per Cycle) • AM Peak Flow Profiles SR 37 / Pleasant SR 37 / Town&Country SR 37 / Greenfield

  8. 4 WINTER EVENT CHECK OF THE SR 37 CORRIDOR BETWEEN (SR 32 & GREENFIELD): Noblesville, IN 1/14/10 (Clear) 24 HOURS 1/7/10 (SNOW) SOLID LINES ARE SNOW EVENTS PER/HOUR Data Source: http://www.wunderground.com/ 3 MONTH PERIOD

  9. 4 WINTER EVENT CHECK OF THE SR 37 CORRIDOR BETWEEN (SR 32 & GREENFIELD): Noblesville, IN 1/14/10 (Clear) 24 HOURS 1/7/10 (SNOW) SOLID LINES ARE SNOW EVENTS PER/HOUR Data Source: http://www.wunderground.com/ 3 MONTH PERIOD

  10. 4 PCDs: SR 37 CORRIDOR BETWEEN (SR 32 & GREENFIELD) NB TRAVEL TIME (Thursday: 1/7/2010) SNOW SB TRAVEL TIME (Thursday: 1/7/2010) SNOW b a SB, SR 37 / SR 32 NB, SR 37 / SR 32 SR 37 SR 37 SR 37 SR 37 SB, SR 37 / Pleasant NB, SR 37 / Pleasant 13:43 09:57 15:57 08:06 c AM Peak d SB, SR 37 / Town & Country NB, SR 37 / Town & Country SB, SR 37 / Greenfield NB, SR 37 / Greenfield

  11. 4 PCDs: SR 37 CORRIDOR BETWEEN (SR 32 & GREENFIELD) SB TRAVEL TIME (Thursday: 1/14/2010) CLEAR b NB TRAVEL TIME (Thursday: 1/14/2010) CLEAR a SB, SR 37 / SR 32 NB, SR 37 / SR 32 SR 37 SR 37 SR 37 SR 37 SB, SR 37 / Pleasant NB, SR 37 / Pleasant 13:56 09:59 18:07 08:01 c AM Peak d SB, SR 37 / Town & Country NB, SR 37 / Town & Country SB, SR 37 / Greenfield NB, SR 37 / Greenfield

  12. 4 SR 37 CORRIDOR BETWEEN (SR 32 & GREENFIELD)Cumulative Travel Times (15 second bins) SR32/SR37 NB AM PEAK (06:00 – 09:00) Average ~52 second Increase in Travel Time Pleasant TRAVEL TIME (MINUTES) Town & Country SB AM PEAK (06:00 – 09:00) Average ~48 second Increase in Travel Time Greenfield TRAVEL TIME (MINUTES)

  13. 4 SR 37 CORRIDOR BETWEEN (SR 32 & GREENFIELD)Cumulative Travel Times (15 second bins) SR32/SR37 NB PM PEAK (16:00 – 19:00) Average ~45 second Increase in Travel Time Pleasant TRAVEL TIME (MINUTES) Town & Country SB PM PEAK (16:00 – 19:00) Average ~36 second Increase in Travel Time Greenfield TRAVEL TIME (MINUTES)

  14. SR 37 CORRIDOR (NB Pleasant )Vehicle Volumes per Cycle 4 1/07 VPD = 10,644 TH 1/14 VPD = 15,520 TH 1/14/10 1/7/10

  15. SR 37 CORRIDOR (SB Pleasant )Vehicle Volumes per Cycle 4 1/07 VPD = 10,644 TH 1/14 VPD = 15,520 TH 1/14/10 1/7/10

  16. 4 FLOW PROFILES: SR 37 CORRIDOR BETWEEN (SR 32 & GREENFIELD) NB TRAVEL TIME (Thursday: 1/7/2010) SNOW SB TRAVEL TIME (Thursday: 1/7/2010) SNOW b  AM PEAK   AM PEAK  a SB, SR 37 / SR 32 NB, SR 37 / SR 32 SR 37 SR 37 SR 37 SR 37 SB, SR 37 / Pleasant NB, SR 37 / Pleasant 09:57 15:57 08:06 13:43 c d SB, SR 37 / Town & Country NB, SR 37 / Town & Country SB, SR 37 / Greenfield NB, SR 37 / Greenfield

  17. 4 FLOW PROFILES: SR 37 CORRIDOR BETWEEN (SR 32 & GREENFIELD) SB TRAVEL TIME (Thursday: 1/14/2010) CLEAR b NB TRAVEL TIME (Thursday: 1/14/2010) CLEAR  AM PEAK   AM PEAK  a SB, SR 37 / SR 32 NB, SR 37 / SR 32 SR 37 SR 37 SR 37 SR 37 SB, SR 37 / Pleasant NB, SR 37 / Pleasant 18:07 08:01 13:56 09:59 c d SB, SR 37 / Town & Country NB, SR 37 / Town & Country SB, SR 37 / Greenfield NB, SR 37 / Greenfield

  18. 5 COORDINATION BREAKDOWN ALONG SR 37 CORRIDOR BETWEEN (SR 37 & GREENFIELD): Noblesville, IN SR32/SR37 Pleasant • OBSERVATIONS: • PCD Platoon Breakdown observed 2/12/2010. • At 32/37 (master location) the cycle times per TOD were not lost • For TOD Plans, Cycle Lengths remained fixed on slave controllers and therefore did not match resulting in a loss of coordination for periods of time during the day. • CONCLUSION: • Master Controller re-booted due to power outage • Backup controller batteries were dead and controller lost time on restart performing a cold boot. Broken Platoons 2/12/2010 Town& Country SR 37 / Greenfield

  19. COORDINATION BREAKDOWN ALONG SR 37 CORRIDOR BETWEEN (SR 37 & GREENFIELD): Noblesville, IN 5 FRIDAY:02/08/2010 FRIDAY:02/08/2010 (Cycle Times Coordinated) 13:00 C = 114s NB, SR 37 / SR 32 C = 114s NB, SR 37 / Pleasant C = 114s NB, SR 37 / Town & Country C = 114s NB, SR 37 / Greenfield

  20. COORDINATION BREAKDOWN ALONG SR 37 CORRIDOR BETWEEN (SR 37 & GREENFIELD): Noblesville, IN 5 FRIDAY:02/08/2010 FRIDAY:02/08/2010 (Cycle Times Coordinated) 15:00 C = 116s NB, SR 37 / SR 32 C = 116s NB, SR 37 / Pleasant C = 116s NB, SR 37 / Town & Country C = 116s NB, SR 37 / Greenfield

  21. COORDINATION BREAKDOWN ALONG SR 37 CORRIDOR BETWEEN (SR 37 & GREENFIELD): Noblesville, IN 5 FRIDAY:02/12/2010 FRIDAY:02/12/2010 (Cycle Times) 13:00 C = 114s NB, SR 37 / SR 32 @ 13:00 Last Logged Timing Change C = 114s NB, SR 37 / Pleasant C = 114s NB, SR 37 / Town & Country C = 114s NB, SR 37 / Greenfield

  22. COORDINATION BREAKDOWN ALONG SR 37 CORRIDOR BETWEEN (SR 37 & GREENFIELD): Noblesville, IN 5 FRIDAY:02/12/2010 FRIDAY:02/12/2010 (Cycle Times) 15:00 C = 116s NB, SR 37 / SR 32 @ 15:00 Coordination LOST C = 116s NB, SR 37 / Pleasant C = 114s NB, SR 37 / Town & Country C = 114s NB, SR 37 / Greenfield

  23. COORDINATION BREAKDOWN ALONG SR 37 CORRIDOR BETWEEN (SR 37 & GREENFIELD): Noblesville, IN 5 FRIDAY:02/12/2010 FRIDAY:02/12/2010 (Cycle Times) 15:00 C = 116s NB, SR 37 / SR 32 @ 15:00 Coordination LOST C = 116s NB, SR 37 / Pleasant C = 114s NB, SR 37 / Town & Country C = 114s NB, SR 37 / Greenfield

  24. 6 DAYLIGHT SAVINGS CLOCK RESET OBSERVED ALONG SR 37 CORRIDOR BETWEEN (SR 37 & GREENFIELD): Noblesville, IN SR32/SR37 Pleasant • OBSERVATIONS: • PCD Data missing for a one-hour period (12:23 – 13:23) • CONCLUSION: • Master Controller was re-set on 3/14/2010 for day-light savings • ARIES corrected for time difference at 04:05 and reset clock back to 03:05 (Log Data over-written from 03:05 to 04:00) • Controller was running proper TOD plan, but the clock was off by one hour. • Clock manually reset at 12:23 to 13:23 Town& Country Clock Updated 3/15/2010 SR 37 / Greenfield

  25. 6 DAYLIGHT SAVINGS CLOCK RESET OBSERVED ALONG SR 37 CORRIDOR BETWEEN (SR 37 & GREENFIELD): Noblesville, IN Clock Updated 3/15/2010 MONDAY 3/15/2010 @ 12:23 CLOCKS ADJUSTED TO 13:23 SR32/SR37 Pleasant Town& Country SR 37 / Greenfield

  26. Questions

  27. EXTRA INFO

  28. DAYLIGHT SAVINGS CLOCK RESET OBSERVED ALONG SR 37 CORRIDOR BETWEEN (SR 32 & GREENFIELD): Noblesville, IN SUNDAY 3/14/2010 @ 2:00 DAY LIGHT SAVINGS TIME MONDAY 3/15/2010 @ 12:23 CLOCKS ADJUSTED TO 13:23 Data Overwritten 3/14/2010 Clock Updated 3/15/2010

  29. PCD Interactive Offset Timing for a 4 controller Coordinated System (Weekend Plan) 6 Sub-Optimal Setting Vehicles Arriving Before Green Random Arrivals Platoon Split by Start of Green Vehicles Arriving Before Green Vehicles Arriving on Green Vehicles Arriving Before Green Vehicles Arriving Before Green Vehicles Arriving Just After Yellow

  30. PCD Interactive Offset Timing for a 4 controller Coordinated System (Weekend Plan) 6 Near-Optimal Setting Vehicles Arriving on Green Random Arrivals Vehicles Arriving on Green Most Vehicles Arriving on Green Vehicles Arriving on Green Vehicles Arriving on Green Platoon Split by Start of Red Vehicles Arriving on Green

  31. MONDAY:02/08/2010 FRIDAY:02/12/2010 15:00 15:00 C = 116s C = 116s 1001 NB, SR 37 / SR 32 PCD NB SR 32/37 to GREENFIELD C = 116s C = 116s 1002 NB, SR 37 / Pleasant Striping Observed Coordination Lost @ 15:00 C = 116s C = 114s 1003 NB, SR 37 / Town & Country C = 116s C = 114s Striping Not Observed 1004 NB, SR 37 / Greenfield

  32. MONDAY:02/08/2010 MONDAY:02/15/2010 15:00 15:00 C = 116s C = 116s 1001 NB, SR 37 / SR 32 PCD NB SR 32/37 to GREENFIELD C = 116s C = 116s 1002 NB, SR 37 / Pleasant Striping Observed C = 116s C = 114s 1003 NB, SR 37 / Town & Country Striping Observed on NB…Southern Intersection Coordination may also be off C = 116s C = 114s 1004 NB, SR 37 / Greenfield

  33. SNOW MONDAY:02/08/2010 FRIDAY:02/12/2010 MONDAY:02/15/2010 15:00 15:00 15:00 C = 116s C = 116s C = 116s 1001 NB, SR 37 / SR 32 PCD NB SR 32/37 to GREENFIELD C = 116s C = 116s C = 116s 1002 NB, SR 37 / Pleasant C = 116s C = 114s C = 114s 1003 NB, SR 37 / Town & Country C = 116s C = 114s C = 114s 1004 NB, SR 37 / Greenfield

  34. SNOW MONDAY:02/08/2010 FRIDAY:02/12/2010 MONDAY:02/15/2010 22:00 22:00 22:00 C = FREE C = FREE C = FREE 1001 NB, SR 37 / SR 32 PCD NB SR 32/37 to GREENFIELD C = FREE C = 114s C = 114s 1002 NB, SR 37 / Pleasant C = FREE C = 114s C = 114s 1003 NB, SR 37 / Town & Country C = FREE C = 114s C = 114s 1004 NB, SR 37 / Greenfield

  35. FRIDAY:02/12/2010 FRIDAY:02/12/2010 (Cycle Times) 19:00 C = 114s 1001 NB, SR 37 / SR 32 PCD NB SR 32/37 to GREENFIELD @ 13:00 Last Logged Timing Change @ 19:00 Coordination C = 114s 1002 NB, SR 37 / Pleasant C = 114s 1003 NB, SR 37 / Town & Country C = 114s 1004 NB, SR 37 / Greenfield

  36. FRIDAY:02/12/2010 FRIDAY:02/12/2010 (Cycle Times) 22:00 C = FREE 1001 NB, SR 37 / SR 32 PCD NB SR 32/37 to GREENFIELD @ 13:00 Last Logged Timing Change @ 22:00 Coordination Lost C = 114s 1002 NB, SR 37 / Pleasant C = 114s 1003 NB, SR 37 / Town & Country C = 114s 1004 NB, SR 37 / Greenfield

  37. MONDAY:02/15/2010 WEDNESDAY:02/17/2010 Coordination Re-Established 2/17/2010 @~12:25 15:00 15:00 C = 116s C = 116s 1001 NB, SR 37 / SR 32 PCD NB SR 32/37 to GREENFIELD Coordination re-established ~12:25 C = 116s C = 116s 1002 NB, SR 37 / Pleasant Striping no longer observed C = 114 C = 116s 1003 NB, SR 37 / Town & Country Striping observed Striping no longer Observed and intersection appears to be coordinated C = 114s C = 116s 1004 NB, SR 37 / Greenfield

  38. WEDNESDAY:02/17/2010 Coordination Re-Established 2/17/2010 @~12:25 WEDNESDAY:02/17/2010 (Cycle Times) 15:00 C = 116s 1001 NB, SR 37 / SR 32 PCD NB SR 32/37 to GREENFIELD @ 12:25 Coordination Established @22:00 (FREE) C = 116s 1002 NB, SR 37 / Pleasant C = 116s 1003 NB, SR 37 / Town & Country C = 116s 1004 NB, SR 37 / Greenfield

  39. Platoon Arrivals (Mismatched Cycles) Analysis of EventCodeID 41: Cycle Length Change EXPECTED RESULTS UN-EXPECTED RESULTS SignalID 1 stopped Logging 1/20/2010 (Separate Issue) Cycle time Changed to 114 Second, resolved 2/17/10 Cycle Length Changes Stopped Logging sometime after 13:00

More Related