Name: Valve Inspection

Display Field: GSURFACE

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:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• PAVED (type: esriFieldTypeSmallInteger, alias: Paved Over, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• GSURFACE (type: esriFieldTypeString, alias: Ground Surface, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Asphalt: Asphalt], [Brick: Brick], [Concrete: Concrete], ... 5 more ...)
• FINTORQUE (type: esriFieldTypeInteger, alias: Final Torque (Ft Pounds), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DEPTHTONUT (type: esriFieldTypeDouble, alias: Depth To Nut (Ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• FACILITYKEY (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SIZE (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4"], [1: 1"], [1.25: 1 1/4"], ... 27 more ...)
• TYPE (type: esriFieldTypeString, alias: Valve Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Ball: Ball], [Butterfly: Butterfly], [Cone: Cone], ... 5 more ...)
• TURNS (type: esriFieldTypeDouble, alias: # of Turns, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OPERATOR (type: esriFieldTypeString, alias: Name of Operator, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• STEM (type: esriFieldTypeString, alias: Stem OK?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• PACKAGE (type: esriFieldTypeString, alias: Packing OK?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• GEARS (type: esriFieldTypeString, alias: Gears OK?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• LUBE (type: esriFieldTypeString, alias: Lube Req'd?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• OTHER (type: esriFieldTypeString, alias: Other Maint Req'd?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: No], [1: Yes], [2: N/A])
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• INSTALLED (type: esriFieldTypeSmallInteger, alias: Yr of Install, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ServiceOrder (type: esriFieldTypeString, alias: ServiceOrder, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Atlas_No (type: esriFieldTypeString, alias: Atlas_No, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Valve_No (type: esriFieldTypeString, alias: Valve_no, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Main_Street (type: esriFieldTypeString, alias: Main_Street, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• From_Main (type: esriFieldTypeString, alias: From_Main, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• From_Curb (type: esriFieldTypeString, alias: From_Curb, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Intersection (type: esriFieldTypeString, alias: Intersection, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• From_Intr_S (type: esriFieldTypeString, alias: From_Intr_S, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• From_Curb_I (type: esriFieldTypeString, alias: From_Curb_I, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• DateInstalled (type: esriFieldTypeDate, alias: DateInstalled, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Make (type: esriFieldTypeString, alias: Make, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TypeField (type: esriFieldTypeString, alias: TypeField, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Purpose (type: esriFieldTypeString, alias: Purpose, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Depth_Inch (type: esriFieldTypeString, alias: Depth_Inch, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• No_Turns (type: esriFieldTypeString, alias: No_Turns, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Turn_Direction (type: esriFieldTypeString, alias: Turn_Direction, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Size_Field (type: esriFieldTypeString, alias: Size_Field, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Normal_Pos (type: esriFieldTypeString, alias: Normal_Pos, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Packing (type: esriFieldTypeString, alias: Packing, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Current_Position (type: esriFieldTypeString, alias: Current_Position, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Operaiton (type: esriFieldTypeString, alias: Operaiton, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Boxing_and (type: esriFieldTypeString, alias: Boxing_and, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Valve Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• PAVED: 0
• GSURFACE: Asphalt
• STEM: 0
• PACKAGE: 0
• GEARS: 0
• LUBE: 0
• OTHER: 0

Relationships:

• wValveInspection__ATTACH (33) -- Related To: wValveInspection__ATTACH (76)
• wSystemValve (8) -- Related To: wSystemValve (33)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/24/2025 3:51:33 AM

Schema Last Edit Date: 11/24/2025 3:51:33 AM

Data Last Edit Date: 11/24/2025 3:51:33 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat