|
Tags: connected | life | road | data | rdb | administr | finnra | bank | finnish | type
I - Road Data Bank in the Finnish Road Administration (Finnra)
14.6.2007 / Reijo Prokkola, Matti Raekallio Reijo Prokkola, Road Data Expert Matti Raekallio, Data Manager Finnra, Central Administration IT and Road Data Services
1
|
|
|
|
Contents of the presentation
Road Data Bank in the Finnish Road Administration (Finnra) 14.6.2007 / Reijo Prokkola, Matti Raekallio Use of road data in Finnra Back ground for Development Details of Road Data Bank Guidelines for the development of RDB in Russia
2
|
|
|
|
Use of Road Data in Finnra
Road Data Bank in the Finnish Road Administration (Finnra) 3 14.6.2007 / Reijo Prokkola, Matti Raekallio 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 Road data is videly used in Finnra. First of all it is the basic information for decision makers. Road data is used for planning of road maintenance actions and for budgeting. The asset value of the road network is counted with the data in the road data bank. The physical data of roads and the amount of traffic determine the level of service of the road network. Information in the Road data bank has an important role in traffic safety evaluations.
|
|
|
|
Data transfer through life cycle: a Vision
Road Data Bank in the Finnish Road Administration (Finnra) 4 14.6.2007 / Reijo Prokkola, Matti Raekallio Planning & Desing Construction STANDARD PRODUCT MODEL Real-time, shared and updated Maintenance
4 A goal or vision of data management could be a data transfer through the life cycle of the road, from planning to construction and maintenance of the road. It means that data should be real-time, common and updated. At the end it will enable the development of a standard product model, like house-building already has. Infra-sector has started co-operation in Scandinavia.
|
|
|
|
Challenges
Road Data Bank in the Finnish Road Administration (Finnra) 5 14.6.2007 / Reijo Prokkola, Matti Raekallio 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 Finnra has several challenges for the data management today and in the near future. How are we going to respond to the demands of network level and design level of information. What are reasonable the costs of collecting data compared to the benifits? How are we able to quarantee the quality of data? What are the effects of larger and longer procurement contracts? How much we should oursource information services? How well we shall manage with the race of development of information technology?
|
|
|
|
Goals of system development
Road Data Bank in the Finnish Road Administration (Finnra) 6 14.6.2007 / Reijo Prokkola, Matti Raekallio Support DB Procurement RDB Planning GISDB Custom DB Traffic management BDB Integration Data Warehouse Additional value DOC DW IMS Distribution of Information Data Information Services TP Data Architecture Development of data services UDDI General Information Service Model
6 The goal of the system development is to devide the system structure into functional layers. Each layer has it’s own task in the consept. Databases will be separated from the systems to its own layer. Data of the databases will be integrated to the data warehouses in accordance with a common data achitecture. Finally the data is processed in the data information layer and provided to the users. The advantage of this concept is that it facilitates the use of common service components in each layer. In a long run the system will be more efficient to use and less expensive to maintain.
|
|
|
|
Development of Centralized Data Warehouse
Road Data Bank in the Finnish Road Administration (Finnra) 7 14.6.2007 / Reijo Prokkola, Matti Raekallio GIS-Base Location RDB Roads&Condition BDB Bridges&Cond. ROAD Segment
7 At the moment Finnra is developing a centralized data warehouse for the most important road, bridge and accident data. It enables common data information services and better use of GIS.
|
|
|
|
RDB in Finnra
Road Data Bank in the Finnish Road Administration (Finnra) 8 14.6.2007 / Reijo Prokkola, Matti Raekallio 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 Let's have a closer look at Road Data Bank in Finnra The history of Finnish road information data banks is over 30 years old. The first road, bridge and accident data banks were introduced already in 1970's. In 1980's road condition measurements prepared the way for management systems. Geografic Information gave a new challenge for the development in 1990's. Today we have a third or even fifth generation of RDB. The technical frame is based on the Oracle internet application server and Oracle database. Today the road data bank consists of more than 150 different data. The most used data types are propably functional class of the road, maintenance class and traffic amounts. Road Data Bank does not include the condition data of roads and bridges. They have their own data banks.
|
|
|
|
Interfaces of the Road Data Bank today
Road Data Bank in the Finnish Road Administration (Finnra) 9 14.6.2007 / Reijo Prokkola, Matti Raekallio Point, section and areal data Maps Road geometry Road address Data description Data 1 Data4 Data5 Data3 Data2 DataX Batch updating Files View Direct updating Data tables Updating Web-applications Input Output GIS RDB Mobile use Other systems and services Ex. Digiroad Interface components (EJB, PLSQL, XML, Sonic) obj obj obj obj
9 Road data bank is the primary database for most of the road network data. The structure of the database is a star model. Each data is presented in it’s own table. Therefore it is very easy to add new road attributes in the database. Road data bank offers several possibilities for the other systems to access the database. These facilities minimize the data duplication in different systems. The latets data is also automatically available to the utilizing systems. The updating and reporting of the road data bank is based on web-applications. Web-applications facilitate external access to the Road data bank and updating the database on-line.
|
|
|
|
Data model of the RDB
Road Data Bank in the Finnish Road Administration (Finnra) 10 14.6.2007 / Reijo Prokkola, Matti Raekallio FEATURE WITH LENGTH CARRIAGE WAY POINT FEATURE POINT CONTACT POINT NODE JUNCTION FEATURES OF JUNCTION ADDRESS- HISTORY ROAD POINT FEATURE WITH LENGTH FEATURE WITH LENGTH POINT FEATURE POINT FEATURE Start End SEGMENT GEOMETRY ROAD- SECTION GIS POINT FEATURE BRIDGE BDB
10 The data model of RDB is based on segments and points. Segment is defied by carriage way. Segments are connected to each other by contact points.
|
|
|
|
Road Address Code System
Road Data Bank in the Finnish Road Administration (Finnra) 11 14.6.2007 / Reijo Prokkola, Matti Raekallio 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 The address is: 512 / 002 / 2893 m 001 Road = 512 Sections 1, 2 and 3 003 002
11 The Finnish road address code system is based on road numbers and sections. Every road has an unique number and is devided into road sections. The road attribute is located by the distance from the beginning of the road section. The road attribute with length is defined by the location of its start and end points.
|
|
|
|
The information stored in the RDB
Road Data Bank in the Finnish Road Administration (Finnra) 14.6.2007 / Reijo Prokkola, Matti Raekallio 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
12
|
|
|
|
The information stored in the RDB
Road Data Bank in the Finnish Road Administration (Finnra) 14.6.2007 / Reijo Prokkola, Matti Raekallio 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)
13
|
|
|
|
The information stored in the RDB
Road Data Bank in the Finnish Road Administration (Finnra) 14.6.2007 / Reijo Prokkola, Matti Raekallio 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
14
|
|
|
|
The information stored in the RDB
Road Data Bank in the Finnish Road Administration (Finnra) 14.6.2007 / Reijo Prokkola, Matti Raekallio 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
15
|
|
|
|
Maintenance of data in RDB
Road Data Bank in the Finnish Road Administration (Finnra) 14.6.2007 / Reijo Prokkola 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
|
|
|
|
Data Quality
Road Data Bank in the Finnish Road Administration (Finnra) 17 14.6.2007 / Reijo Prokkola, Matti Raekallio 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 At the moment the quality of the data is sufficient for network level purposes. Changes of the road network and attributes are updated continuously. Statistics of most important data are made by the situation of first of January every year.
|
|
|
|
II - Guidelines for development of RDB in Russia
1.6.2007 / Markku Tervo Markku Tervo, Procurement Manager Finnish Road Administration, Oulu Road Region
18
|
|
|
|
#19
Road Data Bank in the Finnish Road Administration (Finnra) 19 1.6.2007 / Markku Tervo 19 2007 2010 2015 Steps to the visio VISION 2015 -2020 Strategy - pipe 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
19 19
|
|
|
|
#20
Guidelines for development of RDB in Russia 20 1.6.2007 / Markku Tervo 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 MUST BE COMMON IN RUSSIA regional roads federal roads 10 22
20 20
|
|
|
|
|
Embed a live preview of this presentation on your site.
Copy code to your clipboard, or click here for instructions.
Similar presentations
Loading...
Loading...
Loading...
Loading...
Loading...
Share this presentation
Follow SlideFinder
|
