Bike accident classification

Why you need to be visible on the right side!

Berlin
Bike
2022
Open Data
Author

Néhémie Strupler

Published

February 25, 2022

I finished yesterday’s post in stating that I did not understand which situation the class of accident “0” and “1” covered. In the database, you have another classification of accident and I am struggling to understand it too. The Destatis’ booklet explains that “accident type” (Unfalltyp) describes the conflict situation that led to the accident and in contrast to the class of accident (Unfallart), it is not about the description of the actual collision, but about the kind of conflict that triggered the collision. They are 7 main types:

  1. Driving accident: loss of control of the vehicle.

  2. Turn accident: triggered by a conflict between a person turning and a road user

  3. Turning/crossing accident: The accident was triggered by a conflict between a person who is required to wait and a vehicle that has the right of way at intersections, junctions or exits from properties and parking lots.

  4. Pass-accident The accident was caused by a collision between a vehicle and a pedestrian

  5. Accident caused by stationary traffic: accident between a vehicle in moving traffic and a vehicle that is parking/stopping

  6. Accident in parallel traffic: road users who were moving in the same or opposite directions

  7. Other accident: other class (reversing, obstacles or animals on the road, sudden vehicle damage (brake failure, tire damage, etc.).

Picture of the day

This is a graph of the type of accidents (unfalltyp) involving a bike in Berlin and Brandenburg.

Show the code of the exhibit
library(sf)

# Select Berlin and Brandenburg
# ULAND = 11 (Berlin) | 12 (Brandenburg)
berbrand <- read.csv2(pipe("awk 'BEGIN {FS=\";\"} {if ($3 == 11 || $3 == 12 ) print $0}' Unfallorte2020_LinRef.csv"),
header=FALSE,
colClasses = c(rep("character", 2),
               rep("factor", 18),
               rep("character", 4),
               rep("factor", 1)
))
readLines("Unfallorte2020_LinRef.csv", n=1) |>
  strsplit(";") |> unlist()  |> tolower() -> colnames(berbrand)
colnames(berbrand)
levels(berbrand$uwochentag) <- c("So", "Mo", "Di", "Mi", "Do",
                                 "Fr", "Sa")
levels(berbrand$ulichtverh) <-
  c("Tageslicht","Dämmerung","Dunkelheit")
berbrand$uwochentag <-
  factor(berbrand$uwochentag,levels(berbrand$uwochentag)[c(2:7,1)])

# Select only when bike are involved
 berbrand <- berbrand[berbrand$istrad == 1,]

# Colour palette
retro <- c( "#9239F6", "#903495"  , "#6F3460"  , "#4A354F"  ,
"#D20076"  , "#FF0076"  , "#FF4373"  , "#FF6B58", "#F8B660",
"red")

library(ggplot2)
library(dplyr)

# Bike accident by type
jpeg("bike_unfaelle_type.jpg", width=800, quality=90)
ggplot(berbrand, aes(x = utyp1)) +
  geom_bar(aes(fill = utyp1)) +
    theme_minimal() +
    guides(fill="none") +
                      scale_fill_manual( values = retro ) +
 labs(x = "Type")
dev.off()

Number of bike accident by type. Exhibit made with R (code provided in a comment of this webpage) Data Copyright: DL-DE BY 2.0 Statistische Ämter des Bundes und der Länder, Deutschland, 2021.

It is still not clear to me, how to understand it!