View In:   ArcGIS Online Map Viewer

Name: Hydrant

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

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: 4867.439396247268
YMin: 5021.929198816419
XMax: 3125703.679554045
YMax: 1709734.5256031007
Spatial Reference: 102654  (2232)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LifeCycleStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: ACTIVE
  Label: Active
  Description: N/A
  Symbol:
  
• Value: ABANDONED
  Label: Abandoned/Out of Service/Proposed/Retired
  Description: N/A
  Symbol:
  
• Value: OUTOFSERV
  Label: Abandoned/Out of Service/Proposed/Retired
  Description: N/A
  Symbol:
  
• Value: PROPOSED
  Label: Abandoned/Out of Service/Proposed/Retired
  Description: N/A
  Symbol:
  
• Value: RETIRED
  Label: Abandoned/Out of Service/Proposed/Retired
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [FHNum]
Use Coded Values: true
Symbol:
Color: [255, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 9
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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: esriServerHTMLPopupTypeNone

Type ID Field: LifeCycleStatus

Fields:

• LegacyID ( type: esriFieldTypeString, alias: Work Order, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LegacyID )
• FHNum ( type: esriFieldTypeString, alias: F.H. #, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FHNum )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location )
• HydSize ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 50, defaultValue: 5.25, modelName: HydSize )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 15, defaultValue: WB_67-250, modelName: Model , Coded Values: [WB_67-250: WB_67-250] , [Private: Non-CMWC owned or maintained] , [Other: Other] , ...6 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 15, defaultValue: WaterousPacer, modelName: Manufacturer , Coded Values: [WaterousPacer: Waterous Pacer] , [Other: Other] , [Unknown: Unknown] , ...1 more... )
• FlowDate ( type: esriFieldTypeDate, alias: Flow Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FlowDate )
• 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... )
• FireDistrict ( type: esriFieldTypeString, alias: Fire District, editable: true, nullable: true, length: 6, defaultValue: WMFPD, modelName: FireDistrict , Coded Values: [WMFPD: West Metro Fire Protection District] , [PVMDFD: Pleasant View Metropolitan District Fire Department] , [WRFD: Wheatridge Fire Department] , ...3 more... )
• 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... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• additionalwork ( type: esriFieldTypeString, alias: Additional Work Needed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: additionalwork , Coded Values: [No: No] , [Replace: Replace] , [Future Replace: Future Replace] )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• LifeCycleStatus ( type: esriFieldTypeString, alias: Life Cycle Status, editable: true, nullable: true, length: 15, defaultValue: ACTIVE, modelName: LifeCycleStatus , Coded Values: [PROPOSED: Proposed] , [ACTIVE: Active] , [OUTOFSERV: Out of Service] , ...6 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FA_ID ( type: esriFieldTypeString, alias: FAS_ID, editable: true, nullable: true, length: 18, defaultValue: null, modelName: FA_ID )
• PaintStencil ( type: esriFieldTypeString, alias: Paint/Stencil, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PaintStencil , Coded Values: [Good: Good] , [Needs Painted: Needs Painted] , [Needs Stenciled: Needs Stenciled] , ...1 more... )
• DataValid ( type: esriFieldTypeString, alias: DataValid, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DataValid , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• Number_of_Extensions ( type: esriFieldTypeInteger, alias: Number of Extensions, editable: true, nullable: true, defaultValue: 0, modelName: Number_of_Extensions )
• 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] )
• SolidStem ( type: esriFieldTypeString, alias: Solid Stem, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SolidStem , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• Condition ( type: esriFieldTypeInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: Condition , Coded Values: [1: Excellent] , [2: Good] , [3: Fair] , ...3 more... )
• DataValid_Comment ( type: esriFieldTypeString, alias: Data Valid Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DataValid_Comment )
• workdate ( type: esriFieldTypeDate, alias: Date Last Inspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: workdate )
• commentaddwork ( type: esriFieldTypeString, alias: Additional Work Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: commentaddwork )
• OutOfService ( type: esriFieldTypeString, alias: OutOfService, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OutOfService , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )

Types:

ID: ACTIVE
Name: Active
Domains:
• Model:
  Inherited
• Manufacturer:
  Inherited
• SurveyCollection:
  Inherited
• FireDistrict:
  Inherited
• ServiceArea:
  Inherited
• PressureZone:
  Inherited
• additionalwork:
  Inherited
• LifeCycleStatus:
  Inherited
• PaintStencil:
  Inherited
• DataValid:
  Inherited
• Closed_In_Accounting:
  Inherited
• SolidStem:
  Inherited
• Condition:
  Inherited
• OutOfService:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  commentaddwork: null
  workdate: null
  Model: WB_67-250
  HydSize: 5.25
  SurveyCollection: null
  Location: null
  DataValid: null
  LegacyID: null
  FHNum: null
  InstallDate: null
  Manufacturer: WaterousPacer
  FlowDate: null
  FireDistrict: WMFPD
  ServiceArea: null
  PressureZone: null
  Comments: null
  additionalwork: null
  LifeCycleStatus: ACTIVE
  OutOfService: null
  FA_ID: null
  PaintStencil: null
  Number_of_Extensions: 0
  Closed_In_Accounting: null
  SolidStem: null
  Condition: null
  DataValid_Comment: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: ABANDONED
Name: Abandoned/Out of Service/Proposed/Retired
Domains:
• Model:
  Inherited
• Manufacturer:
  Inherited
• SurveyCollection:
  Inherited
• FireDistrict:
  Inherited
• ServiceArea:
  Inherited
• PressureZone:
  Inherited
• additionalwork:
  Inherited
• LifeCycleStatus:
  Inherited
• PaintStencil:
  Inherited
• DataValid:
  Inherited
• Closed_In_Accounting:
  Inherited
• SolidStem:
  Inherited
• Condition:
  Inherited
• OutOfService:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Abandoned/Out of Service/Proposed/Retired
  Description:
  Prototype:
  commentaddwork: null
  workdate: null
  Model: WB_67-250
  HydSize: 5.25
  SurveyCollection: null
  Location: null
  DataValid: null
  LegacyID: null
  FHNum: null
  InstallDate: null
  Manufacturer: WaterousPacer
  FlowDate: null
  FireDistrict: WMFPD
  ServiceArea: null
  PressureZone: null
  Comments: null
  additionalwork: null
  LifeCycleStatus: ABANDONED
  OutOfService: null
  FA_ID: null
  PaintStencil: null
  Number_of_Extensions: 0
  Closed_In_Accounting: null
  SolidStem: null
  Condition: null
  DataValid_Comment: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: OUTOFSERV
Name: Abandoned/Out of Service/Proposed/Retired
Domains:
• Model:
  Inherited
• Manufacturer:
  Inherited
• SurveyCollection:
  Inherited
• FireDistrict:
  Inherited
• ServiceArea:
  Inherited
• PressureZone:
  Inherited
• additionalwork:
  Inherited
• LifeCycleStatus:
  Inherited
• PaintStencil:
  Inherited
• DataValid:
  Inherited
• Closed_In_Accounting:
  Inherited
• SolidStem:
  Inherited
• Condition:
  Inherited
• OutOfService:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Abandoned/Out of Service/Proposed/Retired (1)
  Description:
  Prototype:
  commentaddwork: null
  workdate: null
  Model: WB_67-250
  HydSize: 5.25
  SurveyCollection: null
  Location: null
  DataValid: null
  LegacyID: null
  FHNum: null
  InstallDate: null
  Manufacturer: WaterousPacer
  FlowDate: null
  FireDistrict: WMFPD
  ServiceArea: null
  PressureZone: null
  Comments: null
  additionalwork: null
  LifeCycleStatus: OUTOFSERV
  OutOfService: null
  FA_ID: null
  PaintStencil: null
  Number_of_Extensions: 0
  Closed_In_Accounting: null
  SolidStem: null
  Condition: null
  DataValid_Comment: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: PROPOSED
Name: Abandoned/Out of Service/Proposed/Retired
Domains:
• Model:
  Inherited
• Manufacturer:
  Inherited
• SurveyCollection:
  Inherited
• FireDistrict:
  Inherited
• ServiceArea:
  Inherited
• PressureZone:
  Inherited
• additionalwork:
  Inherited
• LifeCycleStatus:
  Inherited
• PaintStencil:
  Inherited
• DataValid:
  Inherited
• Closed_In_Accounting:
  Inherited
• SolidStem:
  Inherited
• Condition:
  Inherited
• OutOfService:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Abandoned/Out of Service/Proposed/Retired (2)
  Description:
  Prototype:
  commentaddwork: null
  workdate: null
  Model: WB_67-250
  HydSize: 5.25
  SurveyCollection: null
  Location: null
  DataValid: null
  LegacyID: null
  FHNum: null
  InstallDate: null
  Manufacturer: WaterousPacer
  FlowDate: null
  FireDistrict: WMFPD
  ServiceArea: null
  PressureZone: null
  Comments: null
  additionalwork: null
  LifeCycleStatus: PROPOSED
  OutOfService: null
  FA_ID: null
  PaintStencil: null
  Number_of_Extensions: 0
  Closed_In_Accounting: null
  SolidStem: null
  Condition: null
  DataValid_Comment: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: RETIRED
Name: Abandoned/Out of Service/Proposed/Retired
Domains:
• Model:
  Inherited
• Manufacturer:
  Inherited
• SurveyCollection:
  Inherited
• FireDistrict:
  Inherited
• ServiceArea:
  Inherited
• PressureZone:
  Inherited
• additionalwork:
  Inherited
• LifeCycleStatus:
  Inherited
• PaintStencil:
  Inherited
• DataValid:
  Inherited
• Closed_In_Accounting:
  Inherited
• SolidStem:
  Inherited
• Condition:
  Inherited
• OutOfService:
  Inherited
• Enabled:
  Inherited
Templates:
• Name: Abandoned/Out of Service/Proposed/Retired (3)
  Description:
  Prototype:
  commentaddwork: null
  workdate: null
  Model: WB_67-250
  HydSize: 5.25
  SurveyCollection: null
  Location: null
  DataValid: null
  LegacyID: null
  FHNum: null
  InstallDate: null
  Manufacturer: WaterousPacer
  FlowDate: null
  FireDistrict: WMFPD
  ServiceArea: null
  PressureZone: null
  Comments: null
  additionalwork: null
  LifeCycleStatus: RETIRED
  OutOfService: null
  FA_ID: null
  PaintStencil: null
  Number_of_Extensions: 0
  Closed_In_Accounting: null
  SolidStem: null
  Condition: null
  DataValid_Comment: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• GIS_PROD.GDB_ADMIN.HydrantHistory (0) -- Related To: MaintenanceHydrantHistory (33)

Capabilities: Query,Create,Update,Uploads,Editing

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   Query Related Records   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata