Name: Water Mains

Display Field: NUM

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: fae8ba22dc6b4fbf849b736799d9239d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SIZE ( type: esriFieldTypeString, alias: SIZE, length: 50 , Coded Values: [10": 10"] , [12": 12"] , [16": 16"] , ...9 more... )
• CLASS ( type: esriFieldTypeString, alias: CLASS, length: 50 , 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, length: 50 , Coded Values: [HIGH: HIGH] , [LOW: LOW] )
• NUM ( type: esriFieldTypeString, alias: NUM, length: 50 )
• STREET ( type: esriFieldTypeString, alias: STREET, length: 100 )
• FROM_STREET ( type: esriFieldTypeString, alias: FROM_STREET, length: 100 )
• TO_STREET ( type: esriFieldTypeString, alias: TO_STREET, length: 100 )
• BLOCK ( type: esriFieldTypeInteger, alias: BLOCK )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 50 )
• DATE_INSTALL ( type: esriFieldTypeDate, alias: DATE_INSTALL, length: 8 )
• JOB_NO ( type: esriFieldTypeString, alias: JOB_NO, length: 50 )
• CONTRACTOR ( type: esriFieldTypeString, alias: CONTRACTOR, length: 50 )
• MEASURE ( type: esriFieldTypeString, alias: MEASURE, length: 255 )
• NOTE ( type: esriFieldTypeString, alias: NOTE, length: 4000 )
• MANUFACTURER_M ( type: esriFieldTypeString, alias: MANUFACTURER_M, length: 100 )
• ABANDONED ( type: esriFieldTypeSmallInteger, alias: ABANDONED , Coded Values: [0: No] , [1: Yes] )
• MULTIPLE_HIGH_PRESSURE_LINES ( type: esriFieldTypeSmallInteger, alias: MULTIPLE_HIGH_PRESSURE_LINES , Coded Values: [0: No] , [1: Yes] )
• HIGH_LOW_PRESSURE_LINES ( type: esriFieldTypeSmallInteger, alias: HIGH_LOW_PRESSURE_LINES , Coded Values: [0: No] , [1: Yes] )
• WWW_PROPERTY ( type: esriFieldTypeSmallInteger, alias: WWW_PROPERTY , Coded Values: [0: No] , [1: Yes] )
• LOW_PRESSURE ( type: esriFieldTypeSmallInteger, alias: LOW_PRESSURE , Coded Values: [0: No] , [1: Yes] )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• 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 )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 50 , Coded Values: [CITY OF WATERLOO: CITY OF WATERLOO] , [BLACK HAWK COUNTY: BLACK HAWK COUNTY] , [PRIVATE: PRIVATE] , ...6 more... )
• Status ( type: esriFieldTypeString, alias: Status, length: 50 , Coded Values: [Active: Active] , [Removed: Removed] , [Abandoned: Abandoned] )
• WATER_MAIN_ID ( type: esriFieldTypeString, alias: Water Main ID, length: 255 )
• Northing_Start ( type: esriFieldTypeDouble, alias: Northing Start of Line )
• Easting_Start ( type: esriFieldTypeDouble, alias: Easting Start of Line )
• Northing_End ( type: esriFieldTypeDouble, alias: Northing End of Line )
• Easting_End ( type: esriFieldTypeDouble, alias: Easting End of Line )
• Elements_SO ( type: esriFieldTypeString, alias: Elements SO Number, length: 255 )
• Elements_Task ( type: esriFieldTypeString, alias: Elements Task Number, length: 255 )
• Abandon_Date ( type: esriFieldTypeDate, alias: Abandon Date, length: 8 )
• 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] )
• Material ( type: esriFieldTypeString, alias: Material, length: 255 , Coded Values: [PVC: PVC] , [Cast Iron: Cast Iron] , [Ductile Iron: Ductile Iron] , ...2 more... )

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata