I - Road Data Bank in the Finnish Road Administration (Finnra)

1
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
2
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

3
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

4
Data transfer through life cycle a Vision
Construction
Planning Desing
Maintenance
Real-time, shared and updated
STANDARD PRODUCT MODEL
5
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

6
Goals of system development
General Information Service Model
Distribution of Information
Integration
Data Warehouse Additional value
Procurement
Planning
Traffic management
Data Architecture
Development of data services
GISDB
BDB
RDB
7
Development of Centralized Data Warehouse
GIS-Base Location
ROAD Segment
RDB RoadsCondition
BDB BridgesCond.
8
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

9
Interfaces of the Road Data Bank today
Mobile use
Output
Input
Web-applications
Batch updating
Files
View
Direct updating
Other systems and services Ex. Digiroad
RDB
Data description
Data tables
Data 1
Data4
Data5
Data3
Data2
DataX
obj
obj
Road address
Interface components (EJB, PLSQL, XML, Sonic)
Updating
GIS
Road geometry
Point, section and areal data
obj
obj
Maps
10
Data model of the RDB
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
003
The address is 512 / 002 / 2893 m
002
001
12
The information stored in the RDB
1. Name of the road 2. Links length (m) type public road, ferry, street etc. history of address code system road region and administrative road class 3. Nodes and intersections coordinates name of intersection or crossing classification grade intersection / grade-separated, reference points, others traffic lights pre-selection lane, canalization, right-of-way 4. Data by distance Sight distance sight distances of 150, 300 and 460 m, percent of the length of road section Curvature - angle, radius and direction Inclination longitudinal inclination direction Municipality, province and region Maintenance area Road classes functional class European road Maintenance classes winter pavement
13
The information stored in the RDB
4. Data by distance Constructive measures 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 4. Data by distance Geogrids in pavement Auxiliary lanes 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)
14
The information stored in the RDB
4. Data by distance Special investigations 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 5. Data by point Sight distance (m) Fixing points and landmarks 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
15
The information stored in the RDB
5. Data by point Intersections of private roads 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 6. Traffic accidents Various data about the conditions, participants and consequences of accidents 7. Data types of regions Several types, optional not nationwide
16
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

17
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.
• gtgtgt Statistics made per 1.1. each Year

18
II - Guidelines for development of RDB in Russia
Markku Tervo, Procurement Manager Finnish Road
Administration, Oulu Road Region
19
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

20
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

22
10

• THOSE PRINCIPLES MUST BE COMMON IN RUSSIA
• regional roads
• federal roads

21
21
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...
• gt there should be a collective management group
  of RDB helps regions to organise work (for
  example RADOR can help to organise this group
  work)

22
22
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...

23
23
TIMETABLE OF RDB OF RUSSIA
STEP THREE
STEP TWO
STEP ONE