About this Dataset

Cumberland Piedmont Network 2002-2023 Water Quality Data From Fourteen Park Projects As Of 2023-09-27

This data package was created 2024-04-01 10:14:02 by NPSTORET and includes selected project, location, and result data.

Data contained in Cumberland Piedmont Network NPSTORET back-end file (CUPN_NPSTORET_BE_2024_03_28.ACCDB) were filtered to include:
Project:

ABLI_WQ: CUPN WQ Monitoring, ABLI
CARL_WQ: CUPN WQ Monitoring, CARL
CHCH_WQ: CUPN WQ Monitoring, CHCH
COWP_WQ: CUPN WQ Monitoring, COWP
CUGA_WQ: CUPN WQ Monitoring, CUGA
FODO_WQ: CUPN WQ Monitoring, FODO
GUCO_WQ: CUPN WQ Monitoring, GUCO
KIMO_WQ: CUPN WQ Monitoring, KIMO
LIRI_WQ: CUPN WQ Monitoring, LIRI
MACA_WQ: CUPN WQ Monitoring, MACA
NISI_WQ: CUPN WQ Monitoring, NISI
RUCA_WQ: CUPN WQ Monitoring, RUCA
SHIL_WQ: CUPN WQ Monitoring, SHIL
STRI_WQ: CUPN WQ Monitoring, STRI
Station:
Include Trip QC And All Station Visit Results
Value Status:
Accepted or Certified (exported as Final) or Final

The data package is organized into four data tables:

Projects.csv - describes the purpose and background of the monitoring efforts
Locations.csv - documents the attributes of the monitoring locations/stations
Results.csv - contains the field measurements, observations, and/or lab analyses for each sample/event/data grouping
HUC12.csv - enumerates the domain of allowed values for 12-digit hydrologic unit codes utilized by the Locations datatable

Tables

Locations

@usgov.doi_gov_cumberland_piedmont_network_2002_2023_water_qu_9306b074.locations

60.33 KB
97 rows
40 columns


CREATE TABLE locations (
  "org_code" VARCHAR,
  "park_code" VARCHAR,
  "location_id" VARCHAR,
  "location_name" VARCHAR,
  "location_type" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "lat_lon_method" VARCHAR,
  "lat_lon_datum" VARCHAR,
  "source_map_scale_numeric" VARCHAR,
  "lat_lon_accuracy" VARCHAR,
  "lat_lon_accuracy_unit" VARCHAR,
  "location_description" VARCHAR,
  "travel_directions" VARCHAR,
  "location_purpose" VARCHAR,
  "establishment_date" VARCHAR,
  "huc8_code" BIGINT,
  "huc12_code" VARCHAR,
  "alternate_location_id" VARCHAR,
  "alternate_location_id_context" VARCHAR,
  "elevation" VARCHAR,
  "elevation_unit" VARCHAR,
  "elevation_method" VARCHAR,
  "elevation_datum" VARCHAR,
  "elevation_accuracy" VARCHAR,
  "elevation_accuracy_unit" VARCHAR,
  "country_code" VARCHAR,
  "state_code" VARCHAR,
  "county_code" VARCHAR,
  "drainage_area" VARCHAR,
  "drainage_area_unit" VARCHAR,
  "contributing_area" VARCHAR,
  "contributing_area_unit" VARCHAR,
  "well_id" VARCHAR,
  "well_type" VARCHAR,
  "aquifer_name" VARCHAR,
  "formation_type" VARCHAR,
  "well_hole_depth" VARCHAR,
  "well_hole_depth_unit" VARCHAR,
  "well_status" VARCHAR
);

Projects

@usgov.doi_gov_cumberland_piedmont_network_2002_2023_water_qu_9306b074.projects

85.46 KB
14 rows
14 columns


CREATE TABLE projects (
  "org_code" VARCHAR,
  "project_id" VARCHAR,
  "project_name" VARCHAR,
  "project_description" VARCHAR,
  "project_start_date" TIMESTAMP,
  "project_duration" VARCHAR,
  "project_type" VARCHAR,
  "qapp_summary" VARCHAR,
  "qapp_approved_indicator" VARCHAR,
  "qapp_approval_agency_name" VARCHAR,
  "study_area_description" VARCHAR,
  "design_sampling_summary" VARCHAR,
  "measurement_quality_objectives" VARCHAR,
  "contact" VARCHAR
);