Readme
Updated 5 months ago
‧ Indexed 3 hours ago
Legacy Baton Rouge Traffic Incidents
***On January 1, 2021, the Baton Rouge Police Department switched to a new reporting system. This dataset contains data through 12/31/2020. For data from 1/1/2021 onward visit: https://data.brla.gov/Transportation-and-Infrastructure/Baton-Rouge-Traffic-Incidents/sfeg-d9ip
Traffic incident reports handled by Baton Rouge City Police.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| GEOLOCATION | geolocation | geolocation | Point | Full street address for geocoding |
| GEOLOCATION (state) | geolocation_state | geolocation_state | Text | |
| GEOLOCATION (address) | geolocation_address | geolocation_address | Text | |
| LOCATION KIND | location_kind | location_kind | Text | Describes the land use in the area of the crash |
| SECOND FACTOR | second_factor | second_factor | Text | Secondary causative factor for the crash |
| PRIMARY FACTOR | primary_factor | primary_factor | Text | Primary causative factor for the crash |
| ALIGNMENT | alignment | alignment | Text | Orientation and slope of roadway |
| SURFACE TYPE | surface_type | surface_type | Text | Road surface type |
| SURFACE CONDITION | surface_cond | surface_cond | Text | Road surface condition |
| CLOSEST STREET | closest_street | closest_street | Text | Closest street to where the crash happened |
| FORMATTED STREET | formattedstreet | formattedstreet | Text | Fully formatted street address |
| STREET NAME | st_name | st_name | Text | Crash location - street name |
| STREET# | st_number | st_number | Number | Crash location - street number |
| ZONE | zone | zone | Text | When used with district, will show zone of where the crash happened |
| DISTRICT | district | district | Text | District of where the crash happened |
| TOT VEH | tot_veh | tot_veh | Number | Number of vehicles involved in crash |
| CRASH TIME | crash_time | crash_time | Text | Time of crash |
| CRASH DATE | crash_date | crash_date | Calendar date | Date of crash |
| FILE# | file_number | file_number | Text | Accident Number |
| INJURY | injury | injury | Text | Will be marked with 'X" if the crash involved an injury |
| STREET TYPE | st_type | st_type | Text | Crash location - street type |
| SUBZONE | subzone | subzone | Text | When used with district and zone, will show subzone of where the crash happened |
| LIGHTING | lighting | lighting | Text | Lighting condition |
| ACCESS CONTROL | access_control | access_control | Text | Degree of control by public authority to the abutting land |
| RELATION ROADWAY | relation_roadway | relation_roadway | Text | Location of the crash in relation to the highway |
| WEATHER | weather | weather | Text | Prevailing weather condition at time of crash |
| ROAD CONDITION | road_condition | road_condition | Text | Environmental or physical condition of roadway |
| AT INTERSECTION | at_intersection | at_intersection | Text | Will be marked with 'X" if the crash happened at an intersection |
| PEDESTRIAN | pedestrian | pedestrian | Text | Will be marked with 'X" is the crash involved a pedestrian |
| FATALITY | fatality | fatality | Text | Will be marked with 'X" if the crash involved a fatality |
| TRAIN INVOLVED | train_involved | train_involved | Text | Will be marked with 'X" if the crash involved a train |
| Council Districts_2021_from_d8sa-f3ec | :@computed_region_ntzg_c2w3 | :@computed_region_ntzg_c2w3 | Number | |
| ZIP Codes_from_tqy7_429i | :@computed_region_jrqt_zu77 | :@computed_region_jrqt_zu77 | Number | |
| Neighborhoods_from_qfmj_2fwi | :@computed_region_uvg4_nwq8 | :@computed_region_uvg4_nwq8 | Number | |
| Council Districts_from_9v63_zwfd | :@computed_region_i2e6_956r | :@computed_region_i2e6_956r | Number | |
| ZIP Codes | :@computed_region_8siy_mghw | :@computed_region_8siy_mghw | Number | |
| Zip Codes | :@computed_region_tqy7_429i | :@computed_region_tqy7_429i | Number | |
| Neighborhoods | :@computed_region_qfmj_2fwi | :@computed_region_qfmj_2fwi | Number | |
| Council Districts | :@computed_region_9v63_zwfd | :@computed_region_9v63_zwfd | Number | |
| Neighborhood_BC | :@computed_region_92rf_uvyc | :@computed_region_92rf_uvyc | Number | |
| Council District (Shapefile) | :@computed_region_hfgy_t898 | :@computed_region_hfgy_t898 | Number | |
| Baton Rouge Council Districts | :@computed_region_tm4z_r3je | :@computed_region_tm4z_r3je | Number | |
| Zip Codes_from_8tu6_j4iw | :@computed_region_8tu6_j4iw | :@computed_region_8tu6_j4iw | Number | |
| GEOLOCATION (zip) | geolocation_zip | geolocation_zip | Text | |
| GEOLOCATION (city) | geolocation_city | geolocation_city | Text | |
| ROAD TYPE | road_type | road_type | Text | Layout of roadway |
| MANNER OF COLLISION | manner_of_collision | manner_of_collision | Text | Manner which vehicles initially came into contact |
| HIT&RUN | hit_run | hit_run | Text | Will be marked with 'X" if the crash was a 'hit and run' |
| OCCURED ON | occured_on | occured_on | Text | Type of roadway |
| STREET DIRECTION | st_direction | st_direction | Text | Crash location - street direction |
Upstream Metadata