Statewide Traffic Engineering Warehouse for Archived Regional Data

Document Sample
Statewide Traffic Engineering Warehouse for Archived Regional Data Powered By Docstoc
					Statewide Traffic Engineering Warehouse
      for Archived Regional Data
Statewide ITS Architecture

                 Archived Data
                 User Services




                 STEWARD
    Proposed Data Sources

                  Local TMC’s


  Legacy Data
•RCI
•Traffic Counts
•Crash Records
          Project Objective

• This is a “proof of Concept” project
  and not a complete data warehouse
  development project.
  Current Development Status

• UF has worked with District 2 to
  develop the model for the STEWARD
  database structure and functionality.

• Now talking with with Districts 4, 5, 6
  and 7 to bring them on board.
    What can STEWARD do for TMC
              Managers?
•   Identify detector malfunctions
•   Provide calibration guidance for detectors
•   Perform quality assessment tests on data
•   Provide daily performance measures
•   Facilitate periodic reporting requirements
•   Provide data for research and special studies
STEWARD Test Bed Location:
   •121 RTMS detector stations
   •About 450 individual detection lanes
Archive
Data                Facility Data                          Daily
                                                          Reports




                        ETL Utility

   Raw                                                  Detector
   Data                                                  Data


                                60
                                 15
                                                              QA
                                      5                     Reports

                                  Station Data
                                                 • Lane Distribution
     STEWARD Database
                                                 • I/O Continuity
                        Field        Example
Archive
                        DATE         9/13/2006
Data
                        TIME         08:00:00
                        Direction    1
                        Station_ID   2003
                        Milepost     353.12
                        FwySpeed     55
                        FwyVol       230
                        FwyOcc       10
                        SpeedCV      .09
                        VolRatio     1.65
                        SpeedRatio   1.47
                        EntryVol     55
                        ExitVol      70
     STEWARD Database
                        FwyQA        100%
                        EntryQA      100%
                        ExitQA       100%
Daily conversion Report
                                                 Daily
    • Time covered
                                                Reports
    • Orphan and null detectors
    • Polling interval distribution
Conversion History Summary (1 record per day)
Diagnostic Reports
    • Effective vehicle length distribution
    • Max flow rate at each station


                                                   QA
                                                 Reports
    • Mobility Management (TTI) Tests
    • Lane distribution
    • I/O continuity
    •Comparison with Statistics Office counts
     Database Queries                   Analysis Reports
                                        (CSV Format)


                                 Summary Reports



                        60
                         15
                          5

                         Station Data
STEWARD Database
        Database Queries                   Analysis Reports
                                           (CSV Format)



• Daily Volume Summary for Freeway Lanes and Ramps
• Lane Distribution Summary by Station
• Link Continuity Report
• Performance Analysis Report by Station
• Level of Service Report
•Travel Time Analysis by Link
     Database Queries



                              Summary Reports




Daily Performance Summary
Monthly Performance Summary
Annual Summary and Trend Analysis
All reports are generated in CSV format to
facilitate further analysis, compilation and
                    plotting


                                    Volume-Occupancy graph for S-033, leftmost Lane
                                  (I-95 NB Between University and Bowden at 02-15-06)

                        120


                        100
Volume (Counts, 5min)




                        80


                        60


                        40


                        20


                         0
                              0         2          4             6              8   10   12
                                                       Occupancy (%,5min Avg)
Sample Reports
Freeway and Ramp Volumes
     Input-Output Report

  Diff = Link Output – Link Input
If all entering and exiting lanes
are detected, then a difference
here suggests possible detector
problems
  Lane Balance Report for a Detector Station

   Time      Lane1      Lane2      Lane3        Total   Balance
13:15:00       246
                 Lane    387
                        Balance       420       1053       1.71
13:30:00        254        405        456       1115        1.8
     •Highest lane vol / Lowest lane vol
13:45:00        309        458        470       1237       1.52
     •1.0 Indicates uniform lane distribution
14:00:00        278        433        459       1170       1.65
                            site-specific
     •Large values with no433
14:15:00        301                   462       1196       1.53
     explanation could indicate a detection
14:30:00        298        436        485       1219       1.63
     problem
14:45:00        304        436        494       1234       1.63
15:00:00       342         457        516       1315       1.51
15:15:00       331         457        494       1282       1.49
15:30:00       288         416        465       1169       1.61
Performance Analysis Report
                                                                Vehicle-     Average
                                                     Vehicle          Hour       Spee   Delay (Veh-   Kinetic
Station   Description                                 miles           s            d           hrs)   Energy
  2118    I-95 NB Entrance from Emerson St               3365           90      37.52          0.08   375737
  2117    I-95 NB North of Emerson St    Kinetic Energy
                                                      3530              93      37.94          0.08   413422
  2115    I-95 NB at San Diego Rd                        3812          113      33.62          0.09   367227
  2113     Defined as speed x volume, this measure
          I-95 NB South of Atlantic Blvd   4624   141                           32.69          0.12   353147
  2110     is proportional to the total kinetic energy
          I-95 NB at Atlantic Blvd         1218    23                           53.92          0.01   801233
  2108    I-95 NB Exit to Acosta Bridge    7824   235                           33.25          0.16   446257
           of the traffic stream.
  2106    I-95 NB at Palm Ave                            3997          122      32.82          0.14   257688
  2104
                                        “bottom92line”33.95
           It has been suggested as the 3118
          I-95 NB Entrance from Palm Ave                                                       0.09   314151
  2102    I-95 NB Exit to Park St       5658     201  28.16                                    0.17   306969
  2003
           measure of the productivity of the freeway.44.57
          I-95 NB at Adams St           6713     151                                           0.14   445532
  2006    I-95 NB Entrance from Beaver St        2375    75                     31.55          0.08   265438
           On the other hand, high values of kinetic
  2009    I-95 NB Entrance from State St         3646   111                     32.71          0.11   300507
  2010
           energy8th St
          I-95 NB Exit to
                           might indicate a higher crash 95
                                                 3132                           32.83          0.11   255089
  2014     exposure.
          I-95 NB Exit to MLK Blvd               4380   138                     31.85           0.2   199637
  2015    I-95 NB Entrance from MLK Blvd                 1004           33      30.73          0.07   133596
  2017    I-95 NB Exit to Golfair Blvd                   1273           39      32.53          0.07   160548
  2020    I-95 NB at Gateway Mall                        3041           94       32.5           0.2   134286
  2022    I-95 NB Exit to Lem Turner Blvd                2448           76      32.35          0.18   119400
LOS Report: All Stations, All Day
Travel Time & Delay Report Example




•   All links
•   All origins to a specified destination
•   Specified origin to all destinations
•   Specified origin to specified destination
         Remaining Tasks
• Periodic Report Development
• Develop Quality Assessment
  Procedures
• “Proof of Concept” Data Analysis
• Integrate Legacy Data
                           Southbound
                       TSS data and TC Comparison on 2/9/07


                7000
                6000
                5000                                      2124(TSS)
Hourly Volume




                4000                                      0171 (TC, SB)
                3000                                      2126 (TSS)
                2000
                1000
                  0
                       00

                       00

                       00

                       00

                       00




                       00
                       00




                       00
                     0:

                     0:

                     0:

                     0:

                     0:

                     0:

                     0:

                     0:
                  :0

                  :0

                  :0
                  :0




                  :0

                  :0
                  :0




                  :0
                00




                15

                18
                03

                06

                09

                12




                21



                                  Tim e
                               Hourly Volume
        00
          :0




                    0
                        1000
                               2000
                                           3000
                                                           4000
                                                                           5000
                                                                                  6000
                                                                                         7000
             0:
        02 00
          :0
             0:
        04 00
          :0
             0:
        06 00
          :0
             0
        08 :00
          :0
             0:
        10 00
          :0
             0:
        12 00
          :0
             0:
        14 00
          :0




Tim e
             0
        16 :00
          :0
             0:
        18 00
          :0
             0:
        20 00
          :0
             0:
        22 00
                                                                                                                                       Northbound




          :0
             0:
               00
                                                                                                TSS data and TC Comparison on 2/8/07




                                                               2127(TSS)


                                  2125 (TSS)
                                               0171 (TC, NB)
Discussion?