View In:   ArcGIS Online Map Viewer

Name: Hydrant

Display Field: PN

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1cd3f9f9f36f45e8a7de7bcfd54f5907

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
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: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:

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

Templates:

• Name: Hydrant
  Description:
  Prototype:
  Priority_Needed: null
  PN: null
  ELEVATION: null
  ELEVATIONPOINT: null
  HYDRANT_MAKE: null
  NOTES: null
  DEAD_END_MAIN: null
  SEQ_M: null
  Frozen: null
  Hydrant_Year: null
  Resid_Pressure: null
  Pitot_Pressure: null
  Coefficient: null
  IN_SERVICE: null
  FLOW_RATE: null
  FLOW_RATE_TEST_DATE: null
  Owner: null
  Status: null
  Location: null
  GPS: null
  Static_PSI: null
  Residual_PSI: null
  Flow_Test_Notes: null
  Flush_Zone: null
  Flush_Order: null
  Northing: null
  Easting: null
  Install_Date: null
  Elements_SO: null
  Elements_Task: null
  QuantityAtPSI: null
  TakenBy: null
  HydrantClassification: null
  PitotRDGPSI: null
  Water_Used: null
  Paint: null
  Caps_Greased: null
  Oil_Greased: null
  Packing: null
  O_Ring: null
  Top_Nut: null
  Valve: null
  Valve_Seat: null
  Water_Condition: null
  Abandon_Date: null
  Hydrant_Task: null
  Year: null
  Gain_Loss: null
  Hydrant_Operate: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• Main (1) -- Related To: Water Mains (11)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata