Name: Valves
Display Field: ROOMNAME
Type: Table
Description:
Copyright Text:
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field: ASSET_TYPE_SUBTYPE
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- ASSET_TYPE_SUBTYPE (type: esriFieldTypeInteger, alias: Asset Type Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ASSET_TYPE (type: esriFieldTypeString, alias: Asset Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Backflow Preventer: Backflow Preventer], [Ball Valve: Ball Valve], [Butterfly Valve: Butterfly Valve], ... 14 more ...)
- CAMPUS (type: esriFieldTypeString, alias: Campus, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [D.E. Benton WTP: D.E. Benton WTP], [E.M. Johnson WTP: EM Johnson WTP], [Neuse River WWTP: Neuse River WWTP], ... 2 more ...)
- BUILDING (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [50-Trinity Academy PS: 50-Trinity Academy PS], [51-New Hope PS: 51-New Hope PS], [57-Bent Tree PS: 57-Bent Tree PS], ... 56 more ...)
- FLOOR (type: esriFieldTypeString, alias: Foor, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Basement: Basement], [1st Floor: 1st Floor], [2nd Floor: 2nd Floor], ... 12 more ...)
- FLOORID (type: esriFieldTypeString, alias: Foor ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ROOMTYPE (type: esriFieldTypeString, alias: Room Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Administration: Administration], [Aeration Basin: Aeration Basin], [Aerobic Digester: Aerobic Digester], ... 59 more ...)
- ROOMNAME (type: esriFieldTypeString, alias: Room Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- ROOMID (type: esriFieldTypeString, alias: Room ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- PLC (type: esriFieldTypeString, alias: PLC, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- PROCESS (type: esriFieldTypeString, alias: Process, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- SUBPROCESS (type: esriFieldTypeString, alias: Subprocess, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- ENTITYTYPE (type: esriFieldTypeString, alias: Entity Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- VALVE_AREA (type: esriFieldTypeString, alias: Area, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- FACILITYID (type: esriFieldTypeString, alias: FacilityID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- MAKE (type: esriFieldTypeString, alias: Make, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ASSET_MODEL (type: esriFieldTypeString, alias: Asset Model, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SERIAL_NUMBER (type: esriFieldTypeString, alias: Serial Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- APPLICATION (type: esriFieldTypeString, alias: Application, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ASSET_SIZE (type: esriFieldTypeInteger, alias: Asset Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LAY_LENGTH (type: esriFieldTypeString, alias: Lay Length, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- SEAT_MATERIAL (type: esriFieldTypeString, alias: Seat Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- DISC_MATERIAL (type: esriFieldTypeString, alias: Disc Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ASSET_STYLE (type: esriFieldTypeString, alias: Asset Style, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- BODY_MATERIAL (type: esriFieldTypeString, alias: Body Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- END_CONNECTION (type: esriFieldTypeString, alias: End Connection, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PACKING (type: esriFieldTypeString, alias: Packing, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- SERVICE_CLASS (type: esriFieldTypeString, alias: Service Class, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- SHAFT_MATERIAL (type: esriFieldTypeString, alias: Shaft Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- DIAPHRAGM_MATERIAL (type: esriFieldTypeString, alias: Diaphragm Material, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PRODUCT (type: esriFieldTypeString, alias: Product, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Recycle Water: Recycle Water], [Water: Water], [Hypo (Sodium Hypochlorite): Hypo (Sodium Hypochlorite)], ... 18 more ...)
- BACKFLOW_DEVICE_TYPE (type: esriFieldTypeString, alias: Backflow Device Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ACTUATOR_TYPE (type: esriFieldTypeString, alias: Actuator Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- BUILDINGID (type: esriFieldTypeString, alias: BuildingID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- TAGNAME (type: esriFieldTypeDouble, alias: Tag Name, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ASSET_TAG (type: esriFieldTypeString, alias: Asset Tag, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
Types:
ID: 0
Name: Backflow Preventer
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:[Double Check: Double Check], [RPZ: RPZ]
- Field Name: ACTUATOR_TYPE
Coded Values:
Templates:
Name: Backflow Preventer
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 1
Name: Ball Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Ball Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 2
Name: Butterfly Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Butterfly Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 3
Name: Check Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:
Templates:
Name: Check Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 4
Name: Cone Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Cone Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 5
Name: Control Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Control Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 6
Name: Corporation Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Corporation Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 7
Name: Diaphragm Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Diaphragm Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 8
Name: Gate Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Gate Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 9
Name: Pinch Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Pinch Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 10
Name: Piston Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Piston Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 11
Name: Plug Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Plug Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 12
Name: Slide Gate Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Slide Gate Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 13
Name: Slide/Sluice Gate
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Slide/Sluice Gate
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 14
Name: Solenoid Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Solenoid Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 15
Name: Surge Anticipator Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Surge Anticipator Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 16
Name: Surge Relief Valve
Domains:
- Field Name: ASSET_TYPE
Inherited
- Field Name: FLOOR
Inherited
- Field Name: ROOMTYPE
Inherited
- Field Name: DISC_MATERIAL
Coded Values:
- Field Name: DIAPHRAGM_MATERIAL
Coded Values:
- Field Name: BACKFLOW_DEVICE_TYPE
Coded Values:
- Field Name: ACTUATOR_TYPE
Coded Values:[Electric: Electric], [Pneumatic: Pneumatic], [Hydraulic: Hydraulic], More
Templates:
Name: Surge Relief Valve
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/19/2019 2:42:26 PM
Schema Last Edit Date: 9/19/2019 2:42:26 PM
Data Last Edit Date: 9/19/2019 2:42:26 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat