Jean Lafitte National Historical Park And Preserve Barataria Preserve Water Quality Data From JELA BARA WQ Project As Of 2024-06-26 by US Government | Environmental and Climate Sciences

About this Dataset

Jean Lafitte National Historical Park And Preserve Barataria Preserve Water Quality Data From JELA BARA WQ Project As Of 2024-06-26

This data package was created 2024-10-22 05:14:06 by NPSTORET and includes selected project, location, and result data.

Data contained in the Jean Lafitte National Historical Park and Preserve NPSTORET back-end file (JELA_NPSTORET_BE_20240717.accdb) were filtered to include:
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 five 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
HUC.csv - enumerates the domain of allowed values for 8-digit and 12-digit hydrologic unit codes utilized by the Locations datatable
Characteristics.csv - enumerates the domain of characteristics available in NPSTORET to identify what was sampled, measured or observed in Results

Period of record for filtered data is 2013-09-11 to 2024-06-26. This data package is a snapshot in time of one National Park Service project. The most current data for this project, which may be more or less extensive than that in this data package, can be found on the Water Quality Portal at:
https://www.waterqualitydata.us/data/Result/search?project=JELA_BARA_WQ
Organization: Department of the Interior
Last updated: 2024-11-02T08:47:24.464086
Tags: dissolved-oxygen, npstoret, ph, salinity, specific-conductivity, water-quality, water-temperature

Tables

Results

@usgov.doi_gov_jean_lafitte_national_historical_park_and_pres_d227f1df.results

196.97 KB
10566 rows
89 columns


CREATE TABLE results (
  "org_code" VARCHAR,
  "project_id" VARCHAR,
  "location_id" VARCHAR,
  "activity_id" VARCHAR,
  "activity_type" VARCHAR,
  "medium" VARCHAR,
  "medium_subdivision" VARCHAR,
  "assemblage_sampled_name" VARCHAR,
  "activity_start_date" TIMESTAMP,
  "activity_start_time" VARCHAR,
  "activity_start_time_zone" VARCHAR,
  "activity_end_date" VARCHAR,
  "activity_end_time" VARCHAR,
  "activity_end_time_zone" VARCHAR,
  "activity_relative_depth" VARCHAR,
  "activity_depth" VARCHAR,
  "activity_depth_unit" VARCHAR,
  "activity_upper_depth" VARCHAR,
  "activity_lower_depth" VARCHAR,
  "activity_sampler" VARCHAR,
  "custody_id" VARCHAR,
  "station_visit_comment" VARCHAR,
  "activity_comment" VARCHAR,
  "collection_method_id" VARCHAR,
  "collection_equipment_name" VARCHAR,
  "collection_equipment_description" VARCHAR,
  "container_type" VARCHAR,
  "container_color" VARCHAR,
  "container_size" VARCHAR,
  "container_size_unit" VARCHAR,
  "preparation_method_id" VARCHAR,
  "chemical_preservative" VARCHAR,
  "thermal_preservative" VARCHAR,
  "transport_storage_description" VARCHAR,
  "activity_group_id" VARCHAR,
  "activity_group_name" VARCHAR,
  "activity_group_type" VARCHAR,
  "sampling_component_name" VARCHAR,
  "sampling_component_place_in_series" VARCHAR,
  "characteristic_name" VARCHAR,
  "method_speciation" VARCHAR,
  "filtered_fraction" VARCHAR,
  "result_detection_condition" VARCHAR,
  "result_text" VARCHAR,
  "result_unit" VARCHAR,
  "result_qualifier" VARCHAR,
  "result_status" VARCHAR,
  "result_type" VARCHAR,
  "result_comment" VARCHAR,
  "method_detection_limit" VARCHAR,
  "lower_quantification_limit" VARCHAR,
  "upper_quantification_limit" VARCHAR,
  "limit_comment" VARCHAR,
  "temperature_basis" VARCHAR,
  "statistical_basis" VARCHAR,
  "time_basis" VARCHAR,
  "weight_basis" VARCHAR,
  "particle_size_basis" VARCHAR,
  "precision" VARCHAR,
  "bias" VARCHAR,
  "confidence_interval" VARCHAR,
  "upper_confidence_limit" VARCHAR,
  "lower_confidence_limit" VARCHAR,
  "result_depth_height_measure" VARCHAR,
  "result_depth_height_measure_unit" VARCHAR,
  "analytical_method_id" VARCHAR,
  "analytical_method_id_context" VARCHAR,
  "lab_id" VARCHAR,
  "lab_remark_code" VARCHAR,
  "analysis_start_date" TIMESTAMP,
  "analysis_start_time" VARCHAR,
  "analysis_start_time_zone" VARCHAR,
  "lab_accreditation_indicator" VARCHAR,
  "lab_sample_preparation_id" VARCHAR,
  "dilution_factor" VARCHAR,
  "num_of_replicates" VARCHAR,
  "data_logger_line_name" VARCHAR,
  "biological_intent" VARCHAR,
  "biological_individual_id" VARCHAR,
  "subject_taxon" VARCHAR,
  "unidentified_species_id" VARCHAR,
  "tissue_anatomy" VARCHAR,
  "group_summary_count_or_weight" VARCHAR,
  "group_summary_count_or_weight_unit" VARCHAR,
  "frequency_class_descriptor" VARCHAR,
  "frequency_class_bounds_unit" VARCHAR,
  "frequency_class_lower_bound" VARCHAR,
  "frequency_class_upper_bound" VARCHAR,
  "lab_reported_result" VARCHAR
);

Projects

@usgov.doi_gov_jean_lafitte_national_historical_park_and_pres_d227f1df.projects

20.82 KB
1 row
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
);

Characteristics

@usgov.doi_gov_jean_lafitte_national_historical_park_and_pres_d227f1df.characteristics

334.89 KB
8210 rows
4 columns


CREATE TABLE characteristics (
  "equis_display_name" VARCHAR,
  "wqx_display_name" VARCHAR,
  "cas_num" VARCHAR,
  "srsidentifier" VARCHAR
);

Locations

@usgov.doi_gov_jean_lafitte_national_historical_park_and_pres_d227f1df.locations

32.99 KB
27 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" TIMESTAMP,
  "huc8_code" VARCHAR,
  "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
);