Name: AllCrashes_2018to2022_WillCountyStudyArea
Display Field: CountyName
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: This crash data is a product of IDOT’s Crash Information Section and has been modified by CMAP. Additional information about this dataset is described in CMAP's Safe Streets and Roads for All (SS4A) Technical Memo.
Copyright Text: Illinois Department of Transportation, Chicago Metropolitan Agency for Planning
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: 975620.174214218
YMin: 1652090.45853879
XMax: 1206496.30168157
YMax: 1847276.32442208
Spatial Reference: 102671 (3435)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}}},"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:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- Casenum (type: esriFieldTypeString, alias: Casenum, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- CrashID (type: esriFieldTypeDouble, alias: CrashID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CountyCode (type: esriFieldTypeInteger, alias: CountyCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CrashYear (type: esriFieldTypeString, alias: CrashYear, SQL Type: sqlTypeOther, length: 10, 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: esriFieldTypeInteger, alias: CrashHour, SQL Type: sqlTypeOther, 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: 15, nullable: true, editable: true)
- CollisionTypeCode (type: esriFieldTypeDouble, 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: 20, nullable: true, editable: true)
- AgencyCode (type: esriFieldTypeString, alias: AgencyCode, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- RouteNumber (type: esriFieldTypeDouble, alias: RouteNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Milestation (type: esriFieldTypeDouble, alias: Milestation, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ClassOfTrafficwayCode (type: esriFieldTypeInteger, alias: ClassOfTrafficwayCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NHS (type: esriFieldTypeString, alias: NHS, SQL Type: sqlTypeOther, length: 5, 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: 20, nullable: true, editable: true)
- TimeOfCrash (type: esriFieldTypeString, alias: TimeOfCrash, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- TrafficControlDeviceCondCode (type: esriFieldTypeInteger, alias: TrafficControlDeviceCondCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
- IntersectionRelated (type: esriFieldTypeString, alias: IntersectionRelated, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- HitAndRun (type: esriFieldTypeString, alias: HitAndRun, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- CrashDate (type: esriFieldTypeString, alias: CrashDate, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- NumberOfLanes (type: esriFieldTypeString, alias: NumberOfLanes, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- AlignmentCode (type: esriFieldTypeInteger, alias: AlignmentCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TrafficwayDescriptionCode (type: esriFieldTypeInteger, alias: TrafficwayDescriptionCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
- RoadwayFunctionalClassCode (type: esriFieldTypeInteger, alias: RoadwayFunctionalClassCode, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WorkZoneRelated (type: esriFieldTypeString, alias: WorkZoneRelated, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- CityTownshipFlag (type: esriFieldTypeString, alias: CityTownshipFlag, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- CrashLatitude (type: esriFieldTypeDouble, alias: CrashLatitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CrashLongitude (type: esriFieldTypeDouble, alias: CrashLongitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CountyName (type: esriFieldTypeString, alias: CountyName, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- DayOfWeek (type: esriFieldTypeString, alias: DayOfWeek, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- TypeOfCrash (type: esriFieldTypeString, alias: TypeOfCrash, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
- CityName (type: esriFieldTypeString, alias: CityName, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- CityClass (type: esriFieldTypeString, alias: CityClass, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- ClassOfTrafficWay (type: esriFieldTypeString, alias: ClassOfTrafficWay, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- Cause1 (type: esriFieldTypeString, alias: Cause1, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- Cause2 (type: esriFieldTypeString, alias: Cause2, SQL Type: sqlTypeOther, length: 55, 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: 20, nullable: true, editable: true)
- RoadSurfaceCond (type: esriFieldTypeString, alias: RoadSurfaceCond, SQL Type: sqlTypeOther, length: 20, 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: 20, nullable: true, editable: true)
- LightingCond (type: esriFieldTypeString, alias: LightingCond, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- WeatherCond (type: esriFieldTypeString, alias: WeatherCond, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- RoadAlignment (type: esriFieldTypeString, alias: RoadAlignment, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- TrafficwayDescrip (type: esriFieldTypeString, alias: TrafficwayDescrip, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- RoadwayFunctionalClass (type: esriFieldTypeString, alias: RoadwayFunctionalClass, SQL Type: sqlTypeOther, length: 55, nullable: true, editable: true)
- InvestigatingAgencyDescrip (type: esriFieldTypeString, alias: InvestigatingAgencyDescrip, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- CrashInjurySeverityCode (type: esriFieldTypeString, alias: CrashInjurySeverityCode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- DamagedProperty1 (type: esriFieldTypeString, alias: DamagedProperty1, SQL Type: sqlTypeOther, length: 197, nullable: true, editable: true)
- DamagedProperty2 (type: esriFieldTypeString, alias: DamagedProperty2, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
- AgencyYear (type: esriFieldTypeString, alias: AgencyYear, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- AgencyNumber (type: esriFieldTypeString, alias: AgencyNumber, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- BarCode (type: esriFieldTypeString, alias: BarCode, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- WorkZone1 (type: esriFieldTypeString, alias: WorkZone1, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- WorkZoneType (type: esriFieldTypeString, alias: WorkZoneType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- WorkersPresent (type: esriFieldTypeString, alias: WorkersPresent, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- WorkZone2 (type: esriFieldTypeString, alias: WorkZone2, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- AccessControl (type: esriFieldTypeString, alias: AccessControl, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- FlowCondition (type: esriFieldTypeString, alias: FlowCondition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- DidInvolveSecondaryCrash (type: esriFieldTypeString, alias: DidInvolveSecondaryCrash, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- UrbanRural (type: esriFieldTypeString, alias: UrbanRural, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- Toll (type: esriFieldTypeString, alias: Toll, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- TypeOfReport (type: esriFieldTypeString, alias: TypeOfReport, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ISP_Expressway_Flag (type: esriFieldTypeSmallInteger, alias: ISP_Expressway_Flag, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Intersection_ID (type: esriFieldTypeInteger, alias: Intersection_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: AllCrashes_2018to2022_WillCountyStudyArea
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 11/4/2024 1:13:12 PM
Schema Last Edit Date: 11/4/2024 1:13:12 PM
Data Last Edit Date: 11/4/2024 1:05:27 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat