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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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/01/02 18:00: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: null

Fields:

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

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata