Layers:

Layer: HBG_crashdata_2014_2018 (0)


Name: HBG_crashdata_2014_2018

Display Field: OBJECTID_1

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: HBG_crashdata_2014_2018

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: -8561136.75894749
YMin: 4901171.6299805
XMax: -8553811.9364533
YMax: 4910494.91657122
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":40,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


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: esriFieldTypeString, alias: Code of the Reporting Police Agency, SQL Type: sqlTypeOther, length: 8000, 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: esriFieldTypeInteger, alias: Time Police arrived at the scene, SQL Type: sqlTypeOther, 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: esriFieldTypeInteger, alias: Time Police were dispatched to the scene, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Estimated_hours_roadway_was_clo (type: esriFieldTypeInteger, alias: Estimated hours roadway was closed, SQL Type: sqlTypeOther, 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: esriFieldTypeInteger, alias: Direction of traffic in closed lane (s), SQL Type: sqlTypeOther, 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: esriFieldTypeInteger, alias: Code that defines any special jurisdiction - only for fatal crashes, SQL Type: sqlTypeOther, 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: esriFieldTypeInteger, alias: Code for the Roadway surface type - only for fatal crashes, SQL Type: sqlTypeOther, 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:

Name: HBG_crashdata_2014_2018
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/27/2019 5:27:45 PM

Schema Last Edit Date: 11/27/2019 5:27:45 PM

Data Last Edit Date: 11/27/2019 5:27:45 PM