Name: HydrantMaintenanceInspection
Display Field: FACILITYKEY
Type: Table
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- PRESSURE (type: esriFieldTypeDouble, alias: Pressure (PSI), SQL Type: sqlTypeOther, nullable: true, editable: true)
- FACILITYKEY (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- INSPECTOR (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- CHAINS (type: esriFieldTypeString, alias: Chains Req'd?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- PAINT (type: esriFieldTypeString, alias: Paint Req'd?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- OIL (type: esriFieldTypeString, alias: Lubrication Req'd?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- STAMPED (type: esriFieldTypeString, alias: Stamped?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- GREASED (type: esriFieldTypeString, alias: Greased?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- DRAIN (type: esriFieldTypeString, alias: Drain?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- Buffer (type: esriFieldTypeString, alias: 3ft Buffer?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Open_Close (type: esriFieldTypeString, alias: Difficult to Open?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- ShutOffValveStatus (type: esriFieldTypeString, alias: Valve Accessible?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- Issues (type: esriFieldTypeString, alias: Major Issue?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- BlueMarker (type: esriFieldTypeString, alias: Blue Marker Req'd?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- GPM (type: esriFieldTypeSmallInteger, alias: GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- date_inspected (type: esriFieldTypeDate, alias: Date Inspected, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Templates:
Name: HydrantMaintenanceInspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
- wHydrant (0) -- Related To: wHydrant (0)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/6/2026 5:14:44 PM
Schema Last Edit Date: 1/6/2026 5:14:44 PM
Data Last Edit Date: 1/6/2026 5:14:44 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat