View In:   ArcGIS Online Map Viewer

Name: Historic Road Conditions

Display Field: NAMEID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Authoritative Iowa Winter Road Conditions for 2024-2025. Records are the first instance of when the data changed. This was done to reduce the number of records to only when the attributes of the event were modified.

Service Item Id: 0d53789a896949e0b816b1b951941581

Copyright Text: Iowa Department of Transportation

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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.07570959107825E7
YMin: 4922100.19324
XMax: -1.0036668137115E7
YMax: 5388546.469005
Spatial Reference: 102100  (3857)  VCSWkid(105790)  LatestVCSWkid(3855)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 112, 255, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SEGMENT_ID ( type: esriFieldTypeInteger, alias: Segment ID, editable: true, nullable: true, defaultValue: null, modelName: SEGMENT_ID )
• ROUTE ( type: esriFieldTypeString, alias: Route ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ROUTE )
• NAMEID ( type: esriFieldTypeString, alias: Route Name ID, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NAMEID )
• LONG_NAME ( type: esriFieldTypeString, alias: Route Description, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LONGNAME )
• DISTRICT ( type: esriFieldTypeString, alias: Cost Center Circles, editable: true, nullable: true, length: 150, defaultValue: null, modelName: DISTRICT )
• SUBAREA ( type: esriFieldTypeString, alias: Cost Center Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBAREA )
• EVENT_ID ( type: esriFieldTypeString, alias: CARS Event ID, editable: true, nullable: true, length: 32, defaultValue: null, modelName: EVENT_ID )
• HL_PAVEMENT_CONDITION ( type: esriFieldTypeString, alias: CARS HL Pavement Condition, editable: true, nullable: true, length: 254, defaultValue: null, modelName: HL_PAVEMENT_CONDITION )
• LOC_LINK_DIRECTION ( type: esriFieldTypeString, alias: Location Link Direction, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LOC_LINK_DIRECTION )
• ROAD_CONDITION ( type: esriFieldTypeString, alias: Road Condition, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ROAD_CONDITION )
• CARS_MSG_UPDATE_DATE ( type: esriFieldTypeDate, alias: CARS Message Update Date (UTC), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CARS_MSG_UPDATE_DATE )
• CARS_MSG_INITIAL_DATE ( type: esriFieldTypeDate, alias: CARS Message Initial Date (UTC), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CARS_MSG_INITIAL_DATE )
• PH_PAVEMENT_CONDITION ( type: esriFieldTypeString, alias: CARS Phrase Pavement Condition, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PH_PAVEMENT_CONDITION )
• DISTRICT_NUMBER ( type: esriFieldTypeSmallInteger, alias: DOT District, editable: true, nullable: true, defaultValue: null, modelName: DISTRICT_NO )
• COST_CENTER ( type: esriFieldTypeString, alias: Cost Center Number, editable: true, nullable: true, length: 6, defaultValue: null, modelName: COST_CENTER )
• CONDITION_NOT_NORMAL_START ( type: esriFieldTypeDate, alias: Road Condition Not Normal Start Time (UTC), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITION_NOT_NORMAL_START )
• CONDITION_NOT_NORMAL_END ( type: esriFieldTypeDate, alias: Road Condition Not Normal End Time (UTC), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITION_NOT_NORMAL_END )
• CONDITION_NOT_NORMAL_ELAPSED ( type: esriFieldTypeDouble, alias: Total Elapsed Time Segment Not Normal (Hours), editable: true, nullable: true, defaultValue: null, modelName: CONDITION_NOT_NORMAL_ELAPSED )
• ROUTE_NAME ( type: esriFieldTypeString, alias: Route Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ROUTE_NAME )
• HIST_RECORD_UTC_OFFSET ( type: esriFieldTypeString, alias: REST Service Last Updated UTC Offset, editable: true, nullable: true, length: 6, defaultValue: null, modelName: UTC_OFFSET )
• ROUTE_SEG_INDEX ( type: esriFieldTypeInteger, alias: Route Segment Index, editable: true, nullable: true, defaultValue: null, modelName: ROUTE_SEG_INDEX )
• MSG_UPDATE_UTC_OFFSET ( type: esriFieldTypeString, alias: CARS Update Message Date UTC Offset, editable: true, nullable: true, length: 6, defaultValue: null, modelName: UPDATE_UTC_OFFSET )
• MSG_INITIAL_UTC_OFFSET ( type: esriFieldTypeString, alias: CARS Initial Message Date UTC Offset, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ISSUE_UTC_OFFSET )
• HISTORIC_RECORD_WRITTEN ( type: esriFieldTypeDate, alias: DateTime Record Written to History, editable: false, nullable: true, length: 8, defaultValue: null, modelName: REST_UPDATED )
• PREVIOUS_ROAD_CONDITION ( type: esriFieldTypeString, alias: Previous Road Condition, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PREVIOUS_ROAD_CONDITION )
• CONDITION_CHANGE ( type: esriFieldTypeString, alias: Road Condition Change, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION_CHANGE )
• SEGMENT_LENGTH_MI ( type: esriFieldTypeDouble, alias: Segment Length (Mile - State Plane), editable: true, nullable: true, defaultValue: null, modelName: SEGMENT_LENGTH_MI )
• SEGMENT_MAP_CODE ( type: esriFieldTypeString, alias: Segment Map Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SEGMENT_MAP_CODE )
• ROAD_CONDITION_CODE ( type: esriFieldTypeSmallInteger, alias: Road Condition Code, editable: true, nullable: true, defaultValue: null, modelName: CONDITION_CODE )
• PREVIOUS_CONDITION_HL_PHRASE ( type: esriFieldTypeString, alias: Previous Road Conditon Headline, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PREVIOUS_CONDITION_HL_PHRASE )
• PREVIOUS_CONDITION_PH_PHRASE ( type: esriFieldTypeString, alias: Previous Condition PH Phrase, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PREVIOUS_CONDITION_PH_PHRASE )
• CONDITION_CHANGE_START ( type: esriFieldTypeDate, alias: Change in Road Condition Start Time (UTC), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITION_CHANGE_START )
• CONDITION_CHANGE_END ( type: esriFieldTypeDate, alias: Change in Road Condition End (UTC), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITION_CHANGE_END )
• CONDITION_CHANGE_ELAPSED_TIME ( type: esriFieldTypeDouble, alias: Time Road Segment Has Been Current Condition (Hours), editable: true, nullable: true, defaultValue: null, modelName: CONDITION_CHANGE_TIME )
• EVENT_UPDATE_ID ( type: esriFieldTypeSmallInteger, alias: Event Update ID, editable: true, nullable: true, defaultValue: null, modelName: EVENT_UPDATE_ID )
• PREVIOUS_ROAD_CONDITION_CODE ( type: esriFieldTypeSmallInteger, alias: Previous Road Condition Code, editable: true, nullable: true, defaultValue: null, modelName: PREVIOUS_ROAD_CONDITION_CODE )
• ROUTE_RANK ( type: esriFieldTypeSmallInteger, alias: Route System Rank, editable: true, nullable: true, defaultValue: null, modelName: ROUTE_RANK )
• COND_CHANGE_START_UTC_OFFSET ( type: esriFieldTypeString, alias: Condition Change Start UTC Offset, editable: true, nullable: true, length: 6, defaultValue: null, modelName: COND_CHANGE_START_UTC_OFFSET )
• COND_CHANGE_END_UTC_OFFSET ( type: esriFieldTypeString, alias: Condition Change End UTC Offset, editable: true, nullable: true, length: 6, defaultValue: null, modelName: COND_CHANGE_END_UTC_OFFSET )
• COND_NOT_NORM_START_UTC_OFFSET ( type: esriFieldTypeString, alias: Condition Not Normal Start UTC Offset, editable: true, nullable: true, length: 6, defaultValue: null, modelName: COND_NOT_NORMAL_START_UTC_OFFS )
• COND_NOT_NORM_END_UTC_OFFSET ( type: esriFieldTypeString, alias: Condition Not Normal End UTC Offset, editable: true, nullable: true, length: 6, defaultValue: null, modelName: COND_NOT_NORMAL_END_UTC_OFFSET )
• PREVIOUS_EVENT_ID ( type: esriFieldTypeString, alias: PREVIOUS_EVENT_ID, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PREVIOUS_EVENT_ID )
• PREVIOUS_EVENT_UPDATE_ID ( type: esriFieldTypeInteger, alias: PREVIOUS_EVENT_UPDATE_ID, editable: true, nullable: true, defaultValue: null, modelName: PREVIOUS_EVENT_UPDATE_ID )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.LEN, editable: false, nullable: true, defaultValue: null, modelName: SHAPE.LEN, required: true )

Templates:

• Name: Histoic Road Conditions
  Description:
  Prototype:
  PREVIOUS_EVENT_UPDATE_ID: null
  SEGMENT_ID: null
  ROUTE: null
  NAMEID: null
  LONG_NAME: null
  DISTRICT: null
  SUBAREA: null
  EVENT_ID: null
  HL_PAVEMENT_CONDITION: null
  LOC_LINK_DIRECTION: null
  ROAD_CONDITION: null
  CARS_MSG_UPDATE_DATE: null
  CARS_MSG_INITIAL_DATE: null
  PH_PAVEMENT_CONDITION: null
  DISTRICT_NUMBER: null
  COST_CENTER: null
  CONDITION_NOT_NORMAL_START: null
  CONDITION_NOT_NORMAL_END: null
  CONDITION_NOT_NORMAL_ELAPSED: null
  ROUTE_NAME: null
  HIST_RECORD_UTC_OFFSET: null
  ROUTE_SEG_INDEX: null
  MSG_UPDATE_UTC_OFFSET: null
  MSG_INITIAL_UTC_OFFSET: null
  PREVIOUS_EVENT_ID: null
  PREVIOUS_ROAD_CONDITION: null
  CONDITION_CHANGE: null
  SEGMENT_LENGTH_MI: null
  SEGMENT_MAP_CODE: null
  ROAD_CONDITION_CODE: null
  PREVIOUS_CONDITION_HL_PHRASE: null
  PREVIOUS_CONDITION_PH_PHRASE: null
  CONDITION_CHANGE_START: null
  CONDITION_CHANGE_END: null
  CONDITION_CHANGE_ELAPSED_TIME: null
  EVENT_UPDATE_ID: null
  PREVIOUS_ROAD_CONDITION_CODE: null
  ROUTE_RANK: null
  COND_CHANGE_START_UTC_OFFSET: null
  COND_CHANGE_END_UTC_OFFSET: null
  COND_NOT_NORM_START_UTC_OFFSET: null
  COND_NOT_NORM_END_UTC_OFFSET: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Update,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Update Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata