Name: WaterValveInspection

Display Field: operator

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: 8, nullable: false, editable: false)
• paved (type: esriFieldTypeSmallInteger, alias: Paved Over, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No], ... 1 more ...)
• gsurface (type: esriFieldTypeSmallInteger, alias: Ground Surface, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Asphalt], [8: Asphalt Driveway], [9: Asphalt Sidewalk], ... 9 more ...)
• fintorque (type: esriFieldTypeDouble, 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)
• 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: esriFieldTypeSmallInteger, alias: Stem OK?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• package (type: esriFieldTypeSmallInteger, alias: Packing OK?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• gears (type: esriFieldTypeSmallInteger, alias: Gears OK?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• lube (type: esriFieldTypeSmallInteger, alias: Lube Req'd?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• other (type: esriFieldTypeSmallInteger, alias: Other Maint Req'd?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• insdate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• lastupdate (type: esriFieldTypeDate, alias: LastUpdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• valveid (type: esriFieldTypeGUID, alias: Valve ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: WaterValveInspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• paved: 0

Relationships:

• Get Flow Valve (0) -- Related To: FlowValve (501001)
• Get Service Valve (3) -- Related To: ServiceValve (501006)
• Get System Valve (1) -- Related To: SystemValve (501002)
• Get Pressure Valve (2) -- Related To: PressureValve (501003)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/17/2026 10:09:19 PM

Schema Last Edit Date: 1/17/2026 10:09:19 PM

Data Last Edit Date: 1/17/2026 10:05:46 PM

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