About this Dataset

I08 GroundwaterStations EnterpriseWaterManagement

This is a point feature class of all groundwater elevation monitoring stations (wells) maintained in the California Department of Water Resources’ (hereafter the Department) Enterprise Water Management database. Individual station information comes from a wide variety of sources, including and local and federal agencies, that conduct groundwater elevation monitoring within the state of California.
Organization: State of California
Last updated: 2025-07-23T20:11:05.092381
Tags: california, california-department-of-water-resources, dwr, dwr-gis-atlas, field-monitoring-stations, geoscientific-information, groundwater, groundwater-level, water-resources

Tables

Table 1

@usgov.ca_gov_i08_groundwaterstations_enterprisewatermanagement_7c4ec.table_1

5.93 MB
46,935 rows
29 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "site_code" VARCHAR,
  "well_name" VARCHAR,
  "swn" VARCHAR,
  "stn_id" BIGINT,
  "wcr_no" VARCHAR,
  "loc_desc" VARCHAR,
  "well_use" VARCHAR,
  "well_type" VARCHAR,
  "well_depth" DOUBLE,
  "top_prf" DOUBLE,
  "bot_prf" DOUBLE,
  "last_gse" DOUBLE,
  "last_rpe" DOUBLE,
  "rp_desc" VARCHAR,
  "first_msmt_date" TIMESTAMP,
  "last_msmt_date" TIMESTAMP,
  "msmt_count" BIGINT,
  "stn_cmt" VARCHAR,
  "stn_mod_date" TIMESTAMP,
  "stn_mod_by" VARCHAR,
  "source" VARCHAR,
  "globalid" VARCHAR,
  "monitoring_program" VARCHAR,
  "last_meas_submitting_org_name" VARCHAR,
  "last_meas_cooperating_org_name" VARCHAR,
  "last_updated_date" TIMESTAMP
);