View In:   ArcGIS Online Map Viewer

Name: PennDOT Accidents

Display Field: WEATHER2

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This feature class was created in June 2023 for the purpose of studying vehicle crash (roadway accident) trends in Crawford County over the past two decades (2002 to 2021). This resource was created to inform the update of Crawford County's 2014 Comprehensive Plan. The point geometry provided within this feature class was compiled from spreadsheets downloaded from PennDOT's Crash Download Map ( ) for Crawford County. A series of 20 spreadsheets were downloaded for crashes in order to cover the years ranging from 2002 to 2021. These spreadsheets were compiled into a single sheet that was then converted into a database file in order to be process in GIS. Each crash record was digitized by plotting X (longitude) and Y (latitude) coordinates provided within the original dataset by PennDOT. Records from the earlier years provided within the dataset were more likely to omit GPS coordinates with omissions reducing over the years. Records without GPS coordinates were not mapped. Despite not providing a complete record of all crashes along State roads in Crawford County between 2002 and 2021, this resource served useful for providing a snapshot of crash data over a span of two decades. The primarily purpose for creating and analyzing this dataset was to determine if accident trends in Crawford County have a relationship to land use and development patterns.</SPAN></P></DIV></DIV></DIV>

Service Item Id: 8e39ee1a679a48129481610443e56891

Copyright Text: Data provided by the Pennsylvania Department of Transportation; resource compiled by the Crawford County Planning Office.

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1210424.6722233146
YMin: 487923.44855855405
XMax: 1460773.7433745563
YMax: 623452.4557152092
Spatial Reference: 102728  (2271)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [61, 132, 132, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• CRN ( type: esriFieldTypeInteger, alias: CRN, editable: true, nullable: true, defaultValue: null, modelName: CRN )
• CRASH_YEAR ( type: esriFieldTypeInteger, alias: CRASH_YEAR, editable: true, nullable: true, defaultValue: null, modelName: CRASH_YEAR )
• CRASH_MONT ( type: esriFieldTypeInteger, alias: CRASH_MONT, editable: true, nullable: true, defaultValue: null, modelName: CRASH_MONT )
• MUNICIPALI ( type: esriFieldTypeInteger, alias: MUNICIPALI, editable: true, nullable: true, defaultValue: null, modelName: MUNICIPALI )
• COLLISION_ ( type: esriFieldTypeInteger, alias: COLLISION_, editable: true, nullable: true, defaultValue: null, modelName: COLLISION_ )
• FATAL_COUN ( type: esriFieldTypeInteger, alias: FATAL_COUN, editable: true, nullable: true, defaultValue: null, modelName: FATAL_COUN )
• ILLUMINATI ( type: esriFieldTypeInteger, alias: ILLUMINATI, editable: true, nullable: true, defaultValue: null, modelName: ILLUMINATI )
• ROAD_CONDI ( type: esriFieldTypeInteger, alias: ROAD_CONDI, editable: true, nullable: true, defaultValue: null, modelName: ROAD_CONDI )
• URBAN_RURA ( type: esriFieldTypeInteger, alias: URBAN_RURA, editable: true, nullable: true, defaultValue: null, modelName: URBAN_RURA )
• WEATHER1 ( type: esriFieldTypeInteger, alias: WEATHER1, editable: true, nullable: true, defaultValue: null, modelName: WEATHER1 )
• WEATHER2 ( type: esriFieldTypeString, alias: WEATHER2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: WEATHER2 )
• PED_COUNT ( type: esriFieldTypeInteger, alias: PED_COUNT, editable: true, nullable: true, defaultValue: null, modelName: PED_COUNT )
• BICYCLE_CO ( type: esriFieldTypeInteger, alias: BICYCLE_CO, editable: true, nullable: true, defaultValue: null, modelName: BICYCLE_CO )
• BICYCLE_DE ( type: esriFieldTypeInteger, alias: BICYCLE_DE, editable: true, nullable: true, defaultValue: null, modelName: BICYCLE_DE )
• HORSE_BUGG ( type: esriFieldTypeInteger, alias: HORSE_BUGG, editable: true, nullable: true, defaultValue: null, modelName: HORSE_BUGG )
• MOTORCYCLE ( type: esriFieldTypeInteger, alias: MOTORCYCLE, editable: true, nullable: true, defaultValue: null, modelName: MOTORCYCLE )
• DEC_LAT ( type: esriFieldTypeDouble, alias: DEC_LAT, editable: true, nullable: true, defaultValue: null, modelName: DEC_LAT )
• DEC_LONG ( type: esriFieldTypeDouble, alias: DEC_LONG, editable: true, nullable: true, defaultValue: null, modelName: DEC_LONG )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID )
• CRN_1 ( type: esriFieldTypeInteger, alias: CRN, editable: true, nullable: true, defaultValue: null, modelName: CRN_1 )
• ALCOHOL_RELATED ( type: esriFieldTypeInteger, alias: ALCOHOL_RELATED, editable: true, nullable: true, defaultValue: null, modelName: ALCOHOL_RELATED )
• DRUGGED_DRIVER ( type: esriFieldTypeInteger, alias: DRUGGED_DRIVER, editable: true, nullable: true, defaultValue: null, modelName: DRUGGED_DRIVER )
• DRUG_RELATED ( type: esriFieldTypeInteger, alias: DRUG_RELATED, editable: true, nullable: true, defaultValue: null, modelName: DRUG_RELATED )
• OPIOID_RELATED ( type: esriFieldTypeInteger, alias: OPIOID_RELATED, editable: true, nullable: true, defaultValue: null, modelName: OPIOID_RELATED )

Templates:

• Name: PennDOT Accidents
  Description:
  Prototype:
  DRUG_RELATED: null
  OPIOID_RELATED: null
  CRN: null
  CRASH_YEAR: null
  CRASH_MONT: null
  MUNICIPALI: null
  COLLISION_: null
  FATAL_COUN: null
  ILLUMINATI: null
  ROAD_CONDI: null
  URBAN_RURA: null
  WEATHER1: null
  WEATHER2: null
  PED_COUNT: null
  BICYCLE_CO: null
  BICYCLE_DE: null
  HORSE_BUGG: null
  MOTORCYCLE: null
  DEC_LAT: null
  DEC_LONG: null
  OBJECTID: null
  CRN_1: null
  ALCOHOL_RELATED: null
  DRUGGED_DRIVER: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata