{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 16, "name": "Crashes_2018_22_from_Jake_20240314", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RouteName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "IncidentDate", "type": "esriFieldTypeDate", "alias": "IncidentDate", "length": 8, "domain": null }, { "name": "IncidentDateTime", "type": "esriFieldTypeDate", "alias": "IncidentDateTime", "length": 8, "domain": null }, { "name": "IncidentYear", "type": "esriFieldTypeDouble", "alias": "IncidentYear", "domain": null }, { "name": "IncidentHour", "type": "esriFieldTypeDouble", "alias": "IncidentHour", "domain": null }, { "name": "OfficerNcic", "type": "esriFieldTypeDouble", "alias": "OfficerNcic", "domain": null }, { "name": "OfficerId", "type": "esriFieldTypeString", "alias": "OfficerId", "length": 255, "domain": null }, { "name": "FileNumber", "type": "esriFieldTypeDouble", "alias": "FileNumber", "domain": null }, { "name": "ExtendedNcic", "type": "esriFieldTypeDouble", "alias": "ExtendedNcic", "domain": null }, { "name": "CollisionManner", "type": "esriFieldTypeDouble", "alias": "CollisionManner", "domain": null }, { "name": "LightCondition", "type": "esriFieldTypeDouble", "alias": "LightCondition", "domain": null }, { "name": "FirstHarmfulEvent", "type": "esriFieldTypeDouble", "alias": "FirstHarmfulEvent", "domain": null }, { "name": "FirstHarmfulLocation", "type": "esriFieldTypeString", "alias": "FirstHarmfulLocation", "length": 255, "domain": null }, { "name": "TotalUnits", "type": "esriFieldTypeDouble", "alias": "TotalUnits", "domain": null }, { "name": "TotalMotorists", "type": "esriFieldTypeDouble", "alias": "TotalMotorists", "domain": null }, { "name": "TotalNonMotorists", "type": "esriFieldTypeDouble", "alias": "TotalNonMotorists", "domain": null }, { "name": "TotalInjuries", "type": "esriFieldTypeDouble", "alias": "TotalInjuries", "domain": null }, { "name": "TotalFatalities", "type": "esriFieldTypeDouble", "alias": "TotalFatalities", "domain": null }, { "name": "TotalMotoristsInjuries", "type": "esriFieldTypeDouble", "alias": "TotalMotoristsInjuries", "domain": null }, { "name": "TotalNonMotoristsInjuries", "type": "esriFieldTypeDouble", "alias": "TotalNonMotoristsInjuries", "domain": null }, { "name": "TotalMotoristsFatalities", "type": "esriFieldTypeDouble", "alias": "TotalMotoristsFatalities", "domain": null }, { "name": "TotalNonMotoristsFatalities", "type": "esriFieldTypeDouble", "alias": "TotalNonMotoristsFatalities", "domain": null }, { "name": "InjurySeverity", "type": "esriFieldTypeDouble", "alias": "InjurySeverity", "domain": null }, { "name": "MedicalTransportFlag", "type": "esriFieldTypeString", "alias": "MedicalTransportFlag", "length": 255, "domain": null }, { "name": "FatalAccidentFlag", "type": "esriFieldTypeDouble", "alias": "FatalAccidentFlag", "domain": null }, { "name": "TowAwayFlag", "type": "esriFieldTypeDouble", "alias": "TowAwayFlag", "domain": null }, { "name": "NscReportable", "type": "esriFieldTypeString", "alias": "NscReportable", "length": 255, "domain": null }, { "name": "SchoolBusRelatedFlag", "type": "esriFieldTypeSmallInteger", "alias": "SchoolBusRelatedFlag", "domain": null }, { "name": "WorkZoneRelatedFlag", "type": "esriFieldTypeSmallInteger", "alias": "WorkZoneRelatedFlag", "domain": null }, { "name": "WorkersPresentFlag", "type": "esriFieldTypeDouble", "alias": "WorkersPresentFlag", "domain": null }, { "name": "AlcoholInvolvementFlag", "type": "esriFieldTypeDouble", "alias": "AlcoholInvolvementFlag", "domain": null }, { "name": "DrugInvolvementFlag", "type": "esriFieldTypeDouble", "alias": "DrugInvolvementFlag", "domain": null }, { "name": "HazardousFlag", "type": "esriFieldTypeString", "alias": "HazardousFlag", "length": 255, "domain": null }, { "name": "HitAndRunFlag", "type": "esriFieldTypeSmallInteger", "alias": "HitAndRunFlag", "domain": null }, { "name": "CrossingFeature", "type": "esriFieldTypeString", "alias": "CrossingFeature", "length": 255, "domain": null }, { "name": "Offset_", "type": "esriFieldTypeDouble", "alias": "Offset", "domain": null }, { "name": "OffsetMeasuredFlag", "type": "esriFieldTypeDouble", "alias": "OffsetMeasuredFlag", "domain": null }, { "name": "OffsetUnit", "type": "esriFieldTypeDouble", "alias": "OffsetUnit", "domain": null }, { "name": "MPNum", "type": "esriFieldTypeDouble", "alias": "MPNum", "domain": null }, { "name": "MPOffset", "type": "esriFieldTypeDouble", "alias": "MPOffset", "domain": null }, { "name": "CityId", "type": "esriFieldTypeDouble", "alias": "CityId", "domain": null }, { "name": "CountyId", "type": "esriFieldTypeDouble", "alias": "CountyId", "domain": null }, { "name": "StateId", "type": "esriFieldTypeDouble", "alias": "StateId", "domain": null }, { "name": "StateCode", "type": "esriFieldTypeString", "alias": "StateCode", "length": 255, "domain": null }, { "name": "CountryCode", "type": "esriFieldTypeString", "alias": "CountryCode", "length": 255, "domain": null }, { "name": "Latitude", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null }, { "name": "Longitude", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null }, { "name": "ValidLocationFlag", "type": "esriFieldTypeDouble", "alias": "ValidLocationFlag", "domain": null }, { "name": "LocationToolVersion", "type": "esriFieldTypeString", "alias": "LocationToolVersion", "length": 255, "domain": null }, { "name": "HESIntersectionFlag", "type": "esriFieldTypeString", "alias": "HESIntersectionFlag", "length": 255, "domain": null }, { "name": "IntersectionFlag", "type": "esriFieldTypeDouble", "alias": "IntersectionFlag", "domain": null }, { "name": "IntersectionRouteID", "type": "esriFieldTypeString", "alias": "IntersectionRouteID", "length": 255, "domain": null }, { "name": "IntersectionATISCode", "type": "esriFieldTypeString", "alias": "IntersectionATISCode", "length": 255, "domain": null }, { "name": "TrafficWayType", "type": "esriFieldTypeDouble", "alias": "TrafficWayType", "domain": null }, { "name": "IntersectionType", "type": "esriFieldTypeDouble", "alias": "IntersectionType", "domain": null }, { "name": "JunctionRelation", "type": "esriFieldTypeDouble", "alias": "JunctionRelation", "domain": null }, { "name": "Weather", "type": "esriFieldTypeDouble", "alias": "Weather", "domain": null }, { "name": "PropertyDamageOwnerCode", "type": "esriFieldTypeString", "alias": "PropertyDamageOwnerCode", "length": 255, "domain": null }, { "name": "DayofWeekSortOrder", "type": "esriFieldTypeDouble", "alias": "DayofWeekSortOrder", "domain": null }, { "name": "MonthSortOrder", "type": "esriFieldTypeDouble", "alias": "MonthSortOrder", "domain": null }, { "name": "IncidentID", "type": "esriFieldTypeDouble", "alias": "IncidentID", "domain": null }, { "name": "RouteName", "type": "esriFieldTypeString", "alias": "RouteName", "length": 255, "domain": null }, { "name": "CrossingFeatureName", "type": "esriFieldTypeString", "alias": "CrossingFeatureName", "length": 255, "domain": null }, { "name": "PropertyDamageDescCode", "type": "esriFieldTypeString", "alias": "PropertyDamageDescCode", "length": 255, "domain": null }, { "name": "OffsetDirection", "type": "esriFieldTypeDouble", "alias": "OffsetDirection", "domain": null }, { "name": "SecondaryCrashFlag", "type": "esriFieldTypeDouble", "alias": "SecondaryCrashFlag", "domain": null }, { "name": "GeocodeOffsetInMiles", "type": "esriFieldTypeDouble", "alias": "GeocodeOffsetInMiles", "domain": null }, { "name": "X", "type": "esriFieldTypeDouble", "alias": "X", "domain": null }, { "name": "Y", "type": "esriFieldTypeDouble", "alias": "Y", "domain": null }, { "name": "GeocodeOnRoadRouteId", "type": "esriFieldTypeString", "alias": "GeocodeOnRoadRouteId", "length": 255, "domain": null }, { "name": "FirstHarmfulEvent_TEXT", "type": "esriFieldTypeString", "alias": "FirstHarmfulEvent_TEXT", "length": 255, "domain": null }, { "name": "CollisionManner_TEXT", "type": "esriFieldTypeString", "alias": "CollisionManner_TEXT", "length": 255, "domain": null }, { "name": "JunctionRelation_TEXT", "type": "esriFieldTypeDouble", "alias": "JunctionRelation_TEXT", "domain": null }, { "name": "TrafficWayType_TEXT", "type": "esriFieldTypeString", "alias": "TrafficWayType_TEXT", "length": 255, "domain": null }, { "name": "TrafficWayType_TEXT__groups_", "type": "esriFieldTypeString", "alias": "TrafficWayType_TEXT (groups)", "length": 255, "domain": null }, { "name": "InjurySeverity_TEXT", "type": "esriFieldTypeString", "alias": "InjurySeverity_TEXT", "length": 255, "domain": null }, { "name": "IntersectionType_TEXT", "type": "esriFieldTypeString", "alias": "IntersectionType_TEXT", "length": 255, "domain": null }, { "name": "Weather_TEXT", "type": "esriFieldTypeString", "alias": "Weather_TEXT", "length": 255, "domain": null }, { "name": "LightCondition_TEXT", "type": "esriFieldTypeString", "alias": "LightCondition_TEXT", "length": 255, "domain": null }, { "name": "FLAG_Pedestrian", "type": "esriFieldTypeDouble", "alias": "FLAG_Pedestrian", "domain": null }, { "name": "FLAG_Bike", "type": "esriFieldTypeDouble", "alias": "FLAG_Bike", "domain": null }, { "name": "FLAG_Motorcyclist", "type": "esriFieldTypeDouble", "alias": "FLAG_Motorcyclist", "domain": null }, { "name": "FLAG_Bus", "type": "esriFieldTypeDouble", "alias": "FLAG_Bus", "domain": null }, { "name": "FLAG_Ped_OR_Bike", "type": "esriFieldTypeDouble", "alias": "FLAG_Ped_OR_Bike", "domain": null }, { "name": "FLAG_Speeding_Unit", "type": "esriFieldTypeDouble", "alias": "FLAG_Speeding_Unit", "domain": null }, { "name": "FLAG_Speeding_Person", "type": "esriFieldTypeDouble", "alias": "FLAG_Speeding_Person", "domain": null }, { "name": "FLAG_Impair_DriverUnit1", "type": "esriFieldTypeDouble", "alias": "FLAG_Impair_DriverUnit1", "domain": null }, { "name": "FLAG_Speeding", "type": "esriFieldTypeString", "alias": "FLAG_Speeding", "length": 255, "domain": null }, { "name": "Offset_150ft", "type": "esriFieldTypeString", "alias": "Offset<150ft", "length": 255, "domain": null }, { "name": "FLAG_Unrestrained_Driver", "type": "esriFieldTypeDouble", "alias": "FLAG_Unrestrained_Driver", "domain": null }, { "name": "FLAG_Impair_DriverUnit1__groups", "type": "esriFieldTypeString", "alias": "FLAG_Impair_DriverUnit1 (groups)", "length": 255, "domain": null }, { "name": "FLAG_Unrestrained_Driver__group", "type": "esriFieldTypeString", "alias": "FLAG_Unrestrained_Driver (groups)", "length": 255, "domain": null }, { "name": "Onroad_CrossingFeature", "type": "esriFieldTypeString", "alias": "Onroad+CrossingFeature", "length": 255, "domain": null }, { "name": "IDcount", "type": "esriFieldTypeDouble", "alias": "IDcount", "domain": null }, { "name": "GeocodeOnRoad", "type": "esriFieldTypeString", "alias": "GeocodeOnRoad", "length": 255, "domain": null }, { "name": "GeocodeCrossingFeatureName", "type": "esriFieldTypeString", "alias": "GeocodeCrossingFeatureName", "length": 255, "domain": null }, { "name": "InjurySeverity_TEXT__groups_", "type": "esriFieldTypeString", "alias": "InjurySeverity_TEXT (groups)", "length": 255, "domain": null }, { "name": "LightCondition_GRP", "type": "esriFieldTypeString", "alias": "LightCondition_GRP", "length": 255, "domain": null }, { "name": "GIS_Intersection_Name", "type": "esriFieldTypeString", "alias": "GIS#Intersection_Name", "length": 255, "domain": null }, { "name": "GIS_Intersection_Equipment", "type": "esriFieldTypeString", "alias": "GIS#Intersection_Equipment", "length": 255, "domain": null }, { "name": "GIS_Intersection_ADOT_ROW", "type": "esriFieldTypeString", "alias": "GIS#Intersection_ADOT ROW", "length": 255, "domain": null }, { "name": "GIS_HIN_IntName", "type": "esriFieldTypeString", "alias": "GIS#HIN_IntName", "length": 255, "domain": null }, { "name": "GIS_HIN_Seg_Name", "type": "esriFieldTypeString", "alias": "GIS#HIN_Seg_Name", "length": 255, "domain": null }, { "name": "GIS_Council_DISTRICT", "type": "esriFieldTypeDouble", "alias": "GIS#Council_DISTRICT", "domain": null }, { "name": "GIS_Location", "type": "esriFieldTypeString", "alias": "GIS#Location", "length": 255, "domain": null }, { "name": "GIS_FLAG_ADOT_ROW", "type": "esriFieldTypeString", "alias": "GIS#FLAG_ADOT ROW", "length": 255, "domain": null }, { "name": "GIS_FLAG_Out_Phoenix", "type": "esriFieldTypeString", "alias": "GIS#FLAG_Out Phoenix", "length": 255, "domain": null }, { "name": "GIS_Location__groups_", "type": "esriFieldTypeString", "alias": "GIS#Location (groups)", "length": 255, "domain": null }, { "name": "GIS_HIN_IntName__groups_", "type": "esriFieldTypeString", "alias": "GIS#HIN_IntName (groups)", "length": 255, "domain": null }, { "name": "GIS_HIN_Seg_Name__groups_", "type": "esriFieldTypeString", "alias": "GIS#HIN_Seg_Name (groups)", "length": 255, "domain": null }, { "name": "Crash_type", "type": "esriFieldTypeString", "alias": "Crash_type", "length": 255, "domain": null }, { "name": "Crash_type__groups_", "type": "esriFieldTypeString", "alias": "Crash_type (groups)", "length": 255, "domain": null }, { "name": "Count_blanks", "type": "esriFieldTypeDouble", "alias": "Count blanks", "domain": null }, { "name": "GIS_FLAG_Arterial", "type": "esriFieldTypeString", "alias": "GIS#FLAG_Arterial", "length": 255, "domain": null }, { "name": "Unit_1_UnitTypeDesc", "type": "esriFieldTypeString", "alias": "Unit 1#UnitTypeDesc", "length": 255, "domain": null }, { "name": "Unit_1_TravelDirectionDesc", "type": "esriFieldTypeString", "alias": "Unit 1#TravelDirectionDesc", "length": 255, "domain": null }, { "name": "Unit_1_LaneDesc", "type": "esriFieldTypeString", "alias": "Unit 1#LaneDesc", "length": 255, "domain": null }, { "name": "Unit_1_UnitActionDesc", "type": "esriFieldTypeString", "alias": "Unit 1#UnitActionDesc", "length": 255, "domain": null }, { "name": "Unit_1_BodyStyleDesc", "type": "esriFieldTypeString", "alias": "Unit 1#BodyStyleDesc", "length": 255, "domain": null }, { "name": "Unit_2_UnitTypeDesc", "type": "esriFieldTypeString", "alias": "Unit 2#UnitTypeDesc", "length": 255, "domain": null }, { "name": "Unit_2_TravelDirectionDesc", "type": "esriFieldTypeString", "alias": "Unit 2#TravelDirectionDesc", "length": 255, "domain": null }, { "name": "Unit_2_LaneDesc", "type": "esriFieldTypeString", "alias": "Unit 2#LaneDesc", "length": 255, "domain": null }, { "name": "Unit_2_UnitActionDesc", "type": "esriFieldTypeString", "alias": "Unit 2#UnitActionDesc", "length": 255, "domain": null }, { "name": "Unit_2_BodyStyleDesc", "type": "esriFieldTypeString", "alias": "Unit 2#BodyStyleDesc", "length": 255, "domain": null }, { "name": "IncidentMonth", "type": "esriFieldTypeString", "alias": "IncidentMonth", "length": 255, "domain": null }, { "name": "IncidentDayofWeek", "type": "esriFieldTypeString", "alias": "IncidentDayofWeek", "length": 255, "domain": null }, { "name": "CollisionManner_Updated", "type": "esriFieldTypeString", "alias": "CollisionManner_Updated", "length": 255, "domain": null }, { "name": "Direction1_Direction2", "type": "esriFieldTypeString", "alias": "Direction1_Direction2", "length": 255, "domain": null }, { "name": "Direction_Relationship", "type": "esriFieldTypeString", "alias": "Direction Relationship", "length": 255, "domain": null }, { "name": "Manner_Action1_Relation", "type": "esriFieldTypeString", "alias": "Manner_Action1_Relation", "length": 255, "domain": null }, { "name": "Manner_Directions", "type": "esriFieldTypeString", "alias": "Manner_Directions", "length": 255, "domain": null }, { "name": "CrashDiagram", "type": "esriFieldTypeString", "alias": "CrashDiagram", "length": 255, "domain": null }, { "name": "CollisionManner_Updated2", "type": "esriFieldTypeString", "alias": "CollisionManner_Updated2", "length": 255, "domain": null }, { "name": "CollisionManner_Updated2__Summa", "type": "esriFieldTypeString", "alias": "CollisionManner_Updated2 (Summary)", "length": 255, "domain": null }, { "name": "CollisionManner_Updated2__Why_", "type": "esriFieldTypeString", "alias": "CollisionManner_Updated2 (Why)", "length": 255, "domain": null }, { "name": "GIS_Location__groups__2", "type": "esriFieldTypeString", "alias": "GIS#Location (groups) 2", "length": 255, "domain": null }, { "name": "CollisionManner_Updated2__slice", "type": "esriFieldTypeString", "alias": "CollisionManner_Updated2 (slicers)", "length": 255, "domain": null }, { "name": "CollisionManner_Updated2__meas_", "type": "esriFieldTypeString", "alias": "CollisionManner_Updated2 (meas)", "length": 255, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false, "supportsCurrentUserQueries": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "7548356bb8b84bdaba693227fd9e7ba8" }