Oakland crash analysis: methods Oakland Accident Care, oaklandaccidentcare.com/oakland-collision-data Generated 2026-10-23 by tools/crash-analysis.py from raw files downloaded 2026-10-23. SOURCE California Highway Patrol, California Crash Reporting System (CCRS), on the California Open Data Portal: https://data.ca.gov/dataset/ccrs (license: public domain). Files used: Crashes_YYYY, Parties_YYYY and InjuredWitnessPassengers_YYYY for 2021-2025. CCRS holds crash reports sent to CHP by the CHP and by local agencies, including the Oakland Police Department. Only police-reported crashes are included. Crashes nobody reported are not. WHICH CRASHES - Crash date in 2021-2025 and CCRS "City Name" = Oakland. Rows flagged deleted are dropped. - Rows with the same report number and the same two street names are counted once (the most recently modified row is kept). 36 rows were removed this way. - Injury or fatal crash: CCRS reports at least one person injured or killed. CCRS counts a complaint of pain as an injury. - Fatal crash: at least one person killed. Crash with a serious injury: at least one person with injury extent "suspected serious" (or the older "severe" code). - Freeway crash: CCRS freeway flag, or the primary road is an interstate or state route (I-80, I-580, I-880, I-980, SR-13, SR-24 and their ramps). City-street figures exclude these. - 2025 is provisional. CHP had not published its 2025 annual report when TIMS last checked, and late reports can still be added. Earlier years can also change. ROAD USER (MODE) - Crashes "involving a pedestrian / bicyclist" have a party of that type. "Involving a motorcycle" has a party whose vehicle is a motorcycle or a motor-driven cycle (CCRS vehicle types 2 and 3). A crash can count in more than one column. - People killed or seriously injured are counted from the victim table, by the injured person's type. Drivers and passengers of a motorcycle are "Motorcyclist". HOUR AND DAY Crash time and day of week as recorded on the report, for all injury or fatal crashes 2021-2025. COUNCIL DISTRICT - Boundaries: City of Oakland, Council District 2022 Revised (OaklandGIS), adopted February 23, 2022: https://www.arcgis.com/home/item.html?id=b7e06c587b544d8187fe7a0d508f2078 - Oakland Police Department reports in CCRS carry no coordinates (18276 of 18290 OPD crash rows). We placed those crashes from the two street names on the report: each name is matched to the City of Oakland's street centerline file (https://gismaps.oaklandca.gov/server/rest/services/OaklandStreets/FeatureServer/0/query), and the crash is placed at the point where those two streets meet. Distances from the cross street written on the report (for example "100 ft north") are not applied. If the two streets meet in more than one district, or no meeting point is found, the crash is not placed. - Crashes with officer-reported coordinates (mostly CHP) are placed by those coordinates. - Check: 197 city-street crashes have both coordinates and two street names. Placed both ways, 187 land in the same district. Most of the others are within about 50 meters of an intersection on a district line. - City-street injury or fatal crashes: 7534. Placed from street names: 7016; by coordinates: 29; not placed: 489. TOP 25 INTERSECTIONS - City-street injury or fatal crashes whose report names two streets and puts the crash at the intersection or within 100 feet of the cross street. Street names are standardized (for example "AV" = "AVE", "BL" = "BLVD"). - Intersections are ranked by that count; ties share a rank. Freeways and ramps are excluded. - The column "at the intersection (0 ft)" counts crashes with no distance written. HIT-AND-RUN CCRS hit-and-run flag: felony (injury) or misdemeanor (property damage). Share = hit-and-run crashes / all crashes in that group. SMALL NUMBERS Counts from 1 to 4 are shown as "<5". Zero is shown as 0. WHAT THIS IS NOT Counts of police-reported crashes. They are not rates. They do not say who was at fault or why a crash happened. They will not match the City's traffic-death tracker exactly: the tracker uses its own review and the 30-day rule, and freeway deaths are handled differently.