{
"currentVersion": 11.2,
"cimVersion": "3.2.0",
"id": 24,
"name": "Vehicular Crash Data",
"type": "Feature Layer",
"description": "Point crash locations along the DDOT GIS centerline network. In addition to the location of the crash location, some basic summary statistics of the crash are provided. This data set is also attributed with a number of important attributes that indicate:The DC ward the crash occured in.Summary totals of:Number of Injuries (Minor, Major, Fatal), broken down by type (Ped, Bike, Car)Type of vehicles involved (Ped, Bike, Car)Type of impaired participant (Ped, Bike, Car driver)Was speeding involved?Nearest intersecting streetnameDistance from that intersectionCardinal direction from the intersection",
"geometryType": "esriGeometryPoint",
"sourceSpatialReference": {
"wkid": 26985,
"latestWkid": 26985,
"xyTolerance": 0.002,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -36747100,
"falseY": -29091500,
"xyUnits": 1000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
},
"copyrightText": "Metropolitan Police Department (MPD); District Department of Transportation (DDOT)",
"parentLayer": null,
"subLayers": [],
"minScale": 5000,
"maxScale": 0,
"referenceScale": 0.0,
"drawingInfo": {
"renderer": {
"type": "simple",
"symbol": {
"type": "esriSMS",
"style": "esriSMSCircle",
"color": [
173,
0,
29,
255
],
"size": 4,
"angle": 0,
"xoffset": 0,
"yoffset": 0,
"outline": {
"color": [
0,
0,
0,
255
],
"width": 1
}
}
},
"scaleSymbols": true,
"transparency": 0,
"labelingInfo": null
},
"defaultVisibility": false,
"extent": {
"xmin": -8584385.870870307,
"ymin": 4694256.185522702,
"xmax": -8561517.48981365,
"ymax": 4720920.796963105,
"spatialReference": {
"wkid": 102100,
"latestWkid": 3857,
"xyTolerance": 0.001,
"zTolerance": 0.001,
"mTolerance": 0.001,
"falseX": -20037700,
"falseY": -30241100,
"xyUnits": 10000,
"falseZ": -100000,
"zUnits": 10000,
"falseM": -100000,
"mUnits": 10000
}
},
"timeInfo": {
"startTimeField": "REPORTDATE",
"endTimeField": null,
"trackIdField": null,
"type": "field",
"timeExtent": [
-2208970800000,
1745005200000
],
"timeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"timeInterval": 3,
"timeIntervalUnits": "esriTimeUnitsYears",
"exportOptions": {
"useTime": true,
"timeDataCumulative": false,
"timeOffset": null,
"timeOffsetUnits": null
},
"hasLiveData": true
},
"hasAttachments": false,
"htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
"displayField": "NEARESTINTSTREETNAME",
"typeIdField": null,
"subtypeFieldName": null,
"subtypeField": null,
"defaultSubtypeCode": null,
"fields": [
{
"name": "CRIMEID",
"type": "esriFieldTypeString",
"alias": "CRASHID",
"length": 25,
"domain": null
},
{
"name": "CCN",
"type": "esriFieldTypeString",
"alias": "CCN",
"length": 8,
"domain": null
},
{
"name": "REPORTDATE",
"type": "esriFieldTypeDate",
"alias": "REPORTDATE",
"length": 8,
"domain": null
},
{
"name": "ROUTEID",
"type": "esriFieldTypeString",
"alias": "RouteID",
"length": 255,
"domain": null
},
{
"name": "MEASURE",
"type": "esriFieldTypeDouble",
"alias": "Measure",
"domain": null
},
{
"name": "OFFSET",
"type": "esriFieldTypeDouble",
"alias": "OFFSET",
"domain": null
},
{
"name": "STREETSEGID",
"type": "esriFieldTypeDouble",
"alias": "STREETSEGID",
"domain": null
},
{
"name": "ROADWAYSEGID",
"type": "esriFieldTypeDouble",
"alias": "ROADWAYSEGID",
"domain": null
},
{
"name": "FROMDATE",
"type": "esriFieldTypeDate",
"alias": "FROMDATE",
"length": 8,
"domain": null
},
{
"name": "TODATE",
"type": "esriFieldTypeDate",
"alias": "TODATE",
"length": 8,
"domain": null
},
{
"name": "ADDRESS",
"type": "esriFieldTypeString",
"alias": "ADDRESS",
"length": 100,
"domain": null
},
{
"name": "LATITUDE",
"type": "esriFieldTypeDouble",
"alias": "LATITUDE",
"domain": null
},
{
"name": "LONGITUDE",
"type": "esriFieldTypeDouble",
"alias": "LONGITUDE",
"domain": null
},
{
"name": "XCOORD",
"type": "esriFieldTypeDouble",
"alias": "XCOORD",
"domain": null
},
{
"name": "YCOORD",
"type": "esriFieldTypeDouble",
"alias": "YCOORD",
"domain": null
},
{
"name": "WARD",
"type": "esriFieldTypeString",
"alias": "WARD",
"length": 50,
"domain": null
},
{
"name": "EVENTID",
"type": "esriFieldTypeGUID",
"alias": "EventID",
"length": 38,
"domain": null
},
{
"name": "MAR_ADDRESS",
"type": "esriFieldTypeString",
"alias": "MAR_Address",
"length": 100,
"domain": null
},
{
"name": "MAR_SCORE",
"type": "esriFieldTypeDouble",
"alias": "MAR_SCORE",
"domain": null
},
{
"name": "MAJORINJURIES_BICYCLIST",
"type": "esriFieldTypeInteger",
"alias": "MAJORINJURIES_BICYCLIST",
"domain": null
},
{
"name": "MINORINJURIES_BICYCLIST",
"type": "esriFieldTypeInteger",
"alias": "MINORINJURIES_BICYCLIST",
"domain": null
},
{
"name": "UNKNOWNINJURIES_BICYCLIST",
"type": "esriFieldTypeInteger",
"alias": "UNKNOWNINJURIES_BICYCLIST",
"domain": null
},
{
"name": "FATAL_BICYCLIST",
"type": "esriFieldTypeInteger",
"alias": "FATAL_BICYCLIST",
"domain": null
},
{
"name": "MAJORINJURIES_DRIVER",
"type": "esriFieldTypeInteger",
"alias": "MAJORINJURIES_DRIVER",
"domain": null
},
{
"name": "MINORINJURIES_DRIVER",
"type": "esriFieldTypeInteger",
"alias": "MINORINJURIES_DRIVER",
"domain": null
},
{
"name": "UNKNOWNINJURIES_DRIVER",
"type": "esriFieldTypeInteger",
"alias": "UNKNOWNINJURIES_DRIVER",
"domain": null
},
{
"name": "FATAL_DRIVER",
"type": "esriFieldTypeInteger",
"alias": "FATAL_DRIVER",
"domain": null
},
{
"name": "MAJORINJURIES_PEDESTRIAN",
"type": "esriFieldTypeInteger",
"alias": "MAJORINJURIES_PEDESTRIAN",
"domain": null
},
{
"name": "MINORINJURIES_PEDESTRIAN",
"type": "esriFieldTypeInteger",
"alias": "MINORINJURIES_PEDESTRIAN",
"domain": null
},
{
"name": "UNKNOWNINJURIES_PEDESTRIAN",
"type": "esriFieldTypeInteger",
"alias": "UNKNOWNINJURIES_PEDESTRIAN",
"domain": null
},
{
"name": "FATAL_PEDESTRIAN",
"type": "esriFieldTypeInteger",
"alias": "FATAL_PEDESTRIAN",
"domain": null
},
{
"name": "TOTAL_VEHICLES",
"type": "esriFieldTypeInteger",
"alias": "TOTAL_VEHICLES",
"domain": null
},
{
"name": "TOTAL_BICYCLES",
"type": "esriFieldTypeInteger",
"alias": "TOTAL_BICYCLES",
"domain": null
},
{
"name": "TOTAL_PEDESTRIANS",
"type": "esriFieldTypeInteger",
"alias": "TOTAL_PEDESTRIANS",
"domain": null
},
{
"name": "PEDESTRIANSIMPAIRED",
"type": "esriFieldTypeInteger",
"alias": "PEDESTRIANSIMPAIRED",
"domain": null
},
{
"name": "BICYCLISTSIMPAIRED",
"type": "esriFieldTypeInteger",
"alias": "BICYCLISTSIMPAIRED",
"domain": null
},
{
"name": "DRIVERSIMPAIRED",
"type": "esriFieldTypeInteger",
"alias": "DRIVERSIMPAIRED",
"domain": null
},
{
"name": "TOTAL_TAXIS",
"type": "esriFieldTypeInteger",
"alias": "TOTAL_TAXIS",
"domain": null
},
{
"name": "TOTAL_GOVERNMENT",
"type": "esriFieldTypeInteger",
"alias": "TOTAL_GOVERNMENT",
"domain": null
},
{
"name": "SPEEDING_INVOLVED",
"type": "esriFieldTypeInteger",
"alias": "SPEEDING_INVOLVED",
"domain": null
},
{
"name": "NEARESTINTROUTEID",
"type": "esriFieldTypeString",
"alias": "NEARESTINTROUTEID",
"length": 100,
"domain": null
},
{
"name": "NEARESTINTSTREETNAME",
"type": "esriFieldTypeString",
"alias": "NEARESTINTSTREETNAME",
"length": 250,
"domain": null
},
{
"name": "OFFINTERSECTION",
"type": "esriFieldTypeDouble",
"alias": "OFFINTERSECTION",
"domain": null
},
{
"name": "INTAPPROACHDIRECTION",
"type": "esriFieldTypeString",
"alias": "INTAPPROACHDIRECTION",
"length": 50,
"domain": null
},
{
"name": "LOCATIONERROR",
"type": "esriFieldTypeString",
"alias": "LOCATIONERROR",
"length": 100,
"domain": null
},
{
"name": "LASTUPDATEDATE",
"type": "esriFieldTypeDate",
"alias": "LASTUPDATEDATE",
"length": 8,
"domain": null
},
{
"name": "MPDLATITUDE",
"type": "esriFieldTypeDouble",
"alias": "MPDLATITUDE",
"domain": null
},
{
"name": "MPDLONGITUDE",
"type": "esriFieldTypeDouble",
"alias": "MPDLONGITUDE",
"domain": null
},
{
"name": "MPDGEOX",
"type": "esriFieldTypeDouble",
"alias": "MPDGEOX",
"domain": null
},
{
"name": "MPDGEOY",
"type": "esriFieldTypeDouble",
"alias": "MPDGEOY",
"domain": null
},
{
"name": "FATALPASSENGER",
"type": "esriFieldTypeDouble",
"alias": "FATALPASSENGER",
"domain": null
},
{
"name": "MAJORINJURIESPASSENGER",
"type": "esriFieldTypeDouble",
"alias": "MAJORINJURIESPASSENGER",
"domain": null
},
{
"name": "MINORINJURIESPASSENGER",
"type": "esriFieldTypeDouble",
"alias": "MINORINJURIESPASSENGER",
"domain": null
},
{
"name": "UNKNOWNINJURIESPASSENGER",
"type": "esriFieldTypeDouble",
"alias": "UNKNOWNINJURIESPASSENGER",
"domain": null
},
{
"name": "MAR_ID",
"type": "esriFieldTypeDouble",
"alias": "MAR ID",
"domain": null
},
{
"name": "BLOCKKEY",
"type": "esriFieldTypeString",
"alias": "BLOCKKEY",
"length": 255,
"domain": null
},
{
"name": "SUBBLOCKKEY",
"type": "esriFieldTypeString",
"alias": "SUBBLOCKKEY",
"length": 255,
"domain": null
},
{
"name": "CORRIDORID",
"type": "esriFieldTypeString",
"alias": "CORRIDORID",
"length": 50,
"domain": null
},
{
"name": "NEARESTINTKEY",
"type": "esriFieldTypeString",
"alias": "NEARESTINTKEY",
"length": 50,
"domain": null
},
{
"name": "MAJORINJURIESOTHER",
"type": "esriFieldTypeDouble",
"alias": "MAJORINJURIESOTHER",
"domain": null
},
{
"name": "MINORINJURIESOTHER",
"type": "esriFieldTypeDouble",
"alias": "MINORINJURIESOTHER",
"domain": null
},
{
"name": "UNKNOWNINJURIESOTHER",
"type": "esriFieldTypeDouble",
"alias": "UNKNOWNINJURIESOTHER",
"domain": null
},
{
"name": "FATALOTHER",
"type": "esriFieldTypeDouble",
"alias": "FATALOTHER",
"domain": null
},
{
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE",
"domain": null
},
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null
}
],
"geometryField": {
"name": "SHAPE",
"type": "esriFieldTypeGeometry",
"alias": "SHAPE"
},
"indexes": [
{
"name": "R4054_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "A2656_IX1",
"fields": "SHAPE",
"isAscending": true,
"isUnique": true,
"description": ""
}
],
"subtypes": [],
"relationships": [
{
"id": 0,
"name": "CrashDetails",
"relatedTableId": 25,
"role": "esriRelRoleOrigin",
"keyField": "CRIMEID",
"cardinality": "esriRelCardinalityOneToMany",
"composite": false,
"catalogID": "{6A38B305-09BD-4565-B865-D7DA19A9CF73}"
}
],
"canModifyLayer": true,
"canScaleSymbols": false,
"hasLabels": false,
"capabilities": "Map,Query,Data",
"maxRecordCount": 1000,
"supportsStatistics": true,
"supportsExceedsLimitStatistics": true,
"supportsAdvancedQueries": true,
"hasZ": true,
"hasM": true,
"supportedQueryFormats": "JSON, geoJSON, PBF",
"isDataVersioned": false,
"ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
"useStandardizedQueries": true,
"supportedSpatialRelationships": [
"esriSpatialRelIntersects",
"esriSpatialRelContains",
"esriSpatialRelCrosses",
"esriSpatialRelEnvelopeIntersects",
"esriSpatialRelIndexIntersects",
"esriSpatialRelOverlaps",
"esriSpatialRelTouches",
"esriSpatialRelWithin",
"esriSpatialRelRelation"
],
"advancedQueryCapabilities": {
"useStandardizedQueries": true,
"supportsStatistics": true,
"supportsPercentileStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsAdvancedQueryRelated": true,
"supportsQueryRelatedPagination": true,
"supportsPagination": true,
"supportsLod": false,
"supportsQueryWithLodSR": false,
"supportsTrueCurve": true,
"supportsQueryWithDatumTransformation": true,
"supportsReturningQueryExtent": true,
"supportsQueryWithDistance": true,
"supportsSqlExpression": true,
"supportsTimeRelation": true,
"supportsSqlFormat": false,
"supportsQueryAnalytic": true,
"supportsCurrentUserQueries": true
},
"supportsDatumTransformation": true,
"advancedQueryAnalyticCapabilities": {
"supportsLinearRegression": true,
"supportsAsync": false,
"supportsPercentileAnalytic": true
},
"dateFieldsTimeReference": {
"timeZone": "Eastern Standard Time",
"respectsDaylightSaving": true
},
"preferredTimeReference": null,
"datesInUnknownTimezone": false,
"hasMetadata": true,
"isDataArchived": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsCoordinatesQuantization": true,
"supportsDynamicLegends": true
}