View In:   ArcGIS Online Map Viewer

Name: Sanitary Sewer Mains

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 7b3316de4c7143979ea990acce4c5985

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: 846908.8628408909
YMin: 511146.4693519771
XMax: 875219.3619940579
YMax: 532441.1268938035
Spatial Reference: 103412  (8193)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: MainType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: FMAIN
  Label: FORCE MAIN
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 1
• Value: INTCPTR
  Label: INTERCEPTOR
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Value: MAIN
  Label: MAIN
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 1
• Value: PMAIN
  Label: PRIVATE MAIN
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [56, 168, 0, 255]
  Width: 1
Transparency: 0
Labeling Info:

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

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: MainType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• MainID ( type: esriFieldTypeString, alias: Main ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MainID )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter , Coded Values: [42: 42"] , [36: 36"] , [30: 30"] , ...9 more... )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Material , Coded Values: [C-900: C-900] , [Cast Iron: Cast Iron] , [OTHER: OTHER] , ...10 more... )
• ActiveFlag ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ActiveFlag , Coded Values: [0: False] , [1: True] )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDate )
• RetireDate ( type: esriFieldTypeDate, alias: Retire Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RetireDate )
• LastEditor ( type: esriFieldTypeString, alias: Last Editor, editable: false, nullable: true, length: 50, defaultValue: null, modelName: LastEditor )
• LastUpdate ( type: esriFieldTypeDate, alias: Last Update, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LastUpdate )
• OwnedBy ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OwnedBy , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] , ...1 more... )
• MaintBy ( type: esriFieldTypeSmallInteger, alias: Maint By, editable: true, nullable: true, defaultValue: 1, modelName: MaintBy , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] , ...1 more... )
• LocDesc ( type: esriFieldTypeString, alias: Location Desc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocDesc )
• LinedDate ( type: esriFieldTypeDate, alias: Lined Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LinedDate )
• FromMH ( type: esriFieldTypeString, alias: From MH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FromMH )
• ToMH ( type: esriFieldTypeString, alias: To MH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ToMH )
• UpElev ( type: esriFieldTypeDouble, alias: Up Elev, editable: true, nullable: true, defaultValue: null, modelName: UpElev )
• DwnElev ( type: esriFieldTypeDouble, alias: Dwn Elev, editable: true, nullable: true, defaultValue: null, modelName: DwnElev )
• StreetName ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StreetName , Coded Values: [A ST: A ST] , [ABBINGTON CT: ABBINGTON CT] , [ABBOTT LN: ABBOTT LN] , ...623 more... )
• Slope ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: Slope )
• Length ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
• PipeDrop ( type: esriFieldTypeString, alias: Pipe Drop, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeDrop , Coded Values: [Inside Drop: Inside Drop] , [Outside Drop: Outside Drop] , [Not Applicable: Not Applicable] , ...1 more... )
• DropMH ( type: esriFieldTypeString, alias: Drop MH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DropMH )
• MainType ( type: esriFieldTypeString, alias: Main Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MainType , Coded Values: [FMAIN: FORCE MAIN] , [INTCPTR: INTERCEPTOR] , [MAIN: MAIN] , ...1 more... )
• Label ( type: esriFieldTypeString, alias: Label, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Label )
• UpDepth ( type: esriFieldTypeDouble, alias: Up Depth, editable: true, nullable: true, defaultValue: null, modelName: UpDepth )
• DownDepth ( type: esriFieldTypeDouble, alias: Down Depth, editable: true, nullable: true, defaultValue: null, modelName: DownDepth )
• Asbuilt ( type: esriFieldTypeString, alias: Asbuilt, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Asbuilt )
• Subdivision ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Subdivision )
• Contractor ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Contractor )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Source , Coded Values: [CAD: CAD] , [DIG: Digitized] , [GPS: GPS] , ...7 more... )
• LineContractor ( type: esriFieldTypeString, alias: Line Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LineContractor )
• Vacuumed ( type: esriFieldTypeString, alias: Vacuumed, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Vacuumed , Coded Values: [Yes: Yes] , [No: No] )
• CleaningStatus ( type: esriFieldTypeString, alias: Cleaning Status, editable: true, nullable: true, length: 10, defaultValue: No, modelName: MainJetStatus , Coded Values: [Yes: Yes] , [No: No] , [Assigned: Assigned] )
• TelevisedMainStatus ( type: esriFieldTypeString, alias: Televising Status , editable: true, nullable: true, length: 4, defaultValue: null, modelName: TelevisedMainStatus , Coded Values: [A: Assigned] , [Yes: Yes] , [No: No] , ...2 more... )
• LiningMainStatus ( type: esriFieldTypeString, alias: Lining Status, editable: true, nullable: true, length: 4, defaultValue: No, modelName: LiningMainStatus , Coded Values: [Yes: Yes] , [No: No] )
• CleaningType ( type: esriFieldTypeString, alias: Cleaning Type, editable: true, nullable: true, length: 50, defaultValue: Jet, modelName: CleaningType )
• AccessIssue ( type: esriFieldTypeString, alias: Access Issue, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AccessIssue , Coded Values: [1: Not Applicable] , [2: Cannot Access] , [3: Obstruction Needs Evaluation] , ...1 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Notes )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: FMAIN
Name: FORCE MAIN
Domains:
• Diameter:
  Inherited
• Material:
  Inherited
• ActiveFlag:
  Inherited
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• StreetName:
  Inherited
• PipeDrop:
  Inherited
• MainType:
  Inherited
• Source:
  Inherited
• Vacuumed:
  Inherited
• CleaningStatus:
  Inherited
• TelevisedMainStatus:
  Inherited
• LiningMainStatus:
  Inherited
• AccessIssue:
  Inherited
• EditComplete:
  Inherited
• ReviewComplete:
  Inherited
Templates:
• Name: FORCE MAIN
  Description:
  Prototype:
  DropMH: null
  Material: null
  CleaningType: Jet
  OwnedBy: 1
  Vacuumed: null
  CleaningStatus: No
  TelevisedMainStatus: No
  LiningMainStatus: No
  Notes: null
  MainID: null
  Diameter: null
  ActiveFlag: 1
  InstallDate: null
  RetireDate: null
  AccessIssue: null
  MaintBy: 1
  LocDesc: null
  LinedDate: null
  FromMH: null
  ToMH: null
  UpElev: null
  DwnElev: null
  StreetName: null
  Slope: null
  Length: null
  PipeDrop: null
  MainType: FMAIN
  Label: null
  UpDepth: null
  DownDepth: null
  Asbuilt: null
  Subdivision: null
  Contractor: null
  Source: null
  LineContractor: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: INTCPTR
Name: INTERCEPTOR
Domains:
• Diameter:
  Inherited
• Material:
  Inherited
• ActiveFlag:
  Inherited
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• StreetName:
  Inherited
• PipeDrop:
  Inherited
• MainType:
  Inherited
• Source:
  Inherited
• Vacuumed:
  Inherited
• CleaningStatus:
  Inherited
• TelevisedMainStatus:
  Inherited
• LiningMainStatus:
  Inherited
• AccessIssue:
  Inherited
• EditComplete:
  Inherited
• ReviewComplete:
  Inherited
Templates:
• Name: INTERCEPTOR
  Description:
  Prototype:
  DropMH: null
  Material: null
  CleaningType: Jet
  OwnedBy: 1
  Vacuumed: null
  CleaningStatus: No
  TelevisedMainStatus: No
  LiningMainStatus: No
  Notes: null
  MainID: null
  Diameter: null
  ActiveFlag: 1
  InstallDate: null
  RetireDate: null
  AccessIssue: null
  MaintBy: 1
  LocDesc: null
  LinedDate: null
  FromMH: null
  ToMH: null
  UpElev: null
  DwnElev: null
  StreetName: null
  Slope: null
  Length: null
  PipeDrop: null
  MainType: INTCPTR
  Label: null
  UpDepth: null
  DownDepth: null
  Asbuilt: null
  Subdivision: null
  Contractor: null
  Source: null
  LineContractor: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: MAIN
Name: MAIN
Domains:
• Diameter:
  Inherited
• Material:
  Inherited
• ActiveFlag:
  Inherited
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• StreetName:
  Inherited
• PipeDrop:
  Inherited
• MainType:
  Inherited
• Source:
  Inherited
• Vacuumed:
  Inherited
• CleaningStatus:
  Inherited
• TelevisedMainStatus:
  Inherited
• LiningMainStatus:
  Inherited
• AccessIssue:
  Inherited
• EditComplete:
  Inherited
• ReviewComplete:
  Inherited
Templates:
• Name: MAIN
  Description:
  Prototype:
  DropMH: null
  Material: null
  CleaningType: Jet
  OwnedBy: 1
  Vacuumed: null
  CleaningStatus: No
  TelevisedMainStatus: No
  LiningMainStatus: No
  Notes: null
  MainID: null
  Diameter: null
  ActiveFlag: 1
  InstallDate: null
  RetireDate: null
  AccessIssue: null
  MaintBy: 1
  LocDesc: null
  LinedDate: null
  FromMH: null
  ToMH: null
  UpElev: null
  DwnElev: null
  StreetName: null
  Slope: null
  Length: null
  PipeDrop: null
  MainType: MAIN
  Label: null
  UpDepth: null
  DownDepth: null
  Asbuilt: null
  Subdivision: null
  Contractor: null
  Source: null
  LineContractor: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: PMAIN
Name: PRIVATE MAIN
Domains:
• Diameter:
  Inherited
• Material:
  Inherited
• ActiveFlag:
  Inherited
• OwnedBy:
  Inherited
• MaintBy:
  Inherited
• StreetName:
  Inherited
• PipeDrop:
  Inherited
• MainType:
  Inherited
• Source:
  Inherited
• Vacuumed:
  Inherited
• CleaningStatus:
  Inherited
• TelevisedMainStatus:
  Inherited
• LiningMainStatus:
  Inherited
• AccessIssue:
  Inherited
• EditComplete:
  Inherited
• ReviewComplete:
  Inherited
Templates:
• Name: PRIVATE MAIN
  Description:
  Prototype:
  DropMH: null
  Material: null
  CleaningType: Jet
  OwnedBy: 1
  Vacuumed: null
  CleaningStatus: No
  TelevisedMainStatus: No
  LiningMainStatus: No
  Notes: null
  MainID: null
  Diameter: null
  ActiveFlag: 1
  InstallDate: null
  RetireDate: null
  AccessIssue: null
  MaintBy: 1
  LocDesc: null
  LinedDate: null
  FromMH: null
  ToMH: null
  UpElev: null
  DwnElev: null
  StreetName: null
  Slope: null
  Length: null
  PipeDrop: null
  MainType: PMAIN
  Label: null
  UpDepth: null
  DownDepth: null
  Asbuilt: null
  Subdivision: null
  Contractor: null
  Source: null
  LineContractor: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: LastUpdate
• Editor Field: LastEditor

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata