Baselight
Sign In

Pacific Island Network Streams Monitoring Dataset 2009 - 2023

Department of the Interior

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023

Loading...
Loading...

About this Dataset

Pacific Island Network Streams Monitoring Dataset 2009 - 2023

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 2023 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: 2025-05-11T04:49:36.422391
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, haleakal-national-park, hydrography, hydrology, inland-waters, kala, kalaupapa-national-historical-park, long-term-monitoring, maui, molokai, monitoring, national-park-of-american-samoa-national-park, nps-gov-subject-site-rivers, npsa, pacific-islands-network-network, pacn, streams, surface-water, tau, tutuila, wapa, war-in-the-pacific-national-historical-park, water, water-resources

Tables

PACN Streams Contacts Lookup

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023.pacn_streams_contacts_lookup
  • 5.1 KB
  • 107 rows
  • 3 columns
Loading... 

CREATE TABLE pacn_streams_contacts_lookup (
  "recordedby" VARCHAR,
  "custom_organization" VARCHAR,
  "dynamicproperties" VARCHAR
);

PACN Streams Fish

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023.pacn_streams_fish
  • 145.52 KB
  • 17518 rows
  • 32 columns
Loading... 

CREATE TABLE pacn_streams_fish (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "island" VARCHAR,
  "waterbody" VARCHAR,
  "custom_sitename" VARCHAR,
  "custom_sitetype" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "geodeticdatum" VARCHAR,
  "coordinateuncertaintyinmeters" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "eventremarks" VARCHAR,
  "basisofrecord" VARCHAR,
  "recordedby" VARCHAR,
  "custom_quadrat" BIGINT,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "vernacularname" VARCHAR,
  "individualcount" VARCHAR,
  "measurementvalue" VARCHAR,
  "measurementunit" VARCHAR,
  "occurrencestatus" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN Streams Images

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023.pacn_streams_images
  • 188.51 KB
  • 52624 rows
  • 26 columns
Loading... 

CREATE TABLE pacn_streams_images (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "island" VARCHAR,
  "waterbody" VARCHAR,
  "custom_sitename" VARCHAR,
  "custom_sitetype" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "geodeticdatum" VARCHAR,
  "coordinateuncertaintyinmeters" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "eventremarks" VARCHAR,
  "basisofrecord" VARCHAR,
  "recordedby" VARCHAR,
  "custom_imagedate" TIMESTAMP,
  "custom_imagetime" VARCHAR,
  "custom_imagesource" VARCHAR,
  "associatedmedia" VARCHAR,
  "custom_imagelabel" VARCHAR,
  "custom_associatedmediaremarks" VARCHAR,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN Streams Odonates

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023.pacn_streams_odonates
  • 31.32 KB
  • 70 rows
  • 33 columns
Loading... 

CREATE TABLE pacn_streams_odonates (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "island" VARCHAR,
  "waterbody" VARCHAR,
  "custom_sitename" VARCHAR,
  "custom_sitetype" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "geodeticdatum" VARCHAR,
  "coordinateuncertaintyinmeters" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "eventremarks" VARCHAR,
  "basisofrecord" VARCHAR,
  "recordedby" VARCHAR,
  "custom_odonatesurveystarttime" VARCHAR,
  "custom_odonatesurveyendtime" VARCHAR,
  "custom_weather" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "vernacularname" VARCHAR,
  "individualcount" VARCHAR,
  "sex" VARCHAR,
  "occurrencestatus" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN Streams Quadrats

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023.pacn_streams_quadrats
  • 142.67 KB
  • 10210 rows
  • 31 columns
Loading... 

CREATE TABLE pacn_streams_quadrats (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "island" VARCHAR,
  "waterbody" VARCHAR,
  "custom_sitename" VARCHAR,
  "custom_sitetype" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "geodeticdatum" VARCHAR,
  "coordinateuncertaintyinmeters" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "eventremarks" VARCHAR,
  "basisofrecord" VARCHAR,
  "recordedby" VARCHAR,
  "custom_quadrat" VARCHAR,
  "habitat" VARCHAR,
  "minimumdepthinmeters" VARCHAR,
  "maximumdepthinmeters" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_quadratremarks" VARCHAR,
  "custom_structure" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN Streams Shrimp

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023.pacn_streams_shrimp
  • 173.61 KB
  • 24067 rows
  • 36 columns
Loading... 

CREATE TABLE pacn_streams_shrimp (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "island" VARCHAR,
  "waterbody" VARCHAR,
  "custom_sitename" VARCHAR,
  "custom_sitetype" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "geodeticdatum" VARCHAR,
  "coordinateuncertaintyinmeters" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "eventremarks" VARCHAR,
  "basisofrecord" VARCHAR,
  "recordedby" VARCHAR,
  "custom_quadrat" VARCHAR,
  "custom_section" VARCHAR,
  "custom_collection" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "vernacularname" VARCHAR,
  "individualcount" VARCHAR,
  "measurementvalue" VARCHAR,
  "measurementunit" VARCHAR,
  "reproductivecondition" VARCHAR,
  "dynamicproperties" VARCHAR,
  "occurrencestatus" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN Streams Sites

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023.pacn_streams_sites
  • 45.48 KB
  • 257 rows
  • 18 columns
Loading... 

CREATE TABLE pacn_streams_sites (
  "samplingprotocol" VARCHAR,
  "custom_unitcode" VARCHAR,
  "island" VARCHAR,
  "waterbody" VARCHAR,
  "custom_sitename" VARCHAR,
  "custom_sitetype" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "geodeticdatum" VARCHAR,
  "coordinateuncertaintyinmeters" VARCHAR,
  "custom_decimallatituderivermouth" DOUBLE,
  "custom_decimallongituderivermouth" DOUBLE,
  "custom_distancerivermouth" BIGINT,
  "minimumelevationinmeters" VARCHAR,
  "maximumelevationinmeters" VARCHAR,
  "verbatimlocality" VARCHAR,
  "locationremarks" VARCHAR,
  "locationid" VARCHAR
);

PACN Streams Sites Cover

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023.pacn_streams_sites_cover
  • 30.97 KB
  • 537 rows
  • 15 columns
Loading... 

CREATE TABLE pacn_streams_sites_cover (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "island" VARCHAR,
  "waterbody" VARCHAR,
  "custom_sitename" VARCHAR,
  "custom_sitetype" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "geodeticdatum" VARCHAR,
  "coordinateuncertaintyinmeters" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_cover" VARCHAR,
  "custom_disturbedcover" VARCHAR,
  "locationid" VARCHAR
);

PACN Streams Sites GCU

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023.pacn_streams_sites_gcu
  • 36.91 KB
  • 16313 rows
  • 18 columns
Loading... 

CREATE TABLE pacn_streams_sites_gcu (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "island" VARCHAR,
  "waterbody" VARCHAR,
  "custom_sitename" VARCHAR,
  "custom_sitetype" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "geodeticdatum" VARCHAR,
  "coordinateuncertaintyinmeters" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_meterstart" VARCHAR,
  "custom_geomorphiccode" VARCHAR,
  "measurementvalue" BIGINT,
  "measurementunit" VARCHAR,
  "custom_distancerivermouth" BIGINT,
  "locationid" VARCHAR
);

PACN Streams Snails

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023.pacn_streams_snails
  • 179.43 KB
  • 23277 rows
  • 35 columns
Loading... 

CREATE TABLE pacn_streams_snails (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "island" VARCHAR,
  "waterbody" VARCHAR,
  "custom_sitename" VARCHAR,
  "custom_sitetype" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "geodeticdatum" VARCHAR,
  "coordinateuncertaintyinmeters" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "eventremarks" VARCHAR,
  "basisofrecord" VARCHAR,
  "recordedby" VARCHAR,
  "custom_quadrat" VARCHAR,
  "custom_section" VARCHAR,
  "organismquantity" VARCHAR,
  "organismquantitytype" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "vernacularname" VARCHAR,
  "measurementvalue" VARCHAR,
  "measurementunit" VARCHAR,
  "dynamicproperties" VARCHAR,
  "occurrencestatus" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN Streams Taxon Lookup

@usgov.doi_gov_pacific_island_network_streams_monitoring_2009_2023.pacn_streams_taxon_lookup
  • 16.26 KB
  • 91 rows
  • 14 columns
Loading... 

CREATE TABLE pacn_streams_taxon_lookup (
  "acceptednameusageid" VARCHAR,
  "custom_category" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "specificepithet" VARCHAR,
  "scientificname" VARCHAR,
  "taxonrank" VARCHAR,
  "scientificnameauthorship" VARCHAR,
  "establishmentmeans" VARCHAR,
  "vernacularname" VARCHAR
);

Share link

Anyone who has the link will be able to view this.