View In:   ArcGIS Online Map Viewer

Name: Vehicular Crash Data

Display Field: NEARESTINTSTREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Crashes on the roadway blocks network of Washington, DC maintained by the District Department of Transportation (DDOT). In addition to locations, a related table consisting of crash details is available for each crash. This table provides some anonymized information about each of the persons involved in the crash (linked by CRASHID). These crash data are derived from the Metropolitan Police Department's (MPD) crash data management system (COBALT) and represent DDOT's attempt to summarize some of the most requested elements of the crash data. Further, DDOT has attempted to enhance this summary by locating each crash location along the DDOT roadway block line, providing a number of location references for each crash. In the event that location data is missing or incomplete for a crash, it is unable to be published within this dataset. Location points with some basic summary statistics,The DC ward the crash occurredSummary totals for: injuries (minor, major, fatal) by type (pedestrian, bicycle, car), mode of travel involved (pedestrian, bicycle, car), impaired participants (pedestrian, bicyclist, car passengers)If speeding was involvedNearest intersecting street nameDistance from nearest intersectionCardinal direction from the intersectionRead more at https://ddotwiki.atlassian.net/wiki/spaces/GIS0225/pages/2053603429/Crash+Data. Questions on the contents of these layers should be emailed to Metropolitan Police Department or the DDOT Traffic Safety Division. Questions regarding the Open Data DC can be sent to @OpenDataDC

Copyright Text: District Department of Transportation

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -8584385.870870307
YMin: 4694256.185522702
XMax: -8561517.48981365
YMax: 4720920.796963105
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [173, 0, 29, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: true

Time Info:

Start Time Field: REPORTDATE
End Time Field: null
Track ID Field: null
Time Extent:
[1825/11/08 11:57:02 UTC, 2026/02/25 20:35:00 UTC]

Time Reference:
Time Zone: Eastern Standard Time
Respects Daylight Saving: true

Time Interval: 3
Time Interval Units: esriTimeUnitsYears
Has Live Data: true
Export Options:
Use Time: true
Time Data Cumulative: false
Time Offset: null (null)

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• CRIMEID ( type: esriFieldTypeString, alias: CRASHID, editable: true, nullable: false, length: 25, defaultValue: null, modelName: CrimeID )
• CCN ( type: esriFieldTypeString, alias: CCN, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CCN )
• REPORTDATE ( type: esriFieldTypeDate, alias: REPORTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPORTDATE )
• ROUTEID ( type: esriFieldTypeString, alias: RouteID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RouteID )
• MEASURE ( type: esriFieldTypeDouble, alias: Measure, editable: true, nullable: true, defaultValue: null, modelName: Measure )
• OFFSET ( type: esriFieldTypeDouble, alias: OFFSET, editable: true, nullable: true, defaultValue: null, modelName: OFFSET )
• STREETSEGID ( type: esriFieldTypeDouble, alias: STREETSEGID, editable: true, nullable: true, defaultValue: null, modelName: STREETSEGID )
• ROADWAYSEGID ( type: esriFieldTypeDouble, alias: ROADWAYSEGID, editable: true, nullable: true, defaultValue: null, modelName: ROADWAYSEGID )
• FROMDATE ( type: esriFieldTypeDate, alias: FROMDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FROMDATE )
• TODATE ( type: esriFieldTypeDate, alias: TODATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TODATE )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDRESS )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• XCOORD ( type: esriFieldTypeDouble, alias: XCOORD, editable: true, nullable: true, defaultValue: null, modelName: XCOORD )
• YCOORD ( type: esriFieldTypeDouble, alias: YCOORD, editable: true, nullable: true, defaultValue: null, modelName: YCOORD )
• WARD ( type: esriFieldTypeString, alias: WARD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WARD )
• EVENTID ( type: esriFieldTypeGUID, alias: EventID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: EventID )
• MAR_ADDRESS ( type: esriFieldTypeString, alias: MAR_Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MAR_Address )
• MAR_SCORE ( type: esriFieldTypeDouble, alias: MAR_SCORE, editable: true, nullable: true, defaultValue: null, modelName: MAR_SCORE )
• MAJORINJURIES_BICYCLIST ( type: esriFieldTypeInteger, alias: MAJORINJURIES_BICYCLIST, editable: true, nullable: true, defaultValue: null, modelName: MAJORINJURIES_BICYCLIST )
• MINORINJURIES_BICYCLIST ( type: esriFieldTypeInteger, alias: MINORINJURIES_BICYCLIST, editable: true, nullable: true, defaultValue: null, modelName: MINORINJURIES_BICYCLIST )
• UNKNOWNINJURIES_BICYCLIST ( type: esriFieldTypeInteger, alias: UNKNOWNINJURIES_BICYCLIST, editable: true, nullable: true, defaultValue: null, modelName: UNKNOWNINJURIES_BICYCLIST )
• FATAL_BICYCLIST ( type: esriFieldTypeInteger, alias: FATAL_BICYCLIST, editable: true, nullable: true, defaultValue: null, modelName: FATAL_BICYCLIST )
• MAJORINJURIES_DRIVER ( type: esriFieldTypeInteger, alias: MAJORINJURIES_DRIVER, editable: true, nullable: true, defaultValue: null, modelName: MAJORINJURIES_DRIVER )
• MINORINJURIES_DRIVER ( type: esriFieldTypeInteger, alias: MINORINJURIES_DRIVER, editable: true, nullable: true, defaultValue: null, modelName: MINORINJURIES_DRIVER )
• UNKNOWNINJURIES_DRIVER ( type: esriFieldTypeInteger, alias: UNKNOWNINJURIES_DRIVER, editable: true, nullable: true, defaultValue: null, modelName: UNKNOWNINJURIES_DRIVER )
• FATAL_DRIVER ( type: esriFieldTypeInteger, alias: FATAL_DRIVER, editable: true, nullable: true, defaultValue: null, modelName: FATAL_DRIVER )
• MAJORINJURIES_PEDESTRIAN ( type: esriFieldTypeInteger, alias: MAJORINJURIES_PEDESTRIAN, editable: true, nullable: true, defaultValue: null, modelName: MAJORINJURIES_PEDESTRIAN )
• MINORINJURIES_PEDESTRIAN ( type: esriFieldTypeInteger, alias: MINORINJURIES_PEDESTRIAN, editable: true, nullable: true, defaultValue: null, modelName: MINORINJURIES_PEDESTRIAN )
• UNKNOWNINJURIES_PEDESTRIAN ( type: esriFieldTypeInteger, alias: UNKNOWNINJURIES_PEDESTRIAN, editable: true, nullable: true, defaultValue: null, modelName: UNKNOWNINJURIES_PEDESTRIAN )
• FATAL_PEDESTRIAN ( type: esriFieldTypeInteger, alias: FATAL_PEDESTRIAN, editable: true, nullable: true, defaultValue: null, modelName: FATAL_PEDESTRIAN )
• TOTAL_VEHICLES ( type: esriFieldTypeInteger, alias: TOTAL_VEHICLES, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_VEHICLES )
• TOTAL_BICYCLES ( type: esriFieldTypeInteger, alias: TOTAL_BICYCLES, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_BICYCLES )
• TOTAL_PEDESTRIANS ( type: esriFieldTypeInteger, alias: TOTAL_PEDESTRIANS, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_PEDESTRIANS )
• PEDESTRIANSIMPAIRED ( type: esriFieldTypeInteger, alias: PEDESTRIANSIMPAIRED, editable: true, nullable: true, defaultValue: null, modelName: PEDESTRIANSIMPAIRED )
• BICYCLISTSIMPAIRED ( type: esriFieldTypeInteger, alias: BICYCLISTSIMPAIRED, editable: true, nullable: true, defaultValue: null, modelName: BICYCLISTSIMPAIRED )
• DRIVERSIMPAIRED ( type: esriFieldTypeInteger, alias: DRIVERSIMPAIRED, editable: true, nullable: true, defaultValue: null, modelName: DRIVERSIMPAIRED )
• TOTAL_TAXIS ( type: esriFieldTypeInteger, alias: TOTAL_TAXIS, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_TAXIS )
• TOTAL_GOVERNMENT ( type: esriFieldTypeInteger, alias: TOTAL_GOVERNMENT, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_GOVERNMENT )
• SPEEDING_INVOLVED ( type: esriFieldTypeInteger, alias: SPEEDING_INVOLVED, editable: true, nullable: true, defaultValue: null, modelName: SPEEDING_INVOLVED )
• NEARESTINTROUTEID ( type: esriFieldTypeString, alias: NEARESTINTROUTEID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NEARESTINTROUTEID )
• NEARESTINTSTREETNAME ( type: esriFieldTypeString, alias: NEARESTINTSTREETNAME, editable: true, nullable: true, length: 250, defaultValue: null, modelName: NEARESTINTSTREETNAME )
• OFFINTERSECTION ( type: esriFieldTypeDouble, alias: OFFINTERSECTION, editable: true, nullable: true, defaultValue: null, modelName: OFFINTERSECTION )
• INTAPPROACHDIRECTION ( type: esriFieldTypeString, alias: INTAPPROACHDIRECTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INTAPPROACHDIRECTION )
• LOCATIONERROR ( type: esriFieldTypeString, alias: LOCATIONERROR, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATIONERROR )
• LASTUPDATEDATE ( type: esriFieldTypeDate, alias: LASTUPDATEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATEDATE )
• MPDLATITUDE ( type: esriFieldTypeDouble, alias: MPDLATITUDE, editable: true, nullable: true, defaultValue: null, modelName: MPDLATITUDE )
• MPDLONGITUDE ( type: esriFieldTypeDouble, alias: MPDLONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: MPDLONGITUDE )
• MPDGEOX ( type: esriFieldTypeDouble, alias: MPDGEOX, editable: true, nullable: true, defaultValue: null, modelName: MPDGEOX )
• MPDGEOY ( type: esriFieldTypeDouble, alias: MPDGEOY, editable: true, nullable: true, defaultValue: null, modelName: MPDGEOY )
• FATALPASSENGER ( type: esriFieldTypeDouble, alias: FATALPASSENGER, editable: true, nullable: true, defaultValue: null, modelName: FATALPASSENGER )
• MAJORINJURIESPASSENGER ( type: esriFieldTypeDouble, alias: MAJORINJURIESPASSENGER, editable: true, nullable: true, defaultValue: null, modelName: MAJORINJURIESPASSENGER )
• MINORINJURIESPASSENGER ( type: esriFieldTypeDouble, alias: MINORINJURIESPASSENGER, editable: true, nullable: true, defaultValue: null, modelName: MINORINJURIESPASSENGER )
• UNKNOWNINJURIESPASSENGER ( type: esriFieldTypeDouble, alias: UNKNOWNINJURIESPASSENGER, editable: true, nullable: true, defaultValue: null, modelName: UNKNOWNINJURIESPASSENGER )
• MAR_ID ( type: esriFieldTypeDouble, alias: MAR ID, editable: true, nullable: true, defaultValue: null, modelName: MAR_ID )
• BLOCKKEY ( type: esriFieldTypeString, alias: BLOCKKEY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BLOCKKEY )
• SUBBLOCKKEY ( type: esriFieldTypeString, alias: SUBBLOCKKEY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SUBBLOCKKEY )
• CORRIDORID ( type: esriFieldTypeString, alias: CORRIDORID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CORRIDORID )
• NEARESTINTKEY ( type: esriFieldTypeString, alias: NEARESTINTKEY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEARESTINTKEY )
• MAJORINJURIESOTHER ( type: esriFieldTypeDouble, alias: MAJORINJURIESOTHER, editable: true, nullable: true, defaultValue: null, modelName: MAJORINJURIESOTHER )
• MINORINJURIESOTHER ( type: esriFieldTypeDouble, alias: MINORINJURIESOTHER, editable: true, nullable: true, defaultValue: null, modelName: MINORINJURIESOTHER )
• UNKNOWNINJURIESOTHER ( type: esriFieldTypeDouble, alias: UNKNOWNINJURIESOTHER, editable: true, nullable: true, defaultValue: null, modelName: UNKNOWNINJURIESOTHER )
• FATALOTHER ( type: esriFieldTypeDouble, alias: FATALOTHER, editable: true, nullable: true, defaultValue: null, modelName: FATALOTHER )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Vehicular Crash Data
  Description:
  Prototype:
  UNKNOWNINJURIESOTHER: null
  CRIMEID:
  CCN: null
  REPORTDATE: null
  ROUTEID: null
  MEASURE: null
  OFFSET: null
  STREETSEGID: null
  ROADWAYSEGID: null
  FROMDATE: null
  TODATE: null
  ADDRESS: null
  LATITUDE: null
  LONGITUDE: null
  XCOORD: null
  YCOORD: null
  WARD: null
  EVENTID: null
  MAR_ADDRESS: null
  MAR_SCORE: null
  MAJORINJURIES_BICYCLIST: null
  MINORINJURIES_BICYCLIST: null
  UNKNOWNINJURIES_BICYCLIST: null
  FATAL_BICYCLIST: null
  MAJORINJURIES_DRIVER: null
  MINORINJURIES_DRIVER: null
  UNKNOWNINJURIES_DRIVER: null
  FATAL_DRIVER: null
  MAJORINJURIES_PEDESTRIAN: null
  MINORINJURIES_PEDESTRIAN: null
  UNKNOWNINJURIES_PEDESTRIAN: null
  FATAL_PEDESTRIAN: null
  TOTAL_VEHICLES: null
  TOTAL_BICYCLES: null
  TOTAL_PEDESTRIANS: null
  PEDESTRIANSIMPAIRED: null
  BICYCLISTSIMPAIRED: null
  DRIVERSIMPAIRED: null
  TOTAL_TAXIS: null
  TOTAL_GOVERNMENT: null
  SPEEDING_INVOLVED: null
  NEARESTINTROUTEID: null
  NEARESTINTSTREETNAME: null
  OFFINTERSECTION: null
  INTAPPROACHDIRECTION: null
  LOCATIONERROR: null
  LASTUPDATEDATE: null
  MPDLATITUDE: null
  MPDLONGITUDE: null
  MPDGEOX: null
  MPDGEOY: null
  FATALPASSENGER: null
  MAJORINJURIESPASSENGER: null
  MINORINJURIESPASSENGER: null
  UNKNOWNINJURIESPASSENGER: null
  MAR_ID: null
  BLOCKKEY: null
  SUBBLOCKKEY: null
  CORRIDORID: null
  NEARESTINTKEY: null
  MAJORINJURIESOTHER: null
  MINORINJURIESOTHER: null
  FATALOTHER: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• CrashDetails (3) -- Related To: Crash Details (25)

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata