Public Works

1
Public Works
Ontario Road PatrolAlex Brossault Senior
Industry Consultant
2
Agenda

• Using technology to meet the Minimum Maintenance
  Standards
• Solution Ontario Road Patrol (ORP)
• Case study Region of Waterloo/City of
  Peterborough
• ORP Architecture
• Analyzing the Data

3
Minimum Maintenance Standards for Municipal
Highways

• The minimum maintenance standards were developed
  to provide municipalities with a defence against
  liability from actions arising with regard to
  levels of care on roads and bridges.
• Regulation 239/02, which came into force on
  November 1, 2002, contains the minimum
  maintenance standards.

4
Minimum Maintenance Standards for Municipal
Highways

• Ontario Good Roads Association
• www.ogra.org

5
MMS Solution Using Proven Technology

• Ontario Road Patrol
• Collects all event information required by the
  MMS
• Logs all routes traveled
• Tools for event collection
• Advanced Reporting and Notification
• Originally designed with road patrol requirements
  in mind
• Large buttons and simple GUI interface (for field
  use)
• Reporting
• Historical location/time tracking
• Minimum maintenance standards (Ontario regulation
  239/02)
• Configurable event types and associated attribute
  data
• Synchronizes with central in-house database

6
Road Patrol Architecture
7
Case Study Region of Waterloo

• Population 500,000
• Solutions
• Operations (ORP)

8
Case Study Region of Waterloo

• Operations (ORP)
• Responsibilities
• Data Collection, storage, inspection,
  maintenance, and mapping of road related Assets
• Rationale
• Track location history for legal purposes
• Ontario minimum maintenance standards
• Eliminate paper records
• Centralized data storage access
• Reporting

9
Case Study Region of Waterloo

• Software
• Ontario Road Patrol
• Oracle (enterprise GIS database)
• MS Access (field database)
• Hardware
• Tablet PC (Panasonic Toughbook CF18)
• GPS (Globalsat BU-353 GPS Receiver)

10
Case Study City of Peterborough
11
Case Study City of Peterborough
12
Case Study City of Peterborough
13
Analyzing Road Patrol Data

• Reporting
• Standard Reports
• Custom Reports
• Incident Analyst
• Map Based Analysis
• Temporal Reporting

14
Road Patrol Reports

• Reporting
• Inspection Logs
• Required Inspection
• Completed Inspection
• Required Repairs

15
Report Example
16
Incident Analyst for Road Patrol

• It provides an intuitive user friendly
  environment for analyzing any type of occurrence
  that has a geographic location
• Product includes
• Database connectivity to Road Patrol events
• Automated Incident Mapping Commands
• Change Over Time Playback Facilities
• Temporal Reporting

17
High Level Architecture
18
Snow Ice Accumulation
Repeat Incidents Journey to Incidents Change
Over Time Hotspot Detection Incident
Aggregation Temporal Reporting
19
Temporal Reporting

• Definition
• Simple interface for the creation of
  incident/time-of-day histograms
• Benefits
• Create temporal reports on a daily basis to brief
  responders before they go on duty
• Provides the latest information on trends and
  patterns in a locality
• Help managers understand whether current
  deployment patterns are having the desired effect

20
Conclusion

• Ontario Road Patrol is an effective to for easily
  ensuring compliance with the Minimum Maintenance
  Standards
• Ease of use
• Extensive Reporting
• Extended Analysis