About this Dataset

Pacific Island Network Streams Monitoring Dataset 2009-2022

Throughout the world, freshwater ecosystems are considered to be among the most vulnerable systems. In the isolated Pacific islands there are a relatively small number of native freshwater species, which are mainly endemic to these locations. Throughout the region, native flora and fauna face significant threats from species introductions and habitat destruction. The National Parks in the Pacific Island Network (PACN) protect some of the last relatively pristine stream systems. The Pacific Islands Stream Monitoring Protocol monitors long term changes in stream communities for four of the Pacific Island parks. This dataset contains results from 2009 through 2021 stream animal surveys in HALE, KALA, NPSA, and WAPA and will provide park managers with information necessary to understand status and trends in biotic integrity within park stream systems. This project is ongoing and will be updated annually.
Organization: Department of the Interior
Last updated: 2023-08-24T04:52:58.639436
Tags: aquatic-ecosystems, aquatic-invertebrates, biology, ecological-framework-biological-integrity-focal-species-or-communities-freshwater-invertebrates, ecological-framework-biological-integrity-focal-species-or-communities-riparian-communities, freshwater, guam, hale, haleakala-national-park, hydrography, hydrology, inlandwaters, kala, kalaupapa-national-historical-park, maui, molokai, monitoring, national-park-of-american-samoa-national-park, npsa, pacific-islands-network-network, pacn, streams, surface-water, tau, tutuila, wapa, war-in-the-pacific-national-historical-park, water, water-resources

Tables

Tbl Canopy

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_canopy

139.24 KB
5298 rows
4 columns


CREATE TABLE tbl_canopy (
  "canopy_id" VARCHAR,
  "transect_id" VARCHAR,
  "facing" VARCHAR,
  "measurement" BIGINT
);

Tbl Db Revisions

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_db_revisions

8.31 KB
9 rows
5 columns


CREATE TABLE tbl_db_revisions (
  "revision_id" BIGINT,
  "revision_contact_id" VARCHAR,
  "revision_date" TIMESTAMP,
  "revision_reason" VARCHAR,
  "revision_desc" VARCHAR
);

Tbl Events

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_events

76.06 KB
595 rows
17 columns


CREATE TABLE tbl_events (
  "event_id" VARCHAR,
  "site_id" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "entered_by" VARCHAR,
  "entered_date" TIMESTAMP,
  "updated_by" VARCHAR,
  "updated_date" TIMESTAMP,
  "verified" BIGINT,
  "verified_by" VARCHAR,
  "verified_date" TIMESTAMP,
  "certified" BIGINT,
  "certified_by" VARCHAR,
  "certified_date" TIMESTAMP,
  "event_notes" VARCHAR
);

Tbl Fish

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_fish

107.24 KB
5026 rows
4 columns


CREATE TABLE tbl_fish (
  "fish_id" VARCHAR,
  "event_id" VARCHAR,
  "quadrat" BIGINT,
  "flagged" BIGINT
);

Tbl Images

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_images

325.25 KB
6938 rows
9 columns


CREATE TABLE tbl_images (
  "image_id" VARCHAR,
  "transect_id" VARCHAR,
  "image_label" VARCHAR,
  "image_date" TIMESTAMP,
  "image_time" VARCHAR,
  "image_source" VARCHAR,
  "image_project_path" VARCHAR,
  "image_filename" VARCHAR,
  "image_notes" VARCHAR
);

Tbl Odonates

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_odonates

5.89 KB
22 rows
5 columns


CREATE TABLE tbl_odonates (
  "odonate_id" VARCHAR,
  "event_id" VARCHAR,
  "weather" VARCHAR,
  "flagged" BIGINT,
  "odonate_notes" VARCHAR
);

Tbl Parks

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_parks

3.26 KB
4 rows
3 columns


CREATE TABLE tbl_parks (
  "park_id" VARCHAR,
  "park_name" VARCHAR,
  "unit_code" VARCHAR
);

Tbl Points

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_points

333.33 KB
13830 rows
8 columns


CREATE TABLE tbl_points (
  "point_id" VARCHAR,
  "transect_id" VARCHAR,
  "point" VARCHAR,
  "tape_reading" DOUBLE,
  "depth" DOUBLE,
  "velocity" DOUBLE,
  "shallowness" BIGINT,
  "habitat_type" VARCHAR
);

Tbl QA Results

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_qa_results

20.36 KB
216 rows
11 columns


CREATE TABLE tbl_qa_results (
  "query_name" VARCHAR,
  "time_frame" VARCHAR,
  "query_type" BIGINT,
  "query_result" BIGINT,
  "query_run_time" TIMESTAMP,
  "query_description" VARCHAR,
  "query_expression" VARCHAR,
  "remedy_desc" VARCHAR,
  "remedy_date" TIMESTAMP,
  "qa_user" VARCHAR,
  "is_done" BIGINT
);

Tbl Quadrats

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_quadrats

136.58 KB
5847 rows
9 columns


CREATE TABLE tbl_quadrats (
  "quadrat_id" VARCHAR,
  "event_id" VARCHAR,
  "quadrat" DOUBLE,
  "habitat_type" VARCHAR,
  "ft_depth" DOUBLE,
  "estimated_depth" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE,
  "flagged" BIGINT
);

Tbl Shrimp

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_shrimp

125.85 KB
5747 rows
6 columns


CREATE TABLE tbl_shrimp (
  "shrimp_id" VARCHAR,
  "event_id" VARCHAR,
  "quadrat" DOUBLE,
  "section" VARCHAR,
  "collection" VARCHAR,
  "flagged" BIGINT
);

Tbl Site Geo Unit

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_site_geo_unit

