Layers:

Layer: Crashes - 2012 (0)


Name: Crashes - 2012

Display Field: CityName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: DOT_TRAFFICSAFETY.DOT_GIS.CRASHES2012_SDMExtract

Copyright Text:

Min. Scale: 250000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1937650.87499125
YMin: 8.26567411422729E-05
XMax: 3051759.50011599
YMax: 2130862.00016116
Spatial Reference: 102672 (3436)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[230,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,255,255],"width":0.75}}},"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: esriFieldTypeString, alias: Illinois Case Number (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: County Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashYr (type: esriFieldTypeString, alias: Crash Year, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CrashMonth (type: esriFieldTypeSmallInteger, alias: Crash Month, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashDay (type: esriFieldTypeSmallInteger, alias: Crash Day, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NumberOfVehicles (type: esriFieldTypeSmallInteger, alias: Number Of Vehicles, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DayOfWeekCode (type: esriFieldTypeSmallInteger, alias: Day Of Week Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashHour (type: esriFieldTypeString, alias: Crash Hour, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• CityCode (type: esriFieldTypeSmallInteger, alias: City Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CityClassCode (type: esriFieldTypeSmallInteger, alias: City Class Code, 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: Collision Type Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalFatals (type: esriFieldTypeSmallInteger, alias: Total Fatals, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalInjured (type: esriFieldTypeSmallInteger, alias: Total Injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NoInjuries (type: esriFieldTypeSmallInteger, alias: No Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AInjuries (type: esriFieldTypeSmallInteger, alias: Incapacitating Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BInjuries (type: esriFieldTypeSmallInteger, alias: Non-incapacitating Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CInjuries (type: esriFieldTypeSmallInteger, alias: Possible Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CrashSeverity (type: esriFieldTypeString, alias: Crash Severity, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• AgencyCode (type: esriFieldTypeSmallInteger, alias: Agency Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RouteNumber (type: esriFieldTypeInteger, alias: Route Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Milestation (type: esriFieldTypeDouble, alias: Mile Station, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ClassOfTrafficwayCode (type: esriFieldTypeSmallInteger, alias: Class Of Trafficway Code, 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: Traffic Control Device Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RoadSurfaceConditionCode (type: esriFieldTypeSmallInteger, alias: Road Surface Condition Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RoadDefectsCode (type: esriFieldTypeSmallInteger, alias: Road Defects Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LightConditionCode (type: esriFieldTypeSmallInteger, alias: Light Condition Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WeatherCode (type: esriFieldTypeSmallInteger, alias: Weather Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cause1Code (type: esriFieldTypeString, alias: Primary Cause Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Cause2Code (type: esriFieldTypeString, alias: Secondary Cause Code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• RailroadCrossingNumber (type: esriFieldTypeString, alias: Railroad Crossing Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TimeOfCrash (type: esriFieldTypeString, alias: Time Of Crash, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TrafficControlDeviceCondCode (type: esriFieldTypeSmallInteger, alias: Traffic Control Device Cond Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IntersectionRelated (type: esriFieldTypeString, alias: Intersection Related, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• HitAndRun (type: esriFieldTypeString, alias: Hit And Run, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• CrashDate (type: esriFieldTypeString, alias: Crash Date, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• NumberOfLanes (type: esriFieldTypeString, alias: Number Of Lanes, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• AlignmentCode (type: esriFieldTypeSmallInteger, alias: Alignment Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TrafficwayDescriptionCode (type: esriFieldTypeSmallInteger, alias: Trafficway Description Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RoadwayFunctionalClassCode (type: esriFieldTypeSmallInteger, alias: Roadway Functional Class Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WorkZoneRelated (type: esriFieldTypeString, alias: Work Zone Related, 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: Crash Report County, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DayOfWeek (type: esriFieldTypeString, alias: Day Of Week, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• TypeOfFirstCrash (type: esriFieldTypeString, alias: Type Of First Crash, SQL Type: sqlTypeOther, length: 28, nullable: true, editable: true)
• CityName (type: esriFieldTypeString, alias: City Name, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• CityClass (type: esriFieldTypeString, alias: City Class, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ClassOfTrafficway (type: esriFieldTypeString, alias: Class Of Trafficway, SQL Type: sqlTypeOther, length: 26, nullable: true, editable: true)
• Cause1 (type: esriFieldTypeString, alias: Primary Cause, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Cause2 (type: esriFieldTypeString, alias: Secondary Cause, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• TrafficControlDevice (type: esriFieldTypeString, alias: Traffic Control Device, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• TrafficControlDeviceCond (type: esriFieldTypeString, alias: Traffic Control Device Cond, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• RoadSurfaceCond (type: esriFieldTypeString, alias: Road Surface Cond, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
• RoadDefects (type: esriFieldTypeString, alias: Road Defects, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CrashInjurySeverity (type: esriFieldTypeString, alias: Crash Injury Severity, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• LightingCond (type: esriFieldTypeString, alias: Lighting Cond, SQL Type: sqlTypeOther, length: 23, nullable: true, editable: true)
• WeatherCond (type: esriFieldTypeString, alias: Weather Cond, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
• RoadAlignment (type: esriFieldTypeString, alias: Road Alignment, SQL Type: sqlTypeOther, length: 21, nullable: true, editable: true)
• TrafficwayDescrip (type: esriFieldTypeString, alias: Trafficway Descrip, SQL Type: sqlTypeOther, length: 27, nullable: true, editable: true)
• RoadwayFunctionalClass (type: esriFieldTypeString, alias: Roadway Functional Class, SQL Type: sqlTypeOther, length: 41, nullable: true, editable: true)
• InvestigatingAgencyDescrip (type: esriFieldTypeString, alias: Investigating Agency Descrip, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• CrashSeverityCd (type: esriFieldTypeString, alias: Crash Severity Code, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• DamagedProperty1 (type: esriFieldTypeString, alias: Damaged Property 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DamagedProperty2 (type: esriFieldTypeString, alias: Damaged Property 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AgencyReportYear (type: esriFieldTypeString, alias: Agency Report Year, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• AgencyReportNumber (type: esriFieldTypeString, alias: Agency Report Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SFE (type: esriFieldTypeString, alias: SFE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)

Templates:

Name: Crashes - 2012
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/28/2023 9:25:22 PM

Schema Last Edit Date: 12/28/2023 9:25:22 PM

Data Last Edit Date: 11/12/2018 4:35:18 PM