Name: lu_costs_by_treatment

Display Field: TREATMENT_TYPE

Type: Table

Geometry Type: N/A

Description: Square foot cost of treatment type for paving work. Used in PAMS

Service Item Id: d338823547fb448c93c4ff910af07101

Copyright Text:

Default Visibility: false

MaxRecordCount: 20000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• TREATMENT_TYPE ( type: esriFieldTypeString, alias: TREATMENT_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TREATMENT_TYPE , Coded Values: [M_O: Mill and Overlay] , [OL_ONLY: Overlay Only] , [BR_ONLY: Base Pavement Repair Only] , ...8 more... )
• MILLING_COST ( type: esriFieldTypeString, alias: Milling Cost, editable: true, nullable: true, length: 2, defaultValue: null, modelName: MILLING_COST , Coded Values: [Y: Yes] , [N: No] )
• OVERLAY_COST ( type: esriFieldTypeString, alias: Overlay Cost, editable: true, nullable: true, length: 2, defaultValue: null, modelName: OVERLAY_COST , Coded Values: [Y: Yes] , [N: No] )
• BASE_PAVEMENT_REPAIR_COST ( type: esriFieldTypeString, alias: Base Pavement Repair Cost, editable: true, nullable: true, length: 2, defaultValue: null, modelName: BASE_PAVEMENT_REPAIR_COST , Coded Values: [Y: Yes] , [N: No] )
• PAVING_COST ( type: esriFieldTypeString, alias: Paving Cost, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PAVING_COST , Coded Values: [Y: Yes] , [N: No] )
• UNDERDRAIN_COST ( type: esriFieldTypeString, alias: Underdrain Cost, editable: true, nullable: true, length: 2, defaultValue: null, modelName: UNDERDRAIN_COST , Coded Values: [Y: Yes] , [N: No] )
• CONCRETE_COST ( type: esriFieldTypeString, alias: Concrete Cost, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CONCRETE_COST , Coded Values: [Y: Yes] , [N: No] )
• SUBTOTAL_MAJOR_MR ( type: esriFieldTypeString, alias: Major MR Subtotal, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CONTINGENCY_COST , Coded Values: [Y: Yes] , [N: No] )
• SUBTOTAL_GLOBAL_MR ( type: esriFieldTypeString, alias: Global MR Subtotal, editable: true, nullable: true, length: 2, defaultValue: null, modelName: TOTAL_COST , Coded Values: [Y: Yes] , [N: No] )
• CONTINGENCY_COST ( type: esriFieldTypeString, alias: Contingency Cost, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PRIORITY , Coded Values: [Y: Yes] , [N: No] )
• TOTAL_COST ( type: esriFieldTypeString, alias: Total Cost, editable: true, nullable: true, length: 2, defaultValue: null, modelName: TOTAL_COST , Coded Values: [Y: Yes] , [N: No] )
• INFRARED_COST ( type: esriFieldTypeString, alias: Infrared_Cost, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Infrared_Cost , Coded Values: [Y: Yes] , [N: No] )
• WL_PCT ( type: esriFieldTypeString, alias: WL_PCT, editable: true, nullable: true, length: 1, defaultValue: null, modelName: WL_PCT , Coded Values: [Y: Yes] , [N: No] )

Templates:

• Name: lu_costs_by_treatment
  Description:
  Prototype:
  INFRARED_COST: null
  WL_PCT: null
  TREATMENT_TYPE: null
  MILLING_COST: null
  OVERLAY_COST: null
  BASE_PAVEMENT_REPAIR_COST: null
  PAVING_COST: null
  UNDERDRAIN_COST: null
  CONCRETE_COST: null
  SUBTOTAL_MAJOR_MR: null
  SUBTOTAL_GLOBAL_MR: null
  CONTINGENCY_COST: null
  TOTAL_COST: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

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