19.98 KB
493 rows
3 columns


CREATE TABLE tbl_site_geo_unit (
  "site_geo_unit_id" VARCHAR,
  "site_id" VARCHAR,
  "site_geo_date" TIMESTAMP
);

Tbl Sites

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_sites

50.39 KB
240 rows
26 columns


CREATE TABLE tbl_sites (
  "site_id" VARCHAR,
  "location_id" VARCHAR,
  "site_name" VARCHAR,
  "site_type" VARCHAR,
  "reach" VARCHAR,
  "latitude" DOUBLE,
  "lat_dir" VARCHAR,
  "longitude" DOUBLE,
  "long_dir" VARCHAR,
  "gcs" VARCHAR,
  "site_error" DOUBLE,
  "site_desc" VARCHAR,
  "long_river_mouth" DOUBLE,
  "lat_river_mouth" DOUBLE,
  "river_mouth" BIGINT,
  "upstream" DOUBLE,
  "downstream" DOUBLE,
  "elevation" BIGINT,
  "marker_upstream" VARCHAR,
  "marker_downstream" VARCHAR,
  "site_discontinuned" VARCHAR,
  "site_notes" VARCHAR,
  "site_entered_date" TIMESTAMP,
  "site_entered_by" VARCHAR,
  "site_updated_date" TIMESTAMP,
  "site_updated_by" VARCHAR
);

Tbl Snails

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_snails

122.41 KB
5348 rows
7 columns


CREATE TABLE tbl_snails (
  "snail_id" VARCHAR,
  "event_id" VARCHAR,
  "quadrat" DOUBLE,
  "section" VARCHAR,
  "spat" DOUBLE,
  "eggs" DOUBLE,
  "flagged" BIGINT
);

Tbl Transects

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tbl_transects

122.18 KB
2388 rows
10 columns


CREATE TABLE tbl_transects (
  "transect_id" VARCHAR,
  "event_id" VARCHAR,
  "transect_number" VARCHAR,
  "transect_loc" DOUBLE,
  "channel_width" DOUBLE,
  "total_discharge" DOUBLE,
  "percent_error" DOUBLE,
  "flagged" BIGINT,
  "pdf_path" VARCHAR,
  "transect_notes" VARCHAR
);

Tlu Contacts

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tlu_contacts

20.05 KB
101 rows
18 columns


CREATE TABLE tlu_contacts (
  "contact_id" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_init" VARCHAR,
  "organization" VARCHAR,
  "position_title" VARCHAR,
  "address_type" VARCHAR,
  "address" VARCHAR,
  "address2" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "zip_code" DOUBLE,
  "country" VARCHAR,
  "email_address" VARCHAR,
  "work_phone" VARCHAR,
  "work_extension" DOUBLE,
  "contact_notes" VARCHAR,
  "active" BIGINT
);

Tlu Enumerations

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tlu_enumerations

5.58 KB
95 rows
4 columns


CREATE TABLE tlu_enumerations (
  "enum_code" VARCHAR,
  "enum_description" VARCHAR,
  "enum_group" VARCHAR,
  "sort_order" BIGINT
);

Tlu Taxa

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.tlu_taxa

22.46 KB
90 rows
20 columns


CREATE TABLE tlu_taxa (
  "taxa_id" VARCHAR,
  "aphiaid" DOUBLE,
  "category" VARCHAR,
  "range" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "nativity" VARCHAR,
  "scientific_name" VARCHAR,
  "authority" VARCHAR,
  "synonym" VARCHAR,
  "local_name" VARCHAR,
  "common_name" VARCHAR,
  "taxa_updated_date" TIMESTAMP,
  "updated_by" VARCHAR,
  "updated_notes" VARCHAR
);

Xref Event Contacts

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.xref_event_contacts

25.72 KB
3068 rows
3 columns


CREATE TABLE xref_event_contacts (
  "event_id" VARCHAR,
  "contact_id" VARCHAR,
  "contact_role" VARCHAR
);

Xref Fish Taxa

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.xref_fish_taxa

101.41 KB
15041 rows
4 columns


CREATE TABLE xref_fish_taxa (
  "fish_id" VARCHAR,
  "taxa_id" VARCHAR,
  "size" VARCHAR,
  "count" BIGINT
);

Xref Odonates Taxa

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.xref_odonates_taxa

4.34 KB
44 rows
4 columns


CREATE TABLE xref_odonates_taxa (
  "odonate_id" VARCHAR,
  "taxa_id" VARCHAR,
  "sex" VARCHAR,
  "count" BIGINT
);

Xref Point Structures

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.xref_point_structures

232.52 KB
13745 rows
2 columns


CREATE TABLE xref_point_structures (
  "point_id" VARCHAR,
  "structures" VARCHAR
);

Xref Quadrat Structures

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.xref_quadrat_structures

86.7 KB
7747 rows
2 columns


CREATE TABLE xref_quadrat_structures (
  "quadrat_id" VARCHAR,
  "structures" VARCHAR
);

Xref Shrimp Taxa

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.xref_shrimp_taxa

111.01 KB
19029 rows
6 columns


CREATE TABLE xref_shrimp_taxa (
  "shrimp_id" VARCHAR,
  "taxa_id" VARCHAR,
  "length" DOUBLE,
  "gravid" VARCHAR,
  "count" BIGINT,
  "estimated" BIGINT
);

Xref Site Cover

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2022.xref_site_cover

15.87 KB
485 rows
4 columns


CREATE TABLE xref_site_cover (
  "site_id" VARCHAR,
  "cover" VARCHAR,
  "disturbed_cover" VARCHAR,
  "site_cover_date" TIMESTAMP
);