About this Dataset

Rain Gages

Primarily supports the permanent Combined Sewer Overflow monitoring locations network to determine the beginning and ending of rainfall events and calculate rainfall depth. Also, supports other DWW monitoring programs such as sampling, modeling, and O&M functions. Contains data from UTIL.RAIN_GAGES. Labels are based on the attribute RG_VICINITY_NAME.
Organization: City of Seattle
Last updated: 2025-02-28T23:48:57.381302
Tags: dww, gis, public-utility, rain-gage, seattle-gis-open-data

Tables

Table 1

@usgov.city_of_seattle_rain_gages_be25b.table_1

13.81 kB
22 rows
15 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "rg_fea_key" BIGINT,
  "rg_ref_code" VARCHAR,
  "rg_vicinity_name" VARCHAR,
  "rg_adrs_text" VARCHAR,
  "rg_established_date" VARCHAR,
  "rg_end_date" VARCHAR,
  "rg_status" VARCHAR,
  "rg_comments_text" VARCHAR,
  "rg_assetnum" VARCHAR,
  "rg_northing_y_coord" DOUBLE,
  "rg_easting_x_coord" DOUBLE,
  "rg_elevation_nbr" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);