View In:   ArcGIS Online Map Viewer

Name: Manhole

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Manhole features connect two or more pipes and control the flow of water in the network through pipe elevations.

Copyright Text: City of Sioux Falls

Default Visibility: true

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON

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

Supports Datum Transformation: true

Extent:

XMin: 2244170.8927064203
YMin: 1.5810692443219848E7
XMax: 2278166.2482720055
YMax: 1.5827645121912844E7
Spatial Reference: 32164  (32164)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Status
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Active
  Label: Active
  Description:
  Symbol:
  
• Value: Pending
  Label: Pending
  Description:
  Symbol:
  
• Value: Retired
  Label: Retired
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [0, 0, 0, 0]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Status

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 )
• 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: [Brick: Brick] , [Cobblestone: Cobblestone] , [Fiberglass Reinforced: Fiberglass Reinforced] , ...3 more... )
• MHTYPE ( type: esriFieldTypeString, alias: Manhole Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MHTYPE , Coded Values: [STD: Standard] , [DRP: Drop] , [SPL: Split] , ...4 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: [E/W: E/W] , [N/S: N/S] , [NW/SE: NW/SE] , ...1 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: Our Agency] , [-1: Private] , [-2: Other] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• SUMFLOW ( type: esriFieldTypeDouble, alias: Flow Summary, editable: true, nullable: true, defaultValue: null, modelName: SUMFLOW )
• created_user ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• UNITID ( type: esriFieldTypeString, alias: Unit ID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: UNITID )
• COMPKEY ( type: esriFieldTypeInteger, alias: Comp Key, editable: true, nullable: true, defaultValue: null, modelName: COMPKEY )
• COMPTYPE ( type: esriFieldTypeInteger, alias: Comp Type, editable: true, nullable: true, defaultValue: 22, modelName: COMPTYPE , Coded Values: [21: 21 Sewer Main] , [22: 22 Sewer Structure] , [69: 69 Sewer Misc] )
• PERMITNUMBER ( type: esriFieldTypeString, alias: Permit Number, editable: true, nullable: true, length: 24, defaultValue: null, modelName: PERMITNUMBER )
• CIPNUMBER ( type: esriFieldTypeString, alias: CIP Number, editable: true, nullable: true, length: 24, defaultValue: null, modelName: CIPNUMBER )
• CONTRACTOR ( type: esriFieldTypeString, alias: Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTRACTOR , Coded Values: [605 Company: 605 Company] , [A & J Excavating: A & J Excavating] , [Ace Excavating: Ace Excavating] , ...150 more... )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPECTOR , Coded Values: [Balk, Shane: Balk, Shane] , [Bandy, Rick: Bandy, Rick] , [Bartel, Clyde: Bartel, Clyde] , ...67 more... )
• GPS ( type: esriFieldTypeString, alias: GPS, editable: true, nullable: true, length: 5, defaultValue: null, modelName: GPS , Coded Values: [Yes: Yes] , [No: No] )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: NOTES )
• BASIN ( type: esriFieldTypeString, alias: Basin, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BASIN , Coded Values: [01A: BASIN 01 SUBBASIN A] , [01B: BASIN 01 SUBBASIN B] , [01C: BASIN 01 SUBBASIN C] , ...203 more... )
• ASBUILT_SUBMIT_BY ( type: esriFieldTypeString, alias: As-Built Submitted By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASBUILT_SUBMIT_BY )
• EDIT ( type: esriFieldTypeString, alias: Edit, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EDIT )
• MANHOLEUSE ( type: esriFieldTypeString, alias: Manhole Use, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MANHOLEUSE , Coded Values: [Manhole: Manhole] , [Private MH: Private MH] , [Other: Other] , ...2 more... )
• 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] , ...7 more... )
• LINEDDATE ( type: esriFieldTypeSmallInteger, alias: Lined Date (Year), editable: true, nullable: true, defaultValue: null, modelName: LINEDDATE )
• BURIED ( type: esriFieldTypeString, alias: BURIED, editable: true, nullable: true, length: 5, defaultValue: No, modelName: BURIED , Coded Values: [Yes: Yes] , [No: No] )
• ABOVE_BELOW_GRADE ( type: esriFieldTypeSmallInteger, alias: Above Or Below Grade (Inches), editable: true, nullable: true, defaultValue: null, modelName: ABOVE_BELOW_GRADE )
• FLOWMETER ( type: esriFieldTypeString, alias: Flow Meter, editable: true, nullable: true, length: 5, defaultValue: No, modelName: FLOWMETER , Coded Values: [Yes: Yes] , [No: No] )
• INSTALLDATE ( type: esriFieldTypeSmallInteger, alias: Install Date, editable: true, nullable: true, defaultValue: null, modelName: INSTALLDATE )
• Inspected ( type: esriFieldTypeString, alias: Inspected, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Inspected , Coded Values: [Yes: Yes] , [No: No] )
• LastInspected ( type: esriFieldTypeDate, alias: LastInspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastInspected )
• CondIndex ( type: esriFieldTypeSmallInteger, alias: CondIndex, editable: true, nullable: true, defaultValue: null, modelName: CondIndex )
• LastInspectedBy ( type: esriFieldTypeString, alias: LastInspectedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastInspectedBy )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Active: Active] , [Pending: Pending] , [Retired: Retired] , ...1 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: Active
Name: Active
Domains:
• CVTYPE:
  Inherited
• WALLMAT:
  Inherited
• MHTYPE:
  Inherited
• CONDITION:
  Inherited
• FLOWDIR:
  Inherited
• LINED:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• COMPTYPE:
  Inherited
• CONTRACTOR:
  Inherited
• INSPECTOR:
  Inherited
• GPS:
  Inherited
• BASIN:
  Inherited
• MANHOLEUSE:
  Inherited
• LINERTYPE:
  Inherited
• BURIED:
  Inherited
• FLOWMETER:
  Inherited
• Inspected:
  Inherited
• Status:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  Status: Active
  LastInspectedBy: null
  FACILITYID: 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
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  SUMFLOW: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  UNITID: null
  COMPKEY: null
  COMPTYPE: 22
  PERMITNUMBER: null
  CIPNUMBER: null
  CONTRACTOR: null
  INSPECTOR: null
  GPS: null
  NOTES: null
  BASIN: null
  ASBUILT_SUBMIT_BY: null
  EDIT: null
  MANHOLEUSE: null
  LINERTYPE: null
  LINEDDATE: null
  BURIED: No
  ABOVE_BELOW_GRADE: null
  FLOWMETER: No
  INSTALLDATE: null
  Inspected: null
  LastInspected: null
  CondIndex: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Pending
Name: Pending
Domains:
• CVTYPE:
  Inherited
• WALLMAT:
  Inherited
• MHTYPE:
  Inherited
• CONDITION:
  Inherited
• FLOWDIR:
  Inherited
• LINED:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• COMPTYPE:
  Inherited
• CONTRACTOR:
  Inherited
• INSPECTOR:
  Inherited
• GPS:
  Inherited
• BASIN:
  Inherited
• MANHOLEUSE:
  Inherited
• LINERTYPE:
  Inherited
• BURIED:
  Inherited
• FLOWMETER:
  Inherited
• Inspected:
  Inherited
• Status:
  Inherited
Templates:
• Name: Pending
  Description:
  Prototype:
  Status: Pending
  LastInspectedBy: null
  FACILITYID: 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
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  SUMFLOW: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  UNITID: null
  COMPKEY: null
  COMPTYPE: 22
  PERMITNUMBER: null
  CIPNUMBER: null
  CONTRACTOR: null
  INSPECTOR: null
  GPS: null
  NOTES: null
  BASIN: null
  ASBUILT_SUBMIT_BY: null
  EDIT: null
  MANHOLEUSE: null
  LINERTYPE: null
  LINEDDATE: null
  BURIED: No
  ABOVE_BELOW_GRADE: null
  FLOWMETER: No
  INSTALLDATE: null
  Inspected: null
  LastInspected: null
  CondIndex: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Retired
Name: Retired
Domains:
• CVTYPE:
  Inherited
• WALLMAT:
  Inherited
• MHTYPE:
  Inherited
• CONDITION:
  Inherited
• FLOWDIR:
  Inherited
• LINED:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• COMPTYPE:
  Inherited
• CONTRACTOR:
  Inherited
• INSPECTOR:
  Inherited
• GPS:
  Inherited
• BASIN:
  Inherited
• MANHOLEUSE:
  Inherited
• LINERTYPE:
  Inherited
• BURIED:
  Inherited
• FLOWMETER:
  Inherited
• Inspected:
  Inherited
• Status:
  Inherited
Templates:
• Name: Retired
  Description:
  Prototype:
  Status: Retired
  LastInspectedBy: null
  FACILITYID: 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
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  SUMFLOW: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  UNITID: null
  COMPKEY: null
  COMPTYPE: 22
  PERMITNUMBER: null
  CIPNUMBER: null
  CONTRACTOR: null
  INSPECTOR: null
  GPS: null
  NOTES: null
  BASIN: null
  ASBUILT_SUBMIT_BY: null
  EDIT: null
  MANHOLEUSE: null
  LINERTYPE: null
  LINEDDATE: null
  BURIED: No
  ABOVE_BELOW_GRADE: null
  FLOWMETER: No
  INSTALLDATE: null
  Inspected: null
  LastInspected: null
  CondIndex: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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