About this Dataset

National Groundwater Monitoring Network-Well Construction Data

This dataset is part of the Washington Geological Survey's (WGS) delivery to the National Groundwater Monitoring Network (NGWMN). It contains well construction data for wells submitted the NGWMN.
Organization: State of Washington
Last updated: 2020-11-10T17:21:18.821198
Tags: groundwater, national-groundwater-monitoring-network, washington-geological-survey, water-well

Tables

Table 1

@usgov.state_of_washington_national_groundwater_monitoring_ne_7bcfc0ce.table_1

16.55 kB
3 rows
23 columns

CREATE TABLE table_1 (
  "agency_cd" VARCHAR,
  "site_no" BIGINT,
  "source_site_id" VARCHAR,
  "land_surface_altitude" DOUBLE,
  "altitude_units" VARCHAR,
  "vertical_datum" VARCHAR,
  "well_depth" DOUBLE,
  "well_depth_units" VARCHAR,
  "casing_depth_top" BIGINT,
  "casing_depth_top_unit" VARCHAR,
  "casing_depth_bottom" BIGINT,
  "casing_depth_bottom_unit" VARCHAR,
  "casing_material" VARCHAR,
  "casing_diameter" BIGINT,
  "casing_diameter_unit" VARCHAR,
  "screen_depth_top" BIGINT,
  "screen_depth_top_unit" VARCHAR,
  "screen_depth_bottom" BIGINT,
  "screen_depth_bottom_unit" VARCHAR,
  "screen_material" VARCHAR,
  "screen_diameter" BIGINT,
  "screen_diameter_unit" VARCHAR,
  "comment" VARCHAR
);