View In:   ArcGIS Online Map Viewer

Name: Sewer Structures (Abandoned)

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This layer shows the location of sewer structures in the City of Tumwater. Only sewer structures owned and or maintained by the City are included in this layer. Many of the data fields in this layer have been left empty. They will be removed in the near future.

Service Item Id: fe92c6a273d84f9ba259eadd1c5d35be

Copyright Text: City of Tumwater Public Works Department

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000.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.3689536762127642E7
YMin: 5933190.347877024
XMax: -1.3677392523241226E7
YMax: 5947011.312166705
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: COMPONENTTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 2
  Label: Clean Out
  Description: N/A
  Symbol:
  
• Value: 1
  Label: Manhole
  Description: N/A
  Symbol:
  
• Value: 0
  Label: Other or Unknown
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [FACILITYID]
Use Coded Values: true
Symbol:
Color: [168, 0, 132, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Calibri
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 2000.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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: COMPONENTTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Network Structure, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MAG_MANHOLE )
• STRUCTTYPE ( type: esriFieldTypeInteger, alias: Structure Type, editable: true, nullable: true, defaultValue: null, modelName: MAG_TYPE_CD , Coded Values: [1: Lift Station Wetwell] , [2: Inside Drop] , [3: Outside Drop] , ...4 more... )
• STRUCTDEPTH ( type: esriFieldTypeDouble, alias: Structure Depth (ft), editable: true, nullable: true, defaultValue: null, modelName: MAG_DEPTH )
• STATUS ( type: esriFieldTypeInteger, alias: Status, editable: true, nullable: true, defaultValue: null, modelName: MAG_STAT_CD , Coded Values: [0: N/A] , [1: Operational] , [2: Approved] , ...4 more... )
• COMPONENTTYPE ( type: esriFieldTypeInteger, alias: Component Type, editable: true, nullable: true, defaultValue: null, modelName: MAG_STRC_CD , Coded Values: [8: Pump Station] , [7: Tee] , [6: Field Inlet] , ...6 more... )
• GPSFLAG ( type: esriFieldTypeSmallInteger, alias: GPS Flag, editable: true, nullable: true, defaultValue: 0, modelName: MAG_GPS )
• LUCITYID ( type: esriFieldTypeInteger, alias: Unique Number, editable: true, nullable: true, defaultValue: null, modelName: MAG_MHID )
• INLUCITY ( type: esriFieldTypeSmallInteger, alias: In Lucity Database?, editable: true, nullable: true, defaultValue: 0, modelName: MAG_DB )
• LastModBy ( type: esriFieldTypeString, alias: Last Modified By, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LastModBy , Coded Values: [MATTS: MATT STULL] , [CORAB: CORA BAULKE] , [jradcliff: JEN RADCLIFF] , ...3 more... )
• LastModDate ( type: esriFieldTypeDate, alias: Last Modified date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastModDate )
• LastSynDate ( type: esriFieldTypeDate, alias: Last Synchronized Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastSynDate )
• CAD_LAYER ( type: esriFieldTypeString, alias: CAD_LAYER, editable: true, nullable: true, length: 75, defaultValue: null, modelName: CAD_LAYER )
• INVERTELEVATION ( type: esriFieldTypeDouble, alias: INVERTELEVATION, editable: true, nullable: true, defaultValue: null, modelName: INVERTELEVATION )
• VDATUM ( type: esriFieldTypeString, alias: VDATUM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: VDATUM , Coded Values: [NGVD29: NGVD29] , [NAVD88: NAVD88] )
• NORTHING ( type: esriFieldTypeString, alias: NORTHING, editable: true, nullable: true, length: 25, defaultValue: null, modelName: NORTHING )
• EASTING ( type: esriFieldTypeString, alias: EASTING, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EASTING )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• GPS_TYPE_CODE ( type: esriFieldTypeString, alias: GPS_TYPE_CODE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: GPS_TYPE_CODE )
• PHOTO ( type: esriFieldTypeString, alias: PHOTO, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PHOTO )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, editable: true, nullable: true, length: 150, defaultValue: null, modelName: COMMENT )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD, editable: true, nullable: true, defaultValue: null, modelName: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD, editable: true, nullable: true, defaultValue: null, modelName: Y_COORD )
• DIAMETER_STRUCTURE ( type: esriFieldTypeDouble, alias: DIAMETER_STRUCT, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER_STRUCTURE )
• RIM_ELEVATION ( type: esriFieldTypeString, alias: RIM_ELEVATION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RIM_ELEVATION )
• GPS_UNIT ( type: esriFieldTypeString, alias: GPS_UNIT, editable: true, nullable: true, length: 25, defaultValue: null, modelName: GPS_UNIT , Coded Values: [GEOXH: Trimble GeoXH 6000] , [R8: Trimble R8] , [7X: Trimble Geo7X] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• DataGrade ( type: esriFieldTypeString, alias: DataGrade, editable: true, nullable: true, length: 15, defaultValue: null, modelName: DataGrade , Coded Values: [Survey: Survey] , [GPS: Mapping Grade GPS] , [Plan: Approved Plans] , ...2 more... )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, required: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, required: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, required: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, required: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Owner ( type: esriFieldTypeInteger, alias: Owner, editable: true, nullable: true, defaultValue: null, modelName: Owner , Coded Values: [2: Private] , [1: City] , [0: N/A] )
• RimElev ( type: esriFieldTypeSingle, alias: Rim Elevation, editable: true, nullable: true, defaultValue: null, modelName: RimElev )
• Material ( type: esriFieldTypeInteger, alias: Material, editable: true, nullable: true, defaultValue: null, modelName: Material , Coded Values: [1: Brick] , [2: Concrete] )
• CoverType ( type: esriFieldTypeInteger, alias: Cover Type, editable: true, nullable: true, defaultValue: null, modelName: CoverType , Coded Values: [1: Standard] , [2: Hinged Lid] )
• CoverSize ( type: esriFieldTypeInteger, alias: Cover Size, editable: true, nullable: true, defaultValue: null, modelName: CoverSize , Coded Values: [1: 18] , [2: 24] , [3: 36] )
• ESRIGNSS_POSITIONSOURCETYPE ( type: esriFieldTypeSmallInteger, alias: Position source type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_POSITIONSOURCETYPE , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...3 more... )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ESRIGNSS_RECEIVER )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LATITUDE )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_LONGITUDE )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_ALTITUDE )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_H_RMS )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_V_RMS )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Time, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ESRIGNSS_FIXDATETIME )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_FIXTYPE , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_CORRECTIONAGE )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_STATIONID , Range: [0, 1023] )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Number of Satellites, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_NUMSATS , Range: [0, 99] )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_VDOP )
• ESRIGNSS_DIRECTION ( type: esriFieldTypeDouble, alias: Direction of travel (°), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_DIRECTION )
• ESRIGNSS_SPEED ( type: esriFieldTypeDouble, alias: Speed (km/h), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_SPEED )
• ESRISNSR_AZIMUTH ( type: esriFieldTypeDouble, alias: Compass reading (°), editable: true, nullable: true, defaultValue: null, modelName: ESRISNSR_AZIMUTH )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_H_RMS )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_V_RMS )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeSmallInteger, alias: Averaged Positions, editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_AVG_POSITIONS )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m), editable: true, nullable: true, defaultValue: null, modelName: ESRIGNSS_H_STDDEV )
• VALIDATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Validation status, editable: false, required: true, nullable: true, defaultValue: 6, modelName: VALIDATIONSTATUS , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )

Types:

ID: 2
Name: Clean Out
Domains:
• STRUCTTYPE:
  Inherited
• STATUS:
  Inherited
• COMPONENTTYPE:
  Inherited
• LastModBy:
  Inherited
• VDATUM:
  Inherited
• GPS_UNIT:
  Inherited
• DataGrade:
  Inherited
• Owner:
  Inherited
• Material:
  Inherited
• CoverType:
  Inherited
• CoverSize:
  Inherited
• ESRIGNSS_POSITIONSOURCETYPE:
  Inherited
• ESRIGNSS_FIXTYPE:
  Inherited
• ESRIGNSS_STATIONID:
  Inherited
• ESRIGNSS_NUMSATS:
  Inherited
• VALIDATIONSTATUS:
  Inherited
Templates:
• Name: Clean Out
  Description:
  Prototype:
  STATUS: null
  ESRIGNSS_H_STDDEV: null
  FACILITYID: null
  STRUCTTYPE: null
  STRUCTDEPTH: null
  COMPONENTTYPE: 2
  GPSFLAG: 0
  LUCITYID: null
  INLUCITY: 0
  LastModBy: null
  LastModDate: null
  LastSynDate: null
  CAD_LAYER: null
  INVERTELEVATION: null
  VDATUM: null
  NORTHING: null
  EASTING: null
  GPS_DATE: null
  GPS_TYPE_CODE: null
  PHOTO: null
  COMMENT: null
  X_COORD: null
  Y_COORD: null
  DIAMETER_STRUCTURE: null
  RIM_ELEVATION: null
  GPS_UNIT: null
  ESRIGNSS_SPEED: null
  DataGrade: null
  Source: null
  ESRIGNSS_AVG_POSITIONS: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  Owner: null
  RimElev: null
  Material: null
  CoverType: null
  CoverSize: null
  ESRIGNSS_POSITIONSOURCETYPE: null
  ESRIGNSS_RECEIVER: null
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  ESRIGNSS_H_RMS: null
  ESRIGNSS_V_RMS: null
  ESRIGNSS_FIXDATETIME: null
  ESRIGNSS_FIXTYPE: null
  ESRIGNSS_CORRECTIONAGE: null
  ESRIGNSS_STATIONID: null
  ESRIGNSS_NUMSATS: null
  ESRIGNSS_PDOP: null
  ESRIGNSS_HDOP: null
  ESRIGNSS_VDOP: null
  ESRIGNSS_DIRECTION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: Manhole
Domains:
• STRUCTTYPE:
  Inherited
• STATUS:
  Inherited
• COMPONENTTYPE:
  Inherited
• LastModBy:
  Inherited
• VDATUM:
  Inherited
• GPS_UNIT:
  Inherited
• DataGrade:
  Inherited
• Owner:
  Inherited
• Material:
  Inherited
• CoverType:
  Inherited
• CoverSize:
  Inherited
• ESRIGNSS_POSITIONSOURCETYPE:
  Inherited
• ESRIGNSS_FIXTYPE:
  Inherited
• ESRIGNSS_STATIONID:
  Inherited
• ESRIGNSS_NUMSATS:
  Inherited
• VALIDATIONSTATUS:
  Inherited
Templates:
• Name: Manhole
  Description:
  Prototype:
  STATUS: null
  ESRIGNSS_H_STDDEV: null
  FACILITYID: null
  STRUCTTYPE: null
  STRUCTDEPTH: null
  COMPONENTTYPE: 1
  GPSFLAG: 0
  LUCITYID: null
  INLUCITY: 0
  LastModBy: null
  LastModDate: null
  LastSynDate: null
  CAD_LAYER: null
  INVERTELEVATION: null
  VDATUM: null
  NORTHING: null
  EASTING: null
  GPS_DATE: null
  GPS_TYPE_CODE: null
  PHOTO: null
  COMMENT: null
  X_COORD: null
  Y_COORD: null
  DIAMETER_STRUCTURE: null
  RIM_ELEVATION: null
  GPS_UNIT: null
  ESRIGNSS_SPEED: null
  DataGrade: null
  Source: null
  ESRIGNSS_AVG_POSITIONS: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  Owner: null
  RimElev: null
  Material: null
  CoverType: null
  CoverSize: null
  ESRIGNSS_POSITIONSOURCETYPE: null
  ESRIGNSS_RECEIVER: null
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  ESRIGNSS_H_RMS: null
  ESRIGNSS_V_RMS: null
  ESRIGNSS_FIXDATETIME: null
  ESRIGNSS_FIXTYPE: null
  ESRIGNSS_CORRECTIONAGE: null
  ESRIGNSS_STATIONID: null
  ESRIGNSS_NUMSATS: null
  ESRIGNSS_PDOP: null
  ESRIGNSS_HDOP: null
  ESRIGNSS_VDOP: null
  ESRIGNSS_DIRECTION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 0
Name: Other or Unknown
Domains:
• STRUCTTYPE:
  Inherited
• STATUS:
  Inherited
• COMPONENTTYPE:
  Inherited
• LastModBy:
  Inherited
• VDATUM:
  Inherited
• GPS_UNIT:
  Inherited
• DataGrade:
  Inherited
• Owner:
  Inherited
• Material:
  Inherited
• CoverType:
  Inherited
• CoverSize:
  Inherited
• ESRIGNSS_POSITIONSOURCETYPE:
  Inherited
• ESRIGNSS_FIXTYPE:
  Inherited
• ESRIGNSS_STATIONID:
  Inherited
• ESRIGNSS_NUMSATS:
  Inherited
• VALIDATIONSTATUS:
  Inherited
Templates:
• Name: Other or Unknown
  Description:
  Prototype:
  STATUS: null
  ESRIGNSS_H_STDDEV: null
  FACILITYID: null
  STRUCTTYPE: null
  STRUCTDEPTH: null
  COMPONENTTYPE: 0
  GPSFLAG: 0
  LUCITYID: null
  INLUCITY: 0
  LastModBy: null
  LastModDate: null
  LastSynDate: null
  CAD_LAYER: null
  INVERTELEVATION: null
  VDATUM: null
  NORTHING: null
  EASTING: null
  GPS_DATE: null
  GPS_TYPE_CODE: null
  PHOTO: null
  COMMENT: null
  X_COORD: null
  Y_COORD: null
  DIAMETER_STRUCTURE: null
  RIM_ELEVATION: null
  GPS_UNIT: null
  ESRIGNSS_SPEED: null
  DataGrade: null
  Source: null
  ESRIGNSS_AVG_POSITIONS: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  Owner: null
  RimElev: null
  Material: null
  CoverType: null
  CoverSize: null
  ESRIGNSS_POSITIONSOURCETYPE: null
  ESRIGNSS_RECEIVER: null
  ESRIGNSS_LATITUDE: null
  ESRIGNSS_LONGITUDE: null
  ESRIGNSS_ALTITUDE: null
  ESRIGNSS_H_RMS: null
  ESRIGNSS_V_RMS: null
  ESRIGNSS_FIXDATETIME: null
  ESRIGNSS_FIXTYPE: null
  ESRIGNSS_CORRECTIONAGE: null
  ESRIGNSS_STATIONID: null
  ESRIGNSS_NUMSATS: null
  ESRIGNSS_PDOP: null
  ESRIGNSS_HDOP: null
  ESRIGNSS_VDOP: null
  ESRIGNSS_DIRECTION: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Sync,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

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

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata