Name: CCFD Latest Hydrant Tests

Display Field: OwnerContactName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9057208.3223
YMin: 3748318.5385
XMax: -9011617.7951
YMax: 3772814.3128
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[55,84,137,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field: GlobalID_2

Type ID Field:

Fields:

• HydrantId (type: esriFieldTypeString, alias: HydrantId, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ParcelNumber (type: esriFieldTypeString, alias: ParcelNumber, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CrossSt (type: esriFieldTypeString, alias: Cross Street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HydrantType (type: esriFieldTypeString, alias: Hydrant Type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [1 Way Hydrant: 1 Way Hydrant], [2 Way Hydrant: 2 Way Hydrant], [3 Way Hydrant: 3 Way Hydrant], ... 1 more ...)
• hydrantteststatus (type: esriFieldTypeString, alias: Hydrant Test Status, 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])
• testsetgroup (type: esriFieldTypeString, alias: Test Set Group, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 2 more ...)
• Battalion (type: esriFieldTypeString, alias: Battalion, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [East Battalion: East Battalion], [Central Battalion: Central Battalion], [West Battalion: West Battalion], ... 1 more ...)
• StationID (type: esriFieldTypeString, alias: Station ID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [Station 1: Station 1], [Station 2: Station 2], [Station 3: Station 3], ... 12 more ...)
• DomeColor (type: esriFieldTypeString, alias: Dome Color, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [Red: Red], [Orange: Orange], [Blue: Blue], ... 6 more ...)
• BarrelColor (type: esriFieldTypeString, alias: Barrel Color, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [Red: Red], [Orange: Orange], [Green: Green], ... 6 more ...)
• Make (type: esriFieldTypeString, alias: Make, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Year (type: esriFieldTypeString, alias: Year, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• OwnerContactName (type: esriFieldTypeString, alias: Owner Contact Name, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• OwnerPhone (type: esriFieldTypeString, alias: Owner Phone, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• OwnerEmail (type: esriFieldTypeString, alias: Owner Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TankStorageCapacity (type: esriFieldTypeInteger, alias: Tank Storage Capacity (Gal), SQL Type: sqlTypeOther, nullable: true, editable: true)
• TankPumpCapacity (type: esriFieldTypeInteger, alias: Tank Pump Capacity (GPM), SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPM (type: esriFieldTypeDouble, alias: GPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pitotmaster (type: esriFieldTypeDouble, alias: Pitot Master, SQL Type: sqlTypeOther, nullable: true, editable: true)
• staticmaster (type: esriFieldTypeDouble, alias: Static Master, SQL Type: sqlTypeOther, nullable: true, editable: true)
• residualmaster (type: esriFieldTypeDouble, alias: Residual Master, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MainSize (type: esriFieldTypeDouble, alias: MainSize, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LargestOutletSize (type: esriFieldTypeDouble, alias: Largest Outlet Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SpecialInstructions (type: esriFieldTypeString, alias: Special Insructions, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• InstallationStatus (type: esriFieldTypeString, alias: Installation Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Installed: Installed], [Under Construction: Under Construction], [Duplicate: Duplicate], ... 1 more ...)
• AssignedStation (type: esriFieldTypeString, alias: Assigned Station, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Station 1: Station 1], [Station 2: Station 2], [Station 3: Station 3], ... 11 more ...)
• AssignedShift (type: esriFieldTypeString, alias: Assigned Shift, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [A Shift: A Shift], [B Shift: B Shift], [C Shift: C Shift])
• DueDate (type: esriFieldTypeDate, alias: Due Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• additionalfield1 (type: esriFieldTypeString, alias: Additional Field 1, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• AdditionalField2 (type: esriFieldTypeString, alias: Additional Field 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• additionalnumber1 (type: esriFieldTypeInteger, alias: Additional Number 1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID_2 (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• globalid (type: esriFieldTypeGUID, 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_1760374819528 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1760374819528 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_1760374819528 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1760374819528 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• hydrantid_1760374819528 (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_1760374819528 (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• battalion_1760374819528 (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_1760374819528 (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)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Name: CCFD_Hydrants
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• InstallationStatus: Installed

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: 10/13/2025 4:58:56 PM

Data Last Edit Date: 10/13/2025 4:59:23 PM

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