Layer: Reported_Crash_2015-2019 (ID:1)

View In: Map Viewer

Name: Reported_Crash_2015-2019

Display Field: OBJECTID_1

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":"simple","symbol":{"type":"esriPMS","url":"6bf279725cc2cbb64296fac3c24ff03c","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAWCAYAAADwza0nAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABgElEQVQ4jZ2SvU/CQBiHfy+iiV1wQAYHTQxLQ0fW2hgXBxbYZWR35GPARGE0YWTkD6gLg6MUR9kgXRiIg0PTgekUG3sO5GihBzX+pvt67nnz3iXxzySlq823NBZfKvZ+XNwbdjzYGKjgVIHHdCQAcALqFsBh40C5RTPvRsHqqw7fr4OQjlxPUOGxZzQGN6KC5Kq0b1YRkH6WUu6uTk8uz49SE4exQm88nc0XHnx6BHAdgN5nCQRVCAQEALmMovTLWlbrjGwQ0qgOSmgb5hLkXAcFlQlIJJdRlKBsKgIwpV2dOIyFD08cxkLbx0GpBDcMFnrjab+sZXMZRZk4jLVe3j9CjbICEGQDXBd7s/nC0zoj6fsB5Abg/qEJj1XkB0PhcJHwhwHYzLuoD7sA3w0TrPV3BIAHvYuaVZJ+gKXNRuuiJabrXeW8C6KaHORP4ek62DZM1Kxi+DOsbG3D3A6Km4nUyNpGouCmVWKTg5tWiW07KKxi/Gdwhyke3GKKB2PyC0V3lW92WIFVAAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":16,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Crash_Record_Number (type: esriFieldTypeInteger, alias: Crash Record Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
District_Number_where_Crash_ccc (type: esriFieldTypeInteger, alias: District Number where Crash cccureed, SQL Type: sqlTypeOther, nullable: true, editable: true)
County_Code_Number_where_Crash_ (type: esriFieldTypeInteger, alias: County Code Number where Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
Municipality_Code (type: esriFieldTypeInteger, alias: Municipality Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
Code_of_the_Reporting_Police_Ag (type: esriFieldTypeInteger, alias: Code of the Reporting Police Agency, SQL Type: sqlTypeOther, nullable: true, editable: true)
Year_when_the_Crash_occurred (type: esriFieldTypeInteger, alias: Year when the Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
Month_when_the_Crash_occurred (type: esriFieldTypeInteger, alias: Month when the Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
Day_of_the_Week_code_when_Crash (type: esriFieldTypeInteger, alias: Day of the Week code when Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
The_Time_of_Day_When_the_Crash_ (type: esriFieldTypeInteger, alias: The Time of Day When the Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
The_Hour_of_Day_when_the_Crash_ (type: esriFieldTypeInteger, alias: The Hour of Day when the Crash occurred, SQL Type: sqlTypeOther, nullable: true, editable: true)
Code_that_defines_lighting_at_C (type: esriFieldTypeInteger, alias: Code that defines lighting at Crash scene, SQL Type: sqlTypeOther, nullable: true, editable: true)
Code_for_the_weather_type_at_th (type: esriFieldTypeInteger, alias: Code for the weather type at the time of Crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
Roadway_Surface_Condition_Code (type: esriFieldTypeInteger, alias: Roadway Surface Condition Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
Collision_category_that_defines (type: esriFieldTypeInteger, alias: Collision category that defines the Crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
Code_for_the_Crash_relativity_t (type: esriFieldTypeInteger, alias: Code for the Crash relativity to the road, SQL Type: sqlTypeOther, nullable: true, editable: true)
Code_to_define_the_type_of_Work (type: esriFieldTypeString, alias: Code to define the type of Work Zone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
The_Work_Zone_Location_Code (type: esriFieldTypeString, alias: The Work Zone Location Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Did_the_Crash_occur_in_a_work_z (type: esriFieldTypeString, alias: Did the Crash occur in a work zone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Code_that_defines_the_Intersect (type: esriFieldTypeInteger, alias: Code that defines the Intersection Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
Code_that_defines_the_Traffic_C (type: esriFieldTypeInteger, alias: Code that defines the Traffic Control Device, SQL Type: sqlTypeOther, nullable: true, editable: true)
Code_that_defines_the_crash_loc (type: esriFieldTypeInteger, alias: Code that defines the crash location, SQL Type: sqlTypeOther, nullable: true, editable: true)
Code_to_classify_crash_as_Urban (type: esriFieldTypeInteger, alias: Code to classify crash as Urban or Rural based on municipality, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_fatalities_invo (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)
Total_people_involved (type: esriFieldTypeInteger, alias: Total people involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_count_of_all_Vehicles_and (type: esriFieldTypeInteger, alias: Total count of all Vehicles and Pedestrains, SQL Type: sqlTypeOther, nullable: true, editable: true)
Did_the_crash_involve_a_School_ (type: esriFieldTypeString, alias: Did the crash involve a School Bus (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Did_the_crash_occur_in_a_School (type: esriFieldTypeString, alias: Did the crash occur in a School Zone (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Decimal_format_of_the_Latitude (type: esriFieldTypeString, alias: Decimal format of the Latitude, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Decimal_format_of_the_Longitude (type: esriFieldTypeString, alias: Decimal format of the Longitude, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Time_Police_arrived_at_the_scen (type: esriFieldTypeString, alias: Time Police arrived at the scene, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Speed_limit_for_the_Constructio (type: esriFieldTypeString, alias: Speed limit for the Construction Zone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Time_Police_were_dispatched_to_ (type: esriFieldTypeString, alias: Time Police were dispatched to the scene, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Estimated_hours_roadway_was_clo (type: esriFieldTypeString, alias: Estimated hours roadway was closed, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Was_there_a_lane_closure__Y_N_ (type: esriFieldTypeInteger, alias: Was there a lane closure (Y/N), SQL Type: sqlTypeOther, nullable: true, editable: true)
Direction_of_traffic_in_closed_ (type: esriFieldTypeString, alias: Direction of traffic in closed lane (s), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
PeNNDOT_highway_maintenance_not (type: esriFieldTypeString, alias: PeNNDOT highway maintenance notified, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Code_that_defines_any_special_j (type: esriFieldTypeString, alias: Code that defines any special jurisdiction - only for fatal crashes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Code_for_Traffic_Control_Device (type: esriFieldTypeInteger, alias: Code for Traffic Control Device state, SQL Type: sqlTypeOther, nullable: true, editable: true)
Was_Traffic_Detoured__Y_N_ (type: esriFieldTypeString, alias: Was Traffic Detoured (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Were_construction_personnel_pre (type: esriFieldTypeString, alias: Were construction personnel present (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Was_traffic_rerouted_due_to_wor (type: esriFieldTypeString, alias: Was traffic rerouted due to work zone (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Did_work_zone_have_a_flagman__Y (type: esriFieldTypeString, alias: Did work zone have a flagman (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Did_work_zone_have_a_patrolman_ (type: esriFieldTypeString, alias: Did work zone have a patrolman (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Did_Work_zone_have_a_lane_closu (type: esriFieldTypeString, alias: Did Work zone have a lane closure (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Was_there_moving_work_in_the_zo (type: esriFieldTypeString, alias: Was there moving work in the zone (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Was_this_a_special_type_of_work (type: esriFieldTypeString, alias: Was this a special type of work zone (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Was_a_median_shoulder_in_the_zo (type: esriFieldTypeString, alias: Was a median/shoulder in the zone (Y/N), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
Total_number_of_all_motor_vehic (type: esriFieldTypeInteger, alias: Total number of all motor vehicles involved in the crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Automobiles_Inv (type: esriFieldTypeInteger, alias: Total amount of Automobiles Involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Motorcycles_Inv (type: esriFieldTypeInteger, alias: Total amount of Motorcycles Involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Buses_involved (type: esriFieldTypeInteger, alias: Total amount of Buses involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Small_Trucks_in (type: esriFieldTypeInteger, alias: Total amount of Small Trucks involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Heavy_Trucks_in (type: esriFieldTypeInteger, alias: Total amount of Heavy Trucks involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_count_of_sport_utility_ve (type: esriFieldTypeInteger, alias: Total count of sport utility vehicles involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_vans_involved (type: esriFieldTypeInteger, alias: Total amount of vans involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Bicycles_involv (type: esriFieldTypeInteger, alias: Total amount of Bicycles involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Major_Injuries_ (type: esriFieldTypeInteger, alias: Total amount of Major Injuries involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Moderate_Injuri (type: esriFieldTypeInteger, alias: Total amount of Moderate Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Minimal_Injurie (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)
No_of_injuries_with_unknown_sev (type: esriFieldTypeInteger, alias: No of injuries with unknown severity, SQL Type: sqlTypeOther, nullable: true, editable: true)
No_of_people_that_are_unknown_i (type: esriFieldTypeInteger, alias: No of people that are unknown if injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_16_year_old_dri (type: esriFieldTypeInteger, alias: Total amount of 16 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_17_year_old_dri (type: esriFieldTypeInteger, alias: Total amount of 17 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_18_year_old_dri (type: esriFieldTypeInteger, alias: Total amount of 18 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_19_year_old_dri (type: esriFieldTypeInteger, alias: Total amount of 19 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_20_year_old_dri (type: esriFieldTypeInteger, alias: Total amount of 20 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_50_to_64_year_o (type: esriFieldTypeInteger, alias: Total amount of 50 to 64 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_65_to_74_year_o (type: esriFieldTypeInteger, alias: Total amount of 65 to 74 year old drivers, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_drivers_ages_75 (type: esriFieldTypeInteger, alias: Total amount of drivers ages 75 and up, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_count_of_all_unbelted_occ (type: esriFieldTypeInteger, alias: Total count of all unbelted occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
No_of_people_killed_not_wearing (type: esriFieldTypeInteger, alias: No of people killed not wearing a seatbelt, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total___of_unbelted_sustaining_ (type: esriFieldTypeInteger, alias: Total # of unbelted sustaining Major Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Deaths_of_belted_occupant (type: esriFieldTypeInteger, alias: Total Deaths of belted occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Major_Injuries_of_belted_ (type: esriFieldTypeInteger, alias: Total Major Injuries of belted occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Motorcyclist_fa (type: esriFieldTypeInteger, alias: Total amount of Motorcyclist fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Motorcyclist_Ma (type: esriFieldTypeInteger, alias: Total amount of Motorcyclist Major Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Bicyclist_Fatal (type: esriFieldTypeInteger, alias: Total amount of Bicyclist Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_amount_of_Bicyclist_Major (type: esriFieldTypeInteger, alias: Total amount of Bicyclist Major Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Pedestrian_involved (type: esriFieldTypeInteger, alias: Total Pedestrian involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Pedestrian_Fatalities (type: esriFieldTypeInteger, alias: Total Pedestrian Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Pedestrian_Major_injuries (type: esriFieldTypeInteger, alias: Total Pedestrian Major injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
Injury_severity_level_of_the_cr (type: esriFieldTypeInteger, alias: Injury severity level of the crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
Total_Commercial_vehicles_invol (type: esriFieldTypeInteger, alias: Total Commercial vehicles involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
Decimal_format_of_the_Latitude_ (type: esriFieldTypeDouble, alias: Decimal_format_of_the_Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
Decimal_format_of_the_Longitu_1 (type: esriFieldTypeDouble, alias: Decimal_format_of_the_Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
Code_for_the_Roadway_surface_ty (type: esriFieldTypeString, alias: Code_for_the_Roadway_surface_type_only_for_fatal_crashes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
County_Code_number_where_crash1 (type: esriFieldTypeString, alias: County Code number where crash occured, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
x (type: esriFieldTypeString, alias: x, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
y (type: esriFieldTypeString, alias: y, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/30/2021 3:49:41 PM

Schema Last Edit Date: 9/30/2021 3:49:41 PM

Data Last Edit Date: 9/30/2021 3:49:41 PM

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