View In:   ArcGIS Online Map Viewer

Name: Storm Structure Maintenance Holes

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>This data shows stormwater structures for the City of Tumwater (catch basins, manholes, treatment structures, outlets, etc...). Most of the structures are owned and maintained by the City. There are some private storm facilitieis shown in this layer and they are labeled as private. This layer is in development and any information shown on it should be field verified as needed. Please note that some of the data fields are not filled out and that has been done on purpose. Those fields will likely be removed in the near future.</SPAN></P><P><SPAN>Most of the structures in this layer were mapped with a GPS in the field. Structures mapped in 2014 or later were mapped with a Trimble GeoXH 6000 series GPS unit and all data collected with this unit was post-processed in Trimble's Pathfinder Office software using the Tumwater GPS base station for corrections. Most of the storm structures are mapped to a horizontal accuracy of roughly 1-2 ft. </SPAN><SPAN>Any Rim Elevations shot with the Trimble GeoXH 6000 should only be considered a close estimate. The Rim Elevations could be off by 1-2 feet. Structures mapped before 2014 were mapped with survey grade Trimble GPS unit.</SPAN></P><P><SPAN>In February 2016 the stormwater data from Thurston County was imported / integrated into this layer. Most of the County's data was mapped to survey grade accuracy by Tetra Tech in 2011-2014.</SPAN></P><P><SPAN /></P></DIV></DIV></DIV>

Service Item Id: 1b19bd00f44c4842b8049420f8306dc7

Copyright Text: City of Tumwater Public Works Department

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: 1022931.8402643055
YMin: 596540.4395827204
XMax: 1049543.6607282162
YMax: 628176.1791326404
Spatial Reference: 2927  (2927)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [35, 35, 127, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 255, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [FACILITYID]
Use Coded Values: true
Symbol:
Color: [68, 137, 112, 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: Tahoma
Font Style: normal
Font Weight: bold
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Structure #, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SNG_ST_NO )
• STRUCTTYPE ( type: esriFieldTypeInteger, alias: Structure Type, editable: true, nullable: true, defaultValue: null, modelName: SNG_TYPE_CD , Coded Values: [9: Cleanout] , [6: Treatment Structure] , [5: Infiltration Structure] , ...9 more... )
• STRUCTDEPTH ( type: esriFieldTypeDouble, alias: Struct Depth (ft), editable: true, nullable: true, defaultValue: null, modelName: SNG_DEPTH )
• RIMELEVATION ( type: esriFieldTypeDouble, alias: Rim Elevation, editable: true, nullable: true, defaultValue: null, modelName: SNG_RIM_ELE )
• STATUS ( type: esriFieldTypeInteger, alias: Status, editable: true, nullable: true, defaultValue: null, modelName: SNG_STAT_CD , Coded Values: [952: Parent Out of Service] , [951: Out of Service] , [5: Abandonded - Removed] , ...4 more... )
• OWNEDBY ( type: esriFieldTypeInteger, alias: Owner, editable: true, nullable: true, defaultValue: null, modelName: SNG_FUNC_CD , Coded Values: [6: Port of Olympia] , [5: Olympia] , [4: Private] , ...4 more... )
• GPSFLAG ( type: esriFieldTypeSmallInteger, alias: GPS Flag, editable: true, nullable: true, defaultValue: 0, modelName: SNG_GPS )
• LUCITYID ( type: esriFieldTypeInteger, alias: Unique Number, editable: true, nullable: true, defaultValue: null, modelName: SNG_ID )
• INLUCITY ( type: esriFieldTypeSmallInteger, alias: In Lucity Database?, editable: true, nullable: true, defaultValue: 0, modelName: SNG_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 )
• GPS_DATE ( type: esriFieldTypeDate, alias: GPS Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_DATE )
• PHOTO ( type: esriFieldTypeString, alias: Photo, editable: true, nullable: true, length: 230, defaultValue: null, modelName: PHOTO )
• GPS_COMMENT ( type: esriFieldTypeString, alias: GPS Field Comments, editable: true, nullable: true, length: 70, defaultValue: null, modelName: GPS_COMMENT )
• 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: EASTING, 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 )
• X_COORD ( type: esriFieldTypeDouble, alias: X coordinate, editable: true, nullable: true, defaultValue: null, modelName: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y coordinate, editable: true, nullable: true, defaultValue: null, modelName: Y_COORD )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, editable: true, nullable: true, length: 75, defaultValue: null, modelName: COMMENT )
• SiteID ( type: esriFieldTypeInteger, alias: SiteID, editable: true, nullable: true, defaultValue: null, modelName: SiteID )
• SystemID ( type: esriFieldTypeInteger, alias: SystemID, editable: true, nullable: true, defaultValue: null, modelName: SystemID )
• ComponentID ( type: esriFieldTypeString, alias: ComponentID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ComponentID )
• 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: 75, defaultValue: null, modelName: Source )
• MaintBy ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: null, modelName: MaintBy , Coded Values: [7: Tumwater Facilities] , [6: Port of Olympia] , [5: Olympia] , ...4 more... )
• StructSize ( type: esriFieldTypeString, alias: Structure Size, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StructSize , Coded Values: [9: 84" Diameter] , [8: 72" Diameter] , [7: 60" Diameter] , ...11 more... )
• StructDet ( type: esriFieldTypeString, alias: Structure Detail, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StructDet , Coded Values: [9: Wet Vault] , [7: Curb Inlet] , [6: Grate Inlet Type 2] , ...7 more... )
• ControlStructType ( type: esriFieldTypeString, alias: Control Structure Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ControlStructType , Coded Values: [6: Orifice] , [5: Baffle] , [3: Shear Gate] , ...6 more... )
• PSysName ( type: esriFieldTypeString, alias: Proprietary System Name, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PSysName , Coded Values: [5: Aqua-Swirl] , [4: Vortechs] , [3: EcoStorm Plus] , ...3 more... )
• UIC ( type: esriFieldTypeSmallInteger, alias: UIC, editable: true, nullable: true, defaultValue: null, modelName: UIC , Coded Values: [0: No] , [1: Yes] )
• TreatType ( type: esriFieldTypeSmallInteger, alias: Treatment Type, editable: true, nullable: true, defaultValue: null, modelName: TreatType , Coded Values: [0: N/A] , [1: Filter System] , [2: Oil Water Separator] , ...2 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• LidSize ( type: esriFieldTypeSmallInteger, alias: LidSize, editable: true, nullable: true, defaultValue: null, modelName: LidSize , Coded Values: [1: 24" DIA] , [10: 24x47] , [11: See Comments] , ...8 more... )
• 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 )
• LidType ( type: esriFieldTypeSmallInteger, alias: Lid Type, editable: true, nullable: true, defaultValue: null, modelName: GrateType , Coded Values: [27: SLOTTED] , [26: SOLID] , [21: BEEHIVE] , ...2 more... )
• Inspected ( type: esriFieldTypeInteger, alias: Inspected, editable: true, nullable: true, defaultValue: null, modelName: Inspected , Coded Values: [0: No] , [1: Yes] )
• NeedCleaning ( type: esriFieldTypeInteger, alias: Needs Cleaning, editable: true, nullable: true, defaultValue: null, modelName: NeedCleaning , Coded Values: [0: No] , [1: Yes] )
• NeedMaint ( type: esriFieldTypeInteger, alias: Needs Maintenance, editable: true, nullable: true, defaultValue: null, modelName: NeedMaint , Coded Values: [0: No] , [1: Yes] )
• FieldEdited ( type: esriFieldTypeSmallInteger, alias: FieldEdited, editable: true, nullable: true, defaultValue: null, modelName: FieldEdited , Coded Values: [0: No] , [1: Yes] )
• MaintType ( type: esriFieldTypeInteger, alias: MaintType, editable: true, nullable: true, defaultValue: null, modelName: MaintType , Coded Values: [0: N/A] , [1: Mortar] , [2: Frame & Grate] , ...3 more... )
• 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 )

Templates:

• Name: Storm Structure Maintenance Holes
  Description:
  Prototype:
  ESRIGNSS_AVG_POSITIONS: null
  FACILITYID: null
  STRUCTTYPE: null
  STRUCTDEPTH: null
  RIMELEVATION: null
  STATUS: null
  OWNEDBY: null
  GPSFLAG: 0
  LUCITYID: null
  INLUCITY: 0
  LastModBy: null
  LastModDate: null
  LastSynDate: null
  GPS_DATE: null
  PHOTO: null
  GPS_COMMENT: null
  VDATUM: null
  NORTHING: null
  EASTING: null
  X_COORD: null
  Y_COORD: null
  COMMENT: null
  SiteID: null
  SystemID: null
  ComponentID: null
  DataGrade: null
  Source: null
  MaintBy: null
  StructSize: null
  StructDet: null
  ControlStructType: null
  PSysName: null
  UIC: null
  TreatType: null
  ESRIGNSS_H_STDDEV: null
  LidSize: null
  ESRIGNSS_AVG_V_RMS: null
  ESRIGNSS_AVG_H_RMS: null
  ESRISNSR_AZIMUTH: null
  ESRIGNSS_SPEED: null
  LidType: null
  Inspected: null
  NeedCleaning: null
  NeedMaint: null
  FieldEdited: null
  MaintType: 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,Create,Update,Delete,Uploads,Editing,Sync,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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata