Layer: CrashPoints_2018_22

View In: Map Viewer

Name: CrashPoints_2018_22_KSI

Display Field: Department_Name

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:

Drawing Info:

{"renderer":{"type":"heatmap","field":"","legendOptions":{"minLabel":"Sparse","maxLabel":"Dense"},"colorStops":[{"ratio":0,"color":[133,193,200,0]},{"ratio":0.01,"color":[133,193,200,0]},{"ratio":0.01,"color":[133,193,200,0]},{"ratio":0.01,"color":[133,193,200,0]},{"ratio":0.07692308,"color":[133,193,200,255]},{"ratio":0.15384615,"color":[144,161,190,255]},{"ratio":0.23076923,"color":[156,129,132,255]},{"ratio":0.30769231,"color":[167,97,170,255]},{"ratio":0.38461538,"color":[175,73,128,255]},{"ratio":0.46153846,"color":[184,48,85,255]},{"ratio":0.53846154,"color":[192,24,42,255]},{"ratio":0.61538462,"color":[200,0,0,255]},{"ratio":0.69230769,"color":[211,51,0,255]},{"ratio":0.76923077,"color":[222,102,0,255]},{"ratio":0.84615385,"color":[233,153,0,255]},{"ratio":0.92307692,"color":[244,204,0,255]},{"ratio":1.0,"color":[255,255,0,255]}],"radius":10,"minDensity":0,"maxDensity":0.014813139039851543},"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:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Crash_Identifier (type: esriFieldTypeString, alias: Crash Identifier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Year (type: esriFieldTypeDouble, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Case_Number (type: esriFieldTypeString, alias: Case Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Document_Locator_Number (type: esriFieldTypeDouble, alias: Document Locator Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
Department_Type (type: esriFieldTypeString, alias: Department Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Department_Name (type: esriFieldTypeString, alias: Department Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Police_Station_Name (type: esriFieldTypeString, alias: Police Station Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Occurrence_Date (type: esriFieldTypeDouble, alias: Occurrence Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
Day_of_the_Week (type: esriFieldTypeString, alias: Day of the Week, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Occurrence_Time (type: esriFieldTypeDouble, alias: Occurrence Time, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Killed (type: esriFieldTypeDouble, alias: Total Killed, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Injured (type: esriFieldTypeDouble, alias: Total Injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
Pedestrians_Killed (type: esriFieldTypeDouble, alias: Pedestrians Killed, SQL Type: sqlTypeOther, nullable: true, editable: true)
Pedestrians_Injured (type: esriFieldTypeDouble, alias: Pedestrians Injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
Severity (type: esriFieldTypeString, alias: Severity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Severity_Rating_Code (type: esriFieldTypeString, alias: Severity Rating Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Cross_Street_Intersection (type: esriFieldTypeString, alias: Cross Street Intersection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Alcohol_Involved (type: esriFieldTypeString, alias: Alcohol Involved, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Hazardous_Material_Involved (type: esriFieldTypeString, alias: Hazardous Material Involved, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Fixed_Object (type: esriFieldTypeString, alias: Fixed Object, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Crash_Type (type: esriFieldTypeString, alias: Crash Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Number_of_Vehicles_Involved (type: esriFieldTypeDouble, alias: Number of Vehicles Involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Location_Direction (type: esriFieldTypeString, alias: Location Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Route_Number (type: esriFieldTypeDouble, alias: Route Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
Route_Suffix (type: esriFieldTypeString, alias: Route Suffix, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Standard_Route_Identifier (type: esriFieldTypeString, alias: Standard Route Identifier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Milepost_Number (type: esriFieldTypeDouble, alias: Milepost Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
Road_System (type: esriFieldTypeString, alias: Road System, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Road_Characteristic (type: esriFieldTypeString, alias: Road Characteristic, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Road_Horizontal_Alignment (type: esriFieldTypeString, alias: Road Horizontal Alignment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Road_Grade (type: esriFieldTypeString, alias: Road Grade, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Road_Surface_Type (type: esriFieldTypeString, alias: Road Surface Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Road_Condition (type: esriFieldTypeString, alias: Road Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Light_Condition (type: esriFieldTypeString, alias: Light Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Environmental_Condition (type: esriFieldTypeString, alias: Environmental Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Road_Median_Type (type: esriFieldTypeString, alias: Road Median Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Temporary_Traffic_Control (type: esriFieldTypeString, alias: Temporary Traffic Control, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Distance_to_Cross_Street (type: esriFieldTypeDouble, alias: Distance to Cross Street, SQL Type: sqlTypeOther, nullable: true, editable: true)
Distance_to_Cross_Street_Unit (type: esriFieldTypeString, alias: Distance to Cross Street Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Cross_Street_Direction (type: esriFieldTypeString, alias: Cross Street Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Cross_Street_Name (type: esriFieldTypeString, alias: Cross Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Is_Ramp (type: esriFieldTypeString, alias: Is Ramp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Ramp_Route_Name (type: esriFieldTypeString, alias: Ramp Route Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Ramp_Direction (type: esriFieldTypeString, alias: Ramp Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Posted_Speed_Limit (type: esriFieldTypeDouble, alias: Posted Speed Limit, SQL Type: sqlTypeOther, nullable: true, editable: true)
Cross_Street_Posted_Speed_Limit (type: esriFieldTypeDouble, alias: Cross Street Posted Speed Limit, SQL Type: sqlTypeOther, nullable: true, editable: true)
First_Harmful_Event (type: esriFieldTypeString, alias: First Harmful Event, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Property_Damage (type: esriFieldTypeString, alias: Property Damage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Reporting_Badge_Number (type: esriFieldTypeDouble, alias: Reporting Badge Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
Reviewing_Badge_Number (type: esriFieldTypeString, alias: Reviewing Badge Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Cell_Phone (type: esriFieldTypeString, alias: Cell Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Update_Date (type: esriFieldTypeDouble, alias: Update Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
Cyclist_Involved (type: esriFieldTypeString, alias: Cyclist Involved, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Lane_Quantity (type: esriFieldTypeDouble, alias: Lane Quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
Mercator_X (type: esriFieldTypeDouble, alias: Mercator X, SQL Type: sqlTypeOther, nullable: true, editable: true)
Mercator_Y (type: esriFieldTypeDouble, alias: Mercator Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
Occupant_Physical_Condition__Ki (type: esriFieldTypeString, alias: Occupant Physical Condition: Killed (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Occupant_Physical_Condition__In (type: esriFieldTypeString, alias: Occupant Physical Condition: Incapacitated (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Occupant_Physical_Condition__Mo (type: esriFieldTypeDouble, alias: Occupant Physical Condition: Moderate Injury (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
Occupant_Physical_Condition__Pa (type: esriFieldTypeDouble, alias: Occupant Physical Condition: Pain Complaint (Count), SQL Type: sqlTypeOther, nullable: true, editable: true)
Occupant_Physical_Condition__Un (type: esriFieldTypeString, alias: Occupant Physical Condition: Unknown (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Occupant_Physical_Condition__No (type: esriFieldTypeString, alias: Occupant Physical Condition: Not Recorded (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Pedestrian_Physical_Condition__ (type: esriFieldTypeString, alias: Pedestrian Physical Condition: Killed (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Pedestrian_Physical_Condition_1 (type: esriFieldTypeString, alias: Pedestrian Physical Condition: Incapacitated (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Pedestrian_Physical_Condition_2 (type: esriFieldTypeString, alias: Pedestrian Physical Condition: Moderate Injury (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Pedestrian_Physical_Condition_3 (type: esriFieldTypeString, alias: Pedestrian Physical Condition: Pain Complaint (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Pedestrian_Physical_Condition_4 (type: esriFieldTypeString, alias: Pedestrian Physical Condition: Unknown (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Functional_Class (type: esriFieldTypeString, alias: Functional Class, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Hit_and_Run_Accident (type: esriFieldTypeString, alias: Hit and Run Accident, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Pedestrian_Involved (type: esriFieldTypeString, alias: Pedestrian Involved, SQL Type: sqlTypeOther, length: 255, 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)
Cyclist_Physical_Condition__Kil (type: esriFieldTypeString, alias: Cyclist Physical Condition: Killed (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Cyclist_Physical_Condition__Inc (type: esriFieldTypeString, alias: Cyclist Physical Condition: Incapacitated (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Cyclist_Physical_Condition__Com (type: esriFieldTypeString, alias: Cyclist Physical Condition: Complaint of Pain (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Cyclist_Physical_Condition__Mod (type: esriFieldTypeString, alias: Cyclist Physical Condition: Moderate Pain (Count), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Vehicle_1_Travel_Direction (type: esriFieldTypeString, alias: Vehicle 1 Travel Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Vehicle_2_Travel_Direction (type: esriFieldTypeString, alias: Vehicle 2 Travel Direction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
muni_name (type: esriFieldTypeString, alias: muni_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Sum_KSI (type: esriFieldTypeSmallInteger, alias: Sum_KSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
KSI_Score (type: esriFieldTypeSmallInteger, alias: KSI Score, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/16/2025 6:16:38 PM

Schema Last Edit Date: 4/16/2025 6:16:38 PM

Data Last Edit Date: 4/14/2025 4:26:18 PM

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

Layer: CrashPoints_2018_22_KSI (ID:0)