View In:   ArcGIS Online Map Viewer

Name: Sewer Gravity Mains

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text: Town of Dedham, MA Engineering Department

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 14999.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: -7927810.8044836
YMin: 5193455.555283881
XMax: -7918951.245269205
YMax: 5202323.038610522
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [88, 230, 0, 255]
Width: 8
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [DIAMETER] CONCAT """ " CONCAT [MATERIAL]
Use Coded Values: false
Symbol:
Color: [76, 115, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 2000.0
Max. Scale: 0.0

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

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• facilityid ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...45 more... )
• diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...34 more... )
• mainshape ( type: esriFieldTypeString, alias: Main Shape, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINSHAPE , Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more... )
• linedyear ( type: esriFieldTypeString, alias: Year Lined, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LINEDYEAR )
• linertype ( type: esriFieldTypeString, alias: Liner Type, editable: true, nullable: true, length: 20, defaultValue: NONE, modelName: LINERTYPE , Coded Values: [FF: Fold and Form or Deform/Reform] , [SN: Segmented Panel] , [SP: Segmented Pipe] , ...4 more... )
• frommh ( type: esriFieldTypeString, alias: From Manhole, editable: true, nullable: true, length: 11, defaultValue: null, modelName: FROMMH )
• tomh ( type: esriFieldTypeString, alias: To Manhole, editable: true, nullable: true, length: 11, defaultValue: null, modelName: TOMH )
• watertype ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WATERTYPE , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...6 more... )
• enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• activeflag ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [-1: Private] , [-2: Other] , [-3: Westwood] , ...6 more... )
• maintby ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [-1: Private] , [-2: Other] , [1: Dedham] , ...8 more... )
• sumflow ( type: esriFieldTypeDouble, alias: Flow Summary, editable: true, nullable: true, defaultValue: null, modelName: SUMFLOW )
• downelev ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: DOWNELEV )
• upelev ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: UPELEV )
• slope ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: SLOPE )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Comments )
• locdesc ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• condition ( type: esriFieldTypeString, alias: Pipe Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• tv_inspected ( type: esriFieldTypeSmallInteger, alias: TV Inspected, editable: true, nullable: true, defaultValue: null, modelName: TV_Inspected , Coded Values: [0: False] , [1: True] )
• ii ( type: esriFieldTypeSmallInteger, alias: II, editable: true, nullable: true, defaultValue: null, modelName: II , Coded Values: [0: False] , [1: True] )
• yearlastinspected ( type: esriFieldTypeString, alias: Year Last Inspected, editable: true, nullable: true, length: 4, defaultValue: null, modelName: YearLastInspected )
• metered ( type: esriFieldTypeSmallInteger, alias: Metered, editable: true, nullable: true, defaultValue: null, modelName: Metered , Coded Values: [0: False] , [1: True] )
• meternumber ( type: esriFieldTypeString, alias: Meter Number, editable: true, nullable: true, length: 12, defaultValue: null, modelName: MeterNumber )
• repaired ( type: esriFieldTypeSmallInteger, alias: Repaired, editable: true, nullable: true, defaultValue: null, modelName: Repaired , Coded Values: [0: False] , [1: True] )
• depthavg ( type: esriFieldTypeDouble, alias: Average Depth, editable: true, nullable: true, defaultValue: null, modelName: DepthAvg )
• length ( type: esriFieldTypeSingle, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
• maxhistoricalii ( type: esriFieldTypeSingle, alias: MaxHistoricalII, editable: true, nullable: true, defaultValue: null, modelName: MaxHistoricalII )
• pipelength ( type: esriFieldTypeDouble, alias: Pipe Length, editable: true, nullable: true, defaultValue: null, modelName: PipeLength )
• Shape__Length ( type: esriFieldTypeDouble, alias: st_length(shape), editable: false, nullable: true, defaultValue: null, modelName: st_length(shape), required: true )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Ductile Iron Sewer
  Description: A Ductile Iron Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  pipelength: null
  facilityid: null
  material: DIP
  diameter: null
  mainshape: null
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 8" PVC Sewer
  Description: A 8" PVC Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: PVC
  diameter: 8
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 12" PVC Sewer
  Description: A 12" PVC Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: PVC
  diameter: 12
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 18" PVC Sewer
  Description: A 18" PVC Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: PVC
  diameter: 18
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 24" PVC Sewer
  Description: A 24" PVC Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: PVC
  diameter: 24
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 27" PVC Sewer
  Description: A 27" PVC Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: PVC
  diameter: 27
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 12" Ductile Iron Sewer
  Description: A 12" PVC Ductile Iron Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: DIP
  diameter: 12
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 18" Ductile Iron Sewer
  Description: A 18" Ductile Iron Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: DIP
  diameter: 18
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 24" Ductile Iron Sewer
  Description: A 24" Ductile Iron Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: DIP
  diameter: 24
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 27" Ductile Iron Sewer
  Description: A 27" Ductile Iron Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: DIP
  diameter: 27
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 8" Ductile Iron Sewer
  Description: A 8" Ductile Iron Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: DIP
  diameter: 8
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 12" Reinforced Conrete Sewer
  Description: A 12" Reinforced Conrete Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: RCP
  diameter: 12
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 18" Reinforced Conrete Sewer
  Description: A 18" Reinforced Conrete Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: RCP
  diameter: 18
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 24" Reinforced Conrete Sewer
  Description: A 24" Reinforced Conrete Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: RCP
  diameter: 24
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 27" Reinforced Conrete Sewer
  Description: A 27" Reinforced Conrete Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: RCP
  diameter: 27
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 8" Reinforced Conrete Sewer
  Description: A 8" Reinforced Conrete Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  material: RCP
  diameter: 8
  pipelength: null
  facilityid: null
  mainshape: Circular
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: PVC Sewer
  Description: A PVC Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  pipelength: null
  facilityid: null
  material: PVC
  diameter: null
  mainshape: null
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Reinforced Concrete Sewer
  Description: A Reinforced Concrete Sewer Gravity Main.
  Prototype:
  activeflag: 1
  enabled: 1
  ownedby: 1
  installdate: null
  tomh: null
  watertype: Sewage
  pipelength: null
  facilityid: null
  material: RCP
  diameter: null
  mainshape: null
  linedyear: null
  linertype: NONE
  frommh: null
  maintby: 1
  sumflow: null
  downelev: null
  upelev: null
  slope: null
  comments: null
  locdesc: null
  condition: null
  tv_inspected: null
  ii: null
  yearlastinspected: null
  metered: null
  meternumber: null
  repaired: null
  depthavg: null
  length: null
  maxhistoricalii: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

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