Name: Hydrants

Display Field: GIS_LCMUA_Main.GISSERVICE.waHydrant.HYDRANT_TYPE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1dde647417c441b58f4f48884a53d12b

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2406242.144250214
YMin: 7085698.880770057
XMax: 2426477.523070723
YMax: 7114087.534294471
Spatial Reference: 102738  (2276)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: No
  Label: Inspected Not Painted
  Description: N/A
  Symbol:
  
• Value: Non Operational
  Label: Non Operational
  Description: N/A
  Symbol:
  
• Value: Yes
  Label: Painted and Inspected
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [GIS_LCMUA_Main.GISSERVICE.waHydrant.HYDRANT_UNIQUE_ID]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• GISSERVICE.waHydrant.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GISSERVICE.waHydrant.HYDRANT_TYPE ( type: esriFieldTypeString, alias: Hydrant Type, length: 50 )
• GISSERVICE.waHydrant.SUBTYPE ( type: esriFieldTypeString, alias: Sub-Type, length: 50 )
• GISSERVICE.waHydrant.STREET ( type: esriFieldTypeString, alias: Street, length: 50 )
• GISSERVICE.waHydrant.ALT_STREET ( type: esriFieldTypeString, alias: Alt-Street, length: 50 )
• GISSERVICE.waHydrant.SUBDIVISION ( type: esriFieldTypeString, alias: Subdivision, length: 50 )
• GISSERVICE.waHydrant.YEAR_CONSTRUCTED ( type: esriFieldTypeDouble, alias: Year Constructed )
• GISSERVICE.waHydrant.ASBUILT_DATE ( type: esriFieldTypeDate, alias: As-Built Date, length: 8 )
• GISSERVICE.waHydrant.X_COORDINATE ( type: esriFieldTypeDouble, alias: X Coordinate )
• GISSERVICE.waHydrant.Y_COORDINATE ( type: esriFieldTypeDouble, alias: Y Coordinate )
• GISSERVICE.waHydrant.ADDITIONAL_INFO ( type: esriFieldTypeString, alias: Additional Info, length: 100 )
• GISSERVICE.waHydrant.TYPE_ABBREVIATION ( type: esriFieldTypeString, alias: Type Abbreviation, length: 10 )
• GISSERVICE.waHydrant.OWNER ( type: esriFieldTypeString, alias: Owner, length: 50 )
• GISSERVICE.waHydrant.ACCURACY ( type: esriFieldTypeString, alias: Accuracy, length: 50 )
• GISSERVICE.waHydrant.GPS_DATE ( type: esriFieldTypeDate, alias: GPS Date, length: 8 )
• GISSERVICE.waHydrant.LAST_UPDATE ( type: esriFieldTypeDate, alias: Last Udate, length: 8 )
• GISSERVICE.waHydrant.LAST_EDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• GISSERVICE.waHydrant.HYDRANT_NUMBER ( type: esriFieldTypeSmallInteger, alias: Hydrant Number )
• GISSERVICE.waHydrant.HYDRANT_UNIQUE_ID ( type: esriFieldTypeString, alias: Hydrant Unique ID, length: 30 )
• GISSERVICE.waHydrant.FIELD_VERIFICATION_NEEDED ( type: esriFieldTypeString, alias: Field Verification Needed, length: 50 )
• GISSERVICE.waHydrant.VERIFICATION_COMMENTS ( type: esriFieldTypeString, alias: Verification Comments, length: 50 )
• GISSERVICE.waHydrant.Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled )
• GISSERVICE.waHydrant.Shape ( type: esriFieldTypeGeometry, alias: Shape )
• GISSERVICE.waHydrant.created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• GISSERVICE.waHydrant.created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• GISSERVICE.waHydrant.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GISSERVICE.waHydrant_Maintenance.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• GISSERVICE.waHydrant_Maintenance.DATE_INSPECTED ( type: esriFieldTypeDate, alias: Date Inspected, length: 8 )
• GISSERVICE.waHydrant_Maintenance.CONDITION ( type: esriFieldTypeString, alias: Condition?, length: 20 , Coded Values: [1-Poor: 1-Poor] , [2-Fair: 2-Fair] , [3-Average: 3-Average] , ...3 more... )
• GISSERVICE.waHydrant_Maintenance.STATIC_PSI ( type: esriFieldTypeDouble, alias: Static PSI )
• GISSERVICE.waHydrant_Maintenance.PAINTED ( type: esriFieldTypeString, alias: Painted?, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• GISSERVICE.waHydrant_Maintenance.COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• GISSERVICE.waHydrant_Maintenance.H_GUID ( type: esriFieldTypeGUID, alias: H_GUID, length: 38 )
• GISSERVICE.waHydrant_Maintenance.created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• GISSERVICE.waHydrant_Maintenance.created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• GISSERVICE.waHydrant_Maintenance.last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• GISSERVICE.waHydrant_Maintenance.last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GISSERVICE.waHydrant_Maintenance.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GISSERVICE.waHydrant_Maintenance.EMPLOYEE ( type: esriFieldTypeString, alias: Employee, length: 255 , Coded Values: [Devin S: Devin S] , [Mark D: Mark D] , [Ronald K: Ronald K] , ...13 more... )
• GISSERVICE.waHydrant_Maintenance.MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, length: 255 , Coded Values: [M&H: M&H] , [Iowa: Iowa] , [Clow: Clow] , ...3 more... )
• GISSERVICE.waHydrant_Maintenance.MODEL ( type: esriFieldTypeString, alias: Model or Model #, length: 75 )
• GISSERVICE.waHydrant_Maintenance.HYDRANT_YEAR ( type: esriFieldTypeSmallInteger, alias: Year )
• GISSERVICE.waHydrant_Maintenance.FLOW_PRESSURE ( type: esriFieldTypeSingle, alias: Flow Pressure )
• GISSERVICE.waHydrant_Maintenance.GPM ( type: esriFieldTypeSingle, alias: GPM )
• GISSERVICE.waHydrant_Maintenance.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] )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.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... )
• GISSERVICE.waHydrant_Maintenance.CON_VALVE_PAD ( type: esriFieldTypeString, alias: Concrete Valve Pad?, length: 75 , Coded Values: [Yes: Yes] , [No: No] )
• GISSERVICE.waHydrant_Maintenance.HYDRANT_GRADE ( type: esriFieldTypeString, alias: Is Hydrant to Grade?, length: 75 , Coded Values: [Yes: Yes] , [No: No] )
• GISSERVICE.waHydrant_Maintenance.GRADE_CON_COMMENT ( type: esriFieldTypeString, alias: Grade Condition Comment, length: 255 )
• GISSERVICE.waHydrant_Maintenance.PAINT_DATE ( type: esriFieldTypeDate, alias: Date Painted, length: 8 )
• GISSERVICE.waHydrant_Maintenance.HYDRANT_VALVE_TURNS ( type: esriFieldTypeSingle, alias: HYDRANT_VALVE_TURNS )
• GISSERVICE.waHydrant_Maintenance.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] )
• GISSERVICE.waHydrant_Maintenance.OIL_ADDED ( type: esriFieldTypeString, alias: OIL_ADDED, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• GISSERVICE.waHydrant_Maintenance.REF_ROADMARKERS ( type: esriFieldTypeString, alias: REF_ROADMARKERS, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )

Relationships:

• Forward_Hydrant_Maintenance (0) -- Related To: Hydrant Maintenance Table (5)

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

  Iteminfo   Thumbnail   Metadata