Layer: Fatalities (ID:0)

View In: Map Viewer

Name: Fatalities

Display Field: COUNTY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: HarrisburgCrashes2013to2017

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[168,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,0,0,255],"width":1}},"label":"","description":""},"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: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
CRN (type: esriFieldTypeInteger, alias: Crash Record Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
DISTRICT (type: esriFieldTypeInteger, alias: District Number where Crash cccureed, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNTY (type: esriFieldTypeInteger, alias: County Code Number where Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
MUNICIPALITY (type: esriFieldTypeInteger, alias: Municipality Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
POLICE_AGCY (type: esriFieldTypeString, alias: Code of the Reporting Police Agency, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
CRASH_YEAR (type: esriFieldTypeInteger, alias: Year when the Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
CRASH_MONTH (type: esriFieldTypeInteger, alias: Month when the Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
DAY_OF_WEEK (type: esriFieldTypeInteger, alias: Day of the Week code when Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
TIME_OF_DAY (type: esriFieldTypeInteger, alias: The Time of Day When the Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
HOUR_OF_DAY (type: esriFieldTypeInteger, alias: The Hour of Day when the Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
ILLUMINATION (type: esriFieldTypeInteger, alias: Code that defines lighting at Crash scene, SQL Type: sqlTypeOther, nullable: true, editable: true)
WEATHER (type: esriFieldTypeInteger, alias: Code for the weather type at the time of Crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
ROAD_CONDITION (type: esriFieldTypeInteger, alias: Roadway Surface Condition Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
COLLISION_TYPE (type: esriFieldTypeInteger, alias: Collision category that defines the Crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
RELATION_TO_ROAD (type: esriFieldTypeInteger, alias: Code for the Crash relativity to the road, SQL Type: sqlTypeOther, nullable: true, editable: true)
WORK_ZONE_TYPE (type: esriFieldTypeString, alias: Code to define the type of Work Zone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
WORK_ZONE_LOC (type: esriFieldTypeString, alias: The Work Zone Location Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
WORK_ZONE_IND (type: esriFieldTypeString, alias: Did the Crash occur in a work zone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
INTERSECT_TYPE (type: esriFieldTypeInteger, alias: Code that defines the Intersection Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
TCD_TYPE (type: esriFieldTypeInteger, alias: Code that defines the Traffic Control Device, SQL Type: sqlTypeOther, nullable: true, editable: true)
LOCATION_TYPE (type: esriFieldTypeInteger, alias: Code that defines the crash location, SQL Type: sqlTypeOther, nullable: true, editable: true)
URBAN_RURAL (type: esriFieldTypeInteger, alias: Code to classify crash as Urban or Rural based on municipality, SQL Type: sqlTypeOther, nullable: true, editable: true)
FATAL_COUNT (type: esriFieldTypeInteger, alias: Total amount of fatalities involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
INJURY_COUNT (type: esriFieldTypeInteger, alias: INJURY_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
PERSON_COUNT (type: esriFieldTypeInteger, alias: Total people involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
TOTAL_UNITS (type: esriFieldTypeInteger, alias: Total count of all Vehicles and Pedestrains, SQL Type: sqlTypeOther, nullable: true, editable: true)
SCH_BUS_IND (type: esriFieldTypeString, alias: Did the crash involve a School Bus (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SCH_ZONE_IND (type: esriFieldTypeString, alias: Did the crash occur in a School Zone (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
LATITUDE (type: esriFieldTypeString, alias: Decimal format of the Latitude, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
LONGITUDE (type: esriFieldTypeString, alias: Decimal format of the Longitude, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
ARRIVAL_TM (type: esriFieldTypeInteger, alias: Time Police arrived at the scene, SQL Type: sqlTypeOther, nullable: true, editable: true)
CONS_ZONE_SPD_LIM (type: esriFieldTypeString, alias: Speed limit for the Construction Zone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
DISPATCH_TM (type: esriFieldTypeInteger, alias: Time Police were dispatched to the scene, SQL Type: sqlTypeOther, nullable: true, editable: true)
EST_HRS_CLOSED (type: esriFieldTypeInteger, alias: Estimated hours roadway was closed, SQL Type: sqlTypeOther, nullable: true, editable: true)
LANE_CLOSED (type: esriFieldTypeInteger, alias: Was there a lane closure (Y/N), SQL Type: sqlTypeOther, nullable: true, editable: true)
LN_CLOSE_DIR (type: esriFieldTypeInteger, alias: Direction of traffic in closed lane (s), SQL Type: sqlTypeOther, nullable: true, editable: true)
NTFY_HIWY_MAINT (type: esriFieldTypeString, alias: PeNNDOT highway maintenance notified, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
SPEC_JURIS_CD (type: esriFieldTypeInteger, alias: Code that defines any special jurisdiction - only for fatal crashes, SQL Type: sqlTypeOther, nullable: true, editable: true)
TCD_FUNC_CD (type: esriFieldTypeInteger, alias: Code for Traffic Control Device state, SQL Type: sqlTypeOther, nullable: true, editable: true)
TFC_DETOUR_IND (type: esriFieldTypeString, alias: Was Traffic Detoured (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
WORKERS_PRES (type: esriFieldTypeString, alias: Were construction personnel present (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
WZ_CLOSE_DETOUR (type: esriFieldTypeString, alias: Was traffic rerouted due to work zone (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
WZ_FLAGGER (type: esriFieldTypeString, alias: Did work zone have a flagman (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
WZ_LAW_OFFCR_IND (type: esriFieldTypeString, alias: Did work zone have a patrolman (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
WZ_LN_CLOSURE (type: esriFieldTypeString, alias: Did Work zone have a lane closure (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
WZ_MOVING (type: esriFieldTypeString, alias: Was there moving work in the zone (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
WZ_OTHER (type: esriFieldTypeString, alias: Was this a special type of work zone (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
WZ_SHLDER_MDN (type: esriFieldTypeString, alias: Was a median/shoulder in the zone (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
VEHICLE_COUNT (type: esriFieldTypeInteger, alias: Total number of all motor vehicles involved in the crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
AUTOMOBILE_COUNT (type: esriFieldTypeInteger, alias: Total amount of Automobiles Involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
MOTORCYCLE_COUNT (type: esriFieldTypeInteger, alias: Total amount of Motorcycles Involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
BUS_COUNT (type: esriFieldTypeInteger, alias: Total amount of Buses involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
SMALL_TRUCK_COUNT (type: esriFieldTypeInteger, alias: Total amount of Small Trucks involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
HEAVY_TRUCK_COUNT (type: esriFieldTypeInteger, alias: Total amount of Heavy Trucks involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
SUV_COUNT (type: esriFieldTypeInteger, alias: Total count of sport utility vehicles involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
VAN_COUNT (type: esriFieldTypeInteger, alias: Total amount of vans involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
BICYCLE_COUNT (type: esriFieldTypeInteger, alias: Total amount of Bicycles involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
MAJ_INJ_COUNT (type: esriFieldTypeInteger, alias: Total amount of Major Injuries involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
MOD_INJ_COUNT (type: esriFieldTypeInteger, alias: Total amount of Moderate Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
MIN_INJ_COUNT (type: esriFieldTypeInteger, alias: Total amount of Minimal Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
TOT_INJ_COUNT (type: esriFieldTypeInteger, alias: TOT_INJ_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
UNK_INJ_DEG_COUNT (type: esriFieldTypeInteger, alias: No of injuries with unknown severity, SQL Type: sqlTypeOther, nullable: true, editable: true)
UNK_INJ_PER_COUNT (type: esriFieldTypeInteger, alias: No of people that are unknown if injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
DRIVER_COUNT_16YR (type: esriFieldTypeInteger, alias: Total amount of 16 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
DRIVER_COUNT_17YR (type: esriFieldTypeInteger, alias: Total amount of 17 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
DRIVER_COUNT_18YR (type: esriFieldTypeInteger, alias: Total amount of 18 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
DRIVER_COUNT_19YR (type: esriFieldTypeInteger, alias: Total amount of 19 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
DRIVER_COUNT_20YR (type: esriFieldTypeInteger, alias: Total amount of 20 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
DRIVER_COUNT_50_64YR (type: esriFieldTypeInteger, alias: Total amount of 50 to 64 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
DRIVER_COUNT_65_74YR (type: esriFieldTypeInteger, alias: Total amount of 65 to 74 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
DRIVER_COUNT_75PLUS (type: esriFieldTypeInteger, alias: Total amount of drivers ages 75 and up, SQL Type: sqlTypeOther, nullable: true, editable: true)
UNBELTED_OCC_COUNT (type: esriFieldTypeInteger, alias: Total count of all unbelted occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
UNB_DEATH_COUNT (type: esriFieldTypeInteger, alias: No of people killed not wearing a seatbelt, SQL Type: sqlTypeOther, nullable: true, editable: true)
UNB_MAJ_INJ_COUNT (type: esriFieldTypeInteger, alias: Total # of unbelted sustaining Major Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
BELTED_DEATH_COUNT (type: esriFieldTypeInteger, alias: Total Deaths of belted occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
BELTED_MAJ_INJ_COUNT (type: esriFieldTypeInteger, alias: Total Major Injuries of belted occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
MCYCLE_DEATH_COUNT (type: esriFieldTypeInteger, alias: Total amount of Motorcyclist fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
MCYCLE_MAJ_INJ_COUNT (type: esriFieldTypeInteger, alias: Total amount of Motorcyclist Major Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
BICYCLE_DEATH_COUNT (type: esriFieldTypeInteger, alias: Total amount of Bicyclist Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
BICYCLE_MAJ_INJ_COUNT (type: esriFieldTypeInteger, alias: Total amount of Bicyclist Major Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
PED_COUNT (type: esriFieldTypeInteger, alias: Total Pedestrian involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
PED_DEATH_COUNT (type: esriFieldTypeInteger, alias: Total Pedestrian Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
PED_MAJ_INJ_COUNT (type: esriFieldTypeInteger, alias: Total Pedestrian Major injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
MAX_SEVERITY_LEVEL (type: esriFieldTypeInteger, alias: Injury severity level of the crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
COMM_VEH_COUNT (type: esriFieldTypeInteger, alias: Total Commercial vehicles involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
DEC_LAT (type: esriFieldTypeDouble, alias: Decimal format of the Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
DEC_LONG (type: esriFieldTypeDouble, alias: Decimal format of the Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
RDWY_SURF_TYPE_CD (type: esriFieldTypeInteger, alias: Code for the Roadway surface type - only for fatal crashes, SQL Type: sqlTypeOther, nullable: true, editable: true)
COUNTY_NAME (type: esriFieldTypeString, alias: County Code number where crash occured, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Add Features Update Features Delete Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat