Layer: Crashes - 2013 (ID:0)

View In: Map Viewer

Name: Crashes - 2013

Display Field: CityName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: DOT_TRAFFICSAFETY.DOT_GIS.CRASHES2013_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:

Drawing Info:

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

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)
DidCrashOccurInWorkZone (type: esriFieldTypeString, alias: Did Crash Occur In Work Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
WorkZoneType (type: esriFieldTypeString, alias: Work Zone Type, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
WereWorkersPresent (type: esriFieldTypeString, alias: Were Workers Present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
WorkZone (type: esriFieldTypeString, alias: Work Zone, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/12/2018 4:15:42 PM

Schema Last Edit Date: 11/12/2018 4:15:42 PM

Data Last Edit Date: 11/12/2018 4:15:42 PM

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