View In:   ArcGIS Online Map Viewer

Name: Hydrant Valve

Display Field: NUM

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 46bcd7e9f0be4f35a4d4b853f22312fc

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: 5207823.782287225
YMin: 3613618.7865555584
XMax: 5267974.442497477
YMax: 3673028.025676474
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 )
• NUM ( type: esriFieldTypeString, alias: NUM, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NUM )
• KIND ( type: esriFieldTypeString, alias: KIND, editable: true, nullable: true, length: 50, defaultValue: null, modelName: KIND )
• MAKE_HV ( type: esriFieldTypeString, alias: MAKE_HV, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAKE_HV , Coded Values: [Clow: Clow] , [Mueller: Mueller] , [Kennedy: Kennedy] , ...14 more... )
• SIZE_HV ( type: esriFieldTypeString, alias: SIZE_HV, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIZE_HV , Coded Values: [2": 2"] , [4": 4"] , [6": 6"] , ...11 more... )
• MEASURE_HV ( type: esriFieldTypeString, alias: MEASURE_HV, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MEASURE_HV )
• DATE_SET_HV ( type: esriFieldTypeDate, alias: DATE_SET_HV, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_SET_HV )
• LOCATION_HV ( type: esriFieldTypeString, alias: LOCATION_HV, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION_HV )
• CLOSES_LEFT_HV ( type: esriFieldTypeSmallInteger, alias: CLOSES_LEFT_HV, editable: true, nullable: true, defaultValue: null, modelName: CLOSES_LEFT_HV , Coded Values: [0: No] , [1: Yes] )
• LOOKS_HV ( type: esriFieldTypeString, alias: LOOKS_HV, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOOKS_HV , Coded Values: [N: N] , [S: S] , [E: E] , ...1 more... )
• PIT_HV ( type: esriFieldTypeSmallInteger, alias: PIT_HV, editable: true, nullable: true, defaultValue: null, modelName: PIT_HV , 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 )
• 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_VALVE_ID ( type: esriFieldTypeString, alias: Hydrant Valve 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] )
• Turns ( type: esriFieldTypeDouble, alias: Turns, editable: true, nullable: true, defaultValue: null, modelName: Turns )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elevation )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Notes )
• Grade ( type: esriFieldTypeDouble, alias: Grade, editable: true, nullable: true, defaultValue: null, modelName: Grade )
• Depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: Depth )
• HighTorque ( type: esriFieldTypeDouble, alias: High Torque, editable: true, nullable: true, defaultValue: null, modelName: HighTorque )
• 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 )
• ExerciseDate ( type: esriFieldTypeDate, alias: Exercise Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ExerciseDate )
• 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 )
• Exercise_Status ( type: esriFieldTypeString, alias: Exercise Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Exercise_Status , Coded Values: [Exercised: Exercised] , [Not Exercised: Not Exercised] , [Needs Maintenance: Needs Maintenance] )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Remarks , Coded Values: [Bent/Broken Stem: Bent/Broken Stem] , [Cannot Locate: Cannot Locate] , [Found Closed: Found Closed] , ...6 more... )
• Abandon_Date ( type: esriFieldTypeDate, alias: Abandon Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Abandon_Date )
• 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] )
• Valve_Status ( type: esriFieldTypeString, alias: Valve Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Valve_Status , Coded Values: [Open: Open] , [Closed: Closed] )
• Exercise_Method ( type: esriFieldTypeString, alias: Exercise Method, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Exercise_Method , Coded Values: [Hand: Hand] , [Wachs Truck Mounted: Wachs Truck Mounted] , [P2 Handheld: P2 Handheld] )
• Surface_Type ( type: esriFieldTypeString, alias: Surface Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Surface_Type , Coded Values: [Dirt and Seeds: Dirt and Seeds] , [Paved Surface: Paved Surface] )

Templates:

• Name: Hydrant Valve
  Description:
  Prototype:
  Exercise_Method: null
  NUM: null
  KIND: null
  MAKE_HV: null
  SIZE_HV: null
  MEASURE_HV: null
  DATE_SET_HV: null
  LOCATION_HV: null
  CLOSES_LEFT_HV: null
  LOOKS_HV: null
  PIT_HV: null
  SEQ_M: null
  Valve_Status: null
  Gain_Loss: null
  Year: null
  Abandon_Date: null
  Surface_Type: null
  Owner: null
  Status: null
  Remarks: null
  GPS: null
  Turns: null
  Elevation: null
  Notes: null
  Grade: null
  Depth: null
  HighTorque: null
  Northing: null
  Easting: null
  ExerciseDate: null
  Elements_SO: null
  Elements_Task: null
  Exercise_Status: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

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

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

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