View In:   ArcGIS Online Map Viewer

Name: Sanitary Sewer Mains

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: A wastewater main, also known as a sewer main or main sewer line, is a large underground pipe that collects and transports wastewater (sewage) from multiple sources, like individual homes or buildings, to a wastewater treatment plant. It acts as a central "highway" in a network of smaller pipes (laterals) that carry wastewater from individual properties.

Service Item Id: 943f28e799fc4fe081b79ee36176adaf

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

Extent:

XMin: 846908.8628408909
YMin: 511146.4693519771
XMax: 875219.3619940579
YMax: 532441.1268938035
Spatial Reference: 103412  (8193)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [56, 168, 0, 255]
Width: 2
Label: N/A
Description: N/A
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: false
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: true
Supports Query With LOD Spatial Reference: true
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• facilityid ( modelName: FacilityID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Facility ID, type: esriFieldTypeString )
• activeflag ( modelName: ActiveFlag, nullable: true, editable: true, defaultValue: 1, alias: Active Flag, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• installdate ( modelName: InstallDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• retiredate ( modelName: RetireDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Retire Date, type: esriFieldTypeDate )
• lasteditor ( modelName: LastEditor, nullable: true, editable: false, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString )
• lastupdate ( modelName: LastUpdate, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Last Update, type: esriFieldTypeDate )
• ownedby ( modelName: OwnedBy, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] , ...1 more... )
• maintby ( modelName: MaintBy, nullable: true, editable: true, defaultValue: 1, alias: Maint By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] , ...1 more... )
• locdesc ( modelName: LocDesc, nullable: true, editable: true, defaultValue: null, length: 50, alias: Location Desc, type: esriFieldTypeString )
• material ( modelName: Material, nullable: true, editable: true, defaultValue: null, length: 50, alias: Material, type: esriFieldTypeString , Coded Values: [C-900: C-900] , [Cast Iron: Cast Iron] , [OTHER: OTHER] , ...10 more... )
• diameter ( modelName: Diameter, nullable: true, editable: true, defaultValue: null, alias: Diameter, type: esriFieldTypeDouble , Coded Values: [42: 42"] , [36: 36"] , [30: 30"] , ...9 more... )
• lineddate ( modelName: LinedDate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Lined Date, type: esriFieldTypeDate )
• frommh ( modelName: FromMH, nullable: true, editable: true, defaultValue: null, length: 50, alias: From MH, type: esriFieldTypeString )
• tomh ( modelName: ToMH, nullable: true, editable: true, defaultValue: null, length: 50, alias: To MH, type: esriFieldTypeString )
• upelev ( modelName: UpElev, nullable: true, editable: true, defaultValue: null, alias: Up Elev, type: esriFieldTypeDouble )
• dwnelev ( modelName: DwnElev, nullable: true, editable: true, defaultValue: null, alias: Dwn Elev, type: esriFieldTypeDouble )
• streetname ( modelName: StreetName, nullable: true, editable: true, defaultValue: null, length: 50, alias: Street Name, type: esriFieldTypeString , Coded Values: [A ST: A ST] , [ABBINGTON CT: ABBINGTON CT] , [ABBOTT LN: ABBOTT LN] , ...623 more... )
• slope ( modelName: Slope, nullable: true, editable: true, defaultValue: null, alias: Slope, type: esriFieldTypeDouble )
• length0 ( modelName: Length, nullable: true, editable: true, defaultValue: null, alias: Length, type: esriFieldTypeDouble )
• pipedrop ( modelName: PipeDrop, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Drop, type: esriFieldTypeString , Coded Values: [Inside Drop: Inside Drop] , [Outside Drop: Outside Drop] , [Not Applicable: Not Applicable] , ...1 more... )
• dropmh ( modelName: DropMH, nullable: true, editable: true, defaultValue: null, length: 50, alias: Drop MH, type: esriFieldTypeString )
• maintype ( modelName: MainType, nullable: true, editable: true, defaultValue: null, length: 50, alias: Main Type, type: esriFieldTypeString , Coded Values: [FMAIN: FORCE MAIN] , [INTCPTR: INTERCEPTOR] , [MAIN: MAIN] , ...1 more... )
• label ( modelName: Label, nullable: true, editable: true, defaultValue: null, length: 50, alias: Label, type: esriFieldTypeString )
• updepth ( modelName: UpDepth, nullable: true, editable: true, defaultValue: null, alias: Up Depth, type: esriFieldTypeDouble )
• downdepth ( modelName: DownDepth, nullable: true, editable: true, defaultValue: null, alias: Down Depth, type: esriFieldTypeDouble )
• asbuilt ( modelName: Asbuilt, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asbuilt, type: esriFieldTypeString )
• subdivision ( modelName: Subdivision, nullable: true, editable: true, defaultValue: null, length: 30, alias: Subdivision, type: esriFieldTypeString )
• contractor ( modelName: Contractor, nullable: true, editable: true, defaultValue: null, length: 30, alias: Contractor, type: esriFieldTypeString )
• source ( modelName: Source, nullable: true, editable: true, defaultValue: null, length: 30, alias: Source, type: esriFieldTypeString , Coded Values: [CAD: CAD] , [DIG: Digitized] , [GPS: GPS] , ...7 more... )
• flag_spatialchange ( modelName: Flag_SpatialChange, nullable: true, editable: true, defaultValue: null, length: 50, alias: Flag_SpatialChange, type: esriFieldTypeString )
• flag_generalnotes ( modelName: Flag_GeneralNotes, nullable: true, editable: true, defaultValue: null, length: 255, alias: Flag_GeneralNotes, type: esriFieldTypeString )
• flag_upstreamie_source ( modelName: Flag_UpStreamIE_Source, nullable: true, editable: true, defaultValue: null, length: 50, alias: Flag_UpStreamIE_Source, type: esriFieldTypeString )
• flag_downstreamie_source ( modelName: Flag_DownStreamIE_Source, nullable: true, editable: true, defaultValue: null, length: 50, alias: Flag_DownStreamIE_Source, type: esriFieldTypeString )
• added_updepth_lastfieldwork ( modelName: Added_UpDepth_LastFieldWork, nullable: true, editable: true, defaultValue: null, length: 5, alias: Added_UpDepth_LastFieldWork, type: esriFieldTypeString )
• added_downdepth_lastfieldwork ( modelName: Added_DownDepth_LastFieldWork, nullable: true, editable: true, defaultValue: null, length: 5, alias: Added_DownDepth_LastFieldWork, type: esriFieldTypeString )
• linecontractor ( modelName: LineContractor, nullable: true, editable: true, defaultValue: null, length: 50, alias: Line Contractor, type: esriFieldTypeString )
• vacuumed ( modelName: Vacuumed, nullable: true, editable: true, defaultValue: null, length: 4, alias: Vacuumed, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• cleaningstatus ( modelName: MainJetStatus, nullable: true, editable: true, defaultValue: No, length: 10, alias: Cleaning Status, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Assigned: Assigned] )
• yearcleaned ( modelName: YearCleaned, nullable: true, editable: true, defaultValue: null, length: 30, alias: Year Cleaned, type: esriFieldTypeString )
• editcomplete ( modelName: EditComplete, nullable: true, editable: true, defaultValue: null, length: 4, alias: Edit Complete, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• worder ( modelName: WOrder, nullable: true, editable: true, defaultValue: null, length: 20, alias: Work Order, type: esriFieldTypeString )
• wincan_join ( modelName: WinCan_Join, nullable: true, editable: true, defaultValue: null, length: 10, alias: WinCan_Join, type: esriFieldTypeString )
• televisedmainstatus ( modelName: TelevisedMainStatus, nullable: true, editable: true, defaultValue: null, length: 4, alias: Televising Status , type: esriFieldTypeString , Coded Values: [A: Assigned] , [Yes: Yes] , [No: No] , ...2 more... )
• liningmainstatus ( modelName: LiningMainStatus, nullable: true, editable: true, defaultValue: No, length: 4, alias: Lining Status, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• cleaningtype ( modelName: CleaningType, nullable: true, editable: true, defaultValue: Jet, length: 50, alias: Cleaning Type, type: esriFieldTypeString )
• yearcleaned2 ( modelName: YearCleaned2, nullable: true, editable: true, defaultValue: null, length: 4, alias: Year Cleaned 2, type: esriFieldTypeString )
• yearcleaned3 ( modelName: YearCleaned3, nullable: true, editable: true, defaultValue: null, length: 4, alias: Year Cleaned 3, type: esriFieldTypeString )
• yearcleaned4 ( modelName: YearCleaned4, nullable: true, editable: true, defaultValue: null, length: 4, alias: Year Cleaned 4, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• mainid ( modelName: MainID, nullable: true, editable: true, defaultValue: null, length: 50, alias: Main ID, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• reviewcomplete ( modelName: ReviewComplete, nullable: true, editable: true, defaultValue: null, length: 4, alias: Review Complete, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• video ( modelName: Video, nullable: true, editable: true, defaultValue: null, length: 150, alias: Video, type: esriFieldTypeString )
• accessissue ( modelName: AccessIssue, nullable: true, editable: true, defaultValue: null, length: 20, alias: Access Issue, type: esriFieldTypeString , Coded Values: [1: Not Applicable] , [2: Cannot Access] , [3: Obstruction Needs Evaluation] , ...1 more... )
• notes ( modelName: Notes, nullable: true, editable: true, defaultValue: null, length: 150, alias: Notes, type: esriFieldTypeString )
• lastyearcleaned ( modelName: LastYearCleaned, nullable: true, editable: true, defaultValue: null, length: 5, alias: LastYearCleaned, type: esriFieldTypeString )
• strquickrating ( modelName: StrQuickRating, nullable: true, editable: true, defaultValue: null, length: 10, alias: StrQuickRating, type: esriFieldTypeString )
• omquickrating ( modelName: OMQuickRating, nullable: true, editable: true, defaultValue: null, length: 10, alias: OMQuickRating, type: esriFieldTypeString )
• overallquickrating ( modelName: OverallQuickRating, nullable: true, editable: true, defaultValue: null, length: 10, alias: OverallQuickRating, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: Sanitary Sewer Mains
  Description:
  Prototype:
  updepth: null
  facilityid: null
  notes: null
  installdate: null
  streetname: null
  vacuumed: null
  flag_upstreamie_source: null
  source: null
  editcomplete: null
  diameter: null
  asbuilt: null
  mainid: null
  yearcleaned: null
  ownedby: 1
  reviewcomplete: null
  flag_spatialchange: null
  televisedmainstatus: null
  downdepth: null
  slope: null
  activeflag: 1
  lineddate: null
  cleaningstatus: No
  length0: null
  upelev: null
  retiredate: null
  lastyearcleaned: null
  contractor: null
  omquickrating: null
  flag_generalnotes: null
  added_downdepth_lastfieldwork: null
  video: null
  frommh: null
  yearcleaned3: null
  yearcleaned4: null
  subdivision: null
  pipedrop: null
  worder: null
  dropmh: null
  overallquickrating: null
  wincan_join: null
  yearcleaned2: null
  tomh: null
  added_updepth_lastfieldwork: null
  liningmainstatus: No
  label: null
  dwnelev: null
  strquickrating: null
  cleaningtype: Jet
  flag_downstreamie_source: null
  material: null
  accessissue: null
  linecontractor: null
  maintby: 1
  locdesc: null
  maintype: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Create,Update,Editing,Sync,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Apply Edits   Add Features   Update Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata