View In:   ArcGIS Online Map Viewer

Name: Water Mains

Display Field: NUM

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 46bcd7e9f0be4f35a4d4b853f22312fc

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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: 5208172.639529139
YMin: 3588903.2579027265
XMax: 5267972.826030895
YMax: 3673028.870162979
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: PressureType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: HIGH
  Label: HIGH
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 197, 255, 255]
  Width: 2
• Value: LOW
  Label: LOW
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 92, 230, 255]
  Width: 2
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: 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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: PressureType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SIZE ( type: esriFieldTypeString, alias: SIZE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIZE , Coded Values: [10": 10"] , [12": 12"] , [16": 16"] , ...9 more... )
• CLASS ( type: esriFieldTypeString, alias: CLASS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CLASS , Coded Values: [CAST LEAD JOINT: CAST LEAD JOINT] , [CAST MECH JOINT: CAST MECH JOINT] , [CAST SLIP JOINT: CAST SLIP JOINT] , ...13 more... )
• PressureType ( type: esriFieldTypeString, alias: PressureType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PressureType , Coded Values: [HIGH: HIGH] , [LOW: LOW] )
• NUM ( type: esriFieldTypeString, alias: NUM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NUM )
• STREET ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STREET )
• FROM_STREET ( type: esriFieldTypeString, alias: FROM_STREET, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FROM_STREET )
• TO_STREET ( type: esriFieldTypeString, alias: TO_STREET, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TO_STREET )
• BLOCK ( type: esriFieldTypeInteger, alias: BLOCK, editable: true, nullable: true, defaultValue: null, modelName: BLOCK )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CITY )
• DATE_INSTALL ( type: esriFieldTypeDate, alias: DATE_INSTALL, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_INSTALL )
• JOB_NO ( type: esriFieldTypeString, alias: JOB_NO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: JOB_NO )
• CONTRACTOR ( type: esriFieldTypeString, alias: CONTRACTOR, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTRACTOR )
• MEASURE ( type: esriFieldTypeString, alias: MEASURE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MEASURE )
• NOTE ( type: esriFieldTypeString, alias: NOTE, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: NOTE )
• MANUFACTURER_M ( type: esriFieldTypeString, alias: MANUFACTURER_M, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MANUFACTURER_M )
• ABANDONED ( type: esriFieldTypeSmallInteger, alias: ABANDONED, editable: true, nullable: true, defaultValue: null, modelName: ABANDONED , Coded Values: [0: No] , [1: Yes] )
• MULTIPLE_HIGH_PRESSURE_LINES ( type: esriFieldTypeSmallInteger, alias: MULTIPLE_HIGH_PRESSURE_LINES, editable: true, nullable: true, defaultValue: null, modelName: MULTIPLE_HIGH_PRESSURE_LINES , Coded Values: [0: No] , [1: Yes] )
• HIGH_LOW_PRESSURE_LINES ( type: esriFieldTypeSmallInteger, alias: HIGH_LOW_PRESSURE_LINES, editable: true, nullable: true, defaultValue: null, modelName: HIGH_LOW_PRESSURE_LINES , Coded Values: [0: No] , [1: Yes] )
• WWW_PROPERTY ( type: esriFieldTypeSmallInteger, alias: WWW_PROPERTY, editable: true, nullable: true, defaultValue: null, modelName: WWW_PROPERTY , Coded Values: [0: No] , [1: Yes] )
• LOW_PRESSURE ( type: esriFieldTypeSmallInteger, alias: LOW_PRESSURE, editable: true, nullable: true, defaultValue: null, modelName: LOW_PRESSURE , Coded Values: [0: No] , [1: Yes] )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )
• 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] )
• WATER_MAIN_ID ( type: esriFieldTypeString, alias: Water Main ID, editable: false, nullable: true, length: 255, defaultValue: null, modelName: AssetID )
• Northing_Start ( type: esriFieldTypeDouble, alias: Northing Start of Line, editable: true, nullable: true, defaultValue: null, modelName: Northing_Start )
• Easting_Start ( type: esriFieldTypeDouble, alias: Easting Start of Line, editable: true, nullable: true, defaultValue: null, modelName: Easting_Start )
• Northing_End ( type: esriFieldTypeDouble, alias: Northing End of Line, editable: true, nullable: true, defaultValue: null, modelName: Northing_End )
• Easting_End ( type: esriFieldTypeDouble, alias: Easting End of Line, editable: true, nullable: true, defaultValue: null, modelName: Easting_End )
• 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 )
• 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] )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Material , Coded Values: [PVC: PVC] , [Cast Iron: Cast Iron] , [Ductile Iron: Ductile Iron] , ...2 more... )

