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

142.58 kB
5,298 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.51 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

77.89 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

109.81 kB
5,026 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

333.05 kB
6,938 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

6.03 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.34 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

341.33 kB
13,830 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.85 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

139.86 kB
5,847 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

128.87 kB
5,747 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

20.46 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

51.6 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

125.35 kB
5,348 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

125.11 kB
2,388 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.53 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.71 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

23 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

26.34 kB
3,068 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

103.85 kB
15,041 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.45 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

238.1 kB
13,745 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

88.78 kB
7,747 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

113.68 kB
19,029 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

16.25 kB
485 rows
4 columns

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