1 / 17

PennDOT’s Traffic Data System Redesign

This project focuses on redesigning the Pennsylvania Department of Transportation's (PennDOT) Traffic Data System (TDS) to efficiently manage extensive traffic data. The TDS collects continuous counts from 100 in-pavement counters, gathering over 20 million records monthly from 45,000 temporary count locations. The goal is to create a flexible, integrated web-based solution with limited maintenance costs while overcoming data migration challenges. The project includes tools for data management, analysis, and validation, enhancing the efficiency of traffic analysts and the overall traffic monitoring system.

zeus-rivers
Télécharger la présentation

PennDOT’s Traffic Data System Redesign

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. PennDOT’s Traffic Data System Redesign Greg Ulp, GeoDecisions

  2. TDS Project Background • What is PennDOT’s Traffic Data System (TDS) • 100 in-pavement counters (24/7 continuous counts) • Polling of counters is done each night to collect 24 hours of data • 45,000 temporary count locations • 20,000,000 records of data each month • 9 different applications used to manage the data • Data consumed by several other systems within the DOT • Project Objectives • Produce a Integrated Custom/Flexible Solution • Web-based (internal and external components) • Limited Maintenance Costs • Data Challenges • Data Migration • Amount of data being collected • Impact on existing systems

  3. TDS Project Solution

  4. TDS Temporary Portal

  5. TDS Device File Manager • Device File Manager • ETL GUI • File Definition Editor • I/O Map Editor

  6. TDS File Definition Editor • Allows user to define input stream from counter

  7. TDS I/O Map Editor • Allows user to map data from the counter to the database

  8. TDS I/O Rule Manager • Rule Manger • Define edits/flags for invalid data • Rules are applied while counter data is imported into database

  9. TDS Rule Editor • Define flags for invalid data

  10. TDS Rule Editor

  11. TDS Continuous Data Analysis System (CoDAS) • Used by Traffic Analysts to verify data • Flags pinpoint possible data issues

  12. TDS Continuous Data Analysis System (CoDAS)

  13. TDS Continuous Data Analysis System (CoDAS)

  14. TDS Portal

  15. TDS Traffic Monitoring System (TMS) • Used to manage all 45,000 traffic site locations

  16. TDS Technologies • ASP.net • HTML 5 • Javascript • Angular JS • Crystal Reports • Nhibernate • Oracle • Oracle Partitioning for archiving

  17. Questions Greg Ulp Senior Project Manager GeoDecisions gulp@geodecisions.com

More Related