View In:   ArcGIS Online Map Viewer

Name: Crash Data

Display Field: CITY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: CRASH_CRASH

Service Item Id: 199033e423794554b0ba64826d8baf93

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1000000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -1.0852567262325E7
YMin: 0
XMax: 0
YMax: 5388710.343505
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 0, 255, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CRASH_KEY ( type: esriFieldTypeDouble, alias: Crash Key, editable: true, nullable: true, defaultValue: null, modelName: CRASH_KEY )
• CASENUMBER ( type: esriFieldTypeDouble, alias: Case Number - Iowa DOT, editable: true, nullable: true, defaultValue: null, modelName: CASENUMBER )
• LECASENUM ( type: esriFieldTypeString, alias: Law Enforcement Case Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: LECASENUM )
• CRASH_DATE ( type: esriFieldTypeDate, alias: Date of Crash, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CRASH_DATE )
• CRASH_MONTH ( type: esriFieldTypeInteger, alias: Month of Crash, editable: true, nullable: true, defaultValue: null, modelName: MONTH_ , Coded Values: [1: January] , [2: February] , [3: March] , ...9 more... )
• CRASH_DAY ( type: esriFieldTypeInteger, alias: Day of Week, editable: true, nullable: true, defaultValue: null, modelName: DAY_ , Coded Values: [1: Sunday] , [2: Monday] , [3: Tuesday] , ...4 more... )
• TIMESTR ( type: esriFieldTypeString, alias: Time of Crash, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TIMESTR )
• DISTRICT ( type: esriFieldTypeInteger, alias: DOT District, editable: true, nullable: true, defaultValue: null, modelName: DISTRICT )
• COUNTY_NUMBER ( type: esriFieldTypeInteger, alias: County Number, editable: true, nullable: true, defaultValue: null, modelName: CNTY )
• CITY_NUMBER ( type: esriFieldTypeInteger, alias: City Number, editable: true, nullable: true, defaultValue: null, modelName: CITYNAME )
• SYSTEMSTR ( type: esriFieldTypeString, alias: Route with System, editable: true, nullable: true, length: 6, defaultValue: null, modelName: SYSTEMSTR )
• LITERAL ( type: esriFieldTypeString, alias: Derived Literal Description, editable: true, nullable: true, length: 120, defaultValue: null, modelName: LITERAL )
• FRSTHARM ( type: esriFieldTypeInteger, alias: First Harmful Event, editable: true, nullable: true, defaultValue: null, modelName: FRSTHARM , 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, editable: true, nullable: true, defaultValue: null, modelName: LOCFSTHRM , Coded Values: [1: On Roadway] , [2: Shoulder] , [3: Median] , ...5 more... )
• CRCOMNNR ( type: esriFieldTypeInteger, alias: Manner of Crash/Collision, editable: true, nullable: true, defaultValue: null, modelName: CRCOMNNR , 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, editable: true, nullable: true, defaultValue: null, modelName: MAJCSE , Coded Values: [1: Animal] , [2: Ran Traffic Signal] , [3: Ran Stop Sign] , ...71 more... )
• DRUGALC ( type: esriFieldTypeInteger, alias: Drug or Alcohol Related, editable: true, nullable: true, defaultValue: null, modelName: DRUGALC , Coded Values: [1: Drug] , [2: Alcohol (< Statutory)] , [3: Alcohol (Statutory)] , ...5 more... )
• ECNTCRC ( type: esriFieldTypeInteger, alias: Contributing Circumstances - Environment, editable: true, nullable: true, defaultValue: null, modelName: ECNTCRC , Coded Values: [1: None apparent] , [2: Weather conditions] , [3: Visual obstruction] , ...7 more... )
• LIGHT ( type: esriFieldTypeInteger, alias: Light Conditions, editable: true, nullable: true, defaultValue: null, modelName: LGHT , Coded Values: [1: Daylight] , [2: Dusk] , [3: Dawn] , ...5 more... )
• CSRFCND ( type: esriFieldTypeInteger, alias: Surface Conditions, editable: true, nullable: true, defaultValue: null, modelName: CSRFCND , Coded Values: [1: Dry] , [2: Wet] , [3: Ice/frost] , ...10 more... )
• WEATHER ( type: esriFieldTypeInteger, alias: Weather Conditions, editable: true, nullable: true, defaultValue: null, modelName: WEATHER , Coded Values: [1: Clear] , [2: Cloudy] , [3: Fog, smoke, smog] , ...10 more... )
• RCNTCRC ( type: esriFieldTypeInteger, alias: Contributing Circumstances - Roadway, editable: true, nullable: true, defaultValue: null, modelName: RCNTCRC , 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, editable: true, nullable: true, defaultValue: null, modelName: RDTYP , 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, editable: true, nullable: true, defaultValue: null, modelName: PAVED , Coded Values: [1: Paved] , [2: Unpaved] )
• WZRELATED ( type: esriFieldTypeInteger, alias: Work Zone Related?, editable: true, nullable: true, defaultValue: null, modelName: WZRELATED , Coded Values: [1: Lane closure] , [2: Lane switch/crossover] , [3: Work on shoulder or median] , ...4 more... )
• CSEV ( type: esriFieldTypeInteger, alias: Crash Severity, editable: true, nullable: true, defaultValue: null, modelName: CSEV , Coded Values: [1: Fatal] , [2: Major Injury] , [3: Minor Injury] , ...2 more... )
• FATALITIES ( type: esriFieldTypeInteger, alias: Number of Fatalities, editable: true, nullable: true, defaultValue: null, modelName: FATALITIES )
• INJURIES ( type: esriFieldTypeInteger, alias: Number of Injuries, editable: true, nullable: true, defaultValue: null, modelName: INJURIES )
• MAJINJURY ( type: esriFieldTypeInteger, alias: Number of Major Injuries, editable: true, nullable: true, defaultValue: null, modelName: MAJINJURY )
• MININJURY ( type: esriFieldTypeInteger, alias: Number of Minor Injuries, editable: true, nullable: true, defaultValue: null, modelName: MININJURY )
• POSSINJURY ( type: esriFieldTypeInteger, alias: Number of Possible Injuries, editable: true, nullable: true, defaultValue: null, modelName: POSSINJURY )
• UNKINJURY ( type: esriFieldTypeInteger, alias: Number of Unknown Injuries, editable: true, nullable: true, defaultValue: null, modelName: UNKINJURY )
• PROPDMG ( type: esriFieldTypeDouble, alias: Amount of Property Damage ($), editable: true, nullable: true, defaultValue: null, modelName: PROPDMG )
• VEHICLES ( type: esriFieldTypeInteger, alias: Number of Vehicles Involved, editable: true, nullable: true, defaultValue: null, modelName: VEHICLES )
• TOCCUPANTS ( type: esriFieldTypeInteger, alias: Total Number of Occupants, editable: true, nullable: true, defaultValue: null, modelName: TOCCUPANTS )
• REPORT ( type: esriFieldTypeInteger, alias: Report Type, editable: true, nullable: true, defaultValue: null, modelName: REPORT , Coded Values: [6: Driver] , [7: TraCS] , [8: Officer] )
• XCOORD ( type: esriFieldTypeDouble, alias: X Coordinate (UTM NAD 83 Zone 15), editable: true, nullable: true, defaultValue: null, modelName: XCOORD )
• YCOORD ( type: esriFieldTypeDouble, alias: Y Coordinate (UTM NAD 83 Zone 15), editable: true, nullable: true, defaultValue: null, modelName: YCOORD )
• REST_UPDATED ( type: esriFieldTypeDate, alias: Rest Service Last Updated, editable: false, nullable: true, length: 8, defaultValue: null, modelName: REST_UPDATED )
• REST_UPDATE_UTC_OFFSET ( type: esriFieldTypeString, alias: REST Service UTC Offset, editable: true, nullable: true, length: 6, defaultValue: null, modelName: UTC_OFFSET )
• CRASH_DATETIME ( type: esriFieldTypeDate, alias: Crash Date-Time (Local), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CRASH_DATETIME )
• CRASH_DATETIME_UTC ( type: esriFieldTypeDate, alias: Crash Date-Time (UTC), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CRASH_DATETIME_UTC )
• CRASH_DATETIME_UTC_OFFSET ( type: esriFieldTypeString, alias: Crash Date-Time UTC Offset, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CRASH_DATETIME_UTC_OFFSET )
• CITY_NAME ( type: esriFieldTypeString, alias: City Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CITY_NAME )
• COUNTY_NAME ( type: esriFieldTypeString, alias: County Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COUNTY_NAME )
• CARDINAL ( type: esriFieldTypeInteger, alias: Direction, editable: true, nullable: true, defaultValue: null, modelName: CARDINAL , Coded Values: [1: Northbound (NB)] , [2: Eastbound (EB)] , [3: Southbound (SB)] , ...7 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: Crash Data
  Description:
  Prototype:
  CARDINAL: null
  COUNTY_NAME: null
  CRASH_KEY: null
  CASENUMBER: null
  LECASENUM: null
  CRASH_DATE: null
  CRASH_MONTH: null
  CRASH_DAY: null
  TIMESTR: null
  DISTRICT: null
  COUNTY_NUMBER: null
  CITY_NUMBER: null
  SYSTEMSTR: null
  LITERAL: null
  FRSTHARM: null
  LOCFSTHRM: null
  CRCOMNNR: null
  MAJCSE: null
  DRUGALC: null
  ECNTCRC: null
  LIGHT: null
  CSRFCND: null
  WEATHER: null
  RCNTCRC: null
  RDTYP: null
  PAVED: null
  WZRELATED: null
  CSEV: null
  FATALITIES: null
  INJURIES: null
  MAJINJURY: null
  MININJURY: null
  POSSINJURY: null
  UNKINJURY: null
  PROPDMG: null
  VEHICLES: null
  TOCCUPANTS: null
  REPORT: null
  XCOORD: null
  YCOORD: null
  CITY_NAME: null
  REST_UPDATE_UTC_OFFSET: null
  CRASH_DATETIME: null
  CRASH_DATETIME_UTC: null
  CRASH_DATETIME_UTC_OFFSET: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Sync,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field:
• Creator Field:
• Edit Date Field: REST_UPDATED
• Editor Field:

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata