Baselight

1.08 Crash Data Report (detail)

City of Tempe

@usgov.city_of_tempe_1_08_crash_data_report_detail_498c3

Loading...
Loading...

About this Dataset

1.08 Crash Data Report (detail)

Please note that 2024 data are incomplete and will be updated as additional records become available. Data are complete through 12/31/2023.

Fatal and serious injury crashes are not “accidents” and are preventable. The City of Tempe is committed to reducing the number of fatal and serious injury crashes to zero. This data page provides details about the performance measure related to High Severity Traffic Crashes as well as access to the data sets and any supplemental data. The Engineering and Transportation Department uses this data to improve safety in Tempe.

This data includes vehicle/vehicle, vehicle/bicycle and vehicle/pedestrian crashes in Tempe. The data also includes the type of crash and location. This layer is used in the related Vision Zero story map, web maps and operations dashboard.

Time Zones
Please note that data is stored in Arizona time which is UTC-07:00 (7 hours behind UTC) and does not adjust for daylight savings (as Arizona does not partake in daylight savings). The data is intended to be viewed in Arizona time. Data downloaded as a CSV may appear in UTC time and in some rare circumstances and locations, may display online in UTC or local time zones. As a reference to check data, the record with incident number 2579417 should appear as Jan. 10, 2012 9:04 AM.

Please note that 2024 data are incomplete and will be updated as additional records become available. Data are complete through 12/31/2023.

This page provides data for the High Severity Traffic Crashes performance measure.

The performance measure page is available at 1.08 High Severity Traffic Crashes

Additional Information

Source: Arizona Department of Transportation (ADOT)
Contact (author): Shelly Seyler
Contact (author) E-Mail: Shelly_Seyler@tempe.gov
Contact (maintainer): Julian Dresang
Contact (maintainer) E-Mail: Julian_Dresang@tempe.gov
Data Source Type: CSV files and Excel spreadsheets can be downloaded from ADOT website
Preparation Method: Data is sorted to remove license plate numbers and other sensitive information
Publish Frequency: semi-annually
Publish Method: Manual
Data Dictionary
Organization: City of Tempe
Last updated: 2024-02-09T14:56:07.358133
Tags: accident, arizona, car-accidents, crash, cyclist, engineering-and-transportation, high-severity-traffic-crashes-pm-1-08, pedestrian, safe-and-secure-communities, tempe, transportation, vision-zero

Tables

Table 1

@usgov.city_of_tempe_1_08_crash_data_report_detail_498c3.table_1
  • 2.35 MB
  • 51,305 rows
  • 35 columns
Loading...
CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "incidentid" DOUBLE,
  "datetime" TIMESTAMP,
  "year" DOUBLE,
  "streetname" VARCHAR,
  "crossstreet" VARCHAR,
  "distance" DOUBLE,
  "junctionrelation" VARCHAR,
  "totalinjuries" DOUBLE,
  "totalfatalities" DOUBLE,
  "injuryseverity" VARCHAR,
  "collisionmanner" VARCHAR,
  "lightcondition" VARCHAR,
  "weather" VARCHAR,
  "surfacecondition" VARCHAR,
  "unittype_one" VARCHAR,
  "age_drv1" DOUBLE,
  "gender_drv1" VARCHAR,
  "traveldirection_one" VARCHAR,
  "unitaction_one" VARCHAR,
  "violation1_drv1" VARCHAR,
  "alcoholuse_drv1" VARCHAR,
  "druguse_drv1" VARCHAR,
  "unittype_two" VARCHAR,
  "age_drv2" DOUBLE,
  "gender_drv2" VARCHAR,
  "traveldirection_two" VARCHAR,
  "unitaction_two" VARCHAR,
  "violation1_drv2" VARCHAR,
  "alcoholuse_drv2" VARCHAR,
  "druguse_drv2" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Share link

Anyone who has the link will be able to view this.