About this Dataset

Pacific Island Network Benthic Marine And Marine Fish Monitoring Dataset 2006 - 2022

The Benthic Marine Communities Protocol is implemented in four parks in the Pacific and addresses two monitoring questions: 1) what are the changes over time in the composition (e.g., species or assemblage) and physical structure (rugosity) of the coral reef benthos? And 2) what are the changes over time in settlement, growth, survival, and health of targe coral assemblages, species, or individuals? The Marine Fish Monitoring Protocol is conducted in the same parks and sampling location sites, and addresses one monitoring question: What are the long-term trends in the numerical density, biomass, and size of reef fishes? Sampling location sites were randomly selected on hard substrata in an isobath between the 10- and 20-meter depths. This data package contains data collected for these two protocols.
Organization: Department of the Interior
Last updated: 2023-09-11T17:23:07.441768
Tags: algae, american-samoa, benthic, biology, biota, corals, data-package-type-tabular, ecological-framework-biological-integrity-focal-species-or-communities-fishes, ecological-framework-biological-integrity-focal-species-or-communities-marine-communities, fishes, guam, hardbottom, hawaii, invertebrates, kaho, kala, kalaupapa-national-historical-park, kaloko-honokohau-national-historical-park, molokai, monitoring, national-park-of-american-samoa-national-park, npsa, oceans, ofu, substrate, tutuila, wapa, war-in-the-pacific-national-historical-park

Tables

Tbl Benthic Cover

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_benthic_cover

638.34 kB
39,840 rows
11 columns

CREATE TABLE tbl_benthic_cover (
  "benthic_id" VARCHAR,
  "event_id" VARCHAR,
  "frame" BIGINT,
  "analy_date" TIMESTAMP,
  "framdider" VARCHAR,
  "totalpoint" BIGINT,
  "disease_bleaching" VARCHAR,
  "severity" VARCHAR,
  "benthic_certified" BIGINT,
  "benthic_certified_by" VARCHAR,
  "benthic_certified_date" TIMESTAMP
);

Tbl Events

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_events

79 kB
1,992 rows
13 columns

CREATE TABLE tbl_events (
  "event_id" VARCHAR,
  "location_id" VARCHAR,
  "protocol_name" VARCHAR,
  "start_date" TIMESTAMP,
  "notes" VARCHAR,
  "rugosity" BIGINT,
  "entered_by" VARCHAR,
  "entered_date" TIMESTAMP,
  "updated_date" TIMESTAMP,
  "fish_certified" BIGINT,
  "fish_certified_by" VARCHAR,
  "fish_certified_date" TIMESTAMP,
  "qa_notes" VARCHAR
);

Tbl Fish

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_fish

1.39 MB
59,814 rows
9 columns

CREATE TABLE tbl_fish (
  "fish_id" VARCHAR,
  "event_id" VARCHAR,
  "taxon_id" VARCHAR,
  "number" BIGINT,
  "min" BIGINT,
  "max" BIGINT,
  "avglgth" BIGINT,
  "area" BIGINT,
  "comments" VARCHAR
);

Tbl Juvenile Colony

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_juvenile_colony

133.97 kB
3,267 rows
7 columns

CREATE TABLE tbl_juvenile_colony (
  "juv_colony_id" VARCHAR,
  "surface_id" VARCHAR,
  "taxon_id" VARCHAR,
  "genus_code" VARCHAR,
  "ind_count" DOUBLE,
  "length_mm" DOUBLE,
  "width_mm" DOUBLE
);

Tbl Locations

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_locations

53.76 kB
858 rows
23 columns

CREATE TABLE tbl_locations (
  "location_id" VARCHAR,
  "site_id" VARCHAR,
  "island" VARCHAR,
  "subunit" VARCHAR,
  "loc_name" VARCHAR,
  "loc_type" VARCHAR,
  "latitude" DOUBLE,
  "latitude_dir" VARCHAR,
  "longitude" DOUBLE,
  "longitude_dir" VARCHAR,
  "gcs" VARCHAR,
  "management" VARCHAR,
  "habitat" VARCHAR,
  "compass_bearing" DOUBLE,
  "depth" DOUBLE,
  "cut_distance" DOUBLE,
  "harbor_distance" DOUBLE,
  "loc_notes" VARCHAR,
  "loc_status" VARCHAR,
  "loc_year_established" BIGINT,
  "loc_created_date" TIMESTAMP,
  "loc_updated_date" TIMESTAMP,
  "loc_updated_by" VARCHAR
);

