View In:   ArcGIS Online map viewer

Name: Water System Valves

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF, geoJSON

Min Scale: 24000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: 1605556.5305529155
YMin: 873333.463832537
XMax: 1771969.9347112924
YMax: 1069644.9461942315
Spatial Reference: 2273  (2273)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: CURROPEN
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: 0
  Label: Closed
  Description:
  Symbol:
  
• Value: 1
  Label: Open
  Description:
  Symbol:
  
• Value: 2
  Label: Closed Normally Open
  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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: CURROPEN

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID , editable: false , nullable: false )
• FACILITYID ( type: esriFieldTypeString , alias: Facility Identifier , editable: true , nullable: true , length: 40 )
• LEGACYID ( type: esriFieldTypeString , alias: LEGACYID , editable: true , nullable: true , length: 255 )
• LIFECYCLESTATUS ( type: esriFieldTypeString , alias: Lifecycle Status , editable: true , nullable: true , length: 25 , Coded Values: [Abandoned: Abandoned] , [Active: Active] , [ActiveNew: Active-New] , ...8 more... )
• CONDITION ( type: esriFieldTypeSmallInteger , alias: Condition , editable: true , nullable: true , Coded Values: [1: Excellent] , [2: Very Good] , [3: Good] , ...4 more... )
• CONDITIONDATE ( type: esriFieldTypeDate , alias: Condition Date , editable: true , nullable: true , length: 8 )
• LASTEXERDT ( type: esriFieldTypeDate , alias: Last Exercised Date , editable: true , nullable: true , length: 8 )
• INSTALLDATE ( type: esriFieldTypeDate , alias: Install Date , editable: true , nullable: true , length: 8 )
• LOCDESC ( type: esriFieldTypeString , alias: Location Description , editable: true , nullable: true , length: 200 )
• ROTATION ( type: esriFieldTypeDouble , alias: Rotation , editable: true , nullable: true )
• DIAMETER ( type: esriFieldTypeDouble , alias: Diameter , editable: true , nullable: true , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...27 more... )
• HYDRFLAG ( type: esriFieldTypeSmallInteger , alias: Hydrant Valve , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• VALVETYPE ( type: esriFieldTypeString , alias: Valve Type , editable: true , nullable: true , length: 30 , Coded Values: [Ball: Ball] , [Butterfly: Butterfly] , [Cone: Cone] , ...5 more... )
• LHTHREAD ( type: esriFieldTypeString , alias: Left Hand Thread , editable: true , nullable: true , length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• BYPASSVALVE ( type: esriFieldTypeSmallInteger , alias: Bypass Valve , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• ZONEVALVE ( type: esriFieldTypeSmallInteger , alias: Zone Valve , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• CLOCKTOCLOSE ( type: esriFieldTypeSmallInteger , alias: Clockwise To Close , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• CURROPEN ( type: esriFieldTypeSmallInteger , alias: Currently Open , editable: true , nullable: true , Coded Values: [0: Closed] , [1: Open] , [2: Closed Normally Open] , ...2 more... )
• MOTORIZED ( type: esriFieldTypeSmallInteger , alias: Motorized , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• NORMALLYOPEN ( type: esriFieldTypeSmallInteger , alias: Normally Open , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• PERCENTOPEN ( type: esriFieldTypeInteger , alias: Percent Open , editable: true , nullable: true )
• PRESSURESETTING ( type: esriFieldTypeString , alias: Pressure Setting , editable: true , nullable: true , length: 20 )
• TURNSTOCLOSE ( type: esriFieldTypeInteger , alias: Turns To Close , editable: true , nullable: true )
• REGULATIONTYPE ( type: esriFieldTypeString , alias: Regulation Type , editable: true , nullable: true , length: 20 , Coded Values: [F: Flow] , [P: Pressure] )
• OPERABLE ( type: esriFieldTypeSmallInteger , alias: Operable , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• MANUFACTURER ( type: esriFieldTypeString , alias: Manufacturer , editable: true , nullable: true , length: 255 , Coded Values: [AMD: American Darling] , [AMRF: American Flow Control] , [APCO: APCO Valve & Primer Corporation] , ...17 more... )
• ENABLED ( type: esriFieldTypeSmallInteger , alias: Enabled , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger , alias: Active Flag , editable: true , nullable: true , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger , alias: Owned By , editable: true , nullable: true , Coded Values: [1: LCWSC] , [2: City of Clinton] , [3: Greenville Water System] , ...9 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger , alias: Managed By , editable: true , nullable: true , Coded Values: [1: LCWSC] , [2: City of Clinton] , [3: Greenville Water System] , ...9 more... )
• CAPTUREMETH ( type: esriFieldTypeString , alias: Capture Method , editable: true , nullable: true , length: 100 , Coded Values: [ASB: Asbuilt/Record Drawing] , [DES: Design Drawing] , [GEO: Geocoded] , ...6 more... )
• CAPTUREDATE ( type: esriFieldTypeDate , alias: Capture Date , editable: true , nullable: true , length: 8 )
• LASTUPDATE ( type: esriFieldTypeDate , alias: Last Update Date , editable: true , nullable: true , length: 8 )
• LASTEDITOR ( type: esriFieldTypeString , alias: Last Editor , editable: true , nullable: true , length: 50 )
• NOTES ( type: esriFieldTypeString , alias: Notes , editable: true , nullable: true , length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , editable: false , nullable: false , length: 38 )
• DEPTH ( type: esriFieldTypeString , alias: DEPTH , editable: true , nullable: true , length: 5 , Coded Values: [UNK: Unknown] , [1: 1'] , [2: 2'] , ...15 more... )
• Replaced ( type: esriFieldTypeDate , alias: Replaced , editable: true , nullable: true , length: 8 )
• Abandoned ( type: esriFieldTypeDate , alias: Abandoned , editable: true , nullable: true , length: 8 )

Types:

ID: 0
Name: 0
Domains:
• LIFECYCLESTATUS:
  Inherited
• CONDITION:
  Inherited
• DIAMETER:
  Inherited
• HYDRFLAG:
  Inherited
• VALVETYPE:
  Inherited
• LHTHREAD:
  Inherited
• BYPASSVALVE:
  Inherited
• ZONEVALVE:
  Inherited
• CLOCKTOCLOSE:
  Inherited
• CURROPEN:
  Inherited
• MOTORIZED:
  Inherited
• NORMALLYOPEN:
  Inherited
• REGULATIONTYPE:
  Inherited
• OPERABLE:
  Inherited
• MANUFACTURER:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• CAPTUREMETH:
  Inherited
• DEPTH:
  Inherited
Templates:
• Name: 0
  Description:
  Prototype:
  Replaced: null
  Abandoned: null
  FACILITYID: null
  LEGACYID: null
  LIFECYCLESTATUS: null
  CONDITION: null
  CONDITIONDATE: null
  LASTEXERDT: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  HYDRFLAG: 0
  VALVETYPE: null
  LHTHREAD: null
  BYPASSVALVE: 0
  ZONEVALVE: 0
  CLOCKTOCLOSE: 1
  CURROPEN: 0
  MOTORIZED: 0
  NORMALLYOPEN: 1
  PERCENTOPEN: 100
  PRESSURESETTING: null
  TURNSTOCLOSE: null
  REGULATIONTYPE: null
  OPERABLE: 1
  MANUFACTURER: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  CAPTUREMETH: null
  CAPTUREDATE: null
  LASTUPDATE: null
  LASTEDITOR: null
  NOTES: null
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: 1
Domains:
• LIFECYCLESTATUS:
  Inherited
• CONDITION:
  Inherited
• DIAMETER:
  Inherited
• HYDRFLAG:
  Inherited
• VALVETYPE:
  Inherited
• LHTHREAD:
  Inherited
• BYPASSVALVE:
  Inherited
• ZONEVALVE:
  Inherited
• CLOCKTOCLOSE:
  Inherited
• CURROPEN:
  Inherited
• MOTORIZED:
  Inherited
• NORMALLYOPEN:
  Inherited
• REGULATIONTYPE:
  Inherited
• OPERABLE:
  Inherited
• MANUFACTURER:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• CAPTUREMETH:
  Inherited
• DEPTH:
  Inherited
Templates:
• Name: Active / Active-New
  Description:
  Prototype:
  LEGACYID: null
  DIAMETER: null
  LHTHREAD: null
  BYPASSVALVE: 0
  ZONEVALVE: 0
  CLOCKTOCLOSE: 1
  CURROPEN: 1
  MOTORIZED: 0
  NORMALLYOPEN: 1
  REGULATIONTYPE: null
  MANUFACTURER: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  Abandoned: null
  FACILITYID: null
  LIFECYCLESTATUS: Active
  CONDITION: null
  CONDITIONDATE: null
  LASTEXERDT: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  HYDRFLAG: 0
  VALVETYPE: null
  PERCENTOPEN: 100
  PRESSURESETTING: null
  TURNSTOCLOSE: null
  OPERABLE: 1
  MAINTBY: 1
  CAPTUREMETH: null
  CAPTUREDATE: null
  LASTUPDATE: null
  LASTEDITOR: null
  NOTES: null
  Replaced: null
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Active / Active-New
  Description:
  Prototype:
  LEGACYID: null
  DIAMETER: null
  LHTHREAD: null
  BYPASSVALVE: 0
  ZONEVALVE: 0
  CLOCKTOCLOSE: 1
  CURROPEN: 1
  MOTORIZED: 0
  NORMALLYOPEN: 1
  REGULATIONTYPE: null
  MANUFACTURER: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  Abandoned: null
  FACILITYID: null
  LIFECYCLESTATUS: ActiveNew
  CONDITION: null
  CONDITIONDATE: null
  LASTEXERDT: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  HYDRFLAG: 0
  VALVETYPE: null
  PERCENTOPEN: 100
  PRESSURESETTING: null
  TURNSTOCLOSE: null
  OPERABLE: 1
  MAINTBY: 1
  CAPTUREMETH: null
  CAPTUREDATE: null
  LASTUPDATE: null
  LASTEDITOR: null
  NOTES: null
  Replaced: null
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Inactive
  Description:
  Prototype:
  LEGACYID: null
  DIAMETER: null
  LHTHREAD: null
  BYPASSVALVE: 0
  ZONEVALVE: 0
  CLOCKTOCLOSE: 1
  CURROPEN: 1
  MOTORIZED: 0
  NORMALLYOPEN: 1
  REGULATIONTYPE: null
  MANUFACTURER: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  Abandoned: null
  FACILITYID: null
  LIFECYCLESTATUS: Inactive
  CONDITION: null
  CONDITIONDATE: null
  LASTEXERDT: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  HYDRFLAG: 0
  VALVETYPE: null
  PERCENTOPEN: 100
  PRESSURESETTING: null
  TURNSTOCLOSE: null
  OPERABLE: 1
  MAINTBY: 1
  CAPTUREMETH: null
  CAPTUREDATE: null
  LASTUPDATE: null
  LASTEDITOR: null
  NOTES: null
  Replaced: null
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: 2
Domains:
• LIFECYCLESTATUS:
  Inherited
• CONDITION:
  Inherited
• DIAMETER:
  Inherited
• HYDRFLAG:
  Inherited
• VALVETYPE:
  Inherited
• LHTHREAD:
  Inherited
• BYPASSVALVE:
  Inherited
• ZONEVALVE:
  Inherited
• CLOCKTOCLOSE:
  Inherited
• CURROPEN:
  Inherited
• MOTORIZED:
  Inherited
• NORMALLYOPEN:
  Inherited
• REGULATIONTYPE:
  Inherited
• OPERABLE:
  Inherited
• MANUFACTURER:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• CAPTUREMETH:
  Inherited
• DEPTH:
  Inherited
Templates:
• Name: 2
  Description:
  Prototype:
  Replaced: null
  Abandoned: null
  FACILITYID: null
  LEGACYID: null
  LIFECYCLESTATUS: null
  CONDITION: null
  CONDITIONDATE: null
  LASTEXERDT: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  HYDRFLAG: 0
  VALVETYPE: null
  LHTHREAD: null
  BYPASSVALVE: 0
  ZONEVALVE: 0
  CLOCKTOCLOSE: 1
  CURROPEN: 2
  MOTORIZED: 0
  NORMALLYOPEN: 1
  PERCENTOPEN: 100
  PRESSURESETTING: null
  TURNSTOCLOSE: null
  REGULATIONTYPE: null
  OPERABLE: 1
  MANUFACTURER: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  CAPTUREMETH: null
  CAPTUREDATE: null
  LASTUPDATE: null
  LASTEDITOR: null
  NOTES: null
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

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