View In:   ArcGIS Online Map Viewer

Name: Histoic Road Conditions

Display Field: NAMEID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Authoritative Iowa Winter Road Conditions for 2023-2024. 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.</SPAN></P></DIV></DIV></DIV>

Service Item Id: 9e378429c3a140c3b91b1284f6b439ea

Copyright Text: Iowa Department of Transportation

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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.07570959107825E7
YMin: 4922100.19324
XMax: -1.0036668137115E7
YMax: 5388546.469005
Spatial Reference: 102100  (3857)

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:

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: 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: false, defaultValue: null, modelName: SHAPE.LEN )

Templates:

• Name: Histoic Road Conditions
  Description:
  Prototype:
  PREVIOUS_EVENT_UPDATE_ID: null
  PREVIOUS_EVENT_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
  COND_NOT_NORM_END_UTC_OFFSET: 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
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

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

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