Transcript Road Data Bank in the Finnish Road Administration (Finnra)

14.6.2007 / Reijo Prokkola, Matti Raekallio
I - Road Data Bank in the Finnish
Road Administration (Finnra)
Reijo Prokkola, Road Data Expert
Matti Raekallio, Data Manager
Finnra, Central Administration
IT and Road Data Services
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
Contents of the presentation
Use of road data in Finnra
Back ground for Development
Details of Road Data Bank
Guidelines for the development of RDB in Russia
2
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
Use of Road Data in Finnra
Information for decision makers
Asset management
• planning of road maintenance actions
• budgeting in national and regional level
• counting asset value of road network
Level of service of road network / road section
• to guarantee the fluency of traffic
Traffic safety
• identify reasons for accidents
• make roads safer for road users
3
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
Data transfer through life cycle: a Vision
Planning & Desing
Construction
Real-time, shared and updated
STANDARD PRODUCT MODEL
Maintenance
4
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
Challenges
Two levels of information:
• Network level, network model, 100 %, +/- 3 meters
• Design level, product model, projects only, +/- 1 cm
Cost / benefits of collecting data for decision making
Maintenance and quality of data
Several experiments of procurement going on:
• Long term contracts for maintenance / whole life cycle
• Pavement, bridge, lightning etc. management contracts
Outsourcing / insourcing information services
Short life cycle of information technology
5
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
Goals of system development
Data Information
TP
Services
Data Warehouse
UDDI
Additional value
IMS
DW
DOC
Integration
Custom
Planning
Procurement
Traffic
management
Support
Data Architecture
Development of data services
DB
GIS
DB
RDB
BDB
DB
General Information Service Model
Distribution of Information
6
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
Development of Centralized Data Warehouse
GIS-Base
Location
RDB
Roads&Condition
ROAD
Segment
BDB
Bridges&Cond.
7
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
RDB in Finnra
First RDB in 1970's
• ADB, BDB and ADB
• Condition data and management systems in 1980's
• Personal computers and GIS in 1990's
Latest version of RDB introduced beginning of 2006
• The technical frame is based on Oracle IAS10i (J2EE, Forms 9 etc.) and
Oracle10.2 database.
• Web-based applications
40 data types, 1-10 data/each type, total 150 different data
• most used data types: functional class, maintenance class and traffic
amounts (ADT)
• condition data is not in the RDB
8
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
Interfaces of the Road Data Bank today
Mobile use
Output
Input
Web-applications
Batch
Direct
updating updating
Files
Data description
Data tables
Data 1 Data2
obj
Data3
Data4
Data5
DataX
Road address
Updating
GIS
Road geometry
Point, section and areal data
Maps
obj
Interface components
(EJB, PLSQL, XML, Sonic)
RDB
View
obj
Other
systems
and
services
Ex.
Digiroad
obj
9
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
Data model of the RDB
ROADSECTION
ROAD
CARRIAGE
WAY
BDB
BRIDGE
POINT
NODE
ADDRESSHISTORY
GIS
SEGMENT
GEOMETRY
POINT
Start
POINT
FEATURE
POINT
FEATURE
POINT
FEATURE
POINT
FEATURE
End
CONTACT
POINT
FEATURE
WITH LENGTH
FEATURE
WITH LENGTH
FEATURE
WITH LENGTH
FEATURES OF
JUNCTION
JUNCTION
10
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
11
Road Address Code System
• Each road has an unique number
• Roads are divided into sections in main
junctions
• The average lenght of sections is 5 km
• Direction of measuring is the increasing
numbering of sections
• The object is located by distance along the
road measured from the start of the section
• An object with length is defined by the location
of its start- and endpoints
Road = 512
Sections 1, 2 and 3
The address is:
512 / 002 /
2893 m
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
12
The information stored in the RDB
1. Name of the road
4. Data by distance
2. Links
Sight distance
length (m)
type: public road, ferry, street etc.
history of address code system
road region and administrative road class
sight distances of 150, 300 and 460 m, percent
of the length of road section
Curvature
- angle, radius and direction
Inclination
3. Nodes and intersections
coordinates
name of intersection or crossing
classification: grade intersection / gradeseparated, reference points, others
traffic lights
pre-selection lane, canalization, right-of-way
longitudinal inclination
direction
Municipality, province and region
Maintenance area
Road classes
functional class
European road
Maintenance classes
winter
pavement
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
The information stored in the RDB
4. Data by distance
4. Data by distance
Constructive measures
Geogrids in pavement
Auxiliary lanes
method and time
Administrative measures
change of the administrative road class
Motorways and number of
carriage ways
Width of roadway (0.1 m)
Pavement of the road
Land use & Built-up areas
status in the network of the built-up area
type of land use
Groundwater area
class of area
protection
Subgrade layer specialities
number of lanes
type: overtaking, public transport etc.
Width of shoulder (0.25 m)
Pedestrian and bicycle way
ID and type
separation from road
responsibility of maintenance
Lightning
type of pole
maintenance contractor
Speed limit (permanent)
type of limit
speed limit (km/h)
13
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
The information stored in the RDB
4. Data by distance
5. Data by point
Special investigations
Sight distance (m)
Fixing points and landmarks
project, identification
Width of pavement (0.1 m)
Traffic volumes
year of census
Average Daily Traffic (ADT) by vehicle types
types of yearly variations
peak hour traffic
Bearing capacity
value of spring bearing capacity
standard deviation of mean
Maintenance contractor area
Pavement type by lane
Pavement maintenance actions
information about materials
method and impact
description of point by type and location
Railway grade crossing
safety equipment
Technical devices
Service and rest areas
type/level of service
Bus stops
Location of traffic census
Bearing investigation
bearing capacity
deflection by various dimensions
thickness of pavement
14
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
The information stored in the RDB
5. Data by point
6. Traffic accidents
Intersections of private roads
Various data about the
conditions, participants and
consequences of accidents
various information (main roads only)
Bridge
ID (connection to Bridge Data Base) and name
type of bridge: waterway bridge etc.
weight limit
Underpass
number and name of underpass
type of underpass
detour possibility
Height restriction
Width restriction
7. Data types of regions
Several types, optional not
nationwide
15
14.6.2007 / Reijo Prokkola
Road Data Bank in the Finnish Road
Administration (Finnra)
Maintenance of data in RDB
Road regions are responsible for updating data
• measurement programs (preparing or approving)
• data quality (regional level)
Central administration is responsible for coordination of
principles and rules for updating
• managing the contents of RDB
• preparation of procurement contracts
• developing procurement models
• data quality (national level contracts)
Users are responsible for reporting faults in data quality
16
14.6.2007 / Reijo Prokkola, Matti Raekallio
Road Data Bank in the Finnish Road
Administration (Finnra)
Data Quality
Accuracy of geometry is 1 - 3 meters.
Accuracy of attribute data is 0,5 % within the length of road
section.
The data base will not contain real time data but the
changes of the road network and attributes are updated
continuously.
>>> Statistics made per 1.1. each Year
17
1.6.2007 / Markku Tervo
II - Guidelines for development
of RDB in Russia
Markku Tervo, Procurement Manager
Finnish Road Administration,
Oulu Road Region
1.6.2007 / Markku Tervo
Road Data Bank in the Finnish Road
Administration (Finnra)
19
STEPS TO THE FUTURE !!!
• plan the future – take/make goals
• take small steps – do not try jump to the visio
• FIRST principles – then regional work – then RDB of Russia
VISION
2015 -2020
Steps to
the visio
2007
2010
2015
1.6.2007 / Markku Tervo
Guidelines for development of RDB in Russia
20
FIRST STEP
Creating common principles of road data bank
• numbering roads
• creating principles for data record
• road number,
• road section,
• length from the beginning of road section
• etc
• creating the structure of RDB
THOSE PRINCIPLES
• regional roads
• federal roads
22
10
MUST BE COMMON IN RUSSIA
1.6.2007 / Markku Tervo
Guidelines for development of RDB in Russia
SECOND STEP
Planning and implementing regional RDBs using (according) common principles of road
register
• there can be several projects but common
principles must be same !!!
One really BIG question is how to organise RDB work in
regions
• how to implement projects, how to collect data,
how to maintain data, etc...
=> there should be a collective management group of RDB
= helps regions to organise work (for example RADOR can
help to organise this group work)
21
1.6.2007 / Markku Tervo
Guidelines for development of RDB in Russia
THIRD STEP
As soon as RDB work in regions proceed there should
been developed how to combine regional RDBs
• goal should be possibility to combine
automatically (without ”handwork”) RDB of
whole Russia
Why MUST be possibility to combine regional
RDBs to the RDB of Russia?
• For example – how to implement car navigation systems if
combining is not possible ?
• How to make road network plans of Russia systems if
combining is not possible ?
• Etc...
22
1.6.2007 / Markku Tervo
Guidelines for development of RDB in Russia
23
TIMETABLE OF RDB OF RUSSIA
STEP THREE
STEP TWO
STEP ONE
2007
2010
2015
2020