Types:

ID: HIGH
Name: HIGH
Domains:
• SIZE:
  Inherited
• CLASS:
  Inherited
• PressureType:
  Inherited
• ABANDONED:
  Inherited
• MULTIPLE_HIGH_PRESSURE_LINES:
  Inherited
• HIGH_LOW_PRESSURE_LINES:
  Inherited
• WWW_PROPERTY:
  Inherited
• LOW_PRESSURE:
  Inherited
• Owner:
  Inherited
• Status:
  Inherited
• Year:
  Inherited
• Gain_Loss:
  Inherited
• Material:
  Inherited
Templates:
• Name: HIGH
  Description:
  Prototype:
  Gain_Loss: null
  Year: null
  SIZE: null
  CLASS: null
  PressureType: HIGH
  NUM: null
  STREET: null
  FROM_STREET: null
  TO_STREET: null
  BLOCK: null
  CITY: null
  DATE_INSTALL: null
  JOB_NO: null
  CONTRACTOR: null
  MEASURE: null
  NOTE: null
  MANUFACTURER_M: null
  ABANDONED: null
  MULTIPLE_HIGH_PRESSURE_LINES: null
  HIGH_LOW_PRESSURE_LINES: null
  WWW_PROPERTY: null
  LOW_PRESSURE: null
  Elements_Task: null
  Elements_SO: null
  Easting_End: null
  Northing_End: null
  Abandon_Date: null
  Material: null
  Owner: null
  Status: null
  Easting_Start: null
  Northing_Start: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: LOW
Name: LOW
Domains:
• SIZE:
  Inherited
• CLASS:
  Inherited
• PressureType:
  Inherited
• ABANDONED:
  Inherited
• MULTIPLE_HIGH_PRESSURE_LINES:
  Inherited
• HIGH_LOW_PRESSURE_LINES:
  Inherited
• WWW_PROPERTY:
  Inherited
• LOW_PRESSURE:
  Inherited
• Owner:
  Inherited
• Status:
  Inherited
• Year:
  Inherited
• Gain_Loss:
  Inherited
• Material:
  Inherited
Templates:
• Name: LOW
  Description:
  Prototype:
  Gain_Loss: null
  Year: null
  SIZE: null
  CLASS: null
  PressureType: LOW
  NUM: null
  STREET: null
  FROM_STREET: null
  TO_STREET: null
  BLOCK: null
  CITY: null
  DATE_INSTALL: null
  JOB_NO: null
  CONTRACTOR: null
  MEASURE: null
  NOTE: null
  MANUFACTURER_M: null
  ABANDONED: null
  MULTIPLE_HIGH_PRESSURE_LINES: null
  HIGH_LOW_PRESSURE_LINES: null
  WWW_PROPERTY: null
  LOW_PRESSURE: null
  Elements_Task: null
  Elements_SO: null
  Easting_End: null
  Northing_End: null
  Abandon_Date: null
  Material: null
  Owner: null
  Status: null
  Easting_Start: null
  Northing_Start: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• MainValve (2) -- Related To: Main Valve (4)
• HydrantValve (1) -- Related To: Hydrant Valve (2)
• Hydrant (0) -- Related To: Hydrant (0)

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