Name: TriCounty_Crashes_2017_2024

Display Field: CityName

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: -10018754.1713946
YMin: 5.6649236412909E-09
XMax: 6.32778044253391E-09
YMax: 5008477.95393278
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[75,81,158,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"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:

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)
• ICN (type: esriFieldTypeBigInteger, alias: ICN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashID (type: esriFieldTypeInteger, alias: CrashID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CountyCode (type: esriFieldTypeInteger, alias: CountyCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashYr (type: esriFieldTypeInteger, alias: CrashYr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashMonth (type: esriFieldTypeInteger, alias: CrashMonth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashDay (type: esriFieldTypeInteger, alias: CrashDay, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumberOfVehicles (type: esriFieldTypeInteger, alias: NumberOfVehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DayOfWeekCode (type: esriFieldTypeInteger, alias: DayOfWeekCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashHour (type: esriFieldTypeString, alias: CrashHour, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CityCode (type: esriFieldTypeInteger, alias: CityCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CityClassCode (type: esriFieldTypeInteger, alias: CityClassCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Township (type: esriFieldTypeString, alias: Township, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CollisionTypeCode (type: esriFieldTypeInteger, alias: CollisionTypeCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalFatals (type: esriFieldTypeInteger, alias: TotalFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalInjured (type: esriFieldTypeInteger, alias: TotalInjured, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NoInjuries (type: esriFieldTypeInteger, alias: NoInjuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AInjuries (type: esriFieldTypeInteger, alias: AInjuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BInjuries (type: esriFieldTypeInteger, alias: BInjuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CInjuries (type: esriFieldTypeInteger, alias: CInjuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashSeverity (type: esriFieldTypeString, alias: CrashSeverity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AgencyCode (type: esriFieldTypeInteger, alias: AgencyCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RouteNumber (type: esriFieldTypeString, alias: RouteNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Milestation (type: esriFieldTypeDouble, alias: Milestation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClassOfTrafficwayCode (type: esriFieldTypeString, alias: ClassOfTrafficwayCode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NHS (type: esriFieldTypeString, alias: NHS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TrafficControlDeviceCode (type: esriFieldTypeInteger, alias: TrafficControlDeviceCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RoadSurfaceConditionCode (type: esriFieldTypeInteger, alias: RoadSurfaceConditionCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RoadDefectsCode (type: esriFieldTypeInteger, alias: RoadDefectsCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LightConditionCode (type: esriFieldTypeInteger, alias: LightConditionCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WeatherCode (type: esriFieldTypeInteger, alias: WeatherCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cause1Code (type: esriFieldTypeInteger, alias: Cause1Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cause2Code (type: esriFieldTypeInteger, alias: Cause2Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RailroadCrossingNumber (type: esriFieldTypeString, alias: RailroadCrossingNumber, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TimeOfCrash (type: esriFieldTypeTimeOnly, alias: TimeOfCrash, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrafficControlDeviceConditionCode (type: esriFieldTypeInteger, alias: TrafficControlDeviceConditionCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IntersectionRelated (type: esriFieldTypeString, alias: IntersectionRelated, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HitAndRun (type: esriFieldTypeString, alias: HitAndRun, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CrashDate (type: esriFieldTypeDateOnly, alias: CrashDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumberOfLanes (type: esriFieldTypeString, alias: NumberOfLanes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AlignmentCode (type: esriFieldTypeString, alias: AlignmentCode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TrafficwayDescriptionCode (type: esriFieldTypeInteger, alias: TrafficwayDescriptionCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RoadwayFunctionalClassCode (type: esriFieldTypeString, alias: RoadwayFunctionalClassCode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WorkZoneRelated (type: esriFieldTypeString, alias: WorkZoneRelated, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• City_Township_Flag (type: esriFieldTypeString, alias: City_Township_Flag, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TSCrashCoordinateX (type: esriFieldTypeString, alias: TSCrashCoordinateX, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TSCrashCoordinateY (type: esriFieldTypeString, alias: TSCrashCoordinateY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TSCrashLatitude (type: esriFieldTypeString, alias: TSCrashLatitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TSCrashLongitude (type: esriFieldTypeString, alias: TSCrashLongitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CrashReportCounty (type: esriFieldTypeString, alias: CrashReportCounty, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DayOfWeek (type: esriFieldTypeString, alias: DayOfWeek, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TypeOfFirstCrash (type: esriFieldTypeString, alias: TypeOfFirstCrash, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CityName (type: esriFieldTypeString, alias: CityName, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CityClass (type: esriFieldTypeString, alias: CityClass, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ClassOfTrafficway (type: esriFieldTypeString, alias: ClassOfTrafficway, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Cause1 (type: esriFieldTypeString, alias: Cause1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Cause2 (type: esriFieldTypeString, alias: Cause2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TrafficControlDevice (type: esriFieldTypeString, alias: TrafficControlDevice, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TrafficControlDeviceCond (type: esriFieldTypeString, alias: TrafficControlDeviceCond, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RoadSurfaceCond (type: esriFieldTypeString, alias: RoadSurfaceCond, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RoadDefects (type: esriFieldTypeString, alias: RoadDefects, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CrashInjurySeverity (type: esriFieldTypeString, alias: CrashInjurySeverity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LightingCond (type: esriFieldTypeString, alias: LightingCond, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WeatherCond (type: esriFieldTypeString, alias: WeatherCond, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RoadAlignment (type: esriFieldTypeString, alias: RoadAlignment, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TrafficwayDescrip (type: esriFieldTypeString, alias: TrafficwayDescrip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RoadwayFunctionalClass (type: esriFieldTypeString, alias: RoadwayFunctionalClass, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• InvestigatingAgencyDescrip (type: esriFieldTypeString, alias: InvestigatingAgencyDescrip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CrashSeverityCd (type: esriFieldTypeInteger, alias: CrashSeverityCd, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DamagedProperty1 (type: esriFieldTypeString, alias: DamagedProperty1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DamagedProperty2 (type: esriFieldTypeString, alias: DamagedProperty2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AgencyReportYear (type: esriFieldTypeString, alias: AgencyReportYear, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AgencyReportNumber (type: esriFieldTypeString, alias: AgencyReportNumber, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SFE (type: esriFieldTypeString, alias: SFE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DidCrashOccurInWorkZone (type: esriFieldTypeString, alias: DidCrashOccurInWorkZone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WorkZoneType (type: esriFieldTypeString, alias: WorkZoneType, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WereWorkersPresent (type: esriFieldTypeString, alias: WereWorkersPresent, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• WorkZone (type: esriFieldTypeString, alias: WorkZone, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AccessControl (type: esriFieldTypeString, alias: AccessControl, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FlowCondition (type: esriFieldTypeString, alias: FlowCondition, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DidInvolveSecondaryCrash (type: esriFieldTypeString, alias: DidInvolveSecondaryCrash, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• UrbanRural (type: esriFieldTypeString, alias: UrbanRural, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Toll (type: esriFieldTypeString, alias: Toll, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TypeofReport (type: esriFieldTypeString, alias: TypeofReport, 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)
• FixedLatitude (type: esriFieldTypeDouble, alias: FixedLatitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FixedLat (type: esriFieldTypeDouble, alias: FixedLat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FixedLong (type: esriFieldTypeDouble, alias: FixedLong, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: TriCounty_Crashes_2017_2024
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/23/2026 7:59:02 PM

Schema Last Edit Date: 7/23/2026 7:59:02 PM

Data Last Edit Date: 7/23/2026 7:59:02 PM

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