Name: Fatal Crashes Heatmap

Display Field: Federal_Aid_Urban_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:

XMin: -13702009.065853
YMin: 5668377.89360134
XMax: -13622372.0294309
YMax: 5721679.70761831
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":20,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID_1

Unique ID Field:

Name : OBJECTID_1

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SHAPE_1 (type: esriFieldTypeString, alias: SHAPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• KABCO (type: esriFieldTypeString, alias: KABCO, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Crash_ID (type: esriFieldTypeInteger, alias: Crash ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Crash_Date (type: esriFieldTypeDate, alias: Crash Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Crash_Hour_Description (type: esriFieldTypeString, alias: Crash Hour Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Federal_Aid_Urban_Name (type: esriFieldTypeString, alias: Federal Aid Urban Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FHWA_Functional_Classification (type: esriFieldTypeString, alias: FHWA Functional Classification, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Route_Label (type: esriFieldTypeString, alias: Route Label, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ODOT_Highway_Number (type: esriFieldTypeString, alias: ODOT Highway Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Highway_Number_Suffix (type: esriFieldTypeString, alias: Highway Number Suffix, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Milepoint (type: esriFieldTypeString, alias: Milepoint, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Linear_Reference_System_Key (type: esriFieldTypeString, alias: Linear Reference System Key, 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)
• Unlocatable_Flag (type: esriFieldTypeInteger, alias: Unlocatable Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Recreational_Rd_Name (type: esriFieldTypeString, alias: Recreational Rd Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Intersecting_Rec_Rd_Name (type: esriFieldTypeString, alias: Intersecting Rec Rd Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Road_Description (type: esriFieldTypeString, alias: Road Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Intersecting_Road_Description (type: esriFieldTypeString, alias: Intersecting Road Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Distance_from_Intersection (type: esriFieldTypeString, alias: Distance from Intersection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Posted_Speed (type: esriFieldTypeString, alias: Posted Speed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Rd_Character_Desc (type: esriFieldTypeString, alias: Rd Character Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Off_Roadway_Flag (type: esriFieldTypeInteger, alias: Off Roadway Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Intersection_Type_Desc (type: esriFieldTypeString, alias: Intersection Type Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Intersection_Related_Flag (type: esriFieldTypeInteger, alias: Intersection Related Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roundabout_Flag (type: esriFieldTypeInteger, alias: Roundabout Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Driveway_Related_Flag (type: esriFieldTypeInteger, alias: Driveway Related Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Number_of_Lanes (type: esriFieldTypeString, alias: Number of Lanes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Number_of_Turning_Legs (type: esriFieldTypeString, alias: Number of Turning Legs, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Median_Type_Desc (type: esriFieldTypeString, alias: Median Type Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Crash_Type_Desc (type: esriFieldTypeString, alias: Crash Type Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Collision_Type_Desc (type: esriFieldTypeString, alias: Collision Type Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Crash_Severity_Desc (type: esriFieldTypeString, alias: Crash Severity Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Weather_Desc (type: esriFieldTypeString, alias: Weather Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Road_Surface_Condition_Desc (type: esriFieldTypeString, alias: Road Surface Condition Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Light_Condition_Desc (type: esriFieldTypeString, alias: Light Condition Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Traffic_Control_Device_Desc (type: esriFieldTypeString, alias: Traffic Control Device Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• School_Zone_Indicator (type: esriFieldTypeString, alias: School Zone Indicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Work_Zone_Indicator (type: esriFieldTypeString, alias: Work Zone Indicator, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Alcohol_Involved_Flag (type: esriFieldTypeInteger, alias: Alcohol Involved Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Drug_Involved_Flag (type: esriFieldTypeInteger, alias: Drug Involved Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Speed_Involved_Flag (type: esriFieldTypeInteger, alias: Speed Involved Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hit_and_Run_Flag (type: esriFieldTypeInteger, alias: Hit and Run Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ODOT_Region (type: esriFieldTypeInteger, alias: ODOT Region, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ODOT_District (type: esriFieldTypeString, alias: ODOT District, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Total_Vehicles (type: esriFieldTypeInteger, alias: Total Vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Deaths (type: esriFieldTypeInteger, alias: Total Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Serious_Injuries (type: esriFieldTypeInteger, alias: Total Serious Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Moderate_Injuries (type: esriFieldTypeInteger, alias: Total Moderate Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Minor_Injuries (type: esriFieldTypeInteger, alias: Total Minor Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Pedestrians (type: esriFieldTypeInteger, alias: Total Pedestrians, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Pedestrian_Deaths (type: esriFieldTypeInteger, alias: Total Pedestrian Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Pedestrian_Injuries (type: esriFieldTypeInteger, alias: Total Pedestrian Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Pedal_cyclists (type: esriFieldTypeInteger, alias: Total Pedal-cyclists, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Pedal_cyclist_Deaths (type: esriFieldTypeInteger, alias: Total Pedal-cyclist Deaths, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Pedal_cyclist_Injuries (type: esriFieldTypeInteger, alias: Total Pedal-cyclist Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Unknown_Non_Motorists (type: esriFieldTypeInteger, alias: Total Unknown Non-Motorists, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Unknown_Non_Motorist_Deat (type: esriFieldTypeInteger, alias: Total Unknown Non-Motorist Death, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Unknown_Non_Motorist_Inju (type: esriFieldTypeInteger, alias: Total Unknown Non-Motorist Injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Safety_Equip_Un_used (type: esriFieldTypeInteger, alias: Total Safety Equip Un-used, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Crash_Month (type: esriFieldTypeInteger, alias: Crash Month, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Crash_Day (type: esriFieldTypeInteger, alias: Crash Day, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Crash_Year (type: esriFieldTypeInteger, alias: Crash Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Day_of_Week (type: esriFieldTypeInteger, alias: Day of Week, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Crash_Cause_1_Desc (type: esriFieldTypeString, alias: Crash Cause 1 Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Crash_Cause_2_Desc (type: esriFieldTypeString, alias: Crash Cause 2 Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Crash_Cause_3_Desc (type: esriFieldTypeString, alias: Crash Cause 3 Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Crash_Event_1_Desc (type: esriFieldTypeString, alias: Crash Event 1 Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Crash_Event_2_Desc (type: esriFieldTypeString, alias: Crash Event 2 Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Crash_Event_3_Desc (type: esriFieldTypeString, alias: Crash Event 3 Desc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Pedestrian_Present_Flag (type: esriFieldTypeInteger, alias: Pedestrian Present Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roadway_Departure_Flag (type: esriFieldTypeInteger, alias: Roadway Departure Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Motorcycle_Flag (type: esriFieldTypeInteger, alias: Motorcycle Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Distracted_Driving_Flag (type: esriFieldTypeInteger, alias: Distracted Driving Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Wildlife_Flag (type: esriFieldTypeInteger, alias: Wildlife Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pedalcyclist_Present_Flag (type: esriFieldTypeInteger, alias: Pedalcyclist Present Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Graph_by_Day_of_Week (type: esriFieldTypeString, alias: Graph by Day of Week, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Graph_by_LRS_and_MP (type: esriFieldTypeString, alias: Graph by LRS and MP, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Graph_by_Hour (type: esriFieldTypeString, alias: Graph by Hour, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Graph_LRS_MP (type: esriFieldTypeString, alias: Graph_LRS_MP, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Highest_Injury_Severity_Code (type: esriFieldTypeInteger, alias: Highest Injury Severity Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Highest_Injury_Severity_Descrip (type: esriFieldTypeString, alias: Highest Injury Severity Description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Marijuana_Involved_Flag (type: esriFieldTypeInteger, alias: Marijuana Involved Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Route_Number (type: esriFieldTypeString, alias: Route Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Route_Type (type: esriFieldTypeString, alias: Route Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Youngest_Driver_Involved_Age (type: esriFieldTypeInteger, alias: Youngest Driver Involved Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Oldest_Driver_Involved_Age (type: esriFieldTypeInteger, alias: Oldest Driver Involved Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Youngest_Driver_at_Error_Age (type: esriFieldTypeString, alias: Youngest Driver at Error Age, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Oldest_Driver_at_Error_Age (type: esriFieldTypeString, alias: Oldest Driver at Error Age, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Number_of_Drivers_at_Error (type: esriFieldTypeString, alias: Number of Drivers at Error, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Youngest_Pedestrian_Involved_Ag (type: esriFieldTypeString, alias: Youngest Pedestrian Involved Age, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Oldest_Pedestrian_Involved_Age (type: esriFieldTypeString, alias: Oldest Pedestrian Involved Age, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Male_Driver_Involved (type: esriFieldTypeString, alias: Male Driver Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Female_Driver_Involved (type: esriFieldTypeString, alias: Female Driver Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Non_Binary_Driver_Involved (type: esriFieldTypeString, alias: Non-Binary Driver Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Male_Driver_at_Error (type: esriFieldTypeString, alias: Male Driver at Error, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Female_Driver_at_Error (type: esriFieldTypeString, alias: Female Driver at Error, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Non_Binary_Driver_at_Error (type: esriFieldTypeString, alias: Non-Binary Driver at Error, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Unknown_Gender_Driver_at_Error (type: esriFieldTypeString, alias: Unknown Gender Driver at Error, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Unknown_Gender_Driver_Involved (type: esriFieldTypeString, alias: Unknown Gender Driver Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Metropolitan_Planning_Organizat (type: esriFieldTypeString, alias: Metropolitan Planning Organization, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Youngest_Bicyclist_Involved_Age (type: esriFieldTypeString, alias: Youngest Bicyclist Involved Age, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Oldest_Bicyclist_Involved_Age (type: esriFieldTypeString, alias: Oldest Bicyclist Involved Age, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Female_Bicyclist_Involved (type: esriFieldTypeString, alias: Female Bicyclist Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Male_Bicyclist_Involved (type: esriFieldTypeString, alias: Male Bicyclist Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Non_Binary_Bicyclist_Involved (type: esriFieldTypeString, alias: Non-Binary Bicyclist Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Unknown_Gender_Bicyclist_Involv (type: esriFieldTypeString, alias: Unknown Gender Bicyclist Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Female_Pedestrian_Involved (type: esriFieldTypeString, alias: Female Pedestrian Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Male_Pedestrian_Involved (type: esriFieldTypeString, alias: Male Pedestrian Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Non_Binary_Pedestrian_Involved (type: esriFieldTypeString, alias: Non-Binary Pedestrian Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Unknown_Gender_Pedestrian_Invol (type: esriFieldTypeString, alias: Unknown Gender Pedestrian Involved, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• x (type: esriFieldTypeDouble, alias: x, SQL Type: sqlTypeOther, nullable: true, editable: true)
• y (type: esriFieldTypeDouble, alias: y, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Fatal Crashes Heatmap
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/21/2021 8:30:24 PM

Schema Last Edit Date: 9/21/2021 8:30:24 PM

Data Last Edit Date: 9/21/2021 8:30:24 PM

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