This paper describes a conceptual model for a road accident database, which incorporates the variables defined in the UK national accident data set. The development of the database is carried out using the object modelling technique adapted to meet the requirements of geographical data classes. The paper focuses on an appropriate definition of the road network to reduce data redundancy and provide greater integrity for blackspot analysis by including those elements of the network that do not usually have accidents. The data model is based upon that offered by the Ordnance Survey's Centre Alignment of Roads (OSCAR) Asset Manager digital map series which has been modified to include all road numbers and to reflect the hierarchical structure of the road classification system. A data model has been developed for describing junctions that allows them to be viewed as points on the network or as networks in their own right. Accident frequencies at a high-risk site are usually analysed over intervals of time and so it is important that changes to the site that could affect the accident frequency should be recorded in the database. Consequently, the paper also describes a method for recording temporal aspects of the road network.
Read full abstract