Layer: CRASHES_2021 (ID:0)

View In: Map Viewer

Name: CRASHES_2021

Display Field: CityName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[72,86,168,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:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ICN (type: esriFieldTypeString, alias: ICN, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
CrashID (type: esriFieldTypeString, alias: CrashID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
CountyCode (type: esriFieldTypeSmallInteger, alias: CountyCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
CrashYr (type: esriFieldTypeString, alias: CrashYr, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
CrashMonth (type: esriFieldTypeSmallInteger, alias: CrashMonth, SQL Type: sqlTypeOther, nullable: true, editable: true)
CrashDay (type: esriFieldTypeSmallInteger, alias: CrashDay, SQL Type: sqlTypeOther, nullable: true, editable: true)
NumberOfVehicles (type: esriFieldTypeSmallInteger, alias: NumberOfVehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
DayOfWeekCode (type: esriFieldTypeSmallInteger, alias: DayOfWeekCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
CrashHour (type: esriFieldTypeString, alias: CrashHour, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
CityCode (type: esriFieldTypeSmallInteger, alias: CityCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
CityClassCode (type: esriFieldTypeSmallInteger, alias: CityClassCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
Township (type: esriFieldTypeString, alias: Township, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
CollisionTypeCode (type: esriFieldTypeSmallInteger, alias: CollisionTypeCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
TotalFatals (type: esriFieldTypeSmallInteger, alias: TotalFatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
TotalInjured (type: esriFieldTypeSmallInteger, alias: TotalInjured, SQL Type: sqlTypeOther, nullable: true, editable: true)
NoInjuries (type: esriFieldTypeSmallInteger, alias: NoInjuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
AInjuries (type: esriFieldTypeSmallInteger, alias: AInjuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
BInjuries (type: esriFieldTypeSmallInteger, alias: BInjuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
CInjuries (type: esriFieldTypeSmallInteger, alias: CInjuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
CrashSeverity (type: esriFieldTypeString, alias: CrashSeverity, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
AgencyCode (type: esriFieldTypeSmallInteger, alias: AgencyCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
RouteNumber (type: esriFieldTypeInteger, alias: RouteNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
Milestation (type: esriFieldTypeDouble, alias: Milestation, SQL Type: sqlTypeOther, nullable: true, editable: true)
ClassOfTrafficwayCode (type: esriFieldTypeSmallInteger, alias: ClassOfTrafficwayCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
NHS (type: esriFieldTypeString, alias: NHS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
TrafficControlDeviceCode (type: esriFieldTypeSmallInteger, alias: TrafficControlDeviceCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
RoadSurfaceConditionCode (type: esriFieldTypeSmallInteger, alias: RoadSurfaceConditionCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
RoadDefectsCode (type: esriFieldTypeSmallInteger, alias: RoadDefectsCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
LightConditionCode (type: esriFieldTypeSmallInteger, alias: LightConditionCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
WeatherCode (type: esriFieldTypeSmallInteger, alias: WeatherCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
Cause1Code (type: esriFieldTypeString, alias: Cause1Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
Cause2Code (type: esriFieldTypeString, alias: Cause2Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
RailroadCrossingNumber (type: esriFieldTypeString, alias: RailroadCrossingNumber, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
TimeOfCrash (type: esriFieldTypeString, alias: TimeOfCrash, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
TrafficControlDeviceCondCode (type: esriFieldTypeSmallInteger, alias: TrafficControlDeviceCondCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
IntersectionRelated (type: esriFieldTypeString, alias: IntersectionRelated, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
HitAndRun (type: esriFieldTypeString, alias: HitAndRun, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
CrashDate (type: esriFieldTypeDate, alias: CrashDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
NumberOfLanes (type: esriFieldTypeString, alias: NumberOfLanes, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
AlignmentCode (type: esriFieldTypeSmallInteger, alias: AlignmentCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
TrafficwayDescriptionCode (type: esriFieldTypeSmallInteger, alias: TrafficwayDescriptionCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
RoadwayFunctionalClassCode (type: esriFieldTypeSmallInteger, alias: RoadwayFunctionalClassCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
WorkZoneRelated (type: esriFieldTypeString, alias: WorkZoneRelated, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
City_Township_Flag (type: esriFieldTypeString, alias: City_Township_Flag, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
TSCrashCoordinateX (type: esriFieldTypeDouble, alias: TSCrashCoordinateX, SQL Type: sqlTypeOther, nullable: true, editable: true)
TSCrashCoordinateY (type: esriFieldTypeDouble, alias: TSCrashCoordinateY, SQL Type: sqlTypeOther, nullable: true, editable: true)
TSCrashLatitude (type: esriFieldTypeDouble, alias: TSCrashLatitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
TSCrashLongitude (type: esriFieldTypeDouble, alias: TSCrashLongitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
CrashReportCounty (type: esriFieldTypeString, alias: CrashReportCounty, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
DayOfWeek (type: esriFieldTypeString, alias: DayOfWeek, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
TypeOfFirstCrash (type: esriFieldTypeString, alias: TypeOfFirstCrash, SQL Type: sqlTypeOther, length: 28, nullable: true, editable: true)
CityName (type: esriFieldTypeString, alias: CityName, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
CityClass (type: esriFieldTypeString, alias: CityClass, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ClassOfTrafficway (type: esriFieldTypeString, alias: ClassOfTrafficway, SQL Type: sqlTypeOther, length: 26, nullable: true, editable: true)
Cause1 (type: esriFieldTypeString, alias: Cause1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
Cause2 (type: esriFieldTypeString, alias: Cause2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
TrafficControlDevice (type: esriFieldTypeString, alias: TrafficControlDevice, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
TrafficControlDeviceCond (type: esriFieldTypeString, alias: TrafficControlDeviceCond, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
RoadSurfaceCond (type: esriFieldTypeString, alias: RoadSurfaceCond, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
RoadDefects (type: esriFieldTypeString, alias: RoadDefects, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
CrashInjurySeverity (type: esriFieldTypeString, alias: CrashInjurySeverity, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
LightingCond (type: esriFieldTypeString, alias: LightingCond, SQL Type: sqlTypeOther, length: 23, nullable: true, editable: true)
WeatherCond (type: esriFieldTypeString, alias: WeatherCond, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
RoadAlignment (type: esriFieldTypeString, alias: RoadAlignment, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true)
TrafficwayDescrip (type: esriFieldTypeString, alias: TrafficwayDescrip, SQL Type: sqlTypeOther, length: 27, nullable: true, editable: true)
RoadwayFunctionalClass (type: esriFieldTypeString, alias: RoadwayFunctionalClass, SQL Type: sqlTypeOther, length: 41, nullable: true, editable: true)
InvestigatingAgencyDescrip (type: esriFieldTypeString, alias: InvestigatingAgencyDescrip, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
CrashSeverityCd (type: esriFieldTypeString, alias: CrashSeverityCd, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
DamagedProperty1 (type: esriFieldTypeString, alias: DamagedProperty1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DamagedProperty2 (type: esriFieldTypeString, alias: DamagedProperty2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
AgencyReportYear (type: esriFieldTypeString, alias: AgencyReportYear, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
AgencyReportNumber (type: esriFieldTypeString, alias: AgencyReportNumber, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
SFE (type: esriFieldTypeString, alias: SFE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
DidCrashOccurInWorkZone (type: esriFieldTypeString, alias: DidCrashOccurInWorkZone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
WorkZoneType (type: esriFieldTypeString, alias: WorkZoneType, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
WereWorkersPresent (type: esriFieldTypeString, alias: WereWorkersPresent, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
WorkZone (type: esriFieldTypeString, alias: WorkZone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
AccessControl (type: esriFieldTypeString, alias: AccessControl, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
FlowCondition (type: esriFieldTypeString, alias: FlowCondition, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
DidInvolveSecondaryCrash (type: esriFieldTypeString, alias: DidInvolveSecondaryCrash, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
Toll (type: esriFieldTypeString, alias: Toll, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
UrbanRural (type: esriFieldTypeString, alias: UrbanRural, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/17/2025 5:17:12 PM

Schema Last Edit Date: 7/17/2025 5:17:12 PM

Data Last Edit Date: 7/23/2023 12:35:15 AM

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