View In:   ArcGIS Online Map Viewer

Name: Hydrants

Display Field: ASSETCODE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

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

Supports Datum Transformation: true

Extent:

XMin: 1.1306705277440727E7
YMin: 6728408.642417148
XMax: 1.1334167301256716E7
YMax: 6755050.548778892
Spatial Reference: 102746  (2283)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Phy_Owner
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: COS
  Label: COS
  Description:
  Symbol:
  
• Value: PVT
  Label: PVT
  Description:
  Symbol:
  
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: Phy_Owner

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• NORTHING ( type: esriFieldTypeDouble, alias: Northing, editable: true, nullable: true, defaultValue: null, modelName: NORTHING )
• EASTING ( type: esriFieldTypeDouble, alias: Easting, editable: true, nullable: true, defaultValue: null, modelName: EASTING )
• ASSETCODE ( type: esriFieldTypeString, alias: Asset Code, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ASSETCODE )
• Phy_Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Phy_Owner , Coded Values: [COS: COS] , [PVT: PVT] )
• Phy_Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Phy_Location )
• Phy_Year ( type: esriFieldTypeDouble, alias: Year Installed, editable: true, nullable: true, defaultValue: 0, modelName: Phy_Year )
• Phy_Make ( type: esriFieldTypeString, alias: Make, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Phy_Make , Coded Values: [Kennedy: Kennedy] , [AVK: AVK] , [A. Darling: A. Darling] , ...5 more... )
• Phy_ValvePresent ( type: esriFieldTypeString, alias: Valve Present, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Phy_ValvePresent , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• Phy_Elevation ( type: esriFieldTypeDouble, alias: Elevation (ft), editable: true, nullable: true, defaultValue: 0, modelName: Phy_Elevation )
• Phy_PressureZone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Phy_PressureZone , Coded Values: [Amherst Road: Amherst Road] , [Backwash WTP: Backwash WTP] , [Bonfoey PRV: Bonfoey PRV] , ...11 more... )
• Phy_Photo ( type: esriFieldTypeString, alias: Photo, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Phy_Photo )
• Op_Status ( type: esriFieldTypeString, alias: Op Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Op_Status , Coded Values: [OK: OK] , [OOS: OOS] )
• Op_StatusChangeDate ( type: esriFieldTypeDate, alias: Op Status Change Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Op_StatusChangeDate )
• Op_StatusChangeBy ( type: esriFieldTypeString, alias: Op Status Change By (Name), editable: true, nullable: true, length: 100, defaultValue: null, modelName: Op_StatusChangeBy , Coded Values: [B. Davis: B. Davis] , [C. Combs: C. Combs] , [C. Littlejohn: C. Littlejohn] , ...10 more... )
• Op_StatusChangeReason ( type: esriFieldTypeString, alias: Op Status Change Reason, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Op_StatusChangeReason , Coded Values: [In Service (OK): In Service (OK)] , [Frozen (OOS): Frozen (OOS)] , [Inoperable (OOS): Inoperable (OOS)] , ...1 more... )
• T_Date ( type: esriFieldTypeDate, alias: Test Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: T_Date )
• T_Time ( type: esriFieldTypeString, alias: Test Time, editable: true, nullable: true, length: 50, defaultValue: 0, modelName: T_Time )
• T_By ( type: esriFieldTypeString, alias: Test By (Name), editable: true, nullable: true, length: 100, defaultValue: null, modelName: T_By )
• T_Age ( type: esriFieldTypeDouble, alias: Test Age (Days), editable: true, nullable: true, defaultValue: -1, modelName: T_Age )
• T_Flow ( type: esriFieldTypeString, alias: Test Flow Hydrants (no.), editable: true, nullable: true, length: 50, defaultValue: New or Not Tested, modelName: T_Flow )
• T_PressureStatic ( type: esriFieldTypeDouble, alias: Test Pressure Static (psi), editable: true, nullable: true, defaultValue: -1, modelName: T_PressureStatic )
• T_PressureResidual ( type: esriFieldTypeDouble, alias: Test Pressure Residual (psi), editable: true, nullable: true, defaultValue: -1, modelName: T_PressureResidual )
• T_PressureDrop ( type: esriFieldTypeString, alias: Test Pressure Drop (psi), editable: true, nullable: true, length: 50, defaultValue: New or Not Tested, modelName: T_PressureDrop )
• T_TotalFlow ( type: esriFieldTypeString, alias: Test Total Flow (gpm), editable: true, nullable: true, length: 50, defaultValue: New or Not Tested, modelName: T_TotalFlow )
• T_AvailableFlow ( type: esriFieldTypeString, alias: Test Available Flow (gpm), editable: true, nullable: true, length: 50, defaultValue: New or Not Tested, modelName: T_AvailableFlow )
• T_HydrantColor ( type: esriFieldTypeString, alias: Test Hydrant Color, editable: true, nullable: true, length: 50, defaultValue: New or Not Tested (0), modelName: T_HydrantColor , Coded Values: [New or Not Tested (0): New or Not Tested (0)] , [Blue (>=1,500): Blue (>=1,500)] , [Green (1,000 - 1,499): Green (1,000 - 1,499)] , ...4 more... )
• T_Comments ( type: esriFieldTypeString, alias: Test Comments, editable: true, nullable: true, length: 200, defaultValue: null, modelName: T_Comments )
• T_ResultForm ( type: esriFieldTypeString, alias: Test Result Form, editable: true, nullable: true, length: 300, defaultValue: null, modelName: T_ResultForm )
• Pr_CurrentLocation ( type: esriFieldTypeString, alias: PR Current Location, editable: true, nullable: true, length: 50, defaultValue: No, modelName: Pr_CurrentLocation )
• Pr_StartDate ( type: esriFieldTypeDate, alias: PR Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Pr_StartDate )
• Pr_EndDate ( type: esriFieldTypeDate, alias: PR End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Pr_EndDate )
• Pr_LowMinPressure ( type: esriFieldTypeDouble, alias: PR Lowest Min Pressure (psi), editable: true, nullable: true, defaultValue: -1, modelName: Pr_LowMinPressure )
• Pr_AvgMinPressure ( type: esriFieldTypeDouble, alias: PR Avg Min Pressure (psi), editable: true, nullable: true, defaultValue: -1, modelName: Pr_AvgMinPressure )
• Pr_AvgAvgPressure ( type: esriFieldTypeDouble, alias: PR Avg Avg Pressure (psi), editable: true, nullable: true, defaultValue: -1, modelName: Pr_AvgAvgPressure )
• Pr_AvgMaxPressure ( type: esriFieldTypeDouble, alias: PR Avg Max Pressure (psi), editable: true, nullable: true, defaultValue: -1, modelName: Pr_AvgMaxPressure )
• Pr_HighMaxPressure ( type: esriFieldTypeDouble, alias: PR Highest Max Pressure (psi), editable: true, nullable: true, defaultValue: -1, modelName: Pr_HighMaxPressure )
• Pr_AvgFluMag ( type: esriFieldTypeDouble, alias: PR Avg Fluctuation Magnitude (psi), editable: true, nullable: true, defaultValue: -1, modelName: Pr_AvgFluMag )
• Pr_MaxFluMag ( type: esriFieldTypeDouble, alias: PR Max Fluctuation Magnitude (psi), editable: true, nullable: true, defaultValue: -1, modelName: Pr_MaxFluMag )
• Pr_Comments ( type: esriFieldTypeString, alias: PR Comments, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Pr_Comments )
• Pr_Graph ( type: esriFieldTypeString, alias: PR Graph, editable: true, nullable: true, length: 300, defaultValue: null, modelName: Pr_Graph )
• Rm_RepairNeeded ( type: esriFieldTypeString, alias: Repair Needed, editable: true, nullable: true, length: 50, defaultValue: No, modelName: Rm_RepairNeeded , Coded Values: [New: New] , [No: No] , [Yes: Yes] )
• Rm_RepairRequestDate ( type: esriFieldTypeDate, alias: Repair Request Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Rm_RepairRequestDate )
• Rm_RepairRequestBy ( type: esriFieldTypeString, alias: Repair Request By (Name), editable: true, nullable: true, length: 100, defaultValue: null, modelName: Rm_RepairRequestBy , Coded Values: [B. Davis: B. Davis] , [C. Combs: C. Combs] , [C. Littlejohn: C. Littlejohn] , ...12 more... )
• Rm_RepairRequestReason ( type: esriFieldTypeString, alias: Repair Request Reason, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Rm_RepairRequestReason , Coded Values: [Access: Access] , [Age: Age] , [Condition: Condition] , ...8 more... )
• Rm_RepairRequestAction ( type: esriFieldTypeString, alias: Repair Request Action, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Rm_RepairRequestAction , Coded Values: [Check: Check] , [Clear: Clear] , [Grease: Grease] , ...8 more... )
• Rm_RepairRequestItem ( type: esriFieldTypeString, alias: Repair Request Item, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Rm_RepairRequestItem , Coded Values: [Bonnet: Bonnet] , [Break-Away: Break-Away] , [Cap: Cap] , ...9 more... )
• Rm_RepairRequestComment ( type: esriFieldTypeString, alias: Repair Request Comment, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Rm_RepairRequestComment )
• Rm_RepairRequestAge ( type: esriFieldTypeDouble, alias: Repair Request Age, editable: true, nullable: true, defaultValue: -1, modelName: Rm_RepairRequestAge )
• Rm_CompletedDate ( type: esriFieldTypeDate, alias: Completed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Rm_CompletedDate )
• Rm_RepairCompletedBy ( type: esriFieldTypeString, alias: Repair Completed By (Name), editable: true, nullable: true, length: 100, defaultValue: null, modelName: Rm_RepairCompletedBy , Coded Values: [A. Bowers: A. Bowers] , [B. Davis: B. Davis] , [C. Combs: C. Combs] , ...13 more... )
• Rm_RepairCompletedAction ( type: esriFieldTypeString, alias: Repair Completed Action, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Rm_RepairCompletedAction , Coded Values: [Checked: Checked] , [Cleared: Cleared] , [Greased: Greased] , ...9 more... )
• Rm_RepairCompletedItem ( type: esriFieldTypeString, alias: Repair Completed Item, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Rm_RepairCompletedItem , Coded Values: [Bonnet: Bonnet] , [Break-Away: Break-Away] , [Cap: Cap] , ...9 more... )
• Rm_RepairCompletedComment ( type: esriFieldTypeString, alias: Repair Completed Comment, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Rm_RepairCompletedComment )
• P_PaintCompletedDate ( type: esriFieldTypeDate, alias: Paint Completed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: P_PaintCompletedDate )
• P_PaintCompleteBy ( type: esriFieldTypeString, alias: Paint Complete By (Name), editable: true, nullable: true, length: 100, defaultValue: null, modelName: P_PaintCompleteBy , Coded Values: [B. Davis: B. Davis] , [C. Combs: C. Combs] , [C. Littlejohn: C. Littlejohn] , ...12 more... )
• P_PaintColorPainted ( type: esriFieldTypeString, alias: Paint Color Painted, editable: true, nullable: true, length: 50, defaultValue: null, modelName: P_PaintColorPainted , Coded Values: [Blue: Blue] , [Green: Green] , [Orange: Orange] , ...3 more... )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FD_OpStatus ( type: esriFieldTypeString, alias: FD_OpStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FD_OpStatus )
• FDFLOW ( type: esriFieldTypeDouble, alias: FDFLOW, editable: true, nullable: true, defaultValue: null, modelName: FDFLOW )

Types:

ID: COS
Name: COS
Domains:
• Phy_Owner:
  Inherited
• Phy_Make:
  Inherited
• Phy_ValvePresent:
  Inherited
• Phy_PressureZone:
  Inherited
• Op_Status:
  Inherited
• Op_StatusChangeBy:
  Inherited
• Op_StatusChangeReason:
  Inherited
• T_HydrantColor:
  Inherited
• Rm_RepairNeeded:
  Inherited
• Rm_RepairRequestBy:
  Inherited
• Rm_RepairRequestReason:
  Inherited
• Rm_RepairRequestAction:
  Inherited
• Rm_RepairRequestItem:
  Inherited
• Rm_RepairCompletedBy:
  Inherited
• Rm_RepairCompletedAction:
  Inherited
• Rm_RepairCompletedItem:
  Inherited
• P_PaintCompleteBy:
  Inherited
• P_PaintColorPainted:
  Inherited
Templates:
• Name: COS
  Description:
  Prototype:
  FD_OpStatus: null
  FDFLOW: null
  NORTHING: null
  EASTING: null
  ASSETCODE: null
  Phy_Owner: COS
  Phy_Location: null
  Phy_Year: 0
  Phy_Make: null
  Phy_ValvePresent: null
  Phy_Elevation: 0
  Phy_PressureZone: null
  Phy_Photo: null
  Op_Status: null
  Op_StatusChangeDate: null
  Op_StatusChangeBy: null
  Op_StatusChangeReason: null
  T_Date: null
  T_Time: 0
  T_By: null
  T_Age: -1
  T_Flow: New or Not Tested
  T_PressureStatic: -1
  T_PressureResidual: -1
  T_PressureDrop: New or Not Tested
  T_TotalFlow: New or Not Tested
  T_AvailableFlow: New or Not Tested
  T_HydrantColor: New or Not Tested (0)
  T_Comments: null
  T_ResultForm: null
  Pr_CurrentLocation: No
  Pr_StartDate: null
  Pr_EndDate: null
  Pr_LowMinPressure: -1
  Pr_AvgMinPressure: -1
  Pr_AvgAvgPressure: -1
  Pr_AvgMaxPressure: -1
  Pr_HighMaxPressure: -1
  Pr_AvgFluMag: -1
  Pr_MaxFluMag: -1
  Pr_Comments: null
  Pr_Graph: null
  Rm_RepairNeeded: No
  Rm_RepairRequestDate: null
  Rm_RepairRequestBy: null
  Rm_RepairRequestReason: null
  Rm_RepairRequestAction: null
  Rm_RepairRequestItem: null
  Rm_RepairRequestComment: null
  Rm_RepairRequestAge: -1
  Rm_CompletedDate: null
  Rm_RepairCompletedBy: null
  Rm_RepairCompletedAction: null
  Rm_RepairCompletedItem: null
  Rm_RepairCompletedComment: null
  P_PaintCompletedDate: null
  P_PaintCompleteBy: null
  P_PaintColorPainted: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: PVT
Name: PVT
Domains:
• Phy_Owner:
  Inherited
• Phy_Make:
  Inherited
• Phy_ValvePresent:
  Inherited
• Phy_PressureZone:
  Inherited
• Op_Status:
  Inherited
• Op_StatusChangeBy:
  Inherited
• Op_StatusChangeReason:
  Inherited
• T_HydrantColor:
  Inherited
• Rm_RepairNeeded:
  Inherited
• Rm_RepairRequestBy:
  Inherited
• Rm_RepairRequestReason:
  Inherited
• Rm_RepairRequestAction:
  Inherited
• Rm_RepairRequestItem:
  Inherited
• Rm_RepairCompletedBy:
  Inherited
• Rm_RepairCompletedAction:
  Inherited
• Rm_RepairCompletedItem:
  Inherited
• P_PaintCompleteBy:
  Inherited
• P_PaintColorPainted:
  Inherited
Templates:
• Name:
  Description:
  Prototype:
  ASSETCODE: null
  Phy_Location: null
  Phy_ValvePresent: null
  T_Date: null
  T_By: null
  T_Age: -1
  T_Flow: New or Not Tested
  T_PressureStatic: -1
  T_PressureResidual: -1
  T_PressureDrop: New or Not Tested
  T_TotalFlow: New or Not Tested
  T_ResultForm: null
  Pr_EndDate: null
  Pr_AvgMaxPressure: -1
  Pr_AvgFluMag: -1
  Pr_Graph: null
  Rm_RepairRequestComment: null
  Pr_LowMinPressure: -1
  Pr_AvgMinPressure: -1
  Pr_AvgAvgPressure: -1
  Pr_HighMaxPressure: -1
  FD_OpStatus: null
  NORTHING: null
  EASTING: null
  Phy_Owner: PVT
  Phy_Year: 0
  Phy_Make: null
  Phy_Elevation: 0
  Phy_PressureZone: null
  Phy_Photo: null
  Op_Status: null
  Op_StatusChangeDate: null
  Op_StatusChangeBy: null
  Op_StatusChangeReason: null
  T_Time: 0
  T_AvailableFlow: New or Not Tested
  T_HydrantColor: null
  T_Comments: null
  Pr_CurrentLocation: No
  Pr_StartDate: null
  Pr_MaxFluMag: -1
  Pr_Comments: null
  Rm_RepairNeeded: No
  Rm_RepairRequestDate: null
  Rm_RepairRequestBy: null
  Rm_RepairRequestReason: null
  Rm_RepairRequestAction: null
  Rm_RepairRequestItem: null
  Rm_RepairRequestAge: -1
  Rm_CompletedDate: null
  Rm_RepairCompletedBy: null
  Rm_RepairCompletedAction: null
  Rm_RepairCompletedItem: null
  Rm_RepairCompletedComment: null
  P_PaintCompletedDate: null
  P_PaintCompleteBy: null
  P_PaintColorPainted: null
  FDFLOW: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,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

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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