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 '99' means this falls outside of DC <Null> indicates a geometry error
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

Browser not supported