View In:
ArcGIS Online Map Viewer
Parent Layer:
WaterDistributionNetwork
Name: Valves
Display Field: cFacilityID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Service Item Id: 2c96c38ba295499e82f7d52b783ede50
Copyright Text:
Default Visibility: true
MaxRecordCount: 2000
MaxSelectionCount: 0
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 4800.0
Max Scale: 0.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: 1853588.6363069832
YMin: 724208.3756809823
XMax: 1881935.4402595884
YMax: 749255.1517848432
Spatial Reference: 102723
(3735)
LatestVCSWkid(0)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: AssetGroup
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol: Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
Default Label: <all other values>
UniqueValueInfos:
-
Value: 0
Label: Unknown
Description: N/A
Symbol:
-
Value: 1
Label: Isolation Valve
Description: N/A
Symbol:
-
Value: 2
Label: Boundary Valve
Description: N/A
Symbol:
-
Value: 3
Label: Pressure Zone Valve
Description: N/A
Symbol:
-
Value: 4
Label: Pressure Reducing Valve
Description: N/A
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
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: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: AssetGroup
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
-
cFacilityID
(
type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cFacilityID
)
-
cLegacyID
(
type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: cLegacyID
)
-
Address
(
type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 130, defaultValue: null, modelName: Address
)
-
Location
(
type: esriFieldTypeString, alias: Location Details, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Location
)
-
InstallDate
(
type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate
)
-
WarrantyDate
(
type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate
)
-
cWarranty
(
type: esriFieldTypeString, alias: Warranty Information, editable: true, nullable: true, length: 256, defaultValue: null, modelName: cWarranty
)
-
cWarrantyResponsible
(
type: esriFieldTypeString, alias: Warranty Responsible, editable: true, nullable: true, length: 20, defaultValue: null, modelName: cWarrantyResponsible
)
-
cStatus
(
type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: cStatus
, Coded Values:
[INSERV: In Service]
, [OOSERV: Out of Service]
, [DISPOSE: Disposed/Removed]
, ...2 more...
)
-
cAssetCost
(
type: esriFieldTypeDouble, alias: Asset Cost, editable: true, nullable: true, defaultValue: null, modelName: cAssetCost
)
-
cCondition
(
type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: cCondition
, Coded Values:
[1: Excellent]
, [2: Good]
, [3: Fair]
, ...1 more...
)
-
cConditionDate
(
type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cConditionDate
)
-
cLifeExpectancy
(
type: esriFieldTypeSmallInteger, alias: Life Expectancy in Yrs, editable: true, nullable: true, defaultValue: null, modelName: cLifeExpectancy
)
-
cCOF
(
type: esriFieldTypeSmallInteger, alias: Consequence of Failure, editable: true, nullable: true, defaultValue: null, modelName: cCOF
)
-
cPOF
(
type: esriFieldTypeSmallInteger, alias: Probability of Failure, editable: true, nullable: true, defaultValue: null, modelName: cPOF
)
-
cBRE
(
type: esriFieldTypeSmallInteger, alias: Business Risk Exposure, editable: true, nullable: true, defaultValue: null, modelName: cBRE
)
-
cHazard
(
type: esriFieldTypeString, alias: Hazard?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: cHazard
)
-
cComments
(
type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: cComments
)
-
IsoValveType
(
type: esriFieldTypeString, alias: Isolation Valve Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IsoValveType
, Coded Values:
[BF: Butterfly]
, [GT: Gate Valve]
, [UNK: Unknown]
)
-
ValveSize
(
type: esriFieldTypeSmallInteger, alias: Isolation Valve size, editable: true, nullable: true, defaultValue: null, modelName: ValveSize
, Coded Values:
[2: 2 in]
, [3: 3 in]
, [4: 4 in]
, ...8 more...
)
-
ValvePrivate
(
type: esriFieldTypeString, alias: Private Isolation Valve, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ValvePrivate
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
ValveCondition
(
type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ValveCondition
, Coded Values:
[O: Operable]
, [N: Non-operable (spins, leaning, debris, buried)]
, [U: Unknown]
)
-
ValveExerciseDate
(
type: esriFieldTypeDate, alias: Exercise Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ValveExerciseDate
)
-
ValveProperPosition
(
type: esriFieldTypeString, alias: Proper Position, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ValveProperPosition
, Coded Values:
[Open: Open]
, [Closed: Closed]
, [Unknown: Unknown]
)
-
ValveDateLocated
(
type: esriFieldTypeDate, alias: Date Located, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ValveDateLocated
)
-
ValveNumberTurns
(
type: esriFieldTypeSmallInteger, alias: Number of Turns, editable: true, nullable: true, defaultValue: null, modelName: ValveNumberTurns
)
-
ValvePositionFound
(
type: esriFieldTypeString, alias: Valve Position Found, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ValvePositionFound
, Coded Values:
[Open: Open]
, [Closed: Closed]
, [Unknown: Unknown]
)
-
ValveAssistanceNeeded
(
type: esriFieldTypeString, alias: Valve Assistance Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ValveAssistanceNeeded
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
ValveDefects
(
type: esriFieldTypeString, alias: Defects, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ValveDefects
, Coded Values:
[LK: Leaking]
, [BR: Buried]
, [DB: Debris]
, ...4 more...
)
-
ValveRepairComplete
(
type: esriFieldTypeDate, alias: Date Repair Completed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ValveRepairComplete
)
-
Notes
(
type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Notes
)
-
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
)
-
ValveType
(
type: esriFieldTypeSmallInteger, alias: Valve Type, editable: true, nullable: true, defaultValue: 1, modelName: ValveType
, Coded Values:
[1: Isolation Valve]
, [2: Boundary Valve]
, [3: Pressure Zone Valvle]
, ...1 more...
)
-
BoundaryValve
(
type: esriFieldTypeString, alias: Boundary Valve, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BoundaryValve
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
UpStreamPressure
(
type: esriFieldTypeSmallInteger, alias: Upstream Pressure , editable: true, nullable: true, defaultValue: null, modelName: UpStreamPressure
)
-
UpstreamHgl
(
type: esriFieldTypeDouble, alias: Upstream Hgl, editable: true, nullable: true, defaultValue: null, modelName: UpstreamHgl
)
-
DownstreamPressure
(
type: esriFieldTypeSmallInteger, alias: Downstream Pressure, editable: true, nullable: true, defaultValue: null, modelName: DownstreamPressure
)
-
DownstreamHgl
(
type: esriFieldTypeDouble, alias: Downstream Hgl, editable: true, nullable: true, defaultValue: null, modelName: DownstreamHgl
)
-
ValveElevation
(
type: esriFieldTypeDouble, alias: Valve Elevation, editable: true, nullable: true, defaultValue: null, modelName: ValveElevation
)
-
Brand
(
type: esriFieldTypeString, alias: Brand Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Brand
)
-
AssetGroup
(
type: esriFieldTypeInteger, alias: Asset Group, editable: true, nullable: true, defaultValue: 0, modelName: AssetGroup
)
Types:
ID: 0
Name: Unknown
Domains:
-
cStatus:
Inherited
-
cCondition:
Inherited
-
IsoValveType:
Inherited
-
ValveSize:
Inherited
-
ValvePrivate:
Inherited
-
ValveCondition:
Inherited
-
ValveProperPosition:
Inherited
-
ValvePositionFound:
Inherited
-
ValveAssistanceNeeded:
Inherited
-
ValveDefects:
Inherited
-
ValveType:
Inherited
-
BoundaryValve:
Inherited
Templates:
-
Name: Unknown
Description:
Prototype:
Brand: null
ValveElevation: null
AssetGroup: 0
cFacilityID: null
cLegacyID: null
Address: null
Location: null
InstallDate: null
WarrantyDate: null
cWarranty: null
cWarrantyResponsible: null
cStatus: null
cAssetCost: null
cCondition: null
cConditionDate: null
cLifeExpectancy: null
cCOF: null
cPOF: null
cBRE: null
cHazard: null
cComments: null
IsoValveType: null
ValveSize: null
ValvePrivate: null
ValveCondition: null
ValveExerciseDate: null
ValveProperPosition: null
ValveDateLocated: null
ValveNumberTurns: null
ValvePositionFound: null
ValveAssistanceNeeded: null
ValveDefects: null
ValveRepairComplete: null
Notes: null
DownstreamHgl: null
DownstreamPressure: null
UpstreamHgl: null
UpStreamPressure: null
ValveType: 1
BoundaryValve: null
Drawing Tool: esriFeatureEditToolPoint
ID: 1
Name: Isolation Valve
Domains:
-
cStatus:
Inherited
-
cCondition:
Inherited
-
IsoValveType:
Inherited
-
ValveSize:
Inherited
-
ValvePrivate:
Inherited
-
ValveCondition:
Inherited
-
ValveProperPosition:
Inherited
-
ValvePositionFound:
Inherited
-
ValveAssistanceNeeded:
Inherited
-
ValveDefects:
Inherited
-
ValveType:
Inherited
-
BoundaryValve:
Inherited
Templates:
-
Name: Isolation Valve
Description:
Prototype:
Brand: null
ValveElevation: null
AssetGroup: 1
cFacilityID: null
cLegacyID: null
Address: null
Location: null
InstallDate: null
WarrantyDate: null
cWarranty: null
cWarrantyResponsible: null
cStatus: null
cAssetCost: null
cCondition: null
cConditionDate: null
cLifeExpectancy: null
cCOF: null
cPOF: null
cBRE: null
cHazard: null
cComments: null
IsoValveType: null
ValveSize: null
ValvePrivate: null
ValveCondition: null
ValveExerciseDate: null
ValveProperPosition: null
ValveDateLocated: null
ValveNumberTurns: null
ValvePositionFound: null
ValveAssistanceNeeded: null
ValveDefects: null
ValveRepairComplete: null
Notes: null
DownstreamHgl: null
DownstreamPressure: null
UpstreamHgl: null
UpStreamPressure: null
ValveType: 1
BoundaryValve: null
Drawing Tool: esriFeatureEditToolPoint
ID: 2
Name: Boundary Valve
Domains:
-
cStatus:
Inherited
-
cCondition:
Inherited
-
IsoValveType:
Inherited
-
ValveSize:
Inherited
-
ValvePrivate:
Inherited
-
ValveCondition:
Inherited
-
ValveProperPosition:
Inherited
-
ValvePositionFound:
Inherited
-
ValveAssistanceNeeded:
Inherited
-
ValveDefects:
Inherited
-
ValveType:
Inherited
-
BoundaryValve:
Inherited
Templates:
-
Name: Boundary Valve
Description:
Prototype:
Brand: null
ValveElevation: null
AssetGroup: 2
cFacilityID: null
cLegacyID: null
Address: null
Location: null
InstallDate: null
WarrantyDate: null
cWarranty: null
cWarrantyResponsible: null
cStatus: null
cAssetCost: null
cCondition: null
cConditionDate: null
cLifeExpectancy: null
cCOF: null
cPOF: null
cBRE: null
cHazard: null
cComments: null
IsoValveType: null
ValveSize: null
ValvePrivate: null
ValveCondition: null
ValveExerciseDate: null
ValveProperPosition: null
ValveDateLocated: null
ValveNumberTurns: null
ValvePositionFound: null
ValveAssistanceNeeded: null
ValveDefects: null
ValveRepairComplete: null
Notes: null
DownstreamHgl: null
DownstreamPressure: null
UpstreamHgl: null
UpStreamPressure: null
ValveType: 1
BoundaryValve: null
Drawing Tool: esriFeatureEditToolPoint
ID: 3
Name: Pressure Zone Valve
Domains:
-
cStatus:
Inherited
-
cCondition:
Inherited
-
IsoValveType:
Inherited
-
ValveSize:
Inherited
-
ValvePrivate:
Inherited
-
ValveCondition:
Inherited
-
ValveProperPosition:
Inherited
-
ValvePositionFound:
Inherited
-
ValveAssistanceNeeded:
Inherited
-
ValveDefects:
Inherited
-
ValveType:
Inherited
-
BoundaryValve:
Inherited
Templates:
-
Name: Pressure Zone Valve
Description:
Prototype:
Brand: null
ValveElevation: null
AssetGroup: 3
cFacilityID: null
cLegacyID: null
Address: null
Location: null
InstallDate: null
WarrantyDate: null
cWarranty: null
cWarrantyResponsible: null
cStatus: null
cAssetCost: null
cCondition: null
cConditionDate: null
cLifeExpectancy: null
cCOF: null
cPOF: null
cBRE: null
cHazard: null
cComments: null
IsoValveType: null
ValveSize: null
ValvePrivate: null
ValveCondition: null
ValveExerciseDate: null
ValveProperPosition: null
ValveDateLocated: null
ValveNumberTurns: null
ValvePositionFound: null
ValveAssistanceNeeded: null
ValveDefects: null
ValveRepairComplete: null
Notes: null
DownstreamHgl: null
DownstreamPressure: null
UpstreamHgl: null
UpStreamPressure: null
ValveType: 1
BoundaryValve: null
Drawing Tool: esriFeatureEditToolPoint
ID: 4
Name: Pressure Reducing Valve
Domains:
-
cStatus:
Inherited
-
cCondition:
Inherited
-
IsoValveType:
Inherited
-
ValveSize:
Inherited
-
ValvePrivate:
Inherited
-
ValveCondition:
Inherited
-
ValveProperPosition:
Inherited
-
ValvePositionFound:
Inherited
-
ValveAssistanceNeeded:
Inherited
-
ValveDefects:
Inherited
-
ValveType:
Inherited
-
BoundaryValve:
Inherited
Templates:
-
Name: Pressure Reducing Valve
Description:
Prototype:
Brand: null
ValveElevation: null
AssetGroup: 4
cFacilityID: null
cLegacyID: null
Address: null
Location: null
InstallDate: null
WarrantyDate: null
cWarranty: null
cWarrantyResponsible: null
cStatus: null
cAssetCost: null
cCondition: null
cConditionDate: null
cLifeExpectancy: null
cCOF: null
cPOF: null
cBRE: null
cHazard: null
cComments: null
IsoValveType: null
ValveSize: null
ValvePrivate: null
ValveCondition: null
ValveExerciseDate: null
ValveProperPosition: null
ValveDateLocated: null
ValveNumberTurns: null
ValvePositionFound: null
ValveAssistanceNeeded: null
ValveDefects: null
ValveRepairComplete: null
Notes: null
DownstreamHgl: null
DownstreamPressure: null
UpstreamHgl: null
UpStreamPressure: null
ValveType: 1
BoundaryValve: 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
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: false
Supports Coordinates Quantization: true
Child Resources:
Supported Operations:
Query
Query Analytic
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata
Update Metadata