View In:   ArcGIS Online Map Viewer

Name: Sewer Lines

Display Field: PipeID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: A layer of all wastewater pipe. Includes both gravity sewer pipes and force (pressurized) mains.Fields:OBJECTID - Unique ID assigned by softwarePipeID - Unique ID assigned by city staff.LineType - Is it a gravity main line, a pressurized line, or a sewer laterial (typically privately owned)? PipeShape - Information about the shape of the pipe. Diameter_In - Diameter of round pipes in inches.PipeMaterial - Information about what the pipe made out of (e.g. concrete, PVC, HDPW, etc).SewerShed - Which sewershed is the infrastructure located in. This refers to which treatment plant the wastewater flowing through the pipe ultimately flows to.Source1 - Where did the information included in the fields come from? As built plans? Field inspection? Other?Source2 - Was a second source of information used to fill in the fields? If so, identify it in this field. Comments - General comments or notes.InstallDate - Date the pipe was installed.Ownership - Information regarding who owns the pipe. created_user - The GIS user that created the point.created_date - The date on which the point was created.last_edited_user - The GIS user that last edited the point.last_edited_date - The date when the point was last updated.GlobalID - Unique ID assigned by software.Depth - Depth of cover over top of the pipe. This measurement is in inches.Diam - Diameter of round pipes in inches.Shape_Length - Autocalculated length of the pipe in feet.

Service Item Id: 15e05ba0d36a48878e72f577ff520790

Copyright Text:

Default Visibility: true

MaxRecordCount: 20000

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: 442543.45330000017
YMin: 212689.59600000083
XMax: 449303.80140000023
YMax: 221406.6514999997
Spatial Reference: 32145  (32145)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: LineType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: Gravity
  Label: Gravity
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 2
• Value: Pressurized
  Label: Pressurized
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 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: LineType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PipeID ( type: esriFieldTypeString, alias: Pipe ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PipeID )
• LineType ( type: esriFieldTypeString, alias: Line Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LineType )
• PipeShape ( type: esriFieldTypeString, alias: Pipe Shape, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PipeShape , Coded Values: [Circular: Circular] , [Drop: Drop] , [Ellipse: Ellipse] , ...2 more... )
• Diameter_In ( type: esriFieldTypeSmallInteger, alias: Diameter (Inches), editable: true, nullable: true, defaultValue: null, modelName: Diameter_In )
• PipeMaterial ( type: esriFieldTypeString, alias: Pipe Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeMaterial , Coded Values: [AC: Asbestos] , [Clay: Clay] , [CMP: Corrugated Metal Pipe] , ...14 more... )
• SewerShed ( type: esriFieldTypeString, alias: Sewer Shed, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SewerShed , Coded Values: [Bartlett Bay: Bartlett Bay] , [Ariport Parkway: Airport Parkway] , [Burlington: Burlington] )
• Source1 ( type: esriFieldTypeString, alias: Source1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source1 )
• Source2 ( type: esriFieldTypeString, alias: Source2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source2 )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Comments )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• Ownership ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Ownership , Coded Values: [BTV Airport: BTV Airport] , [Other: Other] , [Private: Private] , ...8 more... )
• 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 )
• Depth ( type: esriFieldTypeSmallInteger, alias: DepthOfCover, editable: true, nullable: true, defaultValue: null, modelName: Depth )
• Diam ( type: esriFieldTypeDouble, alias: Diam, editable: true, nullable: true, defaultValue: null, modelName: Diam )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )

Types:

ID: Gravity
Name: Gravity
Domains:
• PipeShape:
  Inherited
• PipeMaterial:
  Inherited
• SewerShed:
  Inherited
• Ownership:
  Inherited
Templates:
• Name: Gravity
  Description:
  Prototype:
  Diam: null
  Depth: null
  PipeID: null
  LineType: Gravity
  PipeShape: null
  Diameter_In: null
  PipeMaterial: null
  SewerShed: null
  Source1: null
  Source2: null
  Comments: null
  InstallDate: null
  Ownership: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Pressurized
Name: Pressurized
Domains:
• PipeShape:
  Inherited
• PipeMaterial:
  Inherited
• SewerShed:
  Inherited
• Ownership:
  Inherited
Templates:
• Name: Pressurized
  Description:
  Prototype:
  Diam: null
  Depth: null
  PipeID: null
  LineType: Pressurized
  PipeShape: null
  Diameter_In: null
  PipeMaterial: null
  SewerShed: null
  Source1: null
  Source2: null
  Comments: null
  InstallDate: null
  Ownership: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

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   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata