Name: Hydrant Maintenance Table

Display Field: DATE_INSPECTED

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 1dde647417c441b58f4f48884a53d12b

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DATE_INSPECTED ( type: esriFieldTypeDate, alias: Date Inspected, length: 8 )
• CONDITION ( type: esriFieldTypeString, alias: Condition?, length: 20 , Coded Values: [1-Poor: 1-Poor] , [2-Fair: 2-Fair] , [3-Average: 3-Average] , ...3 more... )
• STATIC_PSI ( type: esriFieldTypeDouble, alias: Static PSI )
• PAINTED ( type: esriFieldTypeString, alias: Painted?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• H_GUID ( type: esriFieldTypeGUID, alias: H_GUID, length: 38 )
• EMPLOYEE ( type: esriFieldTypeString, alias: Employee, length: 255 , Coded Values: [Devin S: Devin S] , [Mark D: Mark D] , [Ronald K: Ronald K] , ...13 more... )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, length: 255 , Coded Values: [M&H: M&H] , [Iowa: Iowa] , [Clow: Clow] , ...3 more... )
• MODEL ( type: esriFieldTypeString, alias: Model or Model #, length: 75 )
• HYDRANT_YEAR ( type: esriFieldTypeSmallInteger, alias: Year )
• FLOW_PRESSURE ( type: esriFieldTypeSingle, alias: Flow Pressure )
• GPM ( type: esriFieldTypeSingle, alias: GPM )
• NOZZLE_COEFFICIENT ( type: esriFieldTypeString, alias: Nozzle Coefficient, length: 255 , Coded Values: [COEF 0.90: COEF 0.90] , [COEF 0.80: COEF 0.80] , [COEF 0.70: COEF 0.70] )
• TS_DUST_CAP_WEATHER_SHIELD ( type: esriFieldTypeString, alias: Dust Cap / Weather Shield, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• TS_OPERATING_NUT_STEM ( type: esriFieldTypeString, alias: Operating Nut Stem, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• TS_OIL_PORT_GREASE_FITTING ( type: esriFieldTypeString, alias: Oil Port / Grease Fitting, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• TS_BONNET_BOLTS_NUTS ( type: esriFieldTypeString, alias: Bonnet Bolts / Nuts, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• TS_GASKETS_ORING_SEALS ( type: esriFieldTypeString, alias: Gaskets / O-Ring Seals, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• MID_HOSE_CAPS ( type: esriFieldTypeString, alias: 2 1/2in Hose Caps, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• MID_HOSE_NOZZLES ( type: esriFieldTypeString, alias: 2 1/2in Hose Nozzles, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• MID_PUMPER_STEAMER_CAP ( type: esriFieldTypeString, alias: Pumper Steamer Cap, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• MID_PUMPER_STEAMER_NOZZLE ( type: esriFieldTypeString, alias: Pumper Steamer Nozzle, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• MID_SAFETY_PARTS_STEM ( type: esriFieldTypeString, alias: Safety Flange Parts / Internal Stem Coupling, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• MID_FLANGE_GASKET_ORING ( type: esriFieldTypeString, alias: Flange Gasket / O-Ring Seals, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• MID_FLANGE_BOLTS_NUTS ( type: esriFieldTypeString, alias: Flange Bolts / Nuts, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• SUB_MAIN_OPERATION_VALVE ( type: esriFieldTypeString, alias: Main Operation Valve, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• SUB_WATER_DRAINAGE ( type: esriFieldTypeString, alias: Water Drainage, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• SUB_LOWER_STEM ( type: esriFieldTypeString, alias: Lower Stem, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• SUB_STANDPIPE_SHOE_ASSEMBLY ( type: esriFieldTypeString, alias: Standpipe / Shoe Assembly, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• GEN_LUBE_CAP_NOZZLE_OPNUT ( type: esriFieldTypeString, alias: Lubrication (Caps, Nozzles, Operating Nut), length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• GEN_HYDRANT_OPENED_CLOSED ( type: esriFieldTypeString, alias: Hydrant Opened and Closed Completely, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• GEN_WATER_CONDITION ( type: esriFieldTypeString, alias: Water Condition, length: 75 , Coded Values: [CHECKED AND OK AT THIS TIME: CHECKED AND OK AT THIS TIME] , [MAY REQUIRE FUTURE ATTENTION: MAY REQUIRE FUTURE ATTENTION] , [REQUIRES IMMEDIATE ATTENTION: REQUIRES IMMEDIATE ATTENTION] , ...3 more... )
• GEN_CONDITION_OF_PAINT ( type: esriFieldTypeString, alias: Condition of Paint, length: 75 , Coded Values: [1-Poor: 1-Poor] , [2-Fair: 2-Fair] , [3-Average: 3-Average] , ...3 more... )
• GALLONS_PER_MINUTE ( type: esriFieldTypeString, alias: Gallons Per Minute, length: 75 , Coded Values: [NO FLOW: NO FLOW] , [< 500 GPM: <500 GPM] , [500 - 999 GPM: 500 - 999 GPM] , ...2 more... )
• HYDRANT_VALVE_TURNS ( type: esriFieldTypeSingle, alias: Number of Hydrant Valve Turns )
• CON_VALVE_PAD ( type: esriFieldTypeString, alias: Concrete Valve Pad?, length: 75 , Coded Values: [Yes: Yes] , [No: No] )
• HYDRANT_GRADE ( type: esriFieldTypeString, alias: Is Hydrant to Grade?, length: 75 , Coded Values: [Yes: Yes] , [No: No] )
• GRADE_CON_COMMENT ( type: esriFieldTypeString, alias: Grade Condition Comment, length: 255 )
• PAINT_DATE ( type: esriFieldTypeDate, alias: Date Painted, length: 8 )
• VALVE_STACK ( type: esriFieldTypeString, alias: VALVE_STACK, length: 75 , Coded Values: [Yes, It is to grade: Yes, It is to grade] , [No, It is below grade: No, It is below grade] , [No, It is above grade: No, It is above grade] )
• OIL_ADDED ( type: esriFieldTypeString, alias: OIL_ADDED, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• REF_ROADMARKERS ( type: esriFieldTypeString, alias: REF_ROADMARKERS, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )

Relationships:

• Backward_Hydrant (0) -- Related To: Hydrants (2)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata