Name: wHydrantFlowTest
Display Field: FacilityID
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:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- FacilityID (type: esriFieldTypeString, alias: FacilityID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- PressureZone (type: esriFieldTypeString, alias: PressureZone, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true, Coded Values: [2: Zone 2], [OTH: Other], [UNK: Unknown], ... 7 more ...)
- HydrantType (type: esriFieldTypeString, alias: HydrantType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Wharf: Wharf], [Standard: Standard], [Super: Super])
- Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CLW: Clow], [JJC: James Jones Company], [MC: Mueller Company], ... 1 more ...)
- Diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OutletConfiguration (type: esriFieldTypeString, alias: OutletConfiguration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- StaticPressure_psi (type: esriFieldTypeInteger, alias: StaticPressure_psi, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ResidualPressure_psi (type: esriFieldTypeInteger, alias: ResidualPressure_psi, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- MapGrid (type: esriFieldTypeString, alias: MapGrid, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ValveNumber (type: esriFieldTypeString, alias: ValveNumber, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- GPMValue (type: esriFieldTypeString, alias: GPMValue, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- MainLineType (type: esriFieldTypeString, alias: MainLine Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bypass: Bypass], [DistributionMain: DistributionMain], [DrainLine: DrainLine], ... 1 more ...)
- TestDate (type: esriFieldTypeDate, alias: Test Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- TestTime (type: esriFieldTypeString, alias: Test Time, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- MainLineSize (type: esriFieldTypeDouble, alias: MainLine Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PitotPressure_psi (type: esriFieldTypeSmallInteger, alias: Pitot Pressure_psi, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CalculatedWaterLoss (type: esriFieldTypeDouble, alias: Calculated Water Loss, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Flow_or_Gauge (type: esriFieldTypeString, alias: Flow_or_Gauge, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- GeneralLocation (type: esriFieldTypeString, alias: Geneal Location, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
- ProjectNumber (type: esriFieldTypeString, alias: ProjectNumber, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
- Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
- Gauge_Type (type: esriFieldTypeString, alias: Gauge_Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [wClearWell: wClearWell], [wControlValve: wControlValve], [wFitting: wFitting], ... 9 more ...)
- Gauge_FacilityID (type: esriFieldTypeString, alias: Gauge_FacilityID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- GaugeResidualPressure_psi (type: esriFieldTypeInteger, alias: GaugeResidualPressure_psi, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GaugeStaticPressure_psi (type: esriFieldTypeInteger, alias: GaugeStaticPressure_psi, 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: 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)
Templates:
Name: wHydrantFlowTest
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Attributes:
- HydrantType: Standard
- Manufacturer: CLW
- Diameter: 6
- OutletConfiguration: 4"x2.5"
- StaticPressure_psi: 0
- Gauge_Type: wHydrant
Relationships:
- wHydrant (17) -- Related To: wHydrant (40)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 11/24/2025 3:51:30 AM
Schema Last Edit Date: 11/24/2025 3:51:30 AM
Data Last Edit Date: 11/24/2025 3:51:30 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat