About this Dataset

NCCN Water Quality Monitoring Data Package, 2011-2021

This data package contains North Coast and Cascades Network (NCCN) Inventory and Monitoring Program discrete water quality monitoring tabular data collected during 2011-2021 at Ebey's Landing National Historic Reserve (EBLA), Lewis and Clark National Historical Park (LEWI), Mount Rainier National Park (MORA), North Cascades National Park (NOCA), and Olympic National Park (OLYM).

The protocol, publications, and all other associated links can be found in the project reference at: https://irma.nps.gov/DataStore/Reference/Profile/2195538.

The abundance of rivers and streams is a key characteristic of the NCCN. Ninety-four percent of NCCN is federally-designated wilderness and contains some of the most pristine aquatic habitats in the Pacific Northwest. The prevalence of these resources makes water quality a high ecological and management priority.

Rivers and streams integrate the physical, chemical, and biological characteristics of the watersheds they drain. This puts them at increased risk to a variety of environmental stressors including atmospheric pollution, flow regime changes, and localized disturbances related to land management activities and recreational use. To address risks from a variety of stressors to these systems, the NCCN developed a Water Quality Monitoring Program and protocol that is focused on monitoring the wadable streams that are the most at risk for water quality impairment.

Data within this package include sampling locations and event conditions, physical habitat and channel characteristics, human influence descriptors, invasive species observations, and water chemistry parameters. The associated continuous temperature data can be found in the NPS-hosted Aquarius database https://irma.nps.gov/aqwebportal.
Organization: Department of the Interior
Last updated: 2025-05-11T04:51:30.295000
Tags: aquatic-ecosystems, benthic-macroinvertebrates, bioassessment, biology, channel-morphology, chemistry, clean-water-act, condition, dataloggers, dissolved-oxygen, disturbance, ebeys-landing-national-historical-reserve, ebla, ecological-framework-biological-integrity-at-risk-biota-te-species-and-communities, ecological-framework-biological-integrity-focal-species-or-communities-freshwater-communities, ecological-framework-biological-integrity-focal-species-or-communities-freshwater-invertebrates, ecology, freshwater, habitats, human-disturbance, human-influence, hydrology, impaired, invasive-species, land-management, lewi, lewis-and-clark-national-historical-park, monitoring, mora, mount-rainier-national-park, nccn, noca, north-cascades-national-park, north-coast-and-cascades-network, olym, olympic-national-park, ph, resource-management, riparian, rivers, species, specific-conductance, stream-ecology, streams, temperature, threatened-waters, turbidity, water, water-chemistry, water-quality, watersheds

Tables

NCCN WaterQuality ChannelConstraints

@usgov.doi_gov_nccn_water_quality_monitoring_data_package_2010_2021.nccn_waterquality_channelconstraints

12.04 KB
256 rows
10 columns


CREATE TABLE nccn_waterquality_channelconstraints (
  "parkcode" VARCHAR,
  "locationcode" VARCHAR,
  "locationname" VARCHAR,
  "eventdate" TIMESTAMP,
  "starttime" VARCHAR,
  "channelpattern" VARCHAR,
  "channelconstraint" VARCHAR,
  "percentconstrained" BIGINT,
  "valleywidth_m" BIGINT,
  "edgenotvisible" VARCHAR
);

NCCN WaterQuality ConstrainingFeatures

@usgov.doi_gov_nccn_water_quality_monitoring_data_package_2010_2021.nccn_waterquality_constrainingfeatures

10.35 KB
318 rows
7 columns


CREATE TABLE nccn_waterquality_constrainingfeatures (
  "parkcode" VARCHAR,
  "locationcode" VARCHAR,
  "locationname" VARCHAR,
  "eventdate" TIMESTAMP,
  "starttime" VARCHAR,
  "constrainingfeature" VARCHAR,
  "constrainingfeaturedesc" VARCHAR
);

NCCN WaterQuality HabitatAssessment

@usgov.doi_gov_nccn_water_quality_monitoring_data_package_2010_2021.nccn_waterquality_habitatassessment

13.52 KB
3224 rows
9 columns


CREATE TABLE nccn_waterquality_habitatassessment (
  "parkcode" VARCHAR,
  "locationcode" VARCHAR,
  "locationname" VARCHAR,
  "eventdate" TIMESTAMP,
  "starttime" VARCHAR,
  "habitattype" VARCHAR,
  "habitatparameter" VARCHAR,
  "scope" VARCHAR,
  "rating" BIGINT
);

NCCN WaterQuality HumanInfluences

@usgov.doi_gov_nccn_water_quality_monitoring_data_package_2010_2021.nccn_waterquality_humaninfluences

11.36 KB
4864 rows
7 columns


CREATE TABLE nccn_waterquality_humaninfluences (
  "parkcode" VARCHAR,
  "locationcode" VARCHAR,
  "locationname" VARCHAR,
  "eventdate" TIMESTAMP,
  "starttime" VARCHAR,
  "influencetype" VARCHAR,
  "rating" VARCHAR
);

NCCN WaterQuality InvasiveObs

@usgov.doi_gov_nccn_water_quality_monitoring_data_package_2010_2021.nccn_waterquality_invasiveobs

15.3 KB
373 rows
14 columns


CREATE TABLE nccn_waterquality_invasiveobs (
  "parkcode" VARCHAR,
  "locationcode" VARCHAR,
  "locationname" VARCHAR,
  "eventdate" TIMESTAMP,
  "starttime" VARCHAR,
  "scientificname" VARCHAR,
  "estnum" DOUBLE,
  "estarea_m2" DOUBLE,
  "distribution_iso" VARCHAR,
  "distribution_spor" VARCHAR,
  "distribution_perv" VARCHAR,
  "newtosite" VARCHAR,
  "newtopark" VARCHAR,
  "notes" VARCHAR
);

NCCN WaterQuality Locations

@usgov.doi_gov_nccn_water_quality_monitoring_data_package_2010_2021.nccn_waterquality_locations

13.34 KB
26 rows
16 columns


CREATE TABLE nccn_waterquality_locations (
  "parkcode" VARCHAR,
  "parkname" VARCHAR,
  "locationcode" VARCHAR,
  "locationtype" VARCHAR,
  "locationstatus" VARCHAR,
  "locationname" VARCHAR,
  "reachlength_m" BIGINT,
  "utm_east" BIGINT,
  "utm_north" BIGINT,
  "utmzone" VARCHAR,
  "utmdatum" VARCHAR,
  "decimallongitude" DOUBLE,
  "decimallatitude" DOUBLE,
  "decimaldegreesdatum" VARCHAR,
  "establisheddate" TIMESTAMP,
  "discontinueddate" TIMESTAMP
);

NCCN WaterQuality SamplingEventsAndConditions

@usgov.doi_gov_nccn_water_quality_monitoring_data_package_2010_2021.nccn_waterquality_samplingeventsandconditions

15.49 KB
512 rows
14 columns


CREATE TABLE nccn_waterquality_samplingeventsandconditions (
  "parkcode" VARCHAR,
  "locationcode" VARCHAR,
  "locationname" VARCHAR,
  "eventdate" TIMESTAMP,
  "starttime" VARCHAR,
  "timeframe" VARCHAR,
  "cloudcover" VARCHAR,
  "precipitation" VARCHAR,
  "flow" VARCHAR,
  "airtemp_c" DOUBLE,
  "waterclarity" VARCHAR,
  "waterodor" VARCHAR,
  "sedimentodor" VARCHAR,
  "surfacefilm" VARCHAR
);

NCCN WaterQuality TorrentEvidence

@usgov.doi_gov_nccn_water_quality_monitoring_data_package_2010_2021.nccn_waterquality_torrentevidence

10.48 KB
644 rows
6 columns


CREATE TABLE nccn_waterquality_torrentevidence (
  "parkcode" VARCHAR,
  "locationcode" VARCHAR,
  "locationname" VARCHAR,
  "eventdate" TIMESTAMP,
  "starttime" VARCHAR,
  "torrentevidence" VARCHAR
);

NCCN WaterQuality WaterChemistryData

@usgov.doi_gov_nccn_water_quality_monitoring_data_package_2010_2021.nccn_waterquality_waterchemistrydata

34.86 KB
1762 rows
15 columns


CREATE TABLE nccn_waterquality_waterchemistrydata (
  "parkcode" VARCHAR,
  "locationcode" VARCHAR,
  "locationname" VARCHAR,
  "eventdate" TIMESTAMP,
  "starttime" VARCHAR,
  "endtime" VARCHAR,
  "repnum" BIGINT,
  "do" DOUBLE,
  "ph" DOUBLE,
  "spcond" DOUBLE,
  "temp" DOUBLE,
  "turbidity" DOUBLE,
  "passcalibration" BOOLEAN,
  "passfieldchecks" BOOLEAN,
  "processingflag" VARCHAR
);

NCCN WaterQuality WidthDepth

@usgov.doi_gov_nccn_water_quality_monitoring_data_package_2010_2021.nccn_waterquality_widthdepth

22.2 KB
5621 rows
8 columns


CREATE TABLE nccn_waterquality_widthdepth (
  "parkcode" VARCHAR,
  "locationcode" VARCHAR,
  "locationname" VARCHAR,
  "eventdate" TIMESTAMP,
  "starttime" VARCHAR,
  "meastype" VARCHAR,
  "recnum" BIGINT,
  "value_m" DOUBLE
);