Name: VALVE

Display Field: Name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: ce334058acb74448892fced75305a34f

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: Subtype

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 50 )
• PolyID ( type: esriFieldTypeString, alias: PolyID, length: 50 )
• Subtype ( type: esriFieldTypeInteger, alias: Subtype )
• Name ( type: esriFieldTypeString, alias: Name, length: 150 )
• Make ( type: esriFieldTypeString, alias: Make, length: 50 )
• Model ( type: esriFieldTypeString, alias: Model, length: 50 )
• Serial ( type: esriFieldTypeString, alias: Serial, length: 50 )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 10 , Coded Values: [0: Unobtainable] , [1: Very Good. Like new] , [2: Good. Minor improvement required] , ...3 more... )
• ConditionDate ( type: esriFieldTypeDate, alias: ConditionDate, length: 8 )
• LifeCycle ( type: esriFieldTypeString, alias: LifeCycle, length: 50 , Coded Values: [Planning: Planning] , [Design: Design] , [Construction: Construction] , ...4 more... )
• StatusDate ( type: esriFieldTypeDate, alias: StatusDate, length: 8 )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• Contractor ( type: esriFieldTypeString, alias: Contractor, length: 255 )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0.75: 3/4 inch] , [1: 1 inch] , [1.5: 1 1/2 inch] , ...18 more... )
• Material ( type: esriFieldTypeString, alias: Material, length: 25 , Coded Values: [Brass: Brass] , [Ductile Iron: Ductile Iron] , [PVC: PVC] , ...3 more... )
• NormallyOpen ( type: esriFieldTypeString, alias: NormallyOpen, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• JointType1 ( type: esriFieldTypeString, alias: JointType1, length: 30 , Coded Values: [Bell and Spigot: Bell and Spigot] , [Compression: Compression] , [Flange: Flange] , ...14 more... )
• JointType2 ( type: esriFieldTypeString, alias: JointType2, length: 30 , Coded Values: [Bell and Spigot: Bell and Spigot] , [Compression: Compression] , [Flange: Flange] , ...14 more... )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation )
• AboveGround ( type: esriFieldTypeString, alias: AboveGround, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• NumberOfTurns ( type: esriFieldTypeInteger, alias: Number of Turns )
• PressureSetting ( type: esriFieldTypeDouble, alias: Pressure Setting (psi) )
• Motorized ( type: esriFieldTypeString, alias: Motorized, length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• ActuatorManufacturer ( type: esriFieldTypeString, alias: ActuatorManufacturer, length: 150 )
• ActuatorModel ( type: esriFieldTypeString, alias: ActuatorModel, length: 150 )
• PlantType ( type: esriFieldTypeString, alias: PlantType, length: 25 , Coded Values: [Wastewater: Wastewater] , [Water: Water] , [Reuse: Reuse] , ...4 more... )
• AssetCategory ( type: esriFieldTypeString, alias: AssetCategory, length: 25 , Coded Values: [Process Building: Process Building] , [Process Electrical: Process Electrical] , [Process Mechanical: Process Mechanical] , ...4 more... )
• UnitProcess ( type: esriFieldTypeString, alias: UnitProcess, length: 25 , Coded Values: [Advanced Treatment: Advanced Treatment] , [Dewatering: Dewatering] , [Disinfection: Disinfection] , ...8 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• FacilityName ( type: esriFieldTypeString, alias: FacilityName, length: 150 , Coded Values: [Rotonda WRF: Rotonda WRF] , [West Port WRF: West Port WRF] , [East Port WRF: East Port WRF] , ...14 more... )
• OMLink ( type: esriFieldTypeString, alias: OMLink, length: 250 )
• TagID ( type: esriFieldTypeString, alias: TagID, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 )
• Address ( type: esriFieldTypeString, alias: Address, length: 255 )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 50 )
• MaintBy ( type: esriFieldTypeString, alias: MaintBy, length: 50 , Coded Values: [Charlotte County: Charlotte County] , [City: City] , [FDOT: FDOT] , ...8 more... )
• OwnedBy ( type: esriFieldTypeString, alias: OwnedBy, length: 50 , Coded Values: [FDOT: FDOT] , [COUNTY: COUNTY] , [CITY: CITY] , ...2 more... )
• ConsequenceOfFailure ( type: esriFieldTypeSmallInteger, alias: ConsequenceOfFailure , Coded Values: [1: Very Minor] , [2: Minor] , [3: Moderate] , ...2 more... )
• ProbabilityOfFailure ( type: esriFieldTypeSmallInteger, alias: ProbabilityOfFailure , Coded Values: [1: Very Low: Failure is unlikely] , [2: Low: Failure might happen] , [3: Moderate: Failure could occur] , ...2 more... )
• Criticality ( type: esriFieldTypeSmallInteger, alias: Criticality , Coded Values: [1: Very Low] , [2: Very Low] , [3: Very Low] , ...22 more... )
• PurchasePrice ( type: esriFieldTypeDouble, alias: PurchasePrice )
• PurchaseDate ( type: esriFieldTypeDate, alias: PurchaseDate, length: 8 )
• LastInspectedDate ( type: esriFieldTypeDate, alias: LastInspectedDate, length: 8 )
• LifeExpectancy ( type: esriFieldTypeSmallInteger, alias: LifeExpectancy )
• ReplacementCost ( type: esriFieldTypeDouble, alias: ReplacementCost )
• AttachmentLink ( type: esriFieldTypeString, alias: AttachmentLink, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Size ( type: esriFieldTypeString, alias: Size, length: 20 )
• Description ( type: esriFieldTypeString, alias: Description, length: 255 )
• ValveType ( type: esriFieldTypeString, alias: Valve Type, length: 20 )

Types:

ID: 0
Name: Undefined
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 1
Name: Air Release
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 2
Name: Altitude
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 3
Name: Ball
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 4
Name: Butterfly
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 5
Name: Check
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 6
Name: Duck Bill
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 7
Name: Gate
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 8
Name: Knife
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 9
Name: Mud
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 10
Name: Plug
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 11
Name: Pressure Release
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 12
Name: Pressure Sustaining
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 13
Name: Solenoid
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

ID: 14
Name: Tune Up
Domains:
• Condition:
  Inherited
• LifeCycle:
  Inherited
• Material:
  Inherited
• NormallyOpen:
  Inherited
• JointType1:
  Inherited
• JointType2:
  Inherited
• AboveGround:
  Inherited
• Motorized:
  Inherited
• PlantType:
  Inherited
• AssetCategory:
  Inherited
• UnitProcess:
  Inherited
• FacilityName:
  Inherited
• MaintBy:
  Inherited
• OwnedBy:
  Inherited
• ConsequenceOfFailure:
  Inherited
• ProbabilityOfFailure:
  Inherited
• Criticality:
  Inherited

---

Relationships:

• wplMOTOR (51) -- Related To: wplMOTOR (5)
• wplTanks (17) -- Related To: wtpTanks (2)
• wplFacilities (40) -- Related To: wplFacilities (4)
• wplWell (1) -- Related To: wtpWell (0)
• GISENT.GIS.PlantSites (29) -- Related To: PlantSites (3)
• wplVaults (9) -- Related To: wtpVaults (1)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata