Layer: Collision (ID:0)

View In: Map Viewer

Name: Collision

Display Field: accident_index

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"accident_severity","uniqueValueGroups":[{"heading":"","classes":[{"label":"Fatal","description":"Fatal","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,0,255],"size":5,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["1"]]},{"label":"Serious","description":"Serious","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,170,0,255],"size":5,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["2"]]},{"label":"Slight","description":"Slight","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[137,205,102,255],"size":5,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["3"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,0,255],"size":5,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"1","label":"Fatal"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,170,0,255],"size":5,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"2","label":"Serious"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[137,205,102,255],"size":5,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"3","label":"Slight"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,222,252,255],"toColor":[179,222,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,251,179,255],"toColor":[252,251,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,188,255],"toColor":[252,179,188,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[234,179,252,255],"toColor":[234,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,252,220,255],"toColor":[192,252,220,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,228,215,255],"toColor":[252,228,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[247,215,252,255],"toColor":[247,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,192,252,255],"toColor":[184,192,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,252,252,255],"toColor":[207,252,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[188,252,179,255],"toColor":[188,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[236,252,210,255],"toColor":[236,252,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,229,182,255],"toColor":[252,229,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,221,255],"toColor":[252,187,221,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field: accident_severity

Fields:

OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
accident_index (type: esriFieldTypeBigInteger, alias: Accident Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
accident_year (type: esriFieldTypeInteger, alias: Accident Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
accident_reference (type: esriFieldTypeInteger, alias: Accident Reference, SQL Type: sqlTypeOther, nullable: true, editable: true)
location_easting_osgr (type: esriFieldTypeInteger, alias: Easting (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
location_northing_osgr (type: esriFieldTypeInteger, alias: Northing (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
longitude (type: esriFieldTypeDouble, alias: Longitude (DD), SQL Type: sqlTypeOther, nullable: true, editable: true)
latitude (type: esriFieldTypeDouble, alias: Latitude (DD), SQL Type: sqlTypeOther, nullable: true, editable: true)
police_force (type: esriFieldTypeInteger, alias: Police Force, SQL Type: sqlTypeOther, nullable: true, editable: true)
accident_severity (type: esriFieldTypeInteger, alias: Accident Severity, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Fatal], [2: Serious], [3: Slight])
number_of_vehicles (type: esriFieldTypeInteger, alias: No. Vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
number_of_casualties (type: esriFieldTypeInteger, alias: No. Casualties, SQL Type: sqlTypeOther, nullable: true, editable: true)
date (type: esriFieldTypeDateOnly, alias: Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
day_of_week (type: esriFieldTypeInteger, alias: Day of Week, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Sunday], [2: Monday], [3: Tuesday], ... 4 more ...)
time (type: esriFieldTypeTimeOnly, alias: Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
local_authority_district (type: esriFieldTypeInteger, alias: Local Authority District, SQL Type: sqlTypeOther, nullable: true, editable: true)
local_authority_ons_district (type: esriFieldTypeString, alias: Local Authority District (ONS), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true, Coded Values: [S12000005: Clackmannanshire Council], [S12000006: Dumfries and Galloway Council], [S12000008: East Ayrshire Council], ... 29 more ...)
local_authority_highway (type: esriFieldTypeString, alias: Local Authority (Highway), SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
first_road_class (type: esriFieldTypeInteger, alias: First Road Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Motorway], [2: A(M)], [3: A], ... 4 more ...)
first_road_number (type: esriFieldTypeInteger, alias: First Road Number, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [0: C or Unclassified])
road_type (type: esriFieldTypeInteger, alias: Road Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Roundabout], [2: One way street], [3: Dual carriageway], ... 5 more ...)
speed_limit (type: esriFieldTypeInteger, alias: Speed Limit, SQL Type: sqlTypeOther, nullable: true, editable: true)
junction_detail (type: esriFieldTypeInteger, alias: Junction Detail, SQL Type: sqlTypeOther, nullable: true, editable: true)
junction_control (type: esriFieldTypeInteger, alias: Junction Control, SQL Type: sqlTypeOther, nullable: true, editable: true)
second_road_class (type: esriFieldTypeInteger, alias: Second Road Class, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not at junction or within 20 metres], [1: Motorway], [2: A(M)], ... 6 more ...)
second_road_number (type: esriFieldTypeInteger, alias: Second Road Number, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [0: C or Unclassified])
pedestrian_crossing_human_contr (type: esriFieldTypeInteger, alias: Pedestrian Crossing Human Control, SQL Type: sqlTypeOther, nullable: true, editable: true)
pedestrian_crossing_physical_fa (type: esriFieldTypeInteger, alias: Pedestrian Crossing Physical Facilities, SQL Type: sqlTypeOther, nullable: true, editable: true)
light_conditions (type: esriFieldTypeInteger, alias: Light Conditions, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Daylight], [4: Darkness - lights lit], [5: Darkness - lights unlit], ... 3 more ...)
weather_conditions (type: esriFieldTypeInteger, alias: Weather Conditions, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Fine no high winds], [2: Raining no high winds], [3: Snowing no high winds], ... 7 more ...)
road_surface_conditions (type: esriFieldTypeInteger, alias: Road Surface Conditions, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Dry], [2: Wet or damp], [3: Snow], ... 6 more ...)
special_conditions_at_site (type: esriFieldTypeInteger, alias: Special Conditions At Site, SQL Type: sqlTypeOther, nullable: true, editable: true)
carriageway_hazards (type: esriFieldTypeInteger, alias: Carriageway Hazards, SQL Type: sqlTypeOther, nullable: true, editable: true)
urban_or_rural_area (type: esriFieldTypeInteger, alias: Urban or Rural Area, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Urban], [2: Rural], [3: Unallocated], ... 1 more ...)
did_police_officer_attend_scene (type: esriFieldTypeInteger, alias: Did Police Officer Attend the Scene?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: No - accident was reported using a self completion], ... 1 more ...)
trunk_road_flag (type: esriFieldTypeInteger, alias: Trunk Road Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Trunk (Roads managed by Highways England)], [2: Non-trunk], [-1: Data missing or out of range])
lsoa_of_accident_location (type: esriFieldTypeString, alias: LSOA of Accident Location, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
AccidentDate (type: esriFieldTypeDate, alias: Accident Date, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)

Types:

Field Name: accident_severity
Inherited
Field Name: day_of_week
Inherited
Field Name: local_authority_ons_district
Inherited
Field Name: first_road_class
Inherited
Field Name: road_type
Inherited
Field Name: second_road_class
Inherited
Field Name: light_conditions
Inherited
Field Name: weather_conditions
Inherited
Field Name: road_surface_conditions
Inherited
Field Name: urban_or_rural_area
Inherited
Field Name: did_police_officer_attend_scene_of_accident
Inherited

accident_severity: 1

Field Name: accident_severity
Inherited
Field Name: day_of_week
Inherited
Field Name: local_authority_ons_district
Inherited
Field Name: first_road_class
Inherited
Field Name: road_type
Inherited
Field Name: second_road_class
Inherited
Field Name: light_conditions
Inherited
Field Name: weather_conditions
Inherited
Field Name: road_surface_conditions
Inherited
Field Name: urban_or_rural_area
Inherited
Field Name: did_police_officer_attend_scene_of_accident
Inherited

accident_severity: 2

Field Name: accident_severity
Inherited
Field Name: day_of_week
Inherited
Field Name: local_authority_ons_district
Inherited
Field Name: first_road_class
Inherited
Field Name: road_type
Inherited
Field Name: second_road_class
Inherited
Field Name: light_conditions
Inherited
Field Name: weather_conditions
Inherited
Field Name: road_surface_conditions
Inherited
Field Name: urban_or_rural_area
Inherited
Field Name: did_police_officer_attend_scene_of_accident
Inherited

accident_severity: 3

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/9/2024 2:07:04 PM

Schema Last Edit Date: 7/9/2024 2:07:04 PM

Data Last Edit Date: 7/9/2024 2:03:54 PM

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