Name: Hydrant Inspections

Display Field: Text

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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Text (type: esriFieldTypeString, alias: Hydrant ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Date (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateOnly (type: esriFieldTypeDateOnly, alias: Inspection Due, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• InService (type: esriFieldTypeSmallInteger, alias: InService, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• FlowGPM (type: esriFieldTypeString, alias: Flow (GPM), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Red 1: 0 - 500], [Orange 2: 500 - 1000], [Green 3: 1000 - 1500], ... 1 more ...)
• PSI (type: esriFieldTypeSmallInteger, alias: PSI, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [20 - 100])
• Maintenance (type: esriFieldTypeSmallInteger, alias: Maintenance Needed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• Code (type: esriFieldTypeString, alias: Maintenance Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)

Templates:

Name: Hydrant Inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• Points_1 (2) -- Related To: Hydrants (5)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/17/2025 5:02:57 PM

Schema Last Edit Date: 11/17/2025 5:02:57 PM

Data Last Edit Date: 4/3/2025 7:43:54 PM

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