Name: Crashes_2018_22_from_Jake_20240314

Display Field: RouteName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 7548356bb8b84bdaba693227fd9e7ba8

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID )
• IncidentDate ( type: esriFieldTypeDate, alias: IncidentDate, length: 8 )
• IncidentDateTime ( type: esriFieldTypeDate, alias: IncidentDateTime, length: 8 )
• IncidentYear ( type: esriFieldTypeDouble, alias: IncidentYear )
• IncidentHour ( type: esriFieldTypeDouble, alias: IncidentHour )
• OfficerNcic ( type: esriFieldTypeDouble, alias: OfficerNcic )
• OfficerId ( type: esriFieldTypeString, alias: OfficerId, length: 255 )
• FileNumber ( type: esriFieldTypeDouble, alias: FileNumber )
• ExtendedNcic ( type: esriFieldTypeDouble, alias: ExtendedNcic )
• CollisionManner ( type: esriFieldTypeDouble, alias: CollisionManner )
• LightCondition ( type: esriFieldTypeDouble, alias: LightCondition )
• FirstHarmfulEvent ( type: esriFieldTypeDouble, alias: FirstHarmfulEvent )
• FirstHarmfulLocation ( type: esriFieldTypeString, alias: FirstHarmfulLocation, length: 255 )
• TotalUnits ( type: esriFieldTypeDouble, alias: TotalUnits )
• TotalMotorists ( type: esriFieldTypeDouble, alias: TotalMotorists )
• TotalNonMotorists ( type: esriFieldTypeDouble, alias: TotalNonMotorists )
• TotalInjuries ( type: esriFieldTypeDouble, alias: TotalInjuries )
• TotalFatalities ( type: esriFieldTypeDouble, alias: TotalFatalities )
• TotalMotoristsInjuries ( type: esriFieldTypeDouble, alias: TotalMotoristsInjuries )
• TotalNonMotoristsInjuries ( type: esriFieldTypeDouble, alias: TotalNonMotoristsInjuries )
• TotalMotoristsFatalities ( type: esriFieldTypeDouble, alias: TotalMotoristsFatalities )
• TotalNonMotoristsFatalities ( type: esriFieldTypeDouble, alias: TotalNonMotoristsFatalities )
• InjurySeverity ( type: esriFieldTypeDouble, alias: InjurySeverity )
• MedicalTransportFlag ( type: esriFieldTypeString, alias: MedicalTransportFlag, length: 255 )
• FatalAccidentFlag ( type: esriFieldTypeDouble, alias: FatalAccidentFlag )
• TowAwayFlag ( type: esriFieldTypeDouble, alias: TowAwayFlag )
• NscReportable ( type: esriFieldTypeString, alias: NscReportable, length: 255 )
• SchoolBusRelatedFlag ( type: esriFieldTypeSmallInteger, alias: SchoolBusRelatedFlag )
• WorkZoneRelatedFlag ( type: esriFieldTypeSmallInteger, alias: WorkZoneRelatedFlag )
• WorkersPresentFlag ( type: esriFieldTypeDouble, alias: WorkersPresentFlag )
• AlcoholInvolvementFlag ( type: esriFieldTypeDouble, alias: AlcoholInvolvementFlag )
• DrugInvolvementFlag ( type: esriFieldTypeDouble, alias: DrugInvolvementFlag )
• HazardousFlag ( type: esriFieldTypeString, alias: HazardousFlag, length: 255 )
• HitAndRunFlag ( type: esriFieldTypeSmallInteger, alias: HitAndRunFlag )
• CrossingFeature ( type: esriFieldTypeString, alias: CrossingFeature, length: 255 )
• Offset_ ( type: esriFieldTypeDouble, alias: Offset )
• OffsetMeasuredFlag ( type: esriFieldTypeDouble, alias: OffsetMeasuredFlag )
• OffsetUnit ( type: esriFieldTypeDouble, alias: OffsetUnit )
• MPNum ( type: esriFieldTypeDouble, alias: MPNum )
• MPOffset ( type: esriFieldTypeDouble, alias: MPOffset )
• CityId ( type: esriFieldTypeDouble, alias: CityId )
• CountyId ( type: esriFieldTypeDouble, alias: CountyId )
• StateId ( type: esriFieldTypeDouble, alias: StateId )
• StateCode ( type: esriFieldTypeString, alias: StateCode, length: 255 )
• CountryCode ( type: esriFieldTypeString, alias: CountryCode, length: 255 )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• ValidLocationFlag ( type: esriFieldTypeDouble, alias: ValidLocationFlag )
• LocationToolVersion ( type: esriFieldTypeString, alias: LocationToolVersion, length: 255 )
• HESIntersectionFlag ( type: esriFieldTypeString, alias: HESIntersectionFlag, length: 255 )
• IntersectionFlag ( type: esriFieldTypeDouble, alias: IntersectionFlag )
• IntersectionRouteID ( type: esriFieldTypeString, alias: IntersectionRouteID, length: 255 )
• IntersectionATISCode ( type: esriFieldTypeString, alias: IntersectionATISCode, length: 255 )
• TrafficWayType ( type: esriFieldTypeDouble, alias: TrafficWayType )
• IntersectionType ( type: esriFieldTypeDouble, alias: IntersectionType )
• JunctionRelation ( type: esriFieldTypeDouble, alias: JunctionRelation )
• Weather ( type: esriFieldTypeDouble, alias: Weather )
• PropertyDamageOwnerCode ( type: esriFieldTypeString, alias: PropertyDamageOwnerCode, length: 255 )
• DayofWeekSortOrder ( type: esriFieldTypeDouble, alias: DayofWeekSortOrder )
• MonthSortOrder ( type: esriFieldTypeDouble, alias: MonthSortOrder )
• IncidentID ( type: esriFieldTypeDouble, alias: IncidentID )
• RouteName ( type: esriFieldTypeString, alias: RouteName, length: 255 )
• CrossingFeatureName ( type: esriFieldTypeString, alias: CrossingFeatureName, length: 255 )
• PropertyDamageDescCode ( type: esriFieldTypeString, alias: PropertyDamageDescCode, length: 255 )
• OffsetDirection ( type: esriFieldTypeDouble, alias: OffsetDirection )
• SecondaryCrashFlag ( type: esriFieldTypeDouble, alias: SecondaryCrashFlag )
• GeocodeOffsetInMiles ( type: esriFieldTypeDouble, alias: GeocodeOffsetInMiles )
• X ( type: esriFieldTypeDouble, alias: X )
• Y ( type: esriFieldTypeDouble, alias: Y )
• GeocodeOnRoadRouteId ( type: esriFieldTypeString, alias: GeocodeOnRoadRouteId, length: 255 )
• FirstHarmfulEvent_TEXT ( type: esriFieldTypeString, alias: FirstHarmfulEvent_TEXT, length: 255 )
• CollisionManner_TEXT ( type: esriFieldTypeString, alias: CollisionManner_TEXT, length: 255 )
• JunctionRelation_TEXT ( type: esriFieldTypeDouble, alias: JunctionRelation_TEXT )
• TrafficWayType_TEXT ( type: esriFieldTypeString, alias: TrafficWayType_TEXT, length: 255 )
• TrafficWayType_TEXT__groups_ ( type: esriFieldTypeString, alias: TrafficWayType_TEXT (groups), length: 255 )
• InjurySeverity_TEXT ( type: esriFieldTypeString, alias: InjurySeverity_TEXT, length: 255 )
• IntersectionType_TEXT ( type: esriFieldTypeString, alias: IntersectionType_TEXT, length: 255 )
• Weather_TEXT ( type: esriFieldTypeString, alias: Weather_TEXT, length: 255 )
• LightCondition_TEXT ( type: esriFieldTypeString, alias: LightCondition_TEXT, length: 255 )
• FLAG_Pedestrian ( type: esriFieldTypeDouble, alias: FLAG_Pedestrian )
• FLAG_Bike ( type: esriFieldTypeDouble, alias: FLAG_Bike )
• FLAG_Motorcyclist ( type: esriFieldTypeDouble, alias: FLAG_Motorcyclist )
• FLAG_Bus ( type: esriFieldTypeDouble, alias: FLAG_Bus )
• FLAG_Ped_OR_Bike ( type: esriFieldTypeDouble, alias: FLAG_Ped_OR_Bike )
• FLAG_Speeding_Unit ( type: esriFieldTypeDouble, alias: FLAG_Speeding_Unit )
• FLAG_Speeding_Person ( type: esriFieldTypeDouble, alias: FLAG_Speeding_Person )
• FLAG_Impair_DriverUnit1 ( type: esriFieldTypeDouble, alias: FLAG_Impair_DriverUnit1 )
• FLAG_Speeding ( type: esriFieldTypeString, alias: FLAG_Speeding, length: 255 )
• Offset_150ft ( type: esriFieldTypeString, alias: Offset<150ft, length: 255 )
• FLAG_Unrestrained_Driver ( type: esriFieldTypeDouble, alias: FLAG_Unrestrained_Driver )
• FLAG_Impair_DriverUnit1__groups ( type: esriFieldTypeString, alias: FLAG_Impair_DriverUnit1 (groups), length: 255 )
• FLAG_Unrestrained_Driver__group ( type: esriFieldTypeString, alias: FLAG_Unrestrained_Driver (groups), length: 255 )
• Onroad_CrossingFeature ( type: esriFieldTypeString, alias: Onroad+CrossingFeature, length: 255 )
• IDcount ( type: esriFieldTypeDouble, alias: IDcount )
• GeocodeOnRoad ( type: esriFieldTypeString, alias: GeocodeOnRoad, length: 255 )
• GeocodeCrossingFeatureName ( type: esriFieldTypeString, alias: GeocodeCrossingFeatureName, length: 255 )
• InjurySeverity_TEXT__groups_ ( type: esriFieldTypeString, alias: InjurySeverity_TEXT (groups), length: 255 )
• LightCondition_GRP ( type: esriFieldTypeString, alias: LightCondition_GRP, length: 255 )
• GIS_Intersection_Name ( type: esriFieldTypeString, alias: GIS#Intersection_Name, length: 255 )
• GIS_Intersection_Equipment ( type: esriFieldTypeString, alias: GIS#Intersection_Equipment, length: 255 )
• GIS_Intersection_ADOT_ROW ( type: esriFieldTypeString, alias: GIS#Intersection_ADOT ROW, length: 255 )
• GIS_HIN_IntName ( type: esriFieldTypeString, alias: GIS#HIN_IntName, length: 255 )
• GIS_HIN_Seg_Name ( type: esriFieldTypeString, alias: GIS#HIN_Seg_Name, length: 255 )
• GIS_Council_DISTRICT ( type: esriFieldTypeDouble, alias: GIS#Council_DISTRICT )
• GIS_Location ( type: esriFieldTypeString, alias: GIS#Location, length: 255 )
• GIS_FLAG_ADOT_ROW ( type: esriFieldTypeString, alias: GIS#FLAG_ADOT ROW, length: 255 )
• GIS_FLAG_Out_Phoenix ( type: esriFieldTypeString, alias: GIS#FLAG_Out Phoenix, length: 255 )
• GIS_Location__groups_ ( type: esriFieldTypeString, alias: GIS#Location (groups), length: 255 )
• GIS_HIN_IntName__groups_ ( type: esriFieldTypeString, alias: GIS#HIN_IntName (groups), length: 255 )
• GIS_HIN_Seg_Name__groups_ ( type: esriFieldTypeString, alias: GIS#HIN_Seg_Name (groups), length: 255 )
• Crash_type ( type: esriFieldTypeString, alias: Crash_type, length: 255 )
• Crash_type__groups_ ( type: esriFieldTypeString, alias: Crash_type (groups), length: 255 )
• Count_blanks ( type: esriFieldTypeDouble, alias: Count blanks )
• GIS_FLAG_Arterial ( type: esriFieldTypeString, alias: GIS#FLAG_Arterial, length: 255 )
• Unit_1_UnitTypeDesc ( type: esriFieldTypeString, alias: Unit 1#UnitTypeDesc, length: 255 )
• Unit_1_TravelDirectionDesc ( type: esriFieldTypeString, alias: Unit 1#TravelDirectionDesc, length: 255 )
• Unit_1_LaneDesc ( type: esriFieldTypeString, alias: Unit 1#LaneDesc, length: 255 )
• Unit_1_UnitActionDesc ( type: esriFieldTypeString, alias: Unit 1#UnitActionDesc, length: 255 )
• Unit_1_BodyStyleDesc ( type: esriFieldTypeString, alias: Unit 1#BodyStyleDesc, length: 255 )
• Unit_2_UnitTypeDesc ( type: esriFieldTypeString, alias: Unit 2#UnitTypeDesc, length: 255 )
• Unit_2_TravelDirectionDesc ( type: esriFieldTypeString, alias: Unit 2#TravelDirectionDesc, length: 255 )
• Unit_2_LaneDesc ( type: esriFieldTypeString, alias: Unit 2#LaneDesc, length: 255 )
• Unit_2_UnitActionDesc ( type: esriFieldTypeString, alias: Unit 2#UnitActionDesc, length: 255 )
• Unit_2_BodyStyleDesc ( type: esriFieldTypeString, alias: Unit 2#BodyStyleDesc, length: 255 )
• IncidentMonth ( type: esriFieldTypeString, alias: IncidentMonth, length: 255 )
• IncidentDayofWeek ( type: esriFieldTypeString, alias: IncidentDayofWeek, length: 255 )
• CollisionManner_Updated ( type: esriFieldTypeString, alias: CollisionManner_Updated, length: 255 )
• Direction1_Direction2 ( type: esriFieldTypeString, alias: Direction1_Direction2, length: 255 )
• Direction_Relationship ( type: esriFieldTypeString, alias: Direction Relationship, length: 255 )
• Manner_Action1_Relation ( type: esriFieldTypeString, alias: Manner_Action1_Relation, length: 255 )
• Manner_Directions ( type: esriFieldTypeString, alias: Manner_Directions, length: 255 )
• CrashDiagram ( type: esriFieldTypeString, alias: CrashDiagram, length: 255 )
• CollisionManner_Updated2 ( type: esriFieldTypeString, alias: CollisionManner_Updated2, length: 255 )
• CollisionManner_Updated2__Summa ( type: esriFieldTypeString, alias: CollisionManner_Updated2 (Summary), length: 255 )
• CollisionManner_Updated2__Why_ ( type: esriFieldTypeString, alias: CollisionManner_Updated2 (Why), length: 255 )
• GIS_Location__groups__2 ( type: esriFieldTypeString, alias: GIS#Location (groups) 2, length: 255 )
• CollisionManner_Updated2__slice ( type: esriFieldTypeString, alias: CollisionManner_Updated2 (slicers), length: 255 )
• CollisionManner_Updated2__meas_ ( type: esriFieldTypeString, alias: CollisionManner_Updated2 (meas), length: 255 )

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

  Iteminfo   Thumbnail   Metadata