Tbl Points

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_points

3.61 MB
1,992,000 rows
7 columns

CREATE TABLE tbl_points (
  "benthic_id" VARCHAR,
  "taxon_id" VARCHAR,
  "point" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE,
  "bleaching" VARCHAR,
  "bleaching_cat" VARCHAR
);

Tbl Proof

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_proof

21.96 kB
198 rows
14 columns

CREATE TABLE tbl_proof (
  "start_date" TIMESTAMP,
  "event_id" VARCHAR,
  "unit_code" VARCHAR,
  "data_type" VARCHAR,
  "location_id" VARCHAR,
  "loc_name" VARCHAR,
  "loc_type" VARCHAR,
  "proof_count" BIGINT,
  "proofed" BIGINT,
  "corrected" BIGINT,
  "certified" BIGINT,
  "proof_date" TIMESTAMP,
  "proof_reader" VARCHAR,
  "comments" VARCHAR
);

Tbl Proof Tracking

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_proof_tracking

16.62 kB
198 rows
7 columns

CREATE TABLE tbl_proof_tracking (
  "event_id" VARCHAR,
  "location_id" VARCHAR,
  "points_reviewed" BIGINT,
  "points_corrected" BIGINT,
  "percent_error" DOUBLE,
  "proof_date" TIMESTAMP,
  "proof_reader" VARCHAR
);

Tbl Revision Log

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_revision_log

21.21 kB
106 rows
6 columns

CREATE TABLE tbl_revision_log (
  "revision_id" VARCHAR,
  "revision_date" TIMESTAMP,
  "revision_description" VARCHAR,
  "revision_comments" VARCHAR,
  "revision_by" VARCHAR,
  "ceritified_data_update" BIGINT
);

Tbl Rugosity

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_rugosity

27.74 kB
1,123 rows
3 columns

CREATE TABLE tbl_rugosity (
  "event_id" VARCHAR,
  "chain_length" DOUBLE,
  "tape_length" BIGINT
);

Tbl Settlement

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_settlement

27.83 kB
585 rows
9 columns

CREATE TABLE tbl_settlement (
  "settlement_id" VARCHAR,
  "event_id" VARCHAR,
  "cra" BIGINT,
  "plate_number" BIGINT,
  "retrieved_plate_pair" TIMESTAMP,
  "duration" BIGINT,
  "sett_certified" BIGINT,
  "sett_certified_by" VARCHAR,
  "sett_certified_date" TIMESTAMP
);

Tbl Sites

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_sites

4.11 kB
4 rows
4 columns

CREATE TABLE tbl_sites (
  "site_id" VARCHAR,
  "unit_code" VARCHAR,
  "site_name" VARCHAR,
  "site_area" VARCHAR
);

Tbl Surfaces

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tbl_surfaces

78.72 kB
2,925 rows
4 columns

CREATE TABLE tbl_surfaces (
  "surface_id" VARCHAR,
  "settlement_id" VARCHAR,
  "surface" VARCHAR,
  "orientation" VARCHAR
);

Tlu Contacts

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tlu_contacts

15.2 kB
29 rows
19 columns

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

Tlu Taxon

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.tlu_taxon

136.85 kB
1,200 rows
34 columns

CREATE TABLE tlu_taxon (
  "taxon_id" VARCHAR,
  "aphiaid" DOUBLE,
  "status" VARCHAR,
  "type" VARCHAR,
  "settlement" BIGINT,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "taxon_name" VARCHAR,
  "synonym" VARCHAR,
  "species_code" VARCHAR,
  "authority" VARCHAR,
  "reference" VARCHAR,
  "target_species" VARCHAR,
  "hawaiian_name" VARCHAR,
  "common_name" VARCHAR,
  "trophic" VARCHAR,
  "consumer" VARCHAR,
  "endemic" VARCHAR,
  "mobility" VARCHAR,
  "a_variable" DOUBLE,
  "b_variable" DOUBLE,
  "reference_ab_variable" VARCHAR,
  "congener" VARCHAR,
  "tl_to_sl_fl" DOUBLE,
  "reference_tl_to_sl_fl" VARCHAR,
  "esa_status" VARCHAR,
  "comments" VARCHAR,
  "update_date" TIMESTAMP,
  "update_by" VARCHAR
);

Xref Event Contacts

@usgov.doi_gov_pacific_island_network_benthic_marine_and_mari_45bd034f.xref_event_contacts

33.45 kB
2,609 rows
3 columns

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