Name: Hydrants

Display Field: PN

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 825dfbc2224c40cba70ff4ad6f3d0b11

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 5208006.299966797
YMin: 3613610.489984229
XMax: 5267975.226944715
YMax: 3673385.829094723
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: IN_SERVICE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Y
  Label: Yes
  Description: N/A
  Symbol:
  
• Value: N
  Label: No
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• IN_SERVICE ( type: esriFieldTypeString, alias: In Service, length: 50 , Coded Values: [Y: Yes] , [N: No] )
• FLOW_RATE ( type: esriFieldTypeString, alias: Flow Rate (GPM), length: 50 )
• FLOW_RATE_TEST_DATE ( type: esriFieldTypeDate, alias: Flow Rate Test Date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• PN ( type: esriFieldTypeString, alias: PN, length: 254 )
• ELEVATIONPOINT ( type: esriFieldTypeString, alias: ELEVATIONPOINT, length: 255 )
• HYDRANT_MAKE ( type: esriFieldTypeString, alias: Hydrant Make, length: 255 , Coded Values: [American Darling: American Darling] , [Clow Eddy: Clow Eddy] , [Clow Medallion: Clow Medallion] , ...9 more... )
• NOTES ( type: esriFieldTypeString, alias: NOTES, length: 255 )
• DEAD_END_MAIN ( type: esriFieldTypeSmallInteger, alias: DEAD_END_MAIN , Coded Values: [0: No] , [1: Yes] )
• SEQ_M ( type: esriFieldTypeString, alias: SEQ_M, length: 50 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• HYDRANT_ID ( type: esriFieldTypeString, alias: Hydrant ID, length: 255 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 50 , Coded Values: [CITY OF WATERLOO: CITY OF WATERLOO] , [BLACK HAWK COUNTY: BLACK HAWK COUNTY] , [PRIVATE: PRIVATE] , ...5 more... )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Active: Active] , [Removed: Removed] , [Abandoned: Abandoned] )
• GPS ( type: esriFieldTypeString, alias: GPS, length: 50 , Coded Values: [YES: YES] , [NO: NO] )
• Static_PSI ( type: esriFieldTypeSmallInteger, alias: Static (PSI) )
• Residual_PSI ( type: esriFieldTypeSmallInteger, alias: Residual (PSI) )
• Flow_Test_Notes ( type: esriFieldTypeString, alias: Flow Test Notes, length: 255 )
• Flush_Zone ( type: esriFieldTypeString, alias: Flush Zone, length: 255 )
• Flush_Order ( type: esriFieldTypeString, alias: Flush Order, length: 255 )
• Northing ( type: esriFieldTypeDouble, alias: Northing )
• Easting ( type: esriFieldTypeDouble, alias: Easting )
• Install_Date ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• Elements_SO ( type: esriFieldTypeString, alias: Elements SO Number, length: 255 )
• Elements_Task ( type: esriFieldTypeString, alias: Elements Task Number, length: 255 )
• QuantityAtPSI ( type: esriFieldTypeSmallInteger, alias: Quantity At PSI )
• TakenBy ( type: esriFieldTypeString, alias: Taken By, length: 255 )
• HydrantClassification ( type: esriFieldTypeString, alias: Hydrant Classification, length: 255 , Coded Values: [AA: AA] , [A: A] , [B: B] , ...1 more... )
• PitotRDGPSI ( type: esriFieldTypeDouble, alias: Pitot RDG PSI )
• Water_Used ( type: esriFieldTypeDouble, alias: Water Used )
• Paint ( type: esriFieldTypeString, alias: Paint, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Caps_Greased ( type: esriFieldTypeString, alias: Caps Greased?, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Stems ( type: esriFieldTypeString, alias: Stems, length: 255 , Coded Values: [Operate: Operate] , [NT Operate: NT Operate] , [N/A: N/A] )
• Packing ( type: esriFieldTypeString, alias: Packing, length: 255 , Coded Values: [Operate: Operate] , [NT Operate: NT Operate] , [N/A: N/A] )
• O_Ring ( type: esriFieldTypeString, alias: O Ring, length: 255 , Coded Values: [Operate: Operate] , [NT Operate: NT Operate] , [N/A: N/A] )
• Top_Nut ( type: esriFieldTypeString, alias: Top Nut, length: 255 , Coded Values: [Operate: Operate] , [NT Operate: NT Operate] , [N/A: N/A] )
• Valve ( type: esriFieldTypeString, alias: Valve, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Valve_Seat ( type: esriFieldTypeString, alias: Valve Seat, length: 255 )
• Water_Condition ( type: esriFieldTypeString, alias: Condition of Water, length: 255 )
• Abandon_Date ( type: esriFieldTypeDate, alias: Abandon Date, length: 8 )
• Hydrant_Task ( type: esriFieldTypeString, alias: Hydrant Task, length: 255 , Coded Values: [B: B] , [C: C] , [D: D] , ...2 more... )
• Year ( type: esriFieldTypeString, alias: Year, length: 255 , Coded Values: [2025: 2025] , [2026: 2026] , [2027: 2027] , ...3 more... )
• Gain_Loss ( type: esriFieldTypeString, alias: Gain or Loss, length: 255 , Coded Values: [G: Gain] , [L: Loss] , [No G or L: No Gains or Loss] )
• Hydrant_Operate ( type: esriFieldTypeString, alias: Hydrant Operate, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Location ( type: esriFieldTypeString, alias: Location, length: 255 )
• Pitot_Pressure ( type: esriFieldTypeString, alias: Pitot Pressure, length: 255 )
• Resid_Pressure ( type: esriFieldTypeString, alias: Resid Pressure, length: 255 )
• Hydrant_Year ( type: esriFieldTypeString, alias: Hydrant Year, length: 255 )
• Frozen ( type: esriFieldTypeString, alias: Frozen, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• Priority_Needed ( type: esriFieldTypeString, alias: Priority Needed, length: 255 , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] , ...2 more... )

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

  Iteminfo   Thumbnail   Metadata