Name: HydrantTestingSurveys

Display Field: testedby

Type: Table

Has Views: true

Source Schema Changes Allowed: false

Views

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: 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)
• testdate (type: esriFieldTypeDate, alias: Test Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• testedby (type: esriFieldTypeString, alias: Tested By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• callsigntested (type: esriFieldTypeString, alias: Call Sign Tested, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• shifttested (type: esriFieldTypeString, alias: Shift Tested, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• leakspresent (type: esriFieldTypeString, alias: Leaks Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• testedoutlet (type: esriFieldTypeString, alias: Tested Outlet Diameter (in), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• coefficient (type: esriFieldTypeDouble, alias: Coefficient (0.7-0.99), SQL Type: sqlTypeOther, nullable: true, editable: true)
• pitotpressure (type: esriFieldTypeDouble, alias: Pitot Pressure (psi), SQL Type: sqlTypeOther, nullable: true, editable: true)
• staticpressure (type: esriFieldTypeDouble, alias: Static Pressure (psi), SQL Type: sqlTypeOther, nullable: true, editable: true)
• residualpressure (type: esriFieldTypeDouble, alias: Residual Pressure (psi), SQL Type: sqlTypeOther, nullable: true, editable: true)
• dischargeopening (type: esriFieldTypeDouble, alias: Discharge Opening (in), SQL Type: sqlTypeOther, nullable: true, editable: true)
• minutesflushed (type: esriFieldTypeDouble, alias: Minutes Flushed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• painted (type: esriFieldTypeString, alias: Hydrant recently painted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• flushed (type: esriFieldTypeString, alias: Flushed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• leadvalve (type: esriFieldTypeString, alias: Lead Valve Operated?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lubricated (type: esriFieldTypeString, alias: Hydrant Lubricated?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• repairsneeded (type: esriFieldTypeString, alias: Repairs Needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inservicedefects (type: esriFieldTypeString, alias: In Service Defects, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• outofservicedefects (type: esriFieldTypeString, alias: Out of Service Defects, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• outofservice (type: esriFieldTypeString, alias: Out of Service?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• remarks (type: esriFieldTypeString, alias: Remarks, SQL Type: sqlTypeOther, length: 255, 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: 128, 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: 128, nullable: true, editable: false)
• hydrantid (type: esriFieldTypeString, alias: Hydrant ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• heightadjusted (type: esriFieldTypeString, alias: Height Recently Adjusted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• TestedGPM (type: esriFieldTypeDouble, alias: Tested GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• streetmarker (type: esriFieldTypeString, alias: Street Marker, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• confirmhydranttype (type: esriFieldTypeString, alias: Hydrant Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• battalion (type: esriFieldTypeString, alias: Battalion, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• flowhydrantid (type: esriFieldTypeString, alias: Flow Hydrant ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• flowhydrantaddress (type: esriFieldTypeString, alias: Flow Hydrant Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• testtype (type: esriFieldTypeString, alias: Hydrant Test Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Pressure Test Needed: Pressure Test Needed], [Flush Only Needed: Flush Only Needed], [Repaired, Test Needed: Repaired, Test Needed])
• testhydrantid (type: esriFieldTypeString, alias: This Hydrant ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• additionaltestfield1 (type: esriFieldTypeString, alias: Additional Test Field 1, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• additionaltestfield2 (type: esriFieldTypeString, alias: Additional Test Field 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• installationstatus (type: esriFieldTypeString, alias: Installation Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastknowngpm (type: esriFieldTypeDouble, alias: Last Known GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: HydrantTestingSurveys
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• (0) -- Related To: CCFD_Hydrants (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/23/2026 1:57:14 PM

Schema Last Edit Date: 8/24/2026 6:47:10 PM

Data Last Edit Date: 9/23/2026 1:57:14 PM

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