Baselight

Pacific Island Network Anchialine Pool Monitoring Dataset 2019 - 2024

Department of the Interior

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59

About this Dataset

Pacific Island Network Anchialine Pool Monitoring Dataset 2019 - 2024

Anchialine pools were surveyed in two Pacific Island Network parks, Kaloko-Honokōhau National Historical Park (KAHO) and Puʻuhonua o Hōnaunau National Historical Park National Historical Park (PUHO), to quantify the annual abundance of select crustaceans, mollusc, odonate, and fish species in order to determine if the population size of these species declines or increases over time within each anchialine pool. Abiotic and biotic characteristics were also measured, which included riparian vegetation monitoring, percent cover, canopy closure, substrate particle size, water depth, light measurements, and water quality assessment. Surveys occurred in each park in 2019 and 2023 - 2024 and at PUHO in 2022. This dataset contains the results of the anchialine pool surveys for KAHO and PUHO in 2019 and 2022-2024.
Organization: Department of the Interior
Last updated: 2025-05-11T04:50:28.014791
Tags: aama, abudefduf-abdominalis, acanthurus-triostegus, acanthurus-xanthopterus, african-mouthbrooders, aholehole, akupa-sleeper, algaroba, anax-junius, anchialine-pool, anchialine-snapping-shrimp, apis-mellifera, aquatic-ecosystems, ardea-ibis, argiope-appensa, banded-damselfish, basora-prieta, batis-maritima, beach-naupaka, bigeye-trevally, birdfish, black-mullet, black-saddlebags, black-ulua, bluefin-trevally, boerhavia-coccinea, bolboschoenus-maritimus-ssp-paludosus, brackish-water, brazilian-pepper-tree, brazilian-peppertree, brephidium-exilis, broad-tailed-day-gecko, capparis-sandwichiana, caranx-melampygus, caranx-sexfasciatus, cenchrus-setaceus, cencilla, chaetodon-lunula, chanos-chanos, christmas-berry, christmasberry, coccinia-grandis, coconut-palm, cocos-nucifera, common-green-darner, convict-surgeonfish, convict-tang, convictfish, cordia-subcordata, corky-passionflower, corkystem-passionflower, cosmopolitan-bulrush, crustaceans, cure-for-all, cyperus-javanicus, cyperus-laevigatus, devils-backbone, devils-pumpkin, eleotris-sandwicensis, enallagma-civile, endangered-species, endemic-species, eragrostis-tenella, euphorbia-hirta, familiar-bluet, feeble-shrimp, fetid-passionflower, fishes, florida-holly, fragile-forktail, gambusia-affinis, garden-skink, gold-dust-day-gecko, gomphosus-varius, grapsus-tenuicrustatus, gray-mullet, great-trevally, groundwater, guppy, halocaridina-rubra, hawaiian-aholehole, hawaiian-culture, hawaiian-fishponds, hawaiian-river-shrimp, heliotropium-curassavicum, honey-bee, huehue-haole, indian-mulberry, indigo-berry, ischnura-posita, ischnura-ramburii, ivy-gourd, japanese-lovegrass, japanese-white-eye, javanese-flatsedge, kaho, kalanchoe-daigremontiana, kaloko-honokhau-national-historical-park, kiawe, kou, kuhlia-sandvicensis, kukuau, lampropholis-delicata, lantana-camara, large-orange-sulphur, largeleaf-lantana, macrobrachium-grandimanus, maypop, megalagrion-xanthomelas, mesquite, metabetaeus-lohena, metallic-skink, metopograpsus-thukuhar, milkfish, millions-fish, monitoring, morinda-citrifolia, mosquitofish, mozambique-mouth-breeder, mozambique-mouthbrooder, mozambique-tilapia, mugil-cephalus, natal-lightfoot-crab, native-caper, native-species, nephrolepis-brownii, neripteron-cariosum, nerita-picea, nycticorax-nycticorax-hoactli, odonates, opae-huna, oreochromis-mossambicus, pacific-golden-plover, palaemon-debilis, pandanus, pantala-flavescens, passiflora-foetida, passiflora-suberosa, phelsuma-laticauda, phoebis-agarithe, pillpod-sandmat, pluchea-carolinensis, plumbago-zeylanica, pluvialis-fulva, poecilia-reticulata, portia-tree, pritchardia-maideniana, prosopis-pallida, puho, pus-pilo, puuhonua-o-hnaunau-national-historical-park, quail-plant, rainbowfish, ramburs-forktail, red-pond-shrimp, redstriped-butterflyfish, saddle-wrasse, salt-heliotrope, saltwort, scaevola-taccada, scarlet-fruited-gourd, scarlet-spiderling, scarletfruit-passionflower, schinus-terebinthifolius, screwpine, seaside-heliotrope, seaside-mahoe, sesuvium-portulacastrum, shoreline-seapurslane, smooth-flatsedge, smooth-nutgrass, snails, speckled-tilapias, stinking-passionflower, striped-mullet, talinum-fruticosum, thalassoma-duperrey, thespesia-populnea, thiara, tilapia, tournefortia-argentea, tramea-lacerata, tringa-incana, turtleweed, uhaloa, ulva, velvetleaf-soldierbush, verdolaga-francesa, vespula, waltheria-indica, wandering-glider, wandering-tattler, warui, water-quality, western-cattle-egret, western-mosquitofish, wild-leadwort, wild-passionfruit, wildlife, xylocopa-brasilianorum-sonorina, yellowfin-surgeonfish, zosterops-japonicus

Tables

PACN AP Contacts Lookup

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_contacts_lookup
  • 3.53 KB
  • 16 rows
  • 3 columns
Loading...

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

PACN AP Traps Shrimp Data

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_traps_shrimp_data
  • 28.06 KB
  • 196 rows
  • 29 columns
Loading...

CREATE TABLE pacn_ap_traps_shrimp_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_poolname" VARCHAR,
  "custom_sitenumber" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_surveystarttime" VARCHAR,
  "custom_surveyendtime" VARCHAR,
  "custom_trapnumber" BIGINT,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "sex" VARCHAR,
  "individualcount" VARCHAR,
  "occurrencestatus" VARCHAR,
  "reproductivecondition" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN AP Riparian Data

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_riparian_data
  • 24.75 KB
  • 175 rows
  • 24 columns
Loading...

CREATE TABLE pacn_ap_riparian_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_poolname" VARCHAR,
  "custom_sitenumber" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_weather" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "measurementvalue" VARCHAR,
  "occurrencestatus" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN AP Images Data

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_images_data
  • 29.17 KB
  • 410 rows
  • 25 columns
Loading...

CREATE TABLE pacn_ap_images_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_poolname" VARCHAR,
  "custom_sitenumber" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_imagelabel" VARCHAR,
  "custom_imagedate" TIMESTAMP,
  "custom_imagetime" VARCHAR,
  "custom_photographer" VARCHAR,
  "associatedmedia" VARCHAR,
  "custom_associatedmediaremarks" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN AP Other Taxa Data

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_other_taxa_data
  • 24.84 KB
  • 169 rows
  • 23 columns
Loading...

CREATE TABLE pacn_ap_other_taxa_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_poolname" VARCHAR,
  "custom_sitenumber" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_weather" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "occurrencestatus" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN AP Odonates Data

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_odonates_data
  • 26.35 KB
  • 79 rows
  • 27 columns
Loading...

CREATE TABLE pacn_ap_odonates_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_poolname" VARCHAR,
  "custom_sitenumber" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_surveystarttime" VARCHAR,
  "custom_surveyendtime" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "sex" VARCHAR,
  "individualcount" VARCHAR,
  "occurrencestatus" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN AP Quadrats Shrimp Data

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_quadrats_shrimp_data
  • 27.2 KB
  • 170 rows
  • 28 columns
Loading...

CREATE TABLE pacn_ap_quadrats_shrimp_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_poolname" VARCHAR,
  "custom_sitenumber" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_surveystarttime" VARCHAR,
  "custom_surveyendtime" VARCHAR,
  "custom_quadrat" BIGINT,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "reproductivecondition" VARCHAR,
  "individualcount" VARCHAR,
  "occurrencestatus" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN AP Snails Data

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_snails_data
  • 30.89 KB
  • 780 rows
  • 30 columns
Loading...

CREATE TABLE pacn_ap_snails_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_poolname" VARCHAR,
  "custom_sitenumber" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_surveystarttime" VARCHAR,
  "custom_surveyendtime" VARCHAR,
  "custom_transect" BIGINT,
  "custom_transectlengthinmeters" DOUBLE,
  "individualcount" VARCHAR,
  "occurrencestatus" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "measurementvalue" VARCHAR,
  "measurementunit" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN AP Traps Fish Data

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_traps_fish_data
  • 27.64 KB
  • 194 rows
  • 29 columns
Loading...

CREATE TABLE pacn_ap_traps_fish_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_poolname" VARCHAR,
  "custom_sitenumber" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_surveystarttime" VARCHAR,
  "custom_surveyendtime" VARCHAR,
  "custom_trapnumber" BIGINT,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "sex" VARCHAR,
  "individualcount" VARCHAR,
  "occurrencestatus" VARCHAR,
  "reproductivecondition" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN AP Pool Locations Data

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_pool_locations_data
  • 12.47 KB
  • 15 rows
  • 15 columns
Loading...

CREATE TABLE pacn_ap_pool_locations_data (
  "samplingprotocol" VARCHAR,
  "custom_unitcode" VARCHAR,
  "custom_parkname" VARCHAR,
  "custom_poolname" VARCHAR,
  "custom_colocation" VARCHAR,
  "custom_sitenumber" VARCHAR,
  "custom_ahupuaa" VARCHAR,
  "custom_area" VARCHAR,
  "custom_shoredistanceinmeters" VARCHAR,
  "custom_lavatype" VARCHAR,
  "locality" VARCHAR,
  "locationremarks" VARCHAR,
  "custom_poolmodifiedby" VARCHAR,
  "modified" TIMESTAMP,
  "locationid" VARCHAR
);

PACN AP Transects Data

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_transects_data
  • 40.58 KB
  • 4296 rows
  • 30 columns
Loading...

CREATE TABLE pacn_ap_transects_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_poolname" VARCHAR,
  "custom_sitenumber" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_surveystarttime" VARCHAR,
  "custom_surveyendtime" VARCHAR,
  "custom_transect" BIGINT,
  "custom_transectlengthinmeters" BIGINT,
  "custom_densiometervalues" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "custom_point" BIGINT,
  "measurementtype" VARCHAR,
  "measurementvalue" DOUBLE,
  "measurementunit" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);

PACN AP Taxon Lookup

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_taxon_lookup
  • 21.48 KB
  • 81 rows
  • 17 columns
Loading...

CREATE TABLE pacn_ap_taxon_lookup (
  "acceptednameusageid" VARCHAR,
  "custom_category" VARCHAR,
  "kingdom" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "specificepithet" VARCHAR,
  "scientificname" VARCHAR,
  "taxonrank" VARCHAR,
  "scientificnameauthorship" VARCHAR,
  "establishmentmeans" VARCHAR,
  "vernacularname" VARCHAR,
  "taxonremarks" VARCHAR,
  "modified" TIMESTAMP,
  "custom_modifiedby" VARCHAR,
  "custom_modifiedremarks" VARCHAR
);

PACN AP Quadrat Fish Data

@usgov.doi_gov_pacific_island_network_anchialine_pool_monitor_5069be59.pacn_ap_quadrat_fish_data
  • 27.2 KB
  • 183 rows
  • 28 columns
Loading...

CREATE TABLE pacn_ap_quadrat_fish_data (
  "samplingprotocol" VARCHAR,
  "year" BIGINT,
  "custom_unitcode" VARCHAR,
  "custom_poolname" VARCHAR,
  "custom_sitenumber" VARCHAR,
  "eventdate" TIMESTAMP,
  "custom_enddate" TIMESTAMP,
  "eventtime" VARCHAR,
  "custom_endtime" VARCHAR,
  "recordedby" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventremarks" VARCHAR,
  "dynamicproperties" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_surveystarttime" VARCHAR,
  "custom_surveyendtime" VARCHAR,
  "custom_quadrat" BIGINT,
  "occurrenceremarks" VARCHAR,
  "scientificname" VARCHAR,
  "sex" VARCHAR,
  "individualcount" VARCHAR,
  "occurrencestatus" VARCHAR,
  "informationwithheld" VARCHAR,
  "custom_certified" BIGINT,
  "custom_certifiedby" VARCHAR,
  "custom_certifieddate" TIMESTAMP,
  "eventid" VARCHAR,
  "locationid" VARCHAR
);