Name: Water Main

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Water Main by lifecycle status: Active, Abandoned, Proposed

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1200

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1.1176736533210343E7
YMin: 3564364.180444515
XMax: 1.1388435374116266E7
YMax: 3776063.0213504373
Spatial Reference: 102747  (2284)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 112, 255, 255]
Width: 8
Label: N/A
Description: N/A
Transparency: 25
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: "WATER"
Use Coded Values: true
Symbol:
Color: [0, 38, 115, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: italic
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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: false
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: ASSETGROUP

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID )
• ASSETGROUP ( type: esriFieldTypeInteger, alias: Asset group )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset type )
• ASSOCIATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Association status , Coded Values: [0: None] , [1: Container] , [2: Structure] , ...33 more... )
• ISCONNECTED ( type: esriFieldTypeSmallInteger, alias: Is connected , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• FROMDEVICETERMINAL ( type: esriFieldTypeSmallInteger, alias: From device terminal , Coded Values: [0: None] , [1: Single Terminal] , [2: High Pressure In] , ...15 more... )
• TODEVICETERMINAL ( type: esriFieldTypeSmallInteger, alias: To device terminal , Coded Values: [0: None] , [1: Single Terminal] , [2: High Pressure In] , ...15 more... )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: Global ID, length: 38 )
• SystemSubnetworkName ( type: esriFieldTypeString, alias: System Subnetwork Name, length: 2000 )
• SUPPORTEDSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supported subnetwork name, length: 2000 )
• SUPPORTINGSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supporting subnetwork name, length: 2000 )
• PressureSubnetworkName ( type: esriFieldTypeString, alias: Pressure Subnetwork Name, length: 2000 )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, length: 8 )
• creator ( type: esriFieldTypeString, alias: Creator, length: 255 )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, length: 8 )
• updatedby ( type: esriFieldTypeString, alias: Updated by, length: 255 )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• assetid ( type: esriFieldTypeString, alias: Asset ID, length: 64 )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [2: Private] , [100: Other] , [1: Public] , ...1 more... )
• notes ( type: esriFieldTypeString, alias: Notes, length: 2000 )
• diameter ( type: esriFieldTypeDouble, alias: diameter: Cable Gauge, Diameter, Wire Size , Coded Values: [0: Unknown] , [0.25: 1/4"] , [0.375: 3/8"] , ...123 more... )
• measuredlength ( type: esriFieldTypeDouble, alias: Measured Length )
• adddetails ( type: esriFieldTypeSmallInteger, alias: adddetails: Color Code, Tracer Wire )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• inservicedate ( type: esriFieldTypeDate, alias: In-Service Date, length: 8 )
• retireddate ( type: esriFieldTypeDate, alias: Retired Date, length: 8 )
• material ( type: esriFieldTypeSmallInteger, alias: Material )
• designtype ( type: esriFieldTypeSmallInteger, alias: Water Type )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source )
• spatialconfidence ( type: esriFieldTypeSmallInteger, alias: Spatial Confidence )
• watermainsize ( type: esriFieldTypeDouble, alias: Water Main Size , Coded Values: [0: Unknown] , [4: 4"] , [6: 6"] , ...18 more... )
• houseno ( type: esriFieldTypeString, alias: House Number, length: 10 )
• streetname ( type: esriFieldTypeString, alias: Street Name, length: 35 , Coded Values: [10TH ST: 10TH ST] , [11TH ST: 11TH ST] , [12TH ST: 12TH ST] , ...1408 more... )
• name ( type: esriFieldTypeString, alias: Name, length: 10 )
• pressurezone ( type: esriFieldTypeDouble, alias: Pressure Zone )
• projectno ( type: esriFieldTypeString, alias: Project Number, length: 20 )
• projectsheetno ( type: esriFieldTypeString, alias: Project Sheet Number, length: 15 )
• projectabdno ( type: esriFieldTypeString, alias: Project ABD Number, length: 10 )
• abddate ( type: esriFieldTypeDate, alias: ABD Date, length: 8 )
• incsq ( type: esriFieldTypeSmallInteger, alias: In CSQ? , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• csqlink ( type: esriFieldTypeInteger, alias: Link to CSQ )
• lucitysyncdate ( type: esriFieldTypeDate, alias: Lucity Sync Date, length: 8 )
• VALIDATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Validation status , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: shape_Length )

Types:

ID: 0
Name: Unknown
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown]
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• ownedby:
  Inherited
• watermainsize:
  Inherited
• streetname:
  Inherited
• incsq:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 1
Name: Water Main
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [1: Transmission Main] , [2: Distribution Main] , ...3 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• ownedby:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [4: 4"] , [6: 6"] , ...18 more...
• adddetails:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• material:
  Coded Values: [0: Unknown] , [81: Asbestos Cement - AC] , [83: Cast Iron - CAS] , ...12 more...
• designtype:
  Coded Values: [0: Unknown] , [1: Potable] , [2: Irrigation] , ...4 more...
• watermainsize:
  Inherited
• streetname:
  Inherited
• incsq:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

ID: 2
Name: Service
Domains:
• ASSETTYPE:
  Coded Values: [0: Unknown] , [11: Residential Service] , [12: Commercial Service] , ...7 more...
• ASSOCIATIONSTATUS:
  Inherited
• ISCONNECTED:
  Inherited
• FROMDEVICETERMINAL:
  Inherited
• TODEVICETERMINAL:
  Inherited
• ownedby:
  Inherited
• diameter:
  Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...13 more...
• adddetails:
  Coded Values: [0: Unknown] , [1: Yes] , [2: No]
• lifecyclestatus:
  Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more...
• material:
  Coded Values: [0: Unknown] , [83: Cast Iron - CAS] , [84: Copper - COP] , ...6 more...
• designtype:
  Coded Values: [0: Unknown] , [1: Potable] , [2: Irrigation] , ...4 more...
• watermainsize:
  Inherited
• streetname:
  Inherited
• incsq:
  Inherited
• VALIDATIONSTATUS:
  Inherited

---

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

  Iteminfo   Thumbnail   Metadata