View In:   ArcGIS Online Map Viewer

Name: CMWC's Misc. piping

Display Field: Enabled

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 50000

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: 4770.098083510995
YMin: 4989.676513686776
XMax: 3130246.788975835
YMax: 1748166.3370862454
Spatial Reference: 102654  (2232)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: WaterType
Field 2: Diameter
Field 3: LifeCycleStatus
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Drainage,4,ACTIVE
  Label: Drainage, 1-4"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 255, 0, 255]
  Width: 2
• Value: Drainage,6,ACTIVE
  Label: Drainage, 6"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [85, 255, 0, 255]
  Width: 2
• Value: Drainage,10,ACTIVE
  Label: Drainage, 10-12"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 170, 0, 255]
  Width: 2
• Value: Drainage,12,ACTIVE
  Label: Drainage, 10-12"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 170, 0, 255]
  Width: 2
• Value: Drainage,16,ACTIVE
  Label: Drainage, 14-18"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [132, 0, 168, 255]
  Width: 2
• Value: Plant,4,ACTIVE
  Label: Plant, 1-4"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 255, 0, 255]
  Width: 2
• Value: Plant,6,ACTIVE
  Label: Plant, 6"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [85, 255, 0, 255]
  Width: 2
• Value: Plant,8,ACTIVE
  Label: Plant, 8"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [0, 112, 255, 255]
  Width: 2
• Value: Plant,10,ACTIVE
  Label: Plant, 10-12"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 170, 0, 255]
  Width: 2
• Value: Plant,12,ACTIVE
  Label: Plant, 10-12"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 170, 0, 255]
  Width: 2
• Value: Plant,18,ACTIVE
  Label: Plant, 14-18"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [132, 0, 168, 255]
  Width: 2
• Value: Plant,24,ACTIVE
  Label: Plant, >20"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [230, 0, 169, 255]
  Width: 2
• Value: Plant,30,ACTIVE
  Label: Plant, >20"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [230, 0, 169, 255]
  Width: 2
