Name: Hydrant Maintenance Inspection

Display Field: pressure

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: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field:

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)
• inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• chains (type: esriFieldTypeSmallInteger, alias: Chains Req'd?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• paint (type: esriFieldTypeSmallInteger, alias: Paint Req'd?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• marker (type: esriFieldTypeSmallInteger, alias: Marker Req'd?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• oil (type: esriFieldTypeSmallInteger, alias: Lubrication Req'd?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• stamped (type: esriFieldTypeSmallInteger, alias: Stamped?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• greased (type: esriFieldTypeSmallInteger, alias: Greased?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• drain (type: esriFieldTypeSmallInteger, alias: Drain?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• hydrantid (type: esriFieldTypeGUID, alias: Hydrant ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• globalid (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• insdate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• creationdate (type: esriFieldTypeDate, alias: creationdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• updatedby (type: esriFieldTypeString, alias: updatedby, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• lastupdate (type: esriFieldTypeDate, alias: lastupdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• flowduration (type: esriFieldTypeDouble, alias: Flow Duration, SQL Type: sqlTypeOther, nullable: true, editable: true)
• flowrate (type: esriFieldTypeDouble, alias: Flow Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Hydrant Maintenance Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• WaterDevice (1) -- Related To: Water Device (62)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/15/2023 11:26:29 PM

Schema Last Edit Date: 6/15/2023 11:26:29 PM

Data Last Edit Date: 6/15/2023 11:26:29 PM

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