About this Dataset

Water Wells

This is a hybrid of location sources for well reports (logs). There is one location for all reports, even if it is the same well (new, deepening, etc. may all be separate reports and will be seperate locations).Sources are in a hierarchy with the best source providing the final location. Only 25% of the reports have a latitude/longitude from a source. Most reports are located by the center of the township/range/section/quarter-quarter section or at the section level.
Organization: State of Oregon
Last updated: 2024-04-12T17:13:03.772675
Tags: closed-loop, drinking-well, geotechnical, groundwater, logs, monitoring-well, water, water-well, wells

Tables

Table 1

@usgov.state_of_oregon_water_wells.table_1

52.39 MB
577981 rows
48 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "wl_id" BIGINT,
  "type_of_log" VARCHAR,
  "wl_image_id" DOUBLE,
  "wl_county_code" VARCHAR,
  "wl_nbr" BIGINT,
  "wl_version" BIGINT,
  "well_tag_nbr" DOUBLE,
  "startcard_nbr" DOUBLE,
  "owner_name" VARCHAR,
  "bonded_full_name" VARCHAR,
  "bonded_name_company" VARCHAR,
  "bonded_license_nbr" DOUBLE,
  "owner_well_nbr" VARCHAR,
  "company_job_nbr" VARCHAR,
  "work_new" BIGINT,
  "work_deepening" BIGINT,
  "work_conversion" BIGINT,
  "work_alteration" BIGINT,
  "work_abandonment" BIGINT,
  "work_other" VARCHAR,
  "depth_first_water" DOUBLE,
  "post_static_water_level" DOUBLE,
  "completed_depth" DOUBLE,
  "casing_diameter_max" DOUBLE,
  "start_date" TIMESTAMP,
  "complete_date" TIMESTAMP,
  "received_date" TIMESTAMP,
  "location_county" VARCHAR,
  "tr_key" VARCHAR,
  "trs_key" VARCHAR,
  "trsqq_key" VARCHAR,
  "tax_lot" VARCHAR,
  "street_of_well" VARCHAR,
  "longitude_dec" DOUBLE,
  "latitude_dec" DOUBLE,
  "coordinate_source" VARCHAR,
  "est_horizontal_error" DOUBLE,
  "tds_amount" DOUBLE,
  "tds_unit" VARCHAR,
  "yield_gpm" DOUBLE,
  "temperature" DOUBLE,
  "temperature_unit" VARCHAR,
  "primary_use" VARCHAR,
  "deficiency_status_descr" VARCHAR,
  "well_log_url" VARCHAR
);