Name: Vehicle Data
Display Field: VEH_CRASH_KEY
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description: General vehicle-specific 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)
- VEH_CRASH_KEY (type: esriFieldTypeDouble, alias: Crash Key, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VEH_UNITKEY (type: esriFieldTypeDouble, alias: Unit Key, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CASENUMBER (type: esriFieldTypeDouble, alias: Iowa DOT Case Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DRIVERAGE (type: esriFieldTypeInteger, alias: Driver Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DRIVERGEN (type: esriFieldTypeString, alias: Driver Gender, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [M: Male], [F: Female], [U: Unknown], ... 1 more ...)
- DL_STATE (type: esriFieldTypeString, alias: Driver's License State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [AL: Alabama], [AK: Alaska], [AZ: Arizona], ... 49 more ...)
- CHARGED (type: esriFieldTypeInteger, alias: Driver Charged, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Not Applicable], ... 2 more ...)
- ALCRESULT (type: esriFieldTypeDouble, alias: Alcohol Test Results, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DRUGTEST (type: esriFieldTypeInteger, alias: Drug Test Given?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Blood], [3: Urine], ... 4 more ...)
- DRUGRESULT (type: esriFieldTypeInteger, alias: Drug Test Results, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Negative], [2: Cannabis], [3: Central Nervous Sys. depressants], ... 8 more ...)
- DRIVERCOND (type: esriFieldTypeInteger, alias: Driver Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Apparently normal], [2: Emotional (e.g. depressed, angry)], [3: Asleep/fatigued], ... 13 more ...)
- VISIONOBS (type: esriFieldTypeInteger, alias: Vision Obscured, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Not obscured], [2: Trees/crops], [3: Embankment], ... 18 more ...)
- DCONTCIRC1 (type: esriFieldTypeInteger, alias: Contributing Circumstances 1 - Driver, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Ran traffic signal], [2: Ran stop sign], [3: Exceeded authorized speed], ... 46 more ...)
- DCONTCIRC2 (type: esriFieldTypeInteger, alias: Contributing Circumstances 2 - Driver, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Ran traffic signal], [2: Ran stop sign], [3: Exceeded authorized speed], ... 46 more ...)
- VCONFIG (type: esriFieldTypeInteger, alias: Vehicle Configuration, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Passenger car], [2: Four-tire light truck (pick-up/panel)], [3: Sport utility vehicle], ... 36 more ...)
- CARGOBODY (type: esriFieldTypeInteger, alias: Cargo Body Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Not applicable], [2: Van/enclosed box], [3: Dump (grain/gravel)], ... 20 more ...)
- VYEAR (type: esriFieldTypeInteger, alias: Vehicle Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MAKE (type: esriFieldTypeString, alias: Vehicle Make, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- MODEL (type: esriFieldTypeString, alias: Vehicle Model, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- STYLE (type: esriFieldTypeString, alias: Vehicle Style, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- VLP_STATE (type: esriFieldTypeString, alias: License Plate State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- OCCUPANTS (type: esriFieldTypeInteger, alias: Vehicle Occupants, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VACTION (type: esriFieldTypeInteger, alias: Vehicle Action, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Movement essentially straight], [2: Turning left], [3: Turning right], ... 18 more ...)
- SEQEVENTS1 (type: esriFieldTypeInteger, alias: Sequence of Events 1st Event, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Pre-crash events: Ran off road - right], [2: Pre-crash events: Ran off road - straight], [3: Pre-crash events: Ran off road - left], ... 63 more ...)
- SEQEVENTS2 (type: esriFieldTypeInteger, alias: Sequence of Events 2nd Event, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Pre-crash events: Ran off road - right], [2: Pre-crash events: Ran off road - straight], [3: Pre-crash events: Ran off road - left], ... 63 more ...)
- SEQEVENTS3 (type: esriFieldTypeInteger, alias: Sequence of Events 3rd Event, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Pre-crash events: Ran off road - right], [2: Pre-crash events: Ran off road - straight], [3: Pre-crash events: Ran off road - left], ... 63 more ...)
- SEQEVENTS4 (type: esriFieldTypeInteger, alias: Sequence of Events 4th Event, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Pre-crash events: Ran off road - right], [2: Pre-crash events: Ran off road - straight], [3: Pre-crash events: Ran off road - left], ... 63 more ...)
- MOSTHARM (type: esriFieldTypeInteger, alias: Most Harmful Event, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Pre-crash events: Ran off road - right], [2: Pre-crash events: Ran off road - straight], [3: Pre-crash events: Ran off road - left], ... 63 more ...)
- SPEEDLIMIT (type: esriFieldTypeInteger, alias: Speed Limit, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0 MPH], [5: 5 MPH], [10: 10 MPH], ... 13 more ...)
- TRAFCONT (type: esriFieldTypeInteger, alias: Traffic Controls, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: No controls present], [2: Traffic signals], [3: Flashing traffic control signal], ... 13 more ...)
- FIXOBJSTR (type: esriFieldTypeInteger, alias: Fixed Object Struck, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bridge overhead structure], [2: Bridge pier or support], [3: Bridge/bridge rail parapet], ... 25 more ...)
- MOSTDAMAGE (type: esriFieldTypeInteger, alias: Most Damaged Area, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Front - passenger side corner], [2: Passenger side - front], [3: Passenger side - middle], ... 16 more ...)
- DAMAGE (type: esriFieldTypeInteger, alias: Extent of Damage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: None], [2: Minor damage], [3: Functional damage], ... 4 more ...)
- CSEVERITY (type: esriFieldTypeInteger, alias: Crash Severity, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Fatal], [2: Major Injury], [3: Minor Injury], ... 2 more ...)
- MAJORCAUSE (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 ...)
- CSURFCOND (type: esriFieldTypeInteger, alias: Crash Surface Conditions, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Dry], [2: Wet], [3: Ice/frost], ... 10 more ...)
- DRUGALCREL (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 ...)
- ROADTYPE (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 ...)
- WZ_RELATED (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 ...)
- FATALITIES (type: esriFieldTypeInteger, alias: Number of Fatalities, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CRASH_YEAR (type: esriFieldTypeInteger, alias: Year of Crash, SQL Type: sqlTypeOther, nullable: true, editable: true)
- 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)
- FROM_MEASURE (type: esriFieldTypeDouble, alias: From Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TO_MEASURE (type: esriFieldTypeDouble, alias: To Measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ROUTEID (type: esriFieldTypeString, alias: Route ID, SQL Type: sqlTypeOther, length: 15, 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)
- REST_UPDATED (type: esriFieldTypeDate, alias: REST Service Last Updated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- REST_UPDATED_UTC_OFFSET (type: esriFieldTypeString, alias: REST Service Last Updated UTC Offset, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
- GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: Vehicle Data
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/20/2020 2:18:27 PM
Schema Last Edit Date: 10/20/2020 2:11:42 PM
Data Last Edit Date: 10/20/2020 2:11:42 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates