Name: Collisions 2015_2022

Display Field: geo_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8887651.0744
YMin: 5385927.5628
XMax: -8850984.5492
YMax: 5431513.9841
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"collision_type","uniqueValueInfos":[{"value":"PDO","symbol":{"color":[32,122,212,255],"size":3,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Property Damage Only"},{"value":"Injury","symbol":{"color":[252,225,56,255],"size":3,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,106],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Non-Fatal Injury"},{"value":"Fatal","symbol":{"color":[255,0,0,255],"size":3,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[255,255,255,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Fatal Injury"}]},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: collision_type

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• accident_no_ (type: esriFieldTypeString, alias: Accident No., SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• accident_date (type: esriFieldTypeDate, alias: Accident Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• accident_year (type: esriFieldTypeInteger, alias: Accident Year, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2015: 2015], [2016: 2016], [2017: 2017], ... 5 more ...)
• location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• accident_time (type: esriFieldTypeString, alias: Accident Time, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• geo_id (type: esriFieldTypeInteger, alias: Geo ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• impact_location (type: esriFieldTypeString, alias: Impact Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• collision_type (type: esriFieldTypeString, alias: Collision Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• int_traffic_control (type: esriFieldTypeString, alias: Int Traffic Control, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [1: All-way Stop], [2: Traffic Signal], [3: Two-way Stop], ... 1 more ...)
• environment_condition_1 (type: esriFieldTypeString, alias: Environment Condition 1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• light (type: esriFieldTypeString, alias: Light, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• classification_of_accident (type: esriFieldTypeString, alias: Classification Of Accident, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• initial_impact_type (type: esriFieldTypeString, alias: Initial Impact Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• vehicle_1_type (type: esriFieldTypeString, alias: Vehicle 1 Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• vehicle_1_manoeuver (type: esriFieldTypeString, alias: Vehicle 1 Manoeuver, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• vehicle_2_type (type: esriFieldTypeString, alias: Vehicle 2 Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• vehicle_2_manoeuver (type: esriFieldTypeString, alias: Vehicle 2 Manoeuver, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• accident_location (type: esriFieldTypeString, alias: Accident Location, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pedestrian_1_action (type: esriFieldTypeString, alias: Pedestrian 1 Action, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pedestrian_1_condition (type: esriFieldTypeString, alias: Pedestrian 1 Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pedestrian_2_action (type: esriFieldTypeString, alias: Pedestrian 2 Action, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pedestrian_2_condition (type: esriFieldTypeString, alias: Pedestrian 2 Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• driver_1_sex (type: esriFieldTypeString, alias: Driver 1 Sex, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [1: Female], [2: Male], [3: Other])
• driver_1_age (type: esriFieldTypeInteger, alias: Driver 1 Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• driver_2_sex (type: esriFieldTypeString, alias: Driver 2 Sex, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [1: Female], [2: Male], [3: Other])
• driver_2_age (type: esriFieldTypeInteger, alias: Driver 2 Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• apparent_driver_1_action (type: esriFieldTypeString, alias: Apparent Driver 1 Action, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• apparent_driver_2_action (type: esriFieldTypeString, alias: Apparent Driver 2 Action, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• initial_direction_of_travel_one (type: esriFieldTypeString, alias: Initial Direction Of Travel One, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• initial_direction_of_travel_two (type: esriFieldTypeString, alias: Initial Direction Of Travel Two, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• road_1_surface_condition (type: esriFieldTypeString, alias: Road 1 Surface Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• road_2_surface_condition (type: esriFieldTypeString, alias: Road 2 Surface Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• driver_1_condition (type: esriFieldTypeString, alias: Driver 1 Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• driver_2_condition (type: esriFieldTypeString, alias: Driver 2 Condition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• vehicle_1_first_event (type: esriFieldTypeString, alias: Vehicle 1 First Event, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• vehicle_1_second_event (type: esriFieldTypeString, alias: Vehicle 1 Second Event, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• vehicle_1_third_event (type: esriFieldTypeString, alias: Vehicle 1 Third Event, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• vehicle_2_first_event (type: esriFieldTypeString, alias: Vehicle 2 First Event, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• vehicle_2_second_event (type: esriFieldTypeString, alias: Vehicle 2 Second Event, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• vehicle_2_third_event (type: esriFieldTypeString, alias: Vehicle 2 Third Event, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• community_safety_zone (type: esriFieldTypeString, alias: COMMUNITY SAFETY ZONE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• road_name (type: esriFieldTypeString, alias: ROAD NAME, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• speed_limit (type: esriFieldTypeSmallInteger, alias: SPEED_LIMIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• municipality (type: esriFieldTypeString, alias: MUNICIPALITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ward (type: esriFieldTypeString, alias: WARD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• z_area (type: esriFieldTypeString, alias: Z_AREA, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• road_class (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 1500, nullable: true, editable: true)
• Involves_Pedestrian (type: esriFieldTypeString, alias: Involves_Pedestrian, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Involves_Cyclist (type: esriFieldTypeString, alias: Involves_Cyclist, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CurrentVsTotal (type: esriFieldTypeString, alias: CurrentVsTotal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Types:

ID: PDO
Name: PDO
Domains:

Templates:

Name: PDO
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• collision_type: PDO

---

ID: Injury
Name: Injury
Domains:

Templates:

Name: Injury
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• collision_type: Injury

---

ID: Fatal
Name: Fatal
Domains:

Templates:

Name: Fatal
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• collision_type: Fatal

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/31/2023 1:28:05 PM

Schema Last Edit Date: 7/31/2023 1:28:05 PM

Data Last Edit Date: 7/24/2023 6:32:39 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat