View In:   ArcGIS Online Map Viewer

Name: Test Hydrant Color

Display Field: ASSETCODE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

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: T_HydrantColor
Field 2: null
Field 3: null
Field Delimiter: ;
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: New or Not Tested (0)
  Label: New or Not Tested (0)
  Description:
  Symbol:
  
• Value: Blue (>=1,500)
  Label: Blue (>=1,500)
  Description:
  Symbol:
  
• Value: Green (1,000 - 1,499)
  Label: Green (1,000 - 1,499)
  Description:
  Symbol:
  
• Value: Orange (500 - 999)
  Label: Orange (500 - 999)
  Description:
  Symbol:
  
• Value: Red (350 - 499)
  Label: Red (350 - 499)
  Description:
  Symbol:
  
• Value: Black (1 - 349)
  Label: Black (1 - 349)
  Description:
  Symbol:
  
• Value: Private
  Label: Private
  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: T_HydrantColor

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• 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 )
• 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 )
• 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: New or Not Tested (0)
Name: New or Not Tested (0)
Domains:
• Phy_Owner:
  Inherited
• T_HydrantColor:
  Inherited
• Phy_Make:
  Inherited
• Phy_ValvePresent:
  Inherited
• Phy_PressureZone:
  Inherited
• Op_Status:
  Inherited
• Op_StatusChangeBy:
  Inherited
• Op_StatusChangeReason:
  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: New or Not Tested (0)
  Description:
  Prototype:
  FD_OpStatus: null
  FDFLOW: null
  ASSETCODE: null
  Phy_Owner: null
  Phy_Location: 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
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Blue (>=1,500)
Name: Blue (>=1,500)
Domains:
• Phy_Owner:
  Inherited
• T_HydrantColor:
  Inherited
• Phy_Make:
  Inherited
• Phy_ValvePresent:
  Inherited
• Phy_PressureZone:
  Inherited
• Op_Status:
  Inherited
• Op_StatusChangeBy:
  Inherited
• Op_StatusChangeReason:
  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: Blue (>=1,500)
  Description:
  Prototype:
  FD_OpStatus: null
  FDFLOW: null
  ASSETCODE: null
  Phy_Owner: null
  Phy_Location: 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: Blue (>=1,500)
  T_Comments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Green (1,000 - 1,499)
Name: Green (1,000 - 1,499)
Domains:
• Phy_Owner:
  Inherited
• T_HydrantColor:
  Inherited
• Phy_Make:
  Inherited
• Phy_ValvePresent:
  Inherited
• Phy_PressureZone:
  Inherited
• Op_Status:
  Inherited
• Op_StatusChangeBy:
  Inherited
• Op_StatusChangeReason:
  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: Green (1,000 - 1,499)
  Description:
  Prototype:
  FD_OpStatus: null
  FDFLOW: null
  ASSETCODE: null
  Phy_Owner: null
  Phy_Location: 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: Green (1,000 - 1,499)
  T_Comments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Orange (500 - 999)
Name: Orange (500 - 999)
Domains:
• Phy_Owner:
  Inherited
• T_HydrantColor:
  Inherited
• Phy_Make:
  Inherited
• Phy_ValvePresent:
  Inherited
• Phy_PressureZone:
  Inherited
• Op_Status:
  Inherited
• Op_StatusChangeBy:
  Inherited
• Op_StatusChangeReason:
  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: Orange (500 - 999)
  Description:
  Prototype:
  FD_OpStatus: null
  FDFLOW: null
  ASSETCODE: null
  Phy_Owner: null
  Phy_Location: 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: Orange (500 - 999)
  T_Comments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Red (350 - 499)
Name: Red (350 - 499)
Domains:
• Phy_Owner:
  Inherited
• T_HydrantColor:
  Inherited
• Phy_Make:
  Inherited
• Phy_ValvePresent:
  Inherited
• Phy_PressureZone:
  Inherited
• Op_Status:
  Inherited
• Op_StatusChangeBy:
  Inherited
• Op_StatusChangeReason:
  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: Red (350 - 499)
  Description:
  Prototype:
  FD_OpStatus: null
  FDFLOW: null
  ASSETCODE: null
  Phy_Owner: null
  Phy_Location: 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: Red (350 - 499)
  T_Comments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Black (1 - 349)
Name: Black (1 - 349)
Domains:
• Phy_Owner:
  Inherited
• T_HydrantColor:
  Inherited
• Phy_Make:
  Inherited
• Phy_ValvePresent:
  Inherited
• Phy_PressureZone:
  Inherited
• Op_Status:
  Inherited
• Op_StatusChangeBy:
  Inherited
• Op_StatusChangeReason:
  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: Black (1 - 349)
  Description:
  Prototype:
  FD_OpStatus: null
  FDFLOW: null
  ASSETCODE: null
  Phy_Owner: null
  Phy_Location: 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: Black (1 - 349)
  T_Comments: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Private
Name: Private
Domains:
• Phy_Owner:
  Inherited
• T_HydrantColor:
  Inherited
• Phy_Make:
  Inherited
• Phy_ValvePresent:
  Inherited
• Phy_PressureZone:
  Inherited
• Op_Status:
  Inherited
• Op_StatusChangeBy:
  Inherited
• Op_StatusChangeReason:
  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: Private
  Description:
  Prototype:
  FD_OpStatus: null
  FDFLOW: null
  ASSETCODE: null
  Phy_Owner: null
  Phy_Location: 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: Private
  T_Comments: 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