Crash Points
Data Dictionary
| Description | Field Name | Data Source | Guidance |
|---|---|---|---|
| CCN | CCN | MPD Crash Database | MPD’s official crash record ID number. |
| Report Date | ReportDate | MPD Crash Database | Date crash was reported. |
| Route ID | RouteID | LRS Core Segmentation | RouteID of the route the accident occurred on. If "Route Not Found", this likely means that the crash point was too far away from the DDOT GIS centerline. If a given crash point is 50 meters or more from a centerline, the crash cannot conclusively be linked to a particular roadway/centerline. Check "Location Errors" for more detail about any other issues |
| Measure along route | Measure | LRS Core Segmentation | Measure along the route. |
| Offset | Offset | ||
| Street Segment ID | StreetSegID | LRS Core Segmentation | (see documentation link to the left for more information) |
| Roadway Segment ID | RoadwaySegID | LRS Core Segmentation | (see documentation link to the left for more information) |
| From Date | FromDate | Roads and Highways | System field. For DDOT's internal reference only. |
| To Date | ToDate | Roads and Highways | System field. For DDOT's internal reference only. |
| MAR ID | MARID | Master Address Repository (MAR) | Master Address Repository (MAR) address identifier. |
| Address | Address | Master Address Repository (MAR) | Geocoded address of the crash location, supplied by the MAR. |
| Latitude | Latitude | Master Address Repository (MAR) | The OCTO-supplied latitude of the address location, which is supplied by the MAR. |
| Longitude | Longitude | Master Address Repository (MAR) | The OCTO-supplied longitude of the address location, which is supplied by the MAR. |
| X Coordinate | XCOORD | Master Address Repository (MAR) | The OCTO-supplied X Coordinates (Maryland State Plane Meters) of the address location, which is supplied by the MAR. |
| Y Coordinate | YCOORD | Master Address Repository (MAR) | The OCTO-supplied Y Coordinates (Maryland State Plane Meters) of the address location, which is supplied by the MAR. |
| Ward | Ward | DCGIS | Contains text value for DC Ward for the centerpoint of this segment
|
| Event ID | EventID | Roads and Highways | Unique ID generated by Roads & Highways. For DDOT's internal reference only. |
| Error routing crash to centerline | LocationError | Master Address Repository (MAR) | Error messages describing why the crash point was not linked to one or more centerline network assets. Crash point too far from centerline (>50m): The crashpoint cannot be linked to a nearby DDOT LRS centerline (greater than 50 meters). BlockKey ERROR: The Roadway Blockkey did not match DDOT's current inventory of LRS Blockkey. SubBlockKey ERROR: The Roadway SubBlockkey did not match DDOT's current inventory of LRS Subblock. ERROR on getOnBlockPointInfo: There has been an issue with querying DDOT's network matching tool ERRORS on getNearestBlockIntersection: There has been an issue with querying DDOT's nearest intersection match tool Intersecting Route ERROR. The intersecting route name/id provided does not match up to a DDOT LRS Route. Blockkey ERROR. {} Not Found on Corridor: The Roadway Blockkey provided does not match up to a DDOT's inventory LRS Corridors. Could be an issue with corridor data, block data, or DDOT's network matching tool. |
| MAR Address | MAR_Address | Master Address Repository (MAR) | |
| MAR Score | MAR_Score | Master Address Repository (MAR) | Confidence Level of Geocoding. |
| Major Bicyclist Injuries | MAJORINJURIESBicyclist | MPD Crash Database | Number of bicyclists with a major injury. (see Type/Description table to right) |
| Minor Bicyclist Injuries | MINORINJURIESBicyclist | MPD Crash Database | Number of bicyclists with a minor injury. (see Type/Description table to right) |
| Unknown Bicyclist Injuries | UNKNOWNINJURIESBicyclist | MPD Crash Database | Number of bicyclists with an unknown injury. (see Type/Description table to right) |
| Fatal Bicyclist Injuries | FATALBicyclist | MPD Crash Database | Number of bicyclist fatalities. (see Type/Description table to right) |
| Major Driver Injuries | MAJORINJURIESDriver | MPD Crash Database | Number of drivers with a major injury. (see Type/Description table to right) |
| Minor Driver Injuries | MINORINJURIESDriver | MPD Crash Database | Number of drivers with a minor injury. (see Type/Description table to right) |
| Unknown Driver Injuries | UNKNOWNINJURIESDriver | MPD Crash Database | Number of drivers with an unknown injury. (see Type/Description table to right) |
| Fatal Driver Injuries | FATALDriver | MPD Crash Database | Number of driver fatalities. (see Type/Description table to right) |
| Major Pedestrian injuries | MAJORINJURIESPedestrian | MPD Crash Database | Number of pedestrians with a major injury. (see Type/Description table to right) |
| Minor Pedestrian Injuries | MINORINJURIESPedestrian | MPD Crash Database | Number of pedestrians with a minor injury. (see Type/Description table to right) |
| Unknown Pedestrian Injuries | UNKNOWNINJURIESPedestrian | MPD Crash Database | Number of pedestrians with an unknown injury. (see Type/Description table to right) |
| Fatal Pedestrian Injuries | FATALPedestrian | MPD Crash Database | Number of pedestrian fatalities. (see Type/Description table to right) |
| Total Vehicles Involved | TotalVehicle | MPD Crash Database | Total number of vehicles involved in the crash. |
| Total Bicycles Involved | Total_Bicycles | MPD Crash Database | Total number of bicycles involved in the crash. |
| Total Pedestrians Involved | TotalPedestrians | MPD Crash Database | Total number of pedestrians involved in the crash. |
| Impaired Pedestrians | PedestriansImpaired | MPD Crash Database | Total number of impaired pedestrians involved in the crash. |
| Impaired Bicyclists | BicyclistsImpaired | MPD Crash Database | Total number of impaired bicyclists involved in the crash. |
| Impaired Drivers | DriversImpaired | MPD Crash Database | Total number of impaired drivers involved in the crash. |
| Total Taxis Involved | TotalTaxis | MPD Crash Database | Total number of taxis involved in the crash. |
| Total Government Vehicles Involved | TotalGovernment | MPD Crash Database | Total number of government vehicles involved in the crash. |
| Speeding Involved | SpeedingInvolved | MPD Crash Database | Was speeding involved in the crash? |
| Nearest Intersection RouteID | NearestIntRouteID | LRS Core Segmentation | Intersecting RouteID of the nearest intersection. |
| Nearest Intersection StreetName | NearestIntStreetName | LRS Core Segmentation | Intersecting street name of the nearest intersection. |
| Intersection Offset | OffIntersection | LRS Core Segmentation | Distance from center of intersection (meters). |
| Intersection Approach Direction | IntApproachDirection | LRS Core Segmentation | Direction of the intersection leg from the intersection (North, South, East, West). |
| Last Update Date | LastUpdateDate | ||
| MPD Latitude | MPDLatitude | MPD Crash Database | The MPD-supplied latitude of the crash location. The reporting officer interactively selects the crash location on a web map. This is the Y-coordinate for that location. |
| MPD Longitude | MPDLongitude | MPD Crash Database | The MPD-supplied longitude of the crash location. The reporting officer interactively selects the crash location on a web map. This is the X-coordinate for that location. |
| MPD GEO X | MPDGEOX | MPD/MAR | The MPD-supplied (Crime Table) MAR-based X Coordinates (Maryland State Plane Meters) of the crash location. |
| MPD GEO Y | MPDGEOY | MPD/MAR | The MPD-supplied (Crime Table) MAR-based Y Coordinates (Maryland State Plane Meters) of the crash location. |
| Block Key | BlockKey | LRS Core Segmentation | (see documentation link to the left for more information) |
| SubBlock Key | SubBlockKey | LRS Core Segmentation | (see documentation link to the left for more information) |
| Corridor ID | CorridorID | LRS Core Segmentation | (see documentation link to the left for more information) |
| Nearest Intersection | NearestInt | LRS Core Segmentation | IntersectionKey of the nearest intersection. |
| Fatal Passenger Injuries | FATALPassenger | MPD Crash Database | Number of passenger fatalities. |
| Major Passenger Injuries | MAJORINJURIESPassenger | MPD Crash Database | Number of passengers with a major injury. |
| Minor Passenger Injuries | MINORINJURIESPassenger | MPD Crash Database | Number of passengers with a minor injury. |
| Unknown Passenger Injuries | UNKNOWNINJURIESPassenger | MPD Crash Database | Number of passengers with an unknown injury. |
| Crime ID | CrimeID | MPD Crash Database | The unique database record ID in MPD’s Records Management System (RMS) database. |
Injury Types by Description
| Injury Type | MPD's PD-10 Injury Descriptions |
|---|---|
| Fatal Injuries | Injury type = 'Fatal' or DOD (Date of death) is not null |
| Major Injuries | Other Major Injury |
| Possible Internal Injury | |
| Unconsciousness | |
| Apparent Broken Bones | |
| Loss Of Teeth | |
Concussion | |
| Gunshot (non-fatal) | |
| Severe Laceration | |
| Minor Injuries | Abrasions |
| Minor Cuts | |
| Discomfort | |
| Bleeding | |
| Swelling | |
| Pain | |
| Apparent Minor Injury | |
| Burns-minor | |
| Smoke Inhalation | |
| Bruises | |
| Unknown Injuries | Unknown |