View In:   ArcGIS Online Map Viewer

Parent Layer: Sewer Gravity Mains

Name: Sewer Gravity Mains

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><DIV><P><SPAN>Separated and combined sewer gravity mains.</SPAN></P></DIV></DIV>

Service Item Id: a830f85173824ddb90435c417287ea2c

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: -1.0415868853242405E7
YMin: 5582664.184357711
XMax: -1.0397069949844394E7
YMax: 5590633.5010587955
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: OWNEDBY
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: -1
  Label: Private
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 190, 190, 255]
  Width: 1
• Value: -2
  Label: MCES
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 152, 0, 255]
  Width: 1
• Value: 1
  Label: City
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [168, 0, 0, 255]
  Width: 1
• Value: 7
  Label: Force Main
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 255, 255, 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

HasZ: false

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: OWNEDBY

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• 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] , ...34 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"] , ...37 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: null, modelName: LINERTYPE , Coded Values: [CP: Cured in Place] , [FF: Fold and Form or Deform/Reform] , [SN: Segmented Panel] , ...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] , [1: City] , [-2: MCES] , ...6 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: County] , ...4 more... )
• SUMFLOW ( type: esriFieldTypeDouble, alias: Flow Summary, editable: true, nullable: true, defaultValue: null, modelName: SUMFLOW )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• 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 )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NOTES )
• ASBUILT ( type: esriFieldTypeString, alias: ASBUILT, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ASBUILT )
• TELEVISING_DATE ( type: esriFieldTypeDate, alias: TELEVISING DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TELEVISING_DATE )
• TELEVISING_REPORT ( type: esriFieldTypeString, alias: TELEVISING REPORT, editable: true, nullable: true, length: 150, defaultValue: null, modelName: TELEVISING_REPORT )
• TELEVISING_MEDIA ( type: esriFieldTypeString, alias: TELEVISING MEDIA, editable: true, nullable: true, length: 200, defaultValue: null, modelName: TELEVISING_MEDIA )
• JETTING_FREQUENCY ( type: esriFieldTypeString, alias: JETTING FREQUENCY, editable: true, nullable: true, length: 250, defaultValue: null, modelName: JETTING_COMMENTS , Coded Values: [Monthly: Monthly] , [Quarterly: Quarterly] , [Bi-Annually: Bi-Annually] )
• ROOT_FOAM ( type: esriFieldTypeDate, alias: ROOT FOAM DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ROOT_FOAM )
• LINED ( type: esriFieldTypeDate, alias: LINED DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LINED )
• Length ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
• YEAR_TO_BE_JETTED ( type: esriFieldTypeString, alias: YEAR_TO_BE_JETTED, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YEAR_TO_BE_JETTED )
• 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 )
• ADDL_ASBUILT ( type: esriFieldTypeString, alias: ASBUILT, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ADDL_ASBUILT )
• ADDL3_ASBUILT ( type: esriFieldTypeString, alias: ASBUILT, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ADDL3_ASBUILT )
• DOCID ( type: esriFieldTypeDouble, alias: Asbuilt Document ID, editable: true, nullable: true, defaultValue: null, modelName: DOCID )
• DOCID_A ( type: esriFieldTypeDouble, alias: Asbuilt 2 Document ID, editable: true, nullable: true, defaultValue: null, modelName: DOCID_A )
• DOCID_B ( type: esriFieldTypeDouble, alias: Asbuilt 3 Document ID, editable: true, nullable: true, defaultValue: null, modelName: DOCID_B )
• DOCID_C ( type: esriFieldTypeDouble, alias: Televising Report Document ID, editable: true, nullable: true, defaultValue: null, modelName: DOCID_C )
• TELEVISEDYEAR ( type: esriFieldTypeSmallInteger, alias: Televised Year, editable: true, nullable: true, defaultValue: null, modelName: TELEVISEDYEAR )
• VIDDOCID ( type: esriFieldTypeDouble, alias: VIDDOCID, editable: true, nullable: true, defaultValue: null, modelName: VIDDOCID )
• JETDATE ( type: esriFieldTypeDate, alias: Jetting Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: JETDATE )
• COMMENTS ( type: esriFieldTypeString, alias: Jetting Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENTS )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector's Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTOR , Coded Values: [Scott Blom: Scott Blom] , [Bob Gieseke: Bob Gieseke] , [Kevin Hennes: Kevin Hennes] , ...25 more... )
• ROOTDATE ( type: esriFieldTypeDate, alias: Root Foamed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ROOTDATE )
• LINEDATE ( type: esriFieldTypeDate, alias: Lined Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LINEDATE )
• FLUSHDATE ( type: esriFieldTypeDate, alias: Flushed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FLUSHDATE )
• STATUS ( type: esriFieldTypeString, alias: Maintenance Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STATUS , Coded Values: [Complete: Complete] , [Needs Maintenance: Needs Maintenance] , [Inspection Needed: Inspection Needed] , ...1 more... )
• HOTSPOT ( type: esriFieldTypeString, alias: Hot Spot / Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HOTSPOT , Coded Values: [1st Cleaning Complete: 1st Cleaning Complete] , [2nd Cleaning Complete: 2nd Cleaning Complete] , [All Cleanings Complete: All Cleanings Complete] , ...2 more... )
• QAQCINT ( type: esriFieldTypeString, alias: QAQC Intern, editable: true, nullable: true, length: 50, defaultValue: null, modelName: QAQCINT , Coded Values: [Yes: Yes] , [No: No] )
• QAQCENG ( type: esriFieldTypeString, alias: QAQC Engineer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: QAQCENG , Coded Values: [Yes: Yes] , [No: No] )
• TELEVISECOMP ( type: esriFieldTypeString, alias: Televising Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TELEVISECOMP , Coded Values: [Needs Inspection: Needs Inspection] , [Inspection Complete: Inspection Complete] )
• INSTALLYEAR ( type: esriFieldTypeString, alias: Install Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: INSTALLYEAR )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )

Types:

ID: -1
Name: Private
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• MAINSHAPE:
  Inherited
• LINERTYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• JETTING_FREQUENCY:
  Inherited
• INSPECTOR:
  Inherited
• STATUS:
  Inherited
• HOTSPOT:
  Inherited
• QAQCINT:
  Inherited
• QAQCENG:
  Inherited
• TELEVISECOMP:
  Inherited
Templates:
• Name: Private
  Description:
  Prototype:
  ACTIVEFLAG: 1
  INSTALLDATE: null
  FACILITYID: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINEDYEAR: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  WATERTYPE: null
  ENABLED: 1
  OWNEDBY: -1
  MAINTBY: 1
  SUMFLOW: null
  LASTUPDATE: null
  LASTEDITOR: null
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  NOTES: null
  ASBUILT: null
  TELEVISING_DATE: null
  TELEVISING_REPORT: null
  TELEVISING_MEDIA: null
  JETTING_FREQUENCY: null
  ROOT_FOAM: null
  LINED: null
  Length: null
  YEAR_TO_BE_JETTED: null
  TELEVISECOMP: null
  QAQCENG: null
  QAQCINT: null
  HOTSPOT: null
  INSTALLYEAR: null
  ADDL_ASBUILT: null
  ADDL3_ASBUILT: null
  DOCID: null
  DOCID_A: null
  DOCID_B: null
  DOCID_C: null
  TELEVISEDYEAR: null
  VIDDOCID: null
  JETDATE: null
  COMMENTS: null
  INSPECTOR: null
  ROOTDATE: null
  LINEDATE: null
  FLUSHDATE: null
  STATUS: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: -2
Name: MCES
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• MAINSHAPE:
  Inherited
• LINERTYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• JETTING_FREQUENCY:
  Inherited
• INSPECTOR:
  Inherited
• STATUS:
  Inherited
• HOTSPOT:
  Inherited
• QAQCINT:
  Inherited
• QAQCENG:
  Inherited
• TELEVISECOMP:
  Inherited
Templates:
• Name: MCES
  Description:
  Prototype:
  ACTIVEFLAG: 1
  INSTALLDATE: null
  FACILITYID: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINEDYEAR: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  WATERTYPE: null
  ENABLED: 1
  OWNEDBY: -2
  MAINTBY: 1
  SUMFLOW: null
  LASTUPDATE: null
  LASTEDITOR: null
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  NOTES: null
  ASBUILT: null
  TELEVISING_DATE: null
  TELEVISING_REPORT: null
  TELEVISING_MEDIA: null
  JETTING_FREQUENCY: null
  ROOT_FOAM: null
  LINED: null
  Length: null
  YEAR_TO_BE_JETTED: null
  TELEVISECOMP: null
  QAQCENG: null
  QAQCINT: null
  HOTSPOT: null
  INSTALLYEAR: null
  ADDL_ASBUILT: null
  ADDL3_ASBUILT: null
  DOCID: null
  DOCID_A: null
  DOCID_B: null
  DOCID_C: null
  TELEVISEDYEAR: null
  VIDDOCID: null
  JETDATE: null
  COMMENTS: null
  INSPECTOR: null
  ROOTDATE: null
  LINEDATE: null
  FLUSHDATE: null
  STATUS: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: City
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• MAINSHAPE:
  Inherited
• LINERTYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• JETTING_FREQUENCY:
  Inherited
• INSPECTOR:
  Inherited
• STATUS:
  Inherited
• HOTSPOT:
  Inherited
• QAQCINT:
  Inherited
• QAQCENG:
  Inherited
• TELEVISECOMP:
  Inherited
Templates:
• Name: City
  Description:
  Prototype:
  ACTIVEFLAG: 1
  INSTALLDATE: null
  FACILITYID: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINEDYEAR: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  WATERTYPE: null
  ENABLED: 1
  OWNEDBY: 1
  MAINTBY: 1
  SUMFLOW: null
  LASTUPDATE: null
  LASTEDITOR: null
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  NOTES: null
  ASBUILT: null
  TELEVISING_DATE: null
  TELEVISING_REPORT: null
  TELEVISING_MEDIA: null
  JETTING_FREQUENCY: null
  ROOT_FOAM: null
  LINED: null
  Length: null
  YEAR_TO_BE_JETTED: null
  TELEVISECOMP: null
  QAQCENG: null
  QAQCINT: null
  HOTSPOT: null
  INSTALLYEAR: null
  ADDL_ASBUILT: null
  ADDL3_ASBUILT: null
  DOCID: null
  DOCID_A: null
  DOCID_B: null
  DOCID_C: null
  TELEVISEDYEAR: null
  VIDDOCID: null
  JETDATE: null
  COMMENTS: null
  INSPECTOR: null
  ROOTDATE: null
  LINEDATE: null
  FLUSHDATE: null
  STATUS: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 7
Name: Force Main
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• MAINSHAPE:
  Inherited
• LINERTYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• JETTING_FREQUENCY:
  Inherited
• INSPECTOR:
  Inherited
• STATUS:
  Inherited
• HOTSPOT:
  Inherited
• QAQCINT:
  Inherited
• QAQCENG:
  Inherited
• TELEVISECOMP:
  Inherited
Templates:
• Name: Force Main
  Description:
  Prototype:
  ACTIVEFLAG: 1
  INSTALLDATE: null
  FACILITYID: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINEDYEAR: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  WATERTYPE: null
  ENABLED: 1
  OWNEDBY: 7
  MAINTBY: 1
  SUMFLOW: null
  LASTUPDATE: null
  LASTEDITOR: null
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  NOTES: null
  ASBUILT: null
  TELEVISING_DATE: null
  TELEVISING_REPORT: null
  TELEVISING_MEDIA: null
  JETTING_FREQUENCY: null
  ROOT_FOAM: null
  LINED: null
  Length: null
  YEAR_TO_BE_JETTED: null
  TELEVISECOMP: null
  QAQCENG: null
  QAQCINT: null
  HOTSPOT: null
  INSTALLYEAR: null
  ADDL_ASBUILT: null
  ADDL3_ASBUILT: null
  DOCID: null
  DOCID_A: null
  DOCID_B: null
  DOCID_C: null
  TELEVISEDYEAR: null
  VIDDOCID: null
  JETDATE: null
  COMMENTS: null
  INSPECTOR: null
  ROOTDATE: null
  LINEDATE: null
  FLUSHDATE: null
  STATUS: 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: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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