Name: Crash Data
Display Field: CITY_NAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description: General crash-wide data from the prior 10 years. Data compiled in this format for the Traffic Safety Data and Analysis website (www.iowadot.gov/tsda)
Copyright Text: Iowa Department of Transportation - Bureau of Traffic & Safety
Min. Scale: 1000000
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON
Use Standardized Queries: True
Extent:
XMin: -10758327.4891625
YMin: 4899872.504225
XMax: -10036711.032895
YMax: 5388542.9367025
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,255,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true
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: GLOBALID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- CRASH_KEY (type: esriFieldTypeDouble, alias: Crash Key, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CASENUMBER (type: esriFieldTypeDouble, alias: Case Number - Iowa DOT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LECASENUM (type: esriFieldTypeString, alias: Law Enforcement Case Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- CRASH_DATE (type: esriFieldTypeDate, alias: Date of Crash, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CRASH_MONTH (type: esriFieldTypeInteger, alias: Month of Crash, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: January], [2: February], [3: March], ... 9 more ...)
- CRASH_DAY (type: esriFieldTypeInteger, alias: Day of Week, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Sunday], [2: Monday], [3: Tuesday], ... 4 more ...)
- TIMESTR (type: esriFieldTypeString, alias: Time of Crash, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- DISTRICT (type: esriFieldTypeInteger, alias: DOT District, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COUNTY_NUMBER (type: esriFieldTypeInteger, alias: County Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CITY_NUMBER (type: esriFieldTypeInteger, alias: City Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SYSTEMSTR (type: esriFieldTypeString, alias: Route with System, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- LITERAL (type: esriFieldTypeString, alias: Derived Literal Description, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
- FRSTHARM (type: esriFieldTypeInteger, alias: First Harmful Event, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [20: Non-collision events: Overturn/rollover], [21: Non-collision events: Jackknife], [22: Non-collision events: Non-contact vehicle (phantom)], ... 49 more ...)
- LOCFSTHRM (type: esriFieldTypeInteger, alias: Location of First Harmful Event, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: On Roadway], [2: Shoulder], [3: Median], ... 5 more ...)
- CRCOMNNR (type: esriFieldTypeInteger, alias: Manner of Crash/Collision, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Non-collision (single vehicle)], [2: Head-on (front to front)], [3: Rear-end (front to rear)], ... 9 more ...)
- MAJCSE (type: esriFieldTypeInteger, alias: Major Cause, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Animal], [2: Ran Traffic Signal], [3: Ran Stop Sign], ... 71 more ...)
- DRUGALC (type: esriFieldTypeInteger, alias: Drug or Alcohol Related, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Drug], [2: Alcohol (< Statutory)], [3: Alcohol (Statutory)], ... 5 more ...)
- ECNTCRC (type: esriFieldTypeInteger, alias: Contributing Circumstances - Environment, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None apparent], [2: Weather conditions], [3: Visual obstruction], ... 7 more ...)
- LIGHT (type: esriFieldTypeInteger, alias: Light Conditions, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Daylight], [2: Dusk], [3: Dawn], ... 5 more ...)
- CSRFCND (type: esriFieldTypeInteger, alias: Surface Conditions, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Dry], [2: Wet], [3: Ice/frost], ... 10 more ...)
- WEATHER (type: esriFieldTypeInteger, alias: Weather Conditions, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Clear], [2: Cloudy], [3: Fog, smoke, smog], ... 10 more ...)
- RCNTCRC (type: esriFieldTypeInteger, alias: Contributing Circumstances - Roadway, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None apparent], [2: Surface condition (e.g.wet, icy)], [3: Debris], ... 14 more ...)
- RDTYP (type: esriFieldTypeInteger, alias: Type of Roadway Junction / Feature, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Non-intersection: Non-junction/no special feature], [2: Non-intersection: Bike lanes], [3: Non-intersection: Railroad grade crossing], ... 23 more ...)
- PAVED (type: esriFieldTypeInteger, alias: Paved or Not, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Paved], [2: Unpaved])
- WZRELATED (type: esriFieldTypeInteger, alias: Work Zone Related?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Lane closure], [2: Lane switch/crossover], [3: Work on shoulder or median], ... 4 more ...)
- CSEV (type: esriFieldTypeInteger, alias: Crash Severity, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Fatal], [2: Major Injury], [3: Minor Injury], ... 2 more ...)
- FATALITIES (type: esriFieldTypeInteger, alias: Number of Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
- INJURIES (type: esriFieldTypeInteger, alias: Number of Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAJINJURY (type: esriFieldTypeInteger, alias: Number of Major Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MININJURY (type: esriFieldTypeInteger, alias: Number of Minor Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
- POSSINJURY (type: esriFieldTypeInteger, alias: Number of Possible Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UNKINJURY (type: esriFieldTypeInteger, alias: Number of Unknown Injuries, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PROPDMG (type: esriFieldTypeDouble, alias: Amount of Property Damage ($), SQL Type: sqlTypeOther, nullable: true, editable: true)
- VEHICLES (type: esriFieldTypeInteger, alias: Number of Vehicles Involved, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TOCCUPANTS (type: esriFieldTypeInteger, alias: Total Number of Occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
- REPORT (type: esriFieldTypeInteger, alias: Report Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [6: Driver], [7: TraCS], [8: Officer])
- XCOORD (type: esriFieldTypeDouble, alias: X Coordinate (UTM NAD 83 Zone 15), SQL Type: sqlTypeOther, nullable: true, editable: true)
- YCOORD (type: esriFieldTypeDouble, alias: Y Coordinate (UTM NAD 83 Zone 15), SQL Type: sqlTypeOther, nullable: true, editable: true)
- REST_UPDATED (type: esriFieldTypeDate, alias: Rest Service Last Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- REST_UPDATE_UTC_OFFSET (type: esriFieldTypeString, alias: REST Service UTC Offset, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- CRASH_DATETIME (type: esriFieldTypeDate, alias: Crash Date-Time (Local), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CRASH_DATETIME_UTC (type: esriFieldTypeDate, alias: Crash Date-Time (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CRASH_DATETIME_UTC_OFFSET (type: esriFieldTypeString, alias: Crash Date-Time UTC Offset, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- CITY_NAME (type: esriFieldTypeString, alias: City Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- COUNTY_NAME (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- CARDINAL (type: esriFieldTypeInteger, alias: Direction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Northbound (NB)], [2: Eastbound (EB)], [3: Southbound (SB)], ... 7 more ...)
- GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: Crash Data
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/19/2020 7:23:57 PM
Schema Last Edit Date: 10/19/2020 7:23:57 PM
Data Last Edit Date: 10/19/2020 7:23:57 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates