Name: Hydrant_Inspection

Display Field: INSPECTIONDATE

Type: Table

Has Views: true

Source Schema Changes Allowed: false

Views

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:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: SubtypeField

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, Coded Values: [0: No], [1: Yes])
• PAINT (type: esriFieldTypeString, alias: Paint Req'd?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• MARKER (type: esriFieldTypeString, alias: Marker Req'd?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• OIL (type: esriFieldTypeString, alias: Lubrication Req'd?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• STAMPED (type: esriFieldTypeString, alias: Stamped?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• GREASED (type: esriFieldTypeString, alias: Greased?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• DRAIN (type: esriFieldTypeString, alias: Drain?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• INSPECTIONDATE (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SubtypeField (type: esriFieldTypeSmallInteger, alias: Subtype Field, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CodedDomainField (type: esriFieldTypeSmallInteger, alias: Coded Domain Field, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)

Types:

ID: 1
Name: Subtype 1
Domains:

• Field Name: CHAINS
  Inherited
  
• Field Name: PAINT
  Inherited
  
• Field Name: MARKER
  Inherited
  
• Field Name: OIL
  Inherited
  
• Field Name: STAMPED
  Inherited
  
• Field Name: GREASED
  Inherited
  
• Field Name: DRAIN
  Inherited
  
• Field Name: CodedDomainField
  Coded Values:[1: code 1], [2: code 2], [3: code 3]
  
Templates:

Name: Subtype 1
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• SubtypeField: 1
• CHAINS: 0
• PAINT: 0
• MARKER: 0
• OIL: 0
• STAMPED: 0
• GREASED: 0
• DRAIN: 0

---

ID: 2
Name: Subtype 2
Domains:

• Field Name: CHAINS
  Inherited
  
• Field Name: PAINT
  Inherited
  
• Field Name: MARKER
  Inherited
  
• Field Name: OIL
  Inherited
  
• Field Name: STAMPED
  Inherited
  
• Field Name: GREASED
  Inherited
  
• Field Name: DRAIN
  Inherited
  
• Field Name: CodedDomainField
  Coded Values:[1: code A], [2: code B], [3: cpde C]
  
Templates:

Name: Subtype 2
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• SubtypeField: 2
• CHAINS: 0
• PAINT: 0
• MARKER: 0
• OIL: 0
• STAMPED: 0
• GREASED: 0
• DRAIN: 0

---

Relationships:

• Violations (1) -- Related To: Violations (2)
• wHydrant (0) -- Related To: Hydrants (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/7/2026 6:20:44 AM

Schema Last Edit Date: 1/27/2026 2:51:31 AM

Data Last Edit Date: 4/7/2026 6:20:44 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat