View In:   ArcGIS Online Map Viewer

Name: Sewer Manholes

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Manhole features connect two or more pipes and control the flow of water in the network through pipe elevations. Manhole invert elevations are stored on the pipes, instead of the manholes themselves.</SPAN></P></DIV></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.0415868860577367E7
YMin: 5582664.044412191
XMax: -1.0397069949161883E7
YMax: 5590632.713426276
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: esriSMSCircle
  Color: [255, 190, 190, 255]
  Size: 4.25
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 0] Width: 0
• Value: -2
  Label: MCES
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [168, 112, 0, 255]
  Size: 4.25
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 1
  Label: City
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [230, 76, 0, 255]
  Size: 4.25
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [255, 255, 255, 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: 8
Font Family: Tahoma
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 13500.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [255, 255, 255, 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: 8
Font Family: Tahoma
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 13500.0
Max. Scale: 0.0
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [255, 255, 255, 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: 8
Font Family: Tahoma
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 13500.0
Max. Scale: 0.0

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

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 ID, 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 )
• HIGHELEV ( type: esriFieldTypeDouble, alias: High Pipe Elevation, editable: true, nullable: true, defaultValue: null, modelName: HIGHELEV )
• INVERT ( type: esriFieldTypeDouble, alias: Invert, editable: true, nullable: true, defaultValue: null, modelName: INVERT )
• INVERTELEV ( type: esriFieldTypeDouble, alias: Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVERTELEV )
• RIMELEV ( type: esriFieldTypeDouble, alias: Rim Elevation, editable: true, nullable: true, defaultValue: null, modelName: RIMELEV )
• CVTYPE ( type: esriFieldTypeString, alias: Cover Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CVTYPE , Coded Values: [Standard W/ Lock: Standard W/ Lock] , [Standard W/ Ears: Standard W/ Ears] , [Non-District: Non-District] , ...7 more... )
• WALLMAT ( type: esriFieldTypeString, alias: Wall Material, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WALLMAT , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...34 more... )
• MHTYPE ( type: esriFieldTypeString, alias: Manhole Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MHTYPE , Coded Values: [Access: Access] , [Inside Drop: Inside Drop] , [PTO: PTO] , ...5 more... )
• CONDITION ( type: esriFieldTypeString, alias: Manhole Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CONDITION , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• CUTDEPTH ( type: esriFieldTypeDouble, alias: Pavement Cut Depth, editable: true, nullable: true, defaultValue: null, modelName: CUTDEPTH )
• FLOWDIR ( type: esriFieldTypeString, alias: Flow Direction, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FLOWDIR , Coded Values: [East: East] , [North: North] , [South: South] , ...6 more... )
• LINED ( type: esriFieldTypeString, alias: Lined, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LINED , Coded Values: [Yes: Yes] , [No: No] )
• GPSDATE ( type: esriFieldTypeDate, alias: GPS Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• 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... )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• 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 )
• ASBUILT ( type: esriFieldTypeString, alias: ASBUILT, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ASBUILT )
• DROPPED_MANHOLE ( type: esriFieldTypeString, alias: DROPPED MANHOLE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DROPPED_MANHOLE , Coded Values: [D: D] , [N: N] , [S: S] , ...13 more... )
• BARREL_TYPE ( type: esriFieldTypeString, alias: BARREL TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BARREL_TYPE , Coded Values: [Brick: Brick] , [Concrete: Concrete] , [Lined: Lined] , ...6 more... )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 250, defaultValue: null, modelName: NOTES )
• 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 )
• II ( type: esriFieldTypeString, alias: I & I, editable: true, nullable: true, length: 50, defaultValue: null, modelName: II , Coded Values: [Yes: Yes] , [No: No] )
• MACPVIIDEO ( type: esriFieldTypeString, alias: MACPVIIDEO, editable: true, nullable: true, length: 250, defaultValue: null, modelName: MACPVIIDEO )
• MACPREPORT ( type: esriFieldTypeString, alias: MACPREPORT, editable: true, nullable: true, length: 250, defaultValue: null, modelName: MACPREPORT )
• REHABPLAN ( type: esriFieldTypeString, alias: REHABPLAN, editable: true, nullable: true, length: 250, defaultValue: null, modelName: REHABPLAN )
• REHABSPECS ( type: esriFieldTypeString, alias: REHABSPECS, editable: true, nullable: true, length: 250, defaultValue: null, modelName: REHABSPECS )
• SPECDOCID ( type: esriFieldTypeDouble, alias: SPECDOCID, editable: true, nullable: true, defaultValue: null, modelName: SPECDOCID )
• PLANDOCID ( type: esriFieldTypeDouble, alias: PLANDOCID, editable: true, nullable: true, defaultValue: null, modelName: PLANDOCID )
• VIDDOCID ( type: esriFieldTypeDouble, alias: VIDDOCID, editable: true, nullable: true, defaultValue: null, modelName: VIDDOCID )
• REPORTID ( type: esriFieldTypeDouble, alias: REPORTID, editable: true, nullable: true, defaultValue: null, modelName: REPORTID )
• FLEX ( type: esriFieldTypeString, alias: Flex Seal, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FLEX , Coded Values: [Satisfactory: Satisfactory] , [Unsatisfactory: Unsatisfactory] , [Not Applicable (Not Flex Sealed): Not Applicable (Not Flex Sealed)] )
• DATE ( type: esriFieldTypeDate, alias: Inspected Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• 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... )
• BARREL ( type: esriFieldTypeString, alias: Barrel Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BARREL , Coded Values: [Pass: Pass] , [Fail: Fail] )
• COVER ( type: esriFieldTypeString, alias: Cover Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COVER , Coded Values: [Pass: Pass] , [Fail: Fail] )
• INFILTRATION ( type: esriFieldTypeString, alias: Infiltration Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INFILTRATION , Coded Values: [Pass: Pass] , [Fail: Fail] )
• INVERTCON ( type: esriFieldTypeString, alias: Invert Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INVERTCON , Coded Values: [Pass: Pass] , [Fail: Fail] )
• RING ( type: esriFieldTypeString, alias: Ring Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RING , Coded Values: [Pass: Pass] , [Fail: Fail] )
• STEP ( type: esriFieldTypeString, alias: Step Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STEP , Coded Values: [Pass: Pass] , [Fail: Fail] )
• MAINNEED ( type: esriFieldTypeString, alias: Maintenance Needed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINNEED , Coded Values: [Reconstruct: Reconstruct] , [Tuck Point: Tuck Point] , [Remove Trees: Remove Trees] , ...13 more... )
• PERFDATE ( type: esriFieldTypeDate, alias: Performance Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PERFDATE )
• STATUS ( type: esriFieldTypeString, alias: Maintenance Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS , Coded Values: [Complete: Complete] , [Needs Maintenance: Needs Maintenance] , [Inspection Needed: Inspection Needed] , ...1 more... )

Types:

ID: -1
Name: Private
Domains:
• CVTYPE:
  Inherited
• WALLMAT:
  Inherited
• MHTYPE:
  Inherited
• CONDITION:
  Inherited
• FLOWDIR:
  Inherited
• LINED:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• DROPPED_MANHOLE:
  Inherited
• BARREL_TYPE:
  Inherited
• II:
  Inherited
• FLEX:
  Inherited
• INSPECTOR:
  Inherited
• BARREL:
  Inherited
• COVER:
  Inherited
• INFILTRATION:
  Inherited
• INVERTCON:
  Inherited
• RING:
  Inherited
• STEP:
  Inherited
• MAINNEED:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Private
  Description:
  Prototype:
  ACTIVEFLAG: 1
  PERFDATE: null
  FACILITYID: null
  INSTALLDATE: null
  HIGHELEV: null
  INVERT: null
  INVERTELEV: null
  RIMELEV: null
  CVTYPE: null
  WALLMAT: null
  MHTYPE: null
  CONDITION: null
  CUTDEPTH: null
  FLOWDIR: null
  LINED: null
  GPSDATE: null
  WATERTYPE: null
  LOCDESC: null
  ENABLED: 1
  OWNEDBY: -1
  MAINTBY: 1
  SUMFLOW: null
  ASBUILT: null
  DROPPED_MANHOLE: null
  BARREL_TYPE: null
  NOTES: null
  MAINNEED: null
  STEP: null
  RING: null
  INVERTCON: null
  STATUS: null
  II: null
  MACPVIIDEO: null
  MACPREPORT: null
  REHABPLAN: null
  REHABSPECS: null
  SPECDOCID: null
  PLANDOCID: null
  VIDDOCID: null
  REPORTID: null
  FLEX: null
  DATE: null
  INSPECTOR: null
  BARREL: null
  COVER: null
  INFILTRATION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: -2
Name: MCES
Domains:
• CVTYPE:
  Inherited
• WALLMAT:
  Inherited
• MHTYPE:
  Inherited
• CONDITION:
  Inherited
• FLOWDIR:
  Inherited
• LINED:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• DROPPED_MANHOLE:
  Inherited
• BARREL_TYPE:
  Inherited
• II:
  Inherited
• FLEX:
  Inherited
• INSPECTOR:
  Inherited
• BARREL:
  Inherited
• COVER:
  Inherited
• INFILTRATION:
  Inherited
• INVERTCON:
  Inherited
• RING:
  Inherited
• STEP:
  Inherited
• MAINNEED:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: MCES
  Description:
  Prototype:
  ACTIVEFLAG: 1
  PERFDATE: null
  FACILITYID: null
  INSTALLDATE: null
  HIGHELEV: null
  INVERT: null
  INVERTELEV: null
  RIMELEV: null
  CVTYPE: null
  WALLMAT: null
  MHTYPE: null
  CONDITION: null
  CUTDEPTH: null
  FLOWDIR: null
  LINED: null
  GPSDATE: null
  WATERTYPE: null
  LOCDESC: null
  ENABLED: 1
  OWNEDBY: -2
  MAINTBY: 1
  SUMFLOW: null
  ASBUILT: null
  DROPPED_MANHOLE: null
  BARREL_TYPE: null
  NOTES: null
  MAINNEED: null
  STEP: null
  RING: null
  INVERTCON: null
  STATUS: null
  II: null
  MACPVIIDEO: null
  MACPREPORT: null
  REHABPLAN: null
  REHABSPECS: null
  SPECDOCID: null
  PLANDOCID: null
  VIDDOCID: null
  REPORTID: null
  FLEX: null
  DATE: null
  INSPECTOR: null
  BARREL: null
  COVER: null
  INFILTRATION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: City
Domains:
• CVTYPE:
  Inherited
• WALLMAT:
  Inherited
• MHTYPE:
  Inherited
• CONDITION:
  Inherited
• FLOWDIR:
  Inherited
• LINED:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• DROPPED_MANHOLE:
  Inherited
• BARREL_TYPE:
  Inherited
• II:
  Inherited
• FLEX:
  Inherited
• INSPECTOR:
  Inherited
• BARREL:
  Inherited
• COVER:
  Inherited
• INFILTRATION:
  Inherited
• INVERTCON:
  Inherited
• RING:
  Inherited
• STEP:
  Inherited
• MAINNEED:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: City
  Description:
  Prototype:
  ACTIVEFLAG: 1
  PERFDATE: null
  FACILITYID: null
  INSTALLDATE: null
  HIGHELEV: null
  INVERT: null
  INVERTELEV: null
  RIMELEV: null
  CVTYPE: null
  WALLMAT: null
  MHTYPE: null
  CONDITION: null
  CUTDEPTH: null
  FLOWDIR: null
  LINED: null
  GPSDATE: null
  WATERTYPE: null
  LOCDESC: null
  ENABLED: 1
  OWNEDBY: 1
  MAINTBY: 1
  SUMFLOW: null
  ASBUILT: null
  DROPPED_MANHOLE: null
  BARREL_TYPE: null
  NOTES: null
  MAINNEED: null
  STEP: null
  RING: null
  INVERTCON: null
  STATUS: null
  II: null
  MACPVIIDEO: null
  MACPREPORT: null
  REHABPLAN: null
  REHABSPECS: null
  SPECDOCID: null
  PLANDOCID: null
  VIDDOCID: null
  REPORTID: null
  FLEX: null
  DATE: null
  INSPECTOR: null
  BARREL: null
  COVER: null
  INFILTRATION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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