View In:   ArcGIS Online Map Viewer

Parent Layer: Utilities

Name: Sanitary Sewer Manholes

Display Field: facilityid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 5b82ea05b5324466aedb17259e6cabc5

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

Extent:

XMin: -9640226.2298
YMin: 4287368.716200002
XMax: -9622361.2619
YMax: 4304539.038699999
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [125, 168, 57, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: System-maintained ObjectID, alias: OBJECTID )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Facility ID, type: esriFieldTypeString )
• installdate ( modelName: INSTALLDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• highelev ( modelName: HIGHELEV, nullable: true, editable: true, defaultValue: null, alias: High Pipe Elevation, type: esriFieldTypeDouble )
• invert ( modelName: INVERT, nullable: true, editable: true, defaultValue: null, alias: Invert, type: esriFieldTypeDouble )
• invertelev ( modelName: INVERTELEV, nullable: true, editable: true, defaultValue: null, alias: Invert Elevation, type: esriFieldTypeDouble )
• rimelev ( modelName: RIMELEV, nullable: true, editable: true, defaultValue: null, alias: Rim Elevation, type: esriFieldTypeDouble )
• cvtype ( modelName: CVTYPE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Cover Type, type: esriFieldTypeString , Coded Values: [Standard W/ Lock: Standard W/ Lock] , [Standard W/ Ears: Standard W/ Ears] , [Non-District: Non-District] , ...12 more... )
• wallmat ( modelName: WALLMAT, nullable: true, editable: true, defaultValue: null, length: 25, alias: Wall Material, type: esriFieldTypeString , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...34 more... )
• mhtype ( modelName: MHTYPE, nullable: true, editable: true, defaultValue: STD, length: 30, alias: Manhole Type, type: esriFieldTypeString , Coded Values: [STD: Standard] , [DRP: Drop] , [SPL: Split] , ...4 more... )
• condition ( modelName: CONDITION, nullable: true, editable: true, defaultValue: null, length: 10, alias: Manhole Condition, type: esriFieldTypeString , Coded Values: [Excellent: Excellent] , [Very Good: Very Good] , [Good: Good] , ...4 more... )
• cutdepth ( modelName: CUTDEPTH, nullable: true, editable: true, defaultValue: null, alias: Pavement Cut Depth, type: esriFieldTypeDouble )
• flowdir ( modelName: FLOWDIR, nullable: true, editable: true, defaultValue: null, length: 25, alias: Flow Direction, type: esriFieldTypeString , Coded Values: [East: East] , [North: North] , [South: South] , ...9 more... )
• lined ( modelName: LINED, nullable: true, editable: true, defaultValue: null, length: 3, alias: Lined, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• gpsdate ( modelName: GPSDATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: GPS Date, type: esriFieldTypeDate )
• watertype ( modelName: WATERTYPE, nullable: true, editable: true, defaultValue: Sewage, length: 30, alias: Water Type, type: esriFieldTypeString , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...6 more... )
• locdesc ( modelName: LOCDESC, nullable: true, editable: true, defaultValue: null, length: 200, alias: Location Description, type: esriFieldTypeString )
• enabled ( modelName: ENABLED, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• activeflag ( modelName: ACTIVEFLAG, nullable: true, editable: true, defaultValue: 1, alias: Active Flag, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• ownedby ( modelName: OWNEDBY, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [-1: Private] , [-2: Other] , [1: Smyrna] , ...1 more... )
• maintby ( modelName: MAINTBY, nullable: true, editable: true, defaultValue: 1, alias: Managed By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• sumflow ( modelName: SUMFLOW, nullable: true, editable: true, defaultValue: null, alias: Flow Summary, type: esriFieldTypeDouble )
• status ( modelName: STATUS, nullable: true, editable: true, defaultValue: EXT, length: 50, alias: Status, type: esriFieldTypeString , Coded Values: [EXT: Existing] , [PRO: Proposed] , [ABD: Abandoned] )
• comments ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 50, alias: Comments, type: esriFieldTypeString )
• inlets ( modelName: INLETS, nullable: true, editable: true, defaultValue: null, length: 50, alias: Number of Inlets, type: esriFieldTypeString )
• outlets ( modelName: OUTLETS, nullable: true, editable: true, defaultValue: null, length: 50, alias: Number of Outlets, type: esriFieldTypeString )
• lidtype ( modelName: LIDTYPE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Lid Type, type: esriFieldTypeString )
• shotposition ( modelName: SHOTPOSITION, nullable: true, editable: true, defaultValue: null, length: 50, alias: Shot Position, type: esriFieldTypeString )
• accessibility ( modelName: ACCESSIBILITY, nullable: true, editable: true, defaultValue: null, length: 50, alias: Accessibility, type: esriFieldTypeString )
• obstructed ( modelName: OBSTRUCTED, nullable: true, editable: true, defaultValue: null, length: 50, alias: Obstructed, type: esriFieldTypeString )
• dropmanhole ( modelName: DROPMANHOLE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Drop Manhole, type: esriFieldTypeString )
• pposition1 ( modelName: PPOSITION1, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Postition 1, type: esriFieldTypeString )
• invertelev1 ( modelName: INVERTELEV1, nullable: true, editable: true, defaultValue: null, alias: Invert Elevation 1, type: esriFieldTypeDouble )
• pipeshp1 ( modelName: PIPESHP1, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Shape 1, type: esriFieldTypeString )
• pipedia1 ( modelName: PIPEDIA1, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Diameter 1, type: esriFieldTypeString )
• pposition2 ( modelName: PPOSITION2, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Position 2, type: esriFieldTypeString )
• invertelev2 ( modelName: INVERTELEV2, nullable: true, editable: true, defaultValue: null, alias: Invert Elevation 2, type: esriFieldTypeDouble )
• pipeshp2 ( modelName: PIPESHP2, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Shape 2, type: esriFieldTypeString )
• pipedia2 ( modelName: PIPEDIA2, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Diameter 2, type: esriFieldTypeString )
• pposition3 ( modelName: PPOSITION3, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Position 3, type: esriFieldTypeString )
• invertelev3 ( modelName: INVERTELEV3, nullable: true, editable: true, defaultValue: null, alias: Invert Elevation3, type: esriFieldTypeDouble )
• pipeshp3 ( modelName: PIPESHP3, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Shape 3, type: esriFieldTypeString )
• pipedia3 ( modelName: PIPEDIA3, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Diameter 3, type: esriFieldTypeString )
• pposition4 ( modelName: PPOSITION4, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Position 4, type: esriFieldTypeString )
• invertelev4 ( modelName: INVERTELEV4, nullable: true, editable: true, defaultValue: null, alias: Invert Elevation 4, type: esriFieldTypeDouble )
• pipeshp4 ( modelName: PIPESHP4, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Shape 4, type: esriFieldTypeString )
• pipedia4 ( modelName: PIPEDIA4, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Diameter 4, type: esriFieldTypeString )
• pposition5 ( modelName: PPOSITION5, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Position 5, type: esriFieldTypeString )
• invertelel5 ( modelName: INVERTELEL5, nullable: true, editable: true, defaultValue: null, alias: Invert Elevation 5, type: esriFieldTypeDouble )
• pipeshp5 ( modelName: PIPESHP5, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Shape 5, type: esriFieldTypeString )
• pipedia5 ( modelName: PIPEDIA5, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe Diameter 5, type: esriFieldTypeString )
• updatestatus ( modelName: UPDATESTATUS, nullable: true, editable: true, defaultValue: null, length: 50, alias: Update Status, type: esriFieldTypeString )
• pointid ( modelName: POINTID, nullable: true, editable: true, defaultValue: null, alias: Point ID, type: esriFieldTypeDouble )
• basinid ( modelName: BASINID, nullable: true, editable: true, defaultValue: null, length: 50, alias: Basin ID, type: esriFieldTypeString )
• mhnumber ( modelName: MHNUMBER, nullable: true, editable: true, defaultValue: null, length: 50, alias: Manhole Number, type: esriFieldTypeString )
• locationstatus ( modelName: LOCATIONSTATUS, nullable: true, editable: true, defaultValue: null, length: 50, alias: Location Status, type: esriFieldTypeString , Coded Values: [G: GPS] , [P: Plat] , [O: Other] , ...3 more... )
• dropheight ( modelName: DROPHEIGHT, nullable: true, editable: true, defaultValue: null, alias: Drop Height, type: esriFieldTypeInteger )
• droptype ( modelName: DROPTYPE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Drop Type, type: esriFieldTypeString )
• rimdiameter ( modelName: RIMDIAMETER, nullable: true, editable: true, defaultValue: null, length: 50, alias: Rim Diameter, type: esriFieldTypeString )
• surfacetype ( modelName: SURFACETYPE, nullable: true, editable: true, defaultValue: null, alias: Surface Type, type: esriFieldTypeInteger , Coded Values: [1: Asphalt] , [2: Concrete] , [3: Grass] , ...4 more... )
• esthorizacc ( modelName: ESTHORIZACC, nullable: true, editable: true, defaultValue: null, alias: Estimated Horizontal Accuracy, type: esriFieldTypeDouble )
• hgtabvellip ( modelName: HGTABVELLIP, nullable: true, editable: true, defaultValue: null, alias: Height Above Ellipsoid, type: esriFieldTypeDouble )
• 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 )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• x ( modelName: X, nullable: true, editable: true, defaultValue: null, alias: X, type: esriFieldTypeDouble )
• y ( modelName: Y, nullable: true, editable: true, defaultValue: null, alias: Y, type: esriFieldTypeDouble )
• esrignss_positionsourcetype ( modelName: ESRIGNSS_POSITIONSOURCETYPE, nullable: true, editable: true, defaultValue: null, alias: Position source type, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...2 more... )
• esrignss_receiver ( modelName: ESRIGNSS_RECEIVER, nullable: true, editable: true, defaultValue: null, length: 50, alias: Receiver Name, type: esriFieldTypeString )
• esrignss_latitude ( modelName: ESRIGNSS_LATITUDE, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• esrignss_longitude ( modelName: ESRIGNSS_LONGITUDE, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• esrignss_altitude ( modelName: ESRIGNSS_ALTITUDE, nullable: true, editable: true, defaultValue: null, alias: Altitude, type: esriFieldTypeDouble )
• esrignss_h_rms ( modelName: ESRIGNSS_H_RMS, nullable: true, editable: true, defaultValue: null, alias: Horizontal Accuracy (m), type: esriFieldTypeDouble )
• esrignss_v_rms ( modelName: ESRIGNSS_V_RMS, nullable: true, editable: true, defaultValue: null, alias: Vertical Accuracy (m), type: esriFieldTypeDouble )
• esrignss_fixdatetime ( modelName: ESRIGNSS_FIXDATETIME, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Fix Time, type: esriFieldTypeDate )
• esrignss_fixtype ( modelName: ESRIGNSS_FIXTYPE, nullable: true, editable: true, defaultValue: null, alias: Fix Type, type: esriFieldTypeSmallInteger , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• esrignss_correctionage ( modelName: ESRIGNSS_CORRECTIONAGE, nullable: true, editable: true, defaultValue: null, alias: Correction Age, type: esriFieldTypeDouble )
• esrignss_stationid ( modelName: ESRIGNSS_STATIONID, nullable: true, editable: true, defaultValue: null, alias: Station ID, type: esriFieldTypeSmallInteger , Range: [0, 1023] )
• esrignss_numsats ( modelName: ESRIGNSS_NUMSATS, nullable: true, editable: true, defaultValue: null, alias: Number of Satellites, type: esriFieldTypeSmallInteger , Range: [0, 99] )
• esrignss_pdop ( modelName: ESRIGNSS_PDOP, nullable: true, editable: true, defaultValue: null, alias: PDOP, type: esriFieldTypeDouble )
• esrignss_hdop ( modelName: ESRIGNSS_HDOP, nullable: true, editable: true, defaultValue: null, alias: HDOP, type: esriFieldTypeDouble )
• esrignss_vdop ( modelName: ESRIGNSS_VDOP, nullable: true, editable: true, defaultValue: null, alias: VDOP, type: esriFieldTypeDouble )
• esrignss_direction ( modelName: ESRIGNSS_DIRECTION, nullable: true, editable: true, defaultValue: null, alias: Direction of travel (°), type: esriFieldTypeDouble )
• esrignss_speed ( modelName: ESRIGNSS_SPEED, nullable: true, editable: true, defaultValue: null, alias: Speed (km/h), type: esriFieldTypeDouble )
• esrisnsr_azimuth ( modelName: ESRISNSR_AZIMUTH, nullable: true, editable: true, defaultValue: null, alias: Compass reading (°), type: esriFieldTypeDouble )
• esrignss_avg_h_rms ( modelName: ESRIGNSS_AVG_H_RMS, nullable: true, editable: true, defaultValue: null, alias: Average Horizontal Accuracy (m), type: esriFieldTypeDouble )
• esrignss_avg_v_rms ( modelName: ESRIGNSS_AVG_V_RMS, nullable: true, editable: true, defaultValue: null, alias: Average Vertical Accuracy (m), type: esriFieldTypeDouble )
• esrignss_avg_positions ( modelName: ESRIGNSS_AVG_POSITIONS, nullable: true, editable: true, defaultValue: null, alias: Averaged Positions, type: esriFieldTypeSmallInteger )
• esrignss_h_stddev ( modelName: ESRIGNSS_H_STDDEV, nullable: true, editable: true, defaultValue: null, alias: Standard Deviation (m), type: esriFieldTypeDouble )

Templates:

• Name: Sanitary Sewer Manholes
  Description:
  Prototype:
  esrignss_avg_h_rms: null
  shotposition: null
  facilityid: null
  installdate: null
  accessibility: null
  hgtabvellip: null
  esrignss_hdop: null
  cvtype: null
  outlets: null
  rimdiameter: null
  esrignss_pdop: null
  esrisnsr_azimuth: null
  locationstatus: null
  surfacetype: null
  esrignss_fixdatetime: null
  watertype: Sewage
  gpsdate: null
  ownedby: 1
  esrignss_fixtype: null
  esrignss_h_stddev: null
  esrignss_avg_positions: null
  invert: null
  mhtype: STD
  pipedia5: null
  esrignss_stationid: null
  pipedia4: null
  invertelel5: null
  esrignss_v_rms: null
  pipedia3: null
  obstructed: null
  pipedia2: null
  pipedia1: null
  highelev: null
  activeflag: 1
  invertelev: null
  esrignss_direction: null
  inlets: null
  cutdepth: null
  condition: null
  pointid: null
  sumflow: null
  basinid: null
  status: EXT
  lidtype: null
  flowdir: null
  esrignss_speed: null
  esrignss_avg_v_rms: null
  rimelev: null
  dropmanhole: null
  enabled: 1
  esrignss_longitude: null
  pipeshp2: null
  esrignss_latitude: null
  pipeshp1: null
  pipeshp4: null
  esrignss_receiver: null
  esrignss_altitude: null
  lined: null
  pipeshp3: null
  esrignss_positionsourcetype: null
  pposition3: null
  pposition4: null
  esrignss_vdop: null
  pposition1: null
  esthorizacc: null
  pposition2: null
  pipeshp5: null
  pposition5: null
  comments: null
  mhnumber: null
  wallmat: null
  dropheight: null
  esrignss_correctionage: null
  droptype: null
  esrignss_numsats: null
  updatestatus: null
  x: null
  y: null
  maintby: 1
  invertelev1: null
  locdesc: null
  invertelev2: null
  invertelev3: null
  invertelev4: null
  esrignss_h_rms: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

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

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

Child Resources:   Field Groups   Contingent Values

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