Name: LocationStateRoute

Display Field: City_Name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: b2464ad8a74b473eb3b05bc9b80be1b6

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 )
• Report_Number ( type: esriFieldTypeString, alias: Report Number, length: 255 )
• Record_Type ( type: esriFieldTypeString, alias: Record Type, length: 255 )
• State_Route_Number ( type: esriFieldTypeString, alias: State Route Number, length: 255 )
• RRT_Code ( type: esriFieldTypeString, alias: RRT Code, length: 255 )
• RRQ ( type: esriFieldTypeString, alias: RRQ, length: 255 )
• ARM ( type: esriFieldTypeString, alias: ARM, length: 255 )
• Milepost ( type: esriFieldTypeString, alias: Milepost, length: 255 )
• Milepost_AB_Indicator ( type: esriFieldTypeString, alias: Milepost AB Indicator, length: 255 )
• Additional_Information ( type: esriFieldTypeString, alias: Additional Information, length: 255 )
• Vehicle_1_Compass_Direction ( type: esriFieldTypeString, alias: Vehicle 1 Compass Direction, length: 255 , Coded Values: [0: Unknown or Not Applicable] , [1: N] , [2: NE] , ...6 more... )
• Vehicle_1_Movement_Direction ( type: esriFieldTypeString, alias: Vehicle 1 Movement Direction, length: 255 , Coded Values: [0: Unknown or Not Applicable] , [A: Moving Straight] , [B: Turning Right] , ...18 more... )
• Vehicle_1_Milepost_Direction ( type: esriFieldTypeString, alias: Vehicle 1 Milepost Direction, length: 255 , Coded Values: [0: Unknown or Not Applicable] , [A: Increasing milepost of major roadway] , [B: Decreasing milepost of major roadway] , ...5 more... )
• Diagram_Collision_Type ( type: esriFieldTypeString, alias: Diagram Collision Type, length: 255 )
• Vehicle_2_Compass_Direction ( type: esriFieldTypeString, alias: Vehicle 2 Compass Direction, length: 255 , Coded Values: [0: Unknown or Not Applicable] , [1: N] , [2: NE] , ...6 more... )
• Vehicle_2_Movement_Direction ( type: esriFieldTypeString, alias: Vehicle 2 Movement Direction, length: 255 , Coded Values: [0: Unknown or Not Applicable] , [A: Moving Straight] , [B: Turning Right] , ...18 more... )
• Vehicle_2_Milepost_Direction ( type: esriFieldTypeString, alias: Vehicle 2 Milepost Direction, length: 255 , Coded Values: [0: Unknown or Not Applicable] , [A: Increasing milepost of major roadway] , [B: Decreasing milepost of major roadway] , ...5 more... )
• Impact_Location_Type ( type: esriFieldTypeString, alias: Impact Location Type, length: 255 , Coded Values: [A0: Past Right Shoulder Increasing Milepost] , [A1: Lane 1 Increasing Milepost] , [A2: Lane 2 Increasing Milepost] , ...156 more... )
• City_Name ( type: esriFieldTypeString, alias: City Name, length: 255 , Coded Values: [5: Aberdeen] , [10: Airway Heights] , [15: Albion] , ...278 more... )
• County_Name ( type: esriFieldTypeString, alias: County Name, length: 255 , Coded Values: [1: Adams] , [2: Asotin] , [3: Benton] , ...36 more... )
• Crossroad_Class_Type ( type: esriFieldTypeString, alias: Crossroad Class Type, length: 255 )
• Region_Number ( type: esriFieldTypeString, alias: Region Number, length: 255 )
• Ramp_Location_Type ( type: esriFieldTypeString, alias: Ramp Location Type, length: 255 )
• Pass_As_OK ( type: esriFieldTypeString, alias: Pass As OK, length: 8000 )
• ID ( type: esriFieldTypeString, alias: ID, length: 255 )

Relationships:

• Collisions (1) -- Related To: Collisions (15)
• Collisions (11) -- Related To: Collisions This Year (16)
• Collisions (21) -- Related To: Collisions Last Year (17)
• Collisions (31) -- Related To: Collisions Last 3 Years (18)
• Collisions (41) -- Related To: Collisions Dashboard Layer (41)
• Collisions (51) -- Related To: Collisions- Fatality (42)
• Collisions (61) -- Related To: Collisions- Ped/Bicycle (43)

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

  Iteminfo   Thumbnail   Metadata