Road Safety Data, Collection, Transfer and Analysis DaCoTa. Workpackage 3, Data Warehouse: Deliverable 3.8: Data warehouse – Final Report.

Auteur(s)
Yannis, G. Evgenikos, P. Aarts, L. Kars, V. Brandstaetter, C. Bauer, R. Broughton, J. Haddak, M. Lefèvre, M. Pascal, L. Amoros, E. Zielinska, A. Wnuk, A. Lucas, M. Pace, J.-F. Sanmartin, J. Kirk, A. & Thomas, P.
Jaar
Samenvatting

During the last two decades, the systematic efforts for gathering and harmonising road accident data at the European level have led to a significant upgrade and enhancement of the CARE database. Moreover, important data collection and harmonization efforts have provided very useful results as regards exposure data and safety performance indicators; however, the availability, completeness and level of harmonization of this data varies significantly. At the same time, additional data and related information sources have been established at EU level, including in-depth data, behaviour / attitudes data, programmes and measures data, social cost data etc., mainly in the framework of European research projects. However, these data sources are still not of sufficient comparable quality, are still not sufficiently linked, and the aggregate data are not always accessible. Finally, an important amount of national data remains unexploited at the European level. Consequently, there is a clear need for the consolidation of the various data (at least at an aggregate level) into an integrated system, a data warehouse. This will allow not only for better integration of the various data assembly processes, but also for the provision of a complete set of data services, with full documentation of the data and their sources, in order to support road safety knowledge and the related decision making. This data warehouse will be developed as a complete working tool for road safety stakeholders, for which not only a full description of the structure, format and content will be designed and specified, but also the related content will be provided, consisting in fact of a new system with road safety related data/information in aggregate form. The objective of the DaCoTA WP3 is the development of the DaCoTA System, being a road safety data warehouse to be used as a comprehensive and integrated system with aggregate data and information consolidating, organising and making available all existing data and information, necessary for the support of the decision making. Aggregate road safety data concern road accident data, risk exposure data and road safety performance indicators, but also causation indicators (as those resulting from indepth data) and health indicators (as those resulting from epidemiological data). These indicators will be combined with additional information on other important aspects of road safety, as those related to behavioural, social and political aspects. In particular, an integrated approach for supporting road safety decision making needs to include quantitative information on road users' attitudes and behaviour, on road safety measures implemented, rules and programmes (including enforcement), and on their social costs and benefits. The expected outcome of DaCoTA WP3 is the establishment of a solid but easily accessible, integrated road safety system that will allow for road safety policy and decision making to use a complete set of aggregate road safety related data (road accident data, risk exposure data, safety performance indicators, in-depth data, health indicators/data) and information (programmes, measures, legislation, social cost, behaviours/attitudes, regulations). During the second and last phase of the DaCoTA WP3, the initially designed Data Warehouse structure, format and content were continuously assessed by the members of the CARE/RSPI Experts Group and the DaCoTA partnership during the entire project lifecycle and by policy-makers and other road safety stakeholders during the DaCoTA project Conference in Athens in November 2012. The Data Warehouse structure and content were finalised according to the feedback and additionally, a final set of national and international data and information was defined and gathered through appropriate templates, along with the related explanatory meta-data and the related links. Regarding the output interfaces three new, updated editions of the Annual Statistical Report for 2010, 2011 and 2012 were developed, as well as seventeen (17) Basic Fact Sheets on selected road safety topics. These statistical outputs are enhanced with additional non-CARE data that were gathered and were further included in the data warehouse, either in the form of interactive data (exposure data) or in the form of static data (in-depth accident data, health indicators), the necessary data/information for countries benchmarking and statistical analyses were defined in collaboration with the DaCoTA WP4 (Decision Support) and data/information were provided through the Master Tables to other DaCoTA WPs to conduct analyses (WP1, WP4). (Author/publisher)

Publicatie

Bibliotheeknummer
20151033 ST [electronic version only]
Uitgave

Brussels, European Commission, Directorate General for Mobility and Transport, 2012, 65 p., ref.; Grant Agreement Number TREN/FP7/TR/233659 /"DaCoTA"

SWOV-publicatie

Dit is een publicatie van SWOV, of waar SWOV een bijdrage aan heeft geleverd.