• Value: Plant,36,ACTIVE
  Label: Plant, >20"
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [230, 0, 169, 255]
  Width: 2
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: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: WaterType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• LegacyID ( type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LegacyID )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location , Coded Values: [Arvada: City of Arvada] , [CDOT: CDOT] , [Edgewater: Edgewater] , ...6 more... )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• Comments ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Comments )
• ServiceArea ( type: esriFieldTypeString, alias: Service Area, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ServiceArea , Coded Values: [Denver: Denver] , [MapleGrove: MapleGrove] )
• PressureZone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PressureZone , Coded Values: [A-Blue: A-Blue PS #1, #2 & #5] , [B-Blue: B-Blue PS #3] , [C-Green: C-Green PS #4] , ...22 more... )
• LifeCycleStatus ( type: esriFieldTypeString, alias: Life Cycle Status, editable: true, nullable: true, length: 30, defaultValue: ACTIVE, modelName: LifeCycleStatus , Coded Values: [PROPOSED: Proposed] , [ACTIVE: Active] , [OUTOFSERV: Out of Service] , ...6 more... )
• WaterType ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 10, defaultValue: Potable, modelName: WaterType , Coded Values: [Potable: Potable] , [Raw: Raw] , [Unknown: Unknown] , ...3 more... )
• Diameter ( type: esriFieldTypeInteger, alias: Estimated Effective Life, editable: true, nullable: true, defaultValue: null, modelName: Diameter , Coded Values: [2: 2"] , [4: 4"] , [6: 6"] , ...27 more... )
• SurveyCollection ( type: esriFieldTypeString, alias: Survey Collection, editable: true, nullable: true, length: 15, defaultValue: null, modelName: SurveyCollection , Coded Values: [Unknown: Unknown] , [Other: Other] , [CAD: CAD] , ...8 more... )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 15, defaultValue: PVC, modelName: Material , Coded Values: [CastIron: Cast Iron] , [Steel: Steel] , [DuctileIron: Ductile Iron] , ...10 more... )
• InstallationMethod ( type: esriFieldTypeString, alias: Installation Method, editable: true, nullable: true, length: 15, defaultValue: OpenTrench, modelName: InstallationMethod , Coded Values: [OpenTrench: Open Trench] , [Burst: Burst] , [Bore: Bore] , ...1 more... )
• RecordedLength ( type: esriFieldTypeInteger, alias: Recorded Length, editable: true, nullable: true, defaultValue: null, modelName: RecordedLength )
• GlobalID ( type: esriFieldTypeGlobalID, alias: C Factor, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• MainClass ( type: esriFieldTypeString, alias: Minor Loss, editable: true, nullable: true, length: 255, defaultValue: Distribution, modelName: MainClass , Coded Values: [Transmission: Transmission] , [Distribution: Distribution] , [Internal: Internal] )
• Year ( type: esriFieldTypeSmallInteger, alias: Year, editable: true, nullable: true, defaultValue: null, modelName: Year )
• SedaruID ( type: esriFieldTypeString, alias: SedaruID, editable: true, nullable: true, length: 18, defaultValue: null, modelName: SedaruID )
• FAS_ID ( type: esriFieldTypeString, alias: FAS ID, editable: true, nullable: true, length: 18, defaultValue: null, modelName: FAS_ID )
• Accessibility ( type: esriFieldTypeString, alias: Accessibility, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Accessibility , Coded Values: [Direct_Bury: Direct_Bury] , [Inside_Building: Inside_Building] , [Inside_Vault: Inside_Vault] , ...2 more... )
• Closed_In_Accounting ( type: esriFieldTypeString, alias: Closed_In_Accounting, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Closed_In_Accounting , Coded Values: [Yes: Yes] , [No: No] )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.len, editable: false, nullable: false, defaultValue: null, modelName: Shape.len )

Types:

ID: Drainage
Name: Drainage, 1-4"
Domains:
• Enabled:
  Inherited
• Location:
  Inherited
• ServiceArea:
  Inherited
• PressureZone:
  Inherited
• LifeCycleStatus:
  Inherited
• WaterType:
  Inherited
• Diameter:
  Inherited
• SurveyCollection:
  Inherited
• Material:
  Inherited
• InstallationMethod:
  Inherited
• MainClass:
  Inherited
• Accessibility:
  Inherited
• Closed_In_Accounting:
  Inherited
• SurfaceType:
  Inherited
• ProjectType:
  Inherited
Templates:
• Name: Drainage, 1-4"
  Description:
  Prototype:
  LifeCycleStatus: ACTIVE
  WaterType: Drainage
  PressureZone: null
  Closed_In_Accounting: null
  Ownership: CMWC
  Condition: 1
  SurveyCollection: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  Diameter: 4
  Material: PVC
  InstallationMethod: null
  RecordedLength: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  FAS_ID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Drainage, 6"
  Description:
  Prototype:
  LifeCycleStatus: ACTIVE
  WaterType: Drainage
  PressureZone: null
  Closed_In_Accounting: null
  Ownership: CMWC
  Condition: 1
  SurveyCollection: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  Diameter: 6
  Material: PVC
  InstallationMethod: null
  RecordedLength: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  FAS_ID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Drainage, 10-12"
  Description:
  Prototype:
  LifeCycleStatus: ACTIVE
  WaterType: Drainage
  PressureZone: null
  Closed_In_Accounting: null
  Ownership: CMWC
  Condition: 1
  SurveyCollection: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  Diameter: 10
  Material: PVC
  InstallationMethod: null
  RecordedLength: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  FAS_ID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Drainage, 14-18"
  Description:
  Prototype:
  LifeCycleStatus: ACTIVE
  WaterType: Drainage
  PressureZone: null
  Closed_In_Accounting: null
  Ownership: CMWC
  Condition: 1
  SurveyCollection: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  Diameter: 16
  Material: PVC
  InstallationMethod: null
  RecordedLength: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  FAS_ID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Drainage, 12, ACTIVE
  Description:
  Prototype:
  Closed_In_Accounting: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  PressureZone: null
  LifeCycleStatus: ACTIVE
  WaterType: Drainage
  Diameter: 12
  SurveyCollection: null
  Material: PVC
  InstallationMethod: OpenTrench
  RecordedLength: null
  FAS_ID: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Plant
Name: Plant, 1-4"
Domains:
• Enabled:
  Inherited
• Location:
  Inherited
• ServiceArea:
  Inherited
• PressureZone:
  Inherited
• LifeCycleStatus:
  Inherited
• WaterType:
  Inherited
• Diameter:
  Inherited
• SurveyCollection:
  Inherited
• Material:
  Inherited
• InstallationMethod:
  Inherited
• MainClass:
  Inherited
• Accessibility:
  Inherited
• Closed_In_Accounting:
  Inherited
• SurfaceType:
  Inherited
• ProjectType:
  Inherited
Templates:
• Name: Plant, 1-4"
  Description:
  Prototype:
  LifeCycleStatus: ACTIVE
  WaterType: Plant
  PressureZone: null
  Closed_In_Accounting: null
  Ownership: CMWC
  Condition: 1
  SurveyCollection: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  Diameter: 4
  Material: PVC
  InstallationMethod: null
  RecordedLength: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  FAS_ID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Plant, 6"
  Description:
  Prototype:
  LifeCycleStatus: ACTIVE
  WaterType: Plant
  PressureZone: null
  Closed_In_Accounting: null
  Ownership: CMWC
  Condition: 1
  SurveyCollection: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  Diameter: 6
  Material: PVC
  InstallationMethod: null
  RecordedLength: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  FAS_ID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Plant, 8"
  Description:
  Prototype:
  LifeCycleStatus: ACTIVE
  WaterType: Plant
  PressureZone: null
  Closed_In_Accounting: null
  Ownership: CMWC
  Condition: 1
  SurveyCollection: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  Diameter: 8
  Material: PVC
  InstallationMethod: null
  RecordedLength: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  FAS_ID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Plant, 10-12"
  Description:
  Prototype:
  LifeCycleStatus: ACTIVE
  WaterType: Plant
  PressureZone: null
  Closed_In_Accounting: null
  Ownership: CMWC
  Condition: 1
  SurveyCollection: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  Diameter: 10
  Material: PVC
  InstallationMethod: null
  RecordedLength: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  FAS_ID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Plant, 14-18"
  Description:
  Prototype:
  LifeCycleStatus: ACTIVE
  WaterType: Plant
  PressureZone: null
  Closed_In_Accounting: null
  Ownership: CMWC
  Condition: 1
  SurveyCollection: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  Diameter: 18
  Material: PVC
  InstallationMethod: null
  RecordedLength: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  FAS_ID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Plant, >20"
  Description:
  Prototype:
  LifeCycleStatus: ACTIVE
  WaterType: Plant
  PressureZone: null
  Closed_In_Accounting: null
  Ownership: CMWC
  Condition: 1
  SurveyCollection: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  Diameter: 24
  Material: PVC
  InstallationMethod: null
  RecordedLength: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  FAS_ID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Plant, 12, ACTIVE
  Description:
  Prototype:
  Closed_In_Accounting: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  PressureZone: null
  LifeCycleStatus: ACTIVE
  WaterType: Plant
  Diameter: 12
  SurveyCollection: null
  Material: PVC
  InstallationMethod: OpenTrench
  RecordedLength: null
  FAS_ID: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Plant, 30, ACTIVE
  Description:
  Prototype:
  Closed_In_Accounting: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  PressureZone: null
  LifeCycleStatus: ACTIVE
  WaterType: Plant
  Diameter: 30
  SurveyCollection: null
  Material: PVC
  InstallationMethod: OpenTrench
  RecordedLength: null
  FAS_ID: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Plant, 36, ACTIVE
  Description:
  Prototype:
  Closed_In_Accounting: null
  Accessibility: null
  Enabled: 1
  AssetID: null
  LegacyID: null
  Location: null
  InstallDate: null
  Comments: null
  ServiceArea: null
  PressureZone: null
  LifeCycleStatus: ACTIVE
  WaterType: Plant
  Diameter: 36
  SurveyCollection: null
  Material: PVC
  InstallationMethod: OpenTrench
  RecordedLength: null
  FAS_ID: null
  MainClass: Distribution
  Year: null
  SedaruID: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

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