Parent Layer: Retic Water

Name: Retic Water - Valve (Zonal valves all scales)

Display Field: ComputerName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset represents the locations of Water Valves.

Copyright Text: Department Water and Sanitation Operational GIS 2nd Floor, TOC building

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 128000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -62755.485299999826
YMin: -3789256.5127
XMax: -5204.013849999756
YMax: -3709325.4083000002
Spatial Reference: PROJCS["WGS_1984_Transverse_Mercator",GEOGCS["GCS_WGS_1984",DATUM["D_Hartebeesthoek_1994",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",19.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LU_VLV
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 2
  Label: Divisional (DV)
  Description:
  Symbol:
  
• Value: 5
  Label: Pressure Reducing (PRV)
  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: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: LU_VLV

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• LU_VLV ( type: esriFieldTypeInteger, alias: VALVE FUNCTION )
• GIS_KEY ( type: esriFieldTypeString, alias: GIS ID, length: 10 )
• SAP_KEY ( type: esriFieldTypeString, alias: SAP ID, length: 30 )
• INST_DATE ( type: esriFieldTypeDate, alias: DATE INSTALLED, length: 8 )
• VRFD_DATE ( type: esriFieldTypeDate, alias: DATE VERIFIED, length: 8 )
• VRFD_BY ( type: esriFieldTypeString, alias: VERIFIED BY, length: 15 )
• RTN ( type: esriFieldTypeDouble, alias: ROTATION )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 300 )
• MDP_LU_SRC ( type: esriFieldTypeString, alias: MDP_LU_SRC, length: 20 )
• MDP_LU_MNTN ( type: esriFieldTypeString, alias: MDP_LU_MNTN, length: 15 )
• MDP_MNTN_DATE ( type: esriFieldTypeDate, alias: MDP_MNTN_DATE, length: 8 )
• MDP_PRJ_NMBR ( type: esriFieldTypeString, alias: MDP_PRJ_NMBR, length: 60 )
• HIGHT ( type: esriFieldTypeDouble, alias: HIGHT )
• ActivityID ( type: esriFieldTypeString, alias: ActivityID, length: 20 )
• LastActivity ( type: esriFieldTypeString, alias: LastActivity, length: 4 , Coded Values: [INST: Installation] , [UPDT: Update Info] , [EXE: Exercise Valve] , ...4 more... )
• DateStamp ( type: esriFieldTypeDate, alias: DateStamp, length: 8 )
• OpTime ( type: esriFieldTypeString, alias: OpTime, length: 5 )
• ComputerName ( type: esriFieldTypeString, alias: ComputerName, length: 30 )
• OperatedBy ( type: esriFieldTypeString, alias: OperatedBy, length: 30 )
• ValveID ( type: esriFieldTypeString, alias: ValveID, length: 20 )
• ValveFunction ( type: esriFieldTypeString, alias: ValveFunction, length: 20 , Coded Values: [DV: Distribution Valve] , [HV: Hydrant Valve] , [DS: Domestic Service] , ...9 more... )
• AssemblyType ( type: esriFieldTypeString, alias: AssemblyType, length: 20 , Coded Values: [BALL: BALL] , [BUTTERFLY: BUTTERFLY] , [FLANGE: FLANGE] , ...4 more... )
• ClockwiseToClose ( type: esriFieldTypeString, alias: ClockwiseToClose, length: 2 , Coded Values: [Y: Yes] , [N: No] )
• CurrentlyOpen ( type: esriFieldTypeString, alias: CurrentlyOpen, length: 2 , Coded Values: [Y: Yes] , [N: No] )
• TurnsToClose ( type: esriFieldTypeDouble, alias: TurnsToClose )
• OperationalStatus ( type: esriFieldTypeString, alias: OperationalStatus, length: 5 , Coded Values: [OK: OK] , [NRPR: Needs Repair] , [INOP: Inoperable] , ...4 more... )
• DepthToNut ( type: esriFieldTypeString, alias: DepthToNut, length: 5 )
• GpsX ( type: esriFieldTypeDouble, alias: GpsX )
• GpsY ( type: esriFieldTypeDouble, alias: GpsY )
• LocationDesc ( type: esriFieldTypeString, alias: LocationDesc, length: 200 )
• LinkedDocs ( type: esriFieldTypeString, alias: LinkedDocs, length: 500 )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• HighTorque ( type: esriFieldTypeSmallInteger, alias: HighTorque )
• ReqState ( type: esriFieldTypeString, alias: ReqState, length: 5 , Coded Values: [OPEN: Open] , [CLSD: Closed] , [THROT: Throttled] )
• TEMP_ID1 ( type: esriFieldTypeString, alias: TEMP_ID1, length: 50 )
• TEMP_ID2 ( type: esriFieldTypeString, alias: TEMP_ID2, length: 50 )
• LU_SYNC ( type: esriFieldTypeString, alias: LU_SYNC, length: 30 )
• SAP_OBJ_TYPE ( type: esriFieldTypeString, alias: SAP Object Type, length: 10 )
• SAP_DESCR ( type: esriFieldTypeString, alias: SAP Description, length: 40 )
• SAP_USR_STS ( type: esriFieldTypeSmallInteger, alias: SAP User Status , Coded Values: [-2: Unset] , [0: Sketched] , [1: GIS Captured] , ...5 more... )
• SAP_FLOC_OBJ_NMBR ( type: esriFieldTypeString, alias: SAP Floc Object Number, length: 22 )
• FIN_KEY ( type: esriFieldTypeString, alias: Financial Asset Key, length: 25 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• MNT_AUTH ( type: esriFieldTypeString, alias: Maintenance Authority, length: 25 , Coded Values: [Retic: Retic] , [Bulk: Bulk] , [EAM: EAM] , ...5 more... )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• EDIT_DATE ( type: esriFieldTypeDate, alias: EDIT_DATE, length: 8 )
• SYNC_DATE ( type: esriFieldTypeDate, alias: SYNC_DATE, length: 8 )
• CNTB ( type: esriFieldTypeString, alias: CONTRIBUTED, length: 10 , Coded Values: [YES: YES] , [NO: NO] , [UNKNOWN: UNKNOWN] , ...1 more... )
• DATE_CNTB ( type: esriFieldTypeDate, alias: DATE CONTRIBUTED, length: 8 )

Types:

ID: 1
Name: Isolation
Domains:
• MDP_LU_SRC:
  Coded Values: [AS-BUILT: AS-BUILT] , [CAD: CAD] , [FIELD INSPECTION: FIELD INSPECTION] , ...15 more...
• MDP_LU_MNTN:
  Coded Values: [REPLACEMENT: REPLACEMENT] , [PIPE LINING: PIPE LINING] , [N/A: N/A] , ...1 more...
• LastActivity:
  Inherited
• ValveFunction:
  Inherited
• AssemblyType:
  Inherited
• ClockwiseToClose:
  Inherited
• CurrentlyOpen:
  Inherited
• OperationalStatus:
  Inherited
• Enabled:
  Inherited
• ReqState:
  Inherited
• LU_SYNC:
  Coded Values: [Yes: Yes] , [No - Private: No - Private] , [No - Other: No - Other] , ...5 more...
• SAP_USR_STS:
  Inherited
• MNT_AUTH:
  Inherited
• CNTB:
  Inherited

---

ID: 3
Name: Air
Domains:
• MDP_LU_SRC:
  Coded Values: [AS-BUILT: AS-BUILT] , [CAD: CAD] , [FIELD INSPECTION: FIELD INSPECTION] , ...15 more...
• MDP_LU_MNTN:
  Coded Values: [REPLACEMENT: REPLACEMENT] , [PIPE LINING: PIPE LINING] , [N/A: N/A] , ...1 more...
• LastActivity:
  Inherited
• ValveFunction:
  Inherited
• AssemblyType:
  Inherited
• ClockwiseToClose:
  Inherited
• CurrentlyOpen:
  Inherited
• OperationalStatus:
  Inherited
• Enabled:
  Inherited
• ReqState:
  Inherited
• LU_SYNC:
  Coded Values: [Yes: Yes] , [No - Private: No - Private] , [No - Other: No - Other] , ...5 more...
• SAP_USR_STS:
  Inherited
• MNT_AUTH:
  Inherited
• CNTB:
  Inherited

---

ID: 4
Name: Scour
Domains:
• MDP_LU_SRC:
  Coded Values: [AS-BUILT: AS-BUILT] , [CAD: CAD] , [FIELD INSPECTION: FIELD INSPECTION] , ...15 more...
• MDP_LU_MNTN:
  Coded Values: [REPLACEMENT: REPLACEMENT] , [PIPE LINING: PIPE LINING] , [N/A: N/A] , ...1 more...
• LastActivity:
  Inherited
• ValveFunction:
  Inherited
• AssemblyType:
  Inherited
• ClockwiseToClose:
  Inherited
• CurrentlyOpen:
  Inherited
• OperationalStatus:
  Inherited
• Enabled:
  Inherited
• ReqState:
  Inherited
• LU_SYNC:
  Coded Values: [Yes: Yes] , [No - Private: No - Private] , [No - Other: No - Other] , ...5 more...
• SAP_USR_STS:
  Inherited
• MNT_AUTH:
  Inherited
• CNTB:
  Inherited

---

ID: 5
Name: Pressure Reducing (PRV)
Domains:
• MDP_LU_SRC:
  Coded Values: [AS-BUILT: AS-BUILT] , [CAD: CAD] , [FIELD INSPECTION: FIELD INSPECTION] , ...15 more...
• MDP_LU_MNTN:
  Coded Values: [REPLACEMENT: REPLACEMENT] , [PIPE LINING: PIPE LINING] , [N/A: N/A] , ...1 more...
• LastActivity:
  Inherited
• ValveFunction:
  Inherited
• AssemblyType:
  Inherited
• ClockwiseToClose:
  Inherited
• CurrentlyOpen:
  Inherited
• OperationalStatus:
  Inherited
• Enabled:
  Inherited
• ReqState:
  Inherited
• LU_SYNC:
  Coded Values: [Yes: Yes] , [No - Private: No - Private] , [No - Other: No - Other] , ...5 more...
• SAP_USR_STS:
  Inherited
• MNT_AUTH:
  Inherited
• CNTB:
  Inherited

---

ID: 6
Name: Pressure Sustaining
Domains:
• MDP_LU_SRC:
  Coded Values: [AS-BUILT: AS-BUILT] , [CAD: CAD] , [FIELD INSPECTION: FIELD INSPECTION] , ...15 more...
• MDP_LU_MNTN:
  Coded Values: [REPLACEMENT: REPLACEMENT] , [PIPE LINING: PIPE LINING] , [N/A: N/A] , ...1 more...
• LastActivity:
  Inherited
• ValveFunction:
  Inherited
• AssemblyType:
  Inherited
• ClockwiseToClose:
  Inherited
• CurrentlyOpen:
  Inherited
• OperationalStatus:
  Inherited
• Enabled:
  Inherited
• ReqState:
  Inherited
• LU_SYNC:
  Coded Values: [Yes: Yes] , [No - Private: No - Private] , [No - Other: No - Other] , ...5 more...
• SAP_USR_STS:
  Inherited
• MNT_AUTH:
  Inherited
• CNTB:
  Inherited

---

ID: 7
Name: Non-Return
Domains:
• MDP_LU_SRC:
  Coded Values: [AS-BUILT: AS-BUILT] , [CAD: CAD] , [FIELD INSPECTION: FIELD INSPECTION] , ...15 more...
• MDP_LU_MNTN:
  Coded Values: [REPLACEMENT: REPLACEMENT] , [PIPE LINING: PIPE LINING] , [N/A: N/A] , ...1 more...
• LastActivity:
  Inherited
• ValveFunction:
  Inherited
• AssemblyType:
  Inherited
• ClockwiseToClose:
  Inherited
• CurrentlyOpen:
  Inherited
• OperationalStatus:
  Inherited
• Enabled:
  Inherited
• ReqState:
  Inherited
• LU_SYNC:
  Coded Values: [Yes: Yes] , [No - Private: No - Private] , [No - Other: No - Other] , ...5 more...
• SAP_USR_STS:
  Inherited
• MNT_AUTH:
  Inherited
• CNTB:
  Inherited

---

ID: 2
Name: Divisional (DV)
Domains:
• MDP_LU_SRC:
  Coded Values: [AS-BUILT: AS-BUILT] , [CAD: CAD] , [FIELD INSPECTION: FIELD INSPECTION] , ...15 more...
• MDP_LU_MNTN:
  Coded Values: [REPLACEMENT: REPLACEMENT] , [PIPE LINING: PIPE LINING] , [N/A: N/A] , ...1 more...
• LastActivity:
  Inherited
• ValveFunction:
  Inherited
• AssemblyType:
  Inherited
• ClockwiseToClose:
  Inherited
• CurrentlyOpen:
  Inherited
• OperationalStatus:
  Inherited
• Enabled:
  Inherited
• ReqState:
  Inherited
• LU_SYNC:
  Coded Values: [Yes: Yes] , [No - Private: No - Private] , [No - Other: No - Other] , ...5 more...
• SAP_USR_STS:
  Inherited
• MNT_AUTH:
  Inherited
• CNTB:
  Inherited

---

ID: 8
Name: Irrigation
Domains:
• MDP_LU_SRC:
  Coded Values: [AS-BUILT: AS-BUILT] , [CAD: CAD] , [FIELD INSPECTION: FIELD INSPECTION] , ...15 more...
• MDP_LU_MNTN:
  Coded Values: [REPLACEMENT: REPLACEMENT] , [PIPE LINING: PIPE LINING] , [N/A: N/A] , ...1 more...
• LastActivity:
  Inherited
• ValveFunction:
  Inherited
• AssemblyType:
  Inherited
• ClockwiseToClose:
  Inherited
• CurrentlyOpen:
  Inherited
• OperationalStatus:
  Inherited
• Enabled:
  Inherited
• ReqState:
  Inherited
• LU_SYNC:
  Coded Values: [Yes: Yes] , [No - Private: No - Private] , [No - Other: No - Other] , ...5 more...
• SAP_USR_STS:
  Inherited
• MNT_AUTH:
  Inherited
• CNTB:
  Inherited

---

ID: 10
Name: Unknown
Domains:
• MDP_LU_SRC:
  Coded Values: [AS-BUILT: AS-BUILT] , [CAD: CAD] , [FIELD INSPECTION: FIELD INSPECTION] , ...15 more...
• MDP_LU_MNTN:
  Coded Values: [REPLACEMENT: REPLACEMENT] , [PIPE LINING: PIPE LINING] , [N/A: N/A] , ...1 more...
• LastActivity:
  Inherited
• ValveFunction:
  Inherited
• AssemblyType:
  Inherited
• ClockwiseToClose:
  Inherited
• CurrentlyOpen:
  Inherited
• OperationalStatus:
  Inherited
• Enabled:
  Inherited
• ReqState:
  Inherited
• LU_SYNC:
  Coded Values: [Yes: Yes] , [No - Private: No - Private] , [No - Other: No - Other] , ...5 more...
• SAP_USR_STS:
  Inherited
• MNT_AUTH:
  Inherited
• CNTB:
  Inherited

---

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata