harmonizing alpine traffic data

1

The AlpCheck Information System

AlpCheck Final Conference, VeniceJune 26, 2008

PARADIGMARudolf J. Bauer

© Copyright 2008 Paradigma Unternehmensberatung GmbH 2

Purpose and scope of the Information System

To collect and combine high quality information on Alpine transport – Emphasis on road based cargo traffic– Using existing surveys, count data from highway operators,

data collected from the pilots To provide analytic capabilities to understand the data

and to use it for planning purposes– Operational, tactical and strategic level

To deploy cutting edge business intelligence technology in the domain of transportation planning– Multi-tiered architecture– Documenting the genealogy of the data– High performance processes and data base management

systems


Traffic data sources in the ALPCHECK Information System

Data Set Type Description

CAFT O/D Cross Alpine Freight-Transport/BMVIT survey

ASFINAG Count hourly count at selected highway locations in Austria 2004-2006

ASPI Count hourly count at selected highway locations from Autostrade per l'Italia

VENT Count Alpcheck Pilot, Ventimilia

TF Count Frejus Tunnel Pilot Data

TMB Count Mont Blanc Tunnel, Pilot Data

TGSB Count Grand Sant Bernardo

HTLS O/D SLALA/IREALP Pilot data

WIM O/D Venice/Stuttgart Pilot data

OMEGA Count Slovenia Pilot, Traffic Count


SuperCross


CSST Web-GUI

Selection window

Results window

one time series and diagram for each

year (and possibly each

vehicle and load type)

selection summary

selection by:- section and direction- data origin campaign)- vehicle and load type


Metadata: collection description


Metadata: individual attributes descriptions


The Common Data Model

Number of trucks

Traffic Counts

Origin &Destination

O/D Tours

Vehicles Commodities

Region

Section

Location

Year

Month

Day

Event


Common Database (SuperSTAR)

Estimated goods distribution

(CAFT extrapolated with ASFINAG 2004-06) Brenner

2004-06


Multi-Tiered Architecture Conceptual View

Staging Area: the raw data

Data Warehouse: the authentic data

statistical data analyses layer

Presentation layer

Met

adat

a


Multi-Tiered Application Architecture

CSV files

IBM DB2

SUPERSTAR

SuperWeb, SuperCross

PD

F,

HT

ML

Kettle

SuperCHANNEL

WEB-GUI

MS ACCESS


Datawarehouse

Staging Area(csv, xls,

etc.)

Datawarehouse Common Model

Common DB(SuperSTAR Data Marts)

Individual Sets(SuperSTAR)

ETL routinesKETTLE

ETL routinesKETTLE

ImportSuperCHANNEL

ImportSuperCHANNEL

Load and update process design


Transformation and load process (ETL)Job controlling the update of OMEGA data

1. Set up parameters and find new input files.

2. If new files available, iteratively update staging area.

3. If all files have been used in update, create and install new SuperSTAR database.


Amount of data

1 10 100 1.000 10.000 100.000 1.000.000 10.000.000 100.000.000

CAFT

ASFINAG

ASPI

Ventimiglia

Frejus

Mont Blanc

Great St. Bernard

SLALA/IREALP

Venice WIM

Slovenia Pilot

approx. batch size (records) # records in DB


Benefits, lessons learned

BI Technology can be successfully applied to support traffic planners

The ALPCHECK system is scaleable and performs to expectations

Powerful and easy to use analysis tools support the traffic planner

Heterogeneous data can be compared to enhance the analysis process

Readily available descriptions support the interpretation of the data


ALPCHECK – the way forward

[ALPCHECK information system] – extraction from feeder systems (FTP)– Automatic, scheduled transformation and update– Data interpretation and analysis (query and analysis)

[Decision Support System]– Model supported interpretation and analysis – Analyse traffic data in combination with trade data – Data presentation (geo-referenced user interface)

[Infomobility]– Expansion of scope (multimodal, passenger traffic)– Dynamic acquisition of real time traffic data – Expand usage from planning to traffic management

harmonizing alpine traffic data

Business

supercross copyright

bauer copyright

traffic count copyright

csst webgui copyright

litaliaventcountalpcheck

traffic data sources

information systemto

aspicounthourly count