austintexas-gov/vision-zero-crash-report-data-y2wy-tgr5
Icon for Socrata external plugin
 
Preview
  • vision_zero_crash_report_data
     
 
Readme
Updated 1 day ago
Indexed 4 hours ago

Vision Zero Crash Report Data

Crash data is obtained from the Texas Department of Transportation (TXDOT) Crash Record Information System (CRIS) database, which is populated by reports submitted by Texas Peace Officers throughout the state, including Austin Police Department (APD), and maintained by TXDOT.

Please note that the data and information on this website is for informational purposes only. While we seek to provide accurate information, please note that errors may be present and information presented may not be complete. For official inquiries on City of Austin crash data, contact VisionZero@AustinTexas.gov.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
rpt_street_namerpt_street_namerpt_street_nameTextReported Street Name (road on which crash occurred)
street_nbrstreet_nbrstreet_nbrTextDerived Street Number - Block number of primary street where crash occurred as determined by the Locator application
contrib_factr_p1_idcontrib_factr_p1_idcontrib_factr_p1_idTextThe first factor for a given vehicle which the officer felt possibly contributed to the crash
Single Member Council Districts:@computed_region_8spj_utxs:@computed_region_8spj_utxsNumber
Boundaries: Zip Code Tabulation Areas, 2017:@computed_region_jcrc_4uuy:@computed_region_jcrc_4uuyNumber
BOUNDARIES_single_member_districts:@computed_region_q9nd_rr82:@computed_region_q9nd_rr82Number
Neighborhood Planning Areas:@computed_region_e9j2_6w3z:@computed_region_e9j2_6w3zNumber
Community Registry:@computed_region_m2th_e4b7:@computed_region_m2th_e4b7Number
Zipcodes:@computed_region_rxpj_nzrk:@computed_region_rxpj_nzrkNumber
motorcycle_serious_injury_countmotorcycle_serious_injury_countmotorcycle_serious_injury_countNumber
bicycle_serious_injury_countbicycle_serious_injury_countbicycle_serious_injury_countNumber
bicycle_death_countbicycle_death_countbicycle_death_countNumber
apd_confirmed_death_countapd_confirmed_death_countapd_confirmed_death_countNumberAPD Fatality Count
street_nbr_2street_nbr_2street_nbr_2TextDerived Street Number 2 - Block number of secondary street related to the crash location as determined by the Locator application (If applicable)
bicycle_flbicycle_flbicycle_flTextBicyclist involved crash flag
motorcycle_flmotorcycle_flmotorcycle_flTextMotorcycle involved crash flag
motorcycle_death_countmotorcycle_death_countmotorcycle_death_countNumber
crash_sev_idcrash_sev_idcrash_sev_idNumberCrash Severity - Most severe injury suffered by any one person involved in the crash ( 0=UNKNOWN, 1=INCAPACITATING INJURY, 2=NON-INCAPACITATING INJURY, 3=POSSIBLE INJURY, 4=KILLED, 5=NOT INJURED)
other_serious_injury_countother_serious_injury_countother_serious_injury_countNumber
other_death_countother_death_countother_death_countNumber
private_dr_flprivate_dr_flprivate_dr_flTextFlag indicating whether crash occurred on a private drive or road/private property/parking lot.
motor_vehicle_death_countmotor_vehicle_death_countmotor_vehicle_death_countNumber
pedestrian_death_countpedestrian_death_countpedestrian_death_countNumber
death_cntdeath_cntdeath_cntNumberTotal Death Count
latitudelatitudelatitudeNumberDerived Latitude map coordinate of the crash
motor_vehicle_serious_injury_countmotor_vehicle_serious_injury_countmotor_vehicle_serious_injury_countNumber
crash_idcrash_idcrash_idNumberTxDOT C.R.I.S. system-generated unique identifying number for a crash
pedestrian_serious_injury_countpedestrian_serious_injury_countpedestrian_serious_injury_countNumber
pointpointpointPointPoint datatype created with crash latitude and longitude to enable request of GeoJSON.
crash_fatal_flcrash_fatal_flcrash_fatal_flTextFatal Crash Identifier - Indicates that the crash involved one or more fatalities
pedestrian_flpedestrian_flpedestrian_flTextPedestrian involved crash flag
road_constr_zone_flroad_constr_zone_flroad_constr_zone_flTextConstruction Zone - Indicates whether the crash occurred in or was related to a construction, maintenance, or utility work zone, regardless of whether or not workers were actually present at the time of the crash
rpt_block_numrpt_block_numrpt_block_numTextReported Block Number (road on which crash occurred)
sus_serious_injry_cntsus_serious_injry_cntsus_serious_injry_cntNumberTotal Suspected Serious Injury Count
nonincap_injry_cntnonincap_injry_cntnonincap_injry_cntNumberTotal Non-incapacitating Injury Count
motor_vehicle_flmotor_vehicle_flmotor_vehicle_flTextMotor vehicle involved crash flag
onsys_flonsys_flonsys_flTextFlag indicates whether primary road of crash was on the TxDOT highway system.
poss_injry_cntposs_injry_cntposs_injry_cntNumberTotal Possible Injury Count
atd_mode_category_metadataatd_mode_category_metadataatd_mode_category_metadataTextDescription of units involved in crash
rpt_latituderpt_latituderpt_latitudeNumberReported Latitude
street_name_2street_name_2street_name_2TextDerived Street Name 2 - The road name for the secondary road related to the crash location (If applicable)
rpt_longituderpt_longituderpt_longitudeNumberReported Longitude
street_namestreet_namestreet_nameTextDerived Street Name - Name of the road crash occurred on, as determined by the Locator application.
units_involvedunits_involvedunits_involvedTextMode of units involved in crash
rpt_street_pfxrpt_street_pfxrpt_street_pfxTextReported Street Prefix (road on which crash occurred)
non_injry_cntnon_injry_cntnon_injry_cntNumberTotal Not Injured Count
tot_injry_cnttot_injry_cnttot_injry_cntNumberTotal Injury Count
other_flother_flother_flTextOther involved crash flag
apd_confirmed_fatalityapd_confirmed_fatalityapd_confirmed_fatalityTextAPD Fatality flag
crash_timecrash_timecrash_timeTextCrash Time - Time crash occurred
crash_speed_limitcrash_speed_limitcrash_speed_limitNumberSpeed Limit
longitudelongitudelongitudeNumberDerived Longitude map coordinate of the crash
crash_datecrash_datecrash_dateCalendar dateCrash Date
case_idcase_idcase_idTextCase ID
rpt_street_sfxrpt_street_sfxrpt_street_sfxTextReported Street Suffix (road on which crash occurred)
unkn_injry_cntunkn_injry_cntunkn_injry_cntNumberTotal Unknown Injury Count
contrib_factr_p2_idcontrib_factr_p2_idcontrib_factr_p2_idTextThe second factor for a given vehicle which the officer felt possibly contributed to the crash
Upstream Metadata