Dark Mode
Metropolitan Bicycle Theft Data Log
Product Reviews & Feedback
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
This data product details bicycle theft incidents and related cellar or floor burglaries officially recorded by the police in Berlin, Germany. The data specifically focuses on cases where a bicycle was the property targeted in the crime. Derived from the Berlin police crime statistics data warehouse, this information is updated daily and provided at the planning area level. It includes figures for the current year up to the preceding day of the update, as well as data for the entire previous year, provided the offense time frame can be limited to a maximum of three days.
Columns
The dataset contains 11 columns providing details on the offense:
- ANGELEGT_AM: The date when the transaction was created.
- TATZEIT_ANFANG_DATUM: The date marking the start of the offense period.
- TATZEIT_ANFANG_STUNDE: The hour marking the start of the offense period (the mean time is 14.6).
- TATZEIT_ENDE_DATUM: The date marking the end of the offense period.
- TATZEIT_ENDE_STUNDE: The hour marking the end of the offense period (the mean time is 13.5).
- LOR: An 8-digit identification code representing the spatial hierarchy of lifeworld-oriented planning areas ("lebensweltlich orientierte Räume").
- SCHADENSHOEHE: The value of the stolen goods in Euros, excluding material damage. The maximum recorded value is 10,000 Euros, with a mean of 1,090 Euros.
- VERSUCH: Indicates whether the incident was an attempt (yes/no).
- ART_DES_FAHRRADS: Describes the classification of the bicycle involved (e.g., men's bicycle, women's bicycle).
- DELIKT: Categorizes the delict group, primarily "bicycle theft" or "cellar and floor burglary."
- ERFASSUNGSGRUND: Details the underlying reason for recording the offense, with "Sonstiger schwerer Diebstahl von Fahrrädern" accounting for 90% of records.
Distribution
The data product is distributed as a single CSV file named
Fahrraddiebstahl.csv, which is 5.74 MB in size. It comprises 11 columns and includes approximately 43,100 valid records. The expected frequency of future updates is listed as 'Never'.Usage
This data is highly suitable for detailed urban crime analysis. Potential use cases include:
- Geospatial Analysis: Utilising the LOR code for studying crime distribution and identifying hotspots across Berlin's planning areas.
- Resource Allocation: Supporting police and city planning efforts by highlighting areas requiring increased security measures or patrols.
- Loss Prevention: Analyzing the value (
SCHADENSHOEHE) and type (ART_DES_FAHRRADS) of stolen property to inform targeted prevention strategies for retailers and insurers. - Temporal Pattern Identification: Mapping offenses by start and end dates/hours to reveal daily and seasonal theft patterns.
Coverage
The data is geographically limited to Berlin, Germany. Temporally, it covers the current year, updated up to the previous day, along with all data from the prior full year. A strict condition for inclusion is that the time of the offense must be narrowed down to a period of three days or less. The records span details on property value, specific bicycle types (such as men's or women's bicycles), and location via the 8-digit LOR spatial hierarchy.
License
Attribution 4.0 International (CC BY 4.0)
Who Can Use It
Intended users include:
- Public Safety Analysts: For mapping crime severity and temporal trends.
- Urban Planners and Researchers: To correlate crime data with socio-economic or infrastructural factors using the LOR codes.
- Insurance Providers: To assess regional risk profiles and calculate appropriate premiums based on theft frequency and average loss value.
Dataset Name Suggestions
- Berlin Police Bicycle Crime Incidents
- Metropolitan Bicycle Theft Data Log
- German Cycling Property Offenses
Attributes
Original Data Source: Metropolitan Bicycle Theft Data Log
QUALITYLoading...