View In:   ArcGIS Online Map Viewer

Name: Construction History

Display Field: EVENT_ID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Contains records on construction year, aggregate type and source location, pavement type, surface type, layer types and widths (base, subsurface, surface) construction year and project information (where available)

Service Item Id: cdf790cf3260450fbb0aa8f4eeaf88fa

Copyright Text: Iowa Department of Transportation

Default Visibility: false

MaxRecordCount: 10000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 50000.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.0761217492983611E7
YMin: 4917980.424290336
XMax: -1.0028337635895343E7
YMax: 5394674.882083295
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [127, 53, 109, 255]
Width: 2
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: false
Supports Query With Current User: true

HasZ: true

HasM: true

Time Info:

Start Time Field: EFFECTIVE_START_DATE
End Time Field: EFFECTIVE_END_DATE
Track ID Field: null
Time Extent:
[0182/07/08 00:00:00 UTC, 2051/12/21 00:00:00 UTC]

Time Reference: N/A
Time Interval: 1
Time Interval Units: esriTimeUnitsDays
Has Live Data: false
Export Options:
Use Time: true
Time Data Cumulative: false
Time Offset: -1 (esriTimeUnitsSeconds)

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• EVENT_ID ( type: esriFieldTypeString, alias: EVENT_ID, editable: true, nullable: false, length: 38, defaultValue: null, modelName: EVENT_ID )
• ROUTE_ID ( type: esriFieldTypeString, alias: ROUTE_ID, editable: true, nullable: false, length: 15, defaultValue: null, modelName: ROUTE_ID )
• FROM_MEASURE ( type: esriFieldTypeDouble, alias: FROM_MEASURE, editable: true, nullable: false, defaultValue: null, modelName: FROM_MEASURE )
• TO_MEASURE ( type: esriFieldTypeDouble, alias: TO_MEASURE, editable: true, nullable: false, defaultValue: null, modelName: TO_MEASURE )
• BUSINESS_DATE ( type: esriFieldTypeDate, alias: BUSINESS_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BUSINESS_DATE )
• EFFECTIVE_START_DATE ( type: esriFieldTypeDate, alias: EFFECTIVE_START_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EFFECTIVE_START_DATE )
• EFFECTIVE_END_DATE ( type: esriFieldTypeDate, alias: EFFECTIVE_END_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EFFECTIVE_END_DATE )
• LAYER_YEAR ( type: esriFieldTypeInteger, alias: LAYER_YEAR, editable: true, nullable: true, defaultValue: null, modelName: LAYER_YEAR )
• SURFACE_THICKNESS ( type: esriFieldTypeSingle, alias: SURFACE_THICKNESS, editable: true, nullable: true, defaultValue: null, modelName: SURFACE_THICKNESS )
• BASE_THICKNESS ( type: esriFieldTypeSingle, alias: BASE_THICKNESS, editable: true, nullable: true, defaultValue: null, modelName: BASE_THICKNESS )
• REMOVAL_THICKNESS ( type: esriFieldTypeSingle, alias: REMOVAL_THICKNESS, editable: true, nullable: true, defaultValue: null, modelName: REMOVAL_THICKNESS )
• AGGREGATE_SOURCE ( type: esriFieldTypeString, alias: AGGREGATE_SOURCE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AGGREGATE_SOURCE )
• REMARKS ( type: esriFieldTypeString, alias: REMARKS, editable: true, nullable: true, length: 200, defaultValue: null, modelName: REMARKS )
• SUBDRAIN_PROJ_NUMBER ( type: esriFieldTypeString, alias: SUBDRAIN_PROJ_NUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SUBDRAIN_PROJ_NUMBER )
• SUBDRAIN_PERCENT ( type: esriFieldTypeInteger, alias: SUBDRAIN_PERCENT, editable: true, nullable: true, defaultValue: null, modelName: SUBDRAIN_PERCENT )
• SURFACE_TREATMENT ( type: esriFieldTypeString, alias: SURFACE_TREATMENT, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SURFACE_TREATMENT , Coded Values: [AC: AC = Asphalt] , [MS: MS = Microsurfacing] , [PC: PC = Concrete] , ...2 more... )
• PROJECT_WORK_TYPE ( type: esriFieldTypeString, alias: PROJECT_WORK_TYPE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PROJECT_WORK_TYPE , Coded Values: [W: W = widening project] , [L: L = left (inside) lane(s) only] , [R: R = right (outside) lane(s) only] , ...6 more... )
• SURFACE_MATERIAL ( type: esriFieldTypeString, alias: SURFACE_MATERIAL, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SURFACE_MATERIAL , Coded Values: [AAC: Type A Asphalt Cement Concrete] , [ARC: Asphalt Rubber Cement Concrete] , [ASC: Asphalt-Sand Surface Course] , ...32 more... )
• SUBDRAIN_MULTI ( type: esriFieldTypeString, alias: SUBDRAIN_MULTI, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SUBDRAIN_MULTI , Coded Values: [Y: Y=Yes] , [N: N=No] )
• REMOVAL_TYPE ( type: esriFieldTypeString, alias: REMOVAL_TYPE, editable: true, nullable: true, length: 3, defaultValue: null, modelName: REMOVAL_TYPE , Coded Values: [GND: GND = Grinding] , [MIL: MIL = Milling] , [SCR: SCR = Heater Scarification] )
• AGGREGATE_CLASS_ID ( type: esriFieldTypeString, alias: AGGREGATE_CLASS_ID, editable: true, nullable: true, length: 1, defaultValue: null, modelName: AGGREGATE_CLASS_ID , Coded Values: [1: 1 = Class 1 Durability (<10 yrs)] , [2: 2 = Class 2 Durability (10-20 yrs)] , [3: 3 = Class 3 Durability (>20 yrs)] , ...1 more... )
• AGGREGATE_TYPE ( type: esriFieldTypeString, alias: AGGREGATE_TYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AGGREGATE_TYPE , Coded Values: [C.LST.: C.LST. = Crushed Limestone] , [GRAVEL: GRAVEL = Gravel] , [C.ST/GR: C.ST/GR] , ...16 more... )
• COMPLEX ( type: esriFieldTypeString, alias: COMPLEX, editable: true, nullable: true, length: 1, defaultValue: null, modelName: COMPLEX , Coded Values: [Y: Y=Yes] , [N: N=No] )
• BASE_MATERIAL ( type: esriFieldTypeString, alias: BASE_MATERIAL, editable: true, nullable: true, length: 3, defaultValue: null, modelName: BASE_MATERIAL , Coded Values: [AAC: Type A Asphalt Cement Concrete] , [ARC: Asphalt Rubber Cement Concrete] , [ASC: Asphalt-Sand Surface Course] , ...32 more... )
• SUB_MATERIAL ( type: esriFieldTypeString, alias: SUB_MATERIAL, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SUB_MATERIAL , Coded Values: [AAC: Type A Asphalt Cement Concrete] , [ARC: Asphalt Rubber Cement Concrete] , [ASC: Asphalt-Sand Surface Course] , ...32 more... )
• LOCERROR ( type: esriFieldTypeString, alias: LOCERROR, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCERROR )
• PROJECT_NUMBER ( type: esriFieldTypeString, alias: PROJECT_NUMBER, editable: true, nullable: true, length: 36, defaultValue: null, modelName: PROJECT_NUMBER )
• SUB_THICKNESS ( type: esriFieldTypeSingle, alias: SUB_THICKNESS2, editable: true, nullable: true, defaultValue: null, modelName: SUB_THICKNESS )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.LEN, editable: false, nullable: true, defaultValue: null, modelName: SHAPE.LEN, required: true )

Templates:

• Name: Construction History
  Description:
  Prototype:
  PROJECT_NUMBER: null
  SUB_THICKNESS: null
  EVENT_ID:
  ROUTE_ID:
  FROM_MEASURE: 0
  TO_MEASURE: 0
  BUSINESS_DATE: null
  EFFECTIVE_START_DATE: null
  EFFECTIVE_END_DATE: null
  LAYER_YEAR: null
  SURFACE_THICKNESS: null
  BASE_THICKNESS: null
  REMOVAL_THICKNESS: null
  AGGREGATE_SOURCE: null
  REMARKS: null
  SUBDRAIN_PROJ_NUMBER: null
  SUBDRAIN_PERCENT: null
  SURFACE_TREATMENT: null
  PROJECT_WORK_TYPE: null
  SURFACE_MATERIAL: null
  SUBDRAIN_MULTI: null
  REMOVAL_TYPE: null
  AGGREGATE_CLASS_ID: null
  AGGREGATE_TYPE: null
  COMPLEX: null
  BASE_MATERIAL: null
  SUB_MATERIAL: null
  LOCERROR: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: SYSTEM_CREATE_DATE
• Creator Field: USER_CREATE
• Edit Date Field: SYSTEM_MOD_DATE
• Editor Field: USER_MOD

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:

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