Pacific Island Network Established Invasive Plant Species Monitoring Dataset 2010-2022
Department of the Interior
@usgov.doi_gov_pacific_island_network_established_invasive_pl_77c9323c
Department of the Interior
@usgov.doi_gov_pacific_island_network_established_invasive_pl_77c9323c
The Pacific Island Inventory and Monitoring Network (PACN) collected data on the status of established invasive plant species in the mangrove community of American Memorial Park (AMME), in the wet forest and subalpine plant communities of Hawaiʻi Volcanoes National Park (HAVO) and Haleakalā National Park (HALE), and in the wet forests and coastal community of Kalaupapa National Historical Park (KALA). Specifically, crews collected data on nonnative species richness, frequency and cover along 250, 500 and 1,000 meter long belt transects.
Organization: Department of the Interior
Last updated: 2025-09-14T21:23:10.663413
Tags: american-memorial-park, amme, biota, ecological-framework-biological-integrity-invasive-species-invasive-exotic-plants, field-inventory-and-monitoring, hale, haleakala-national-park, havo, hawaii-volcanoes-national-park, invasive-species, kala, kalaupapa-national-historical-park, national-park-system-unit-code-thesaurus, nonindigenous-species, nps-gov-subject-site-invasive-non-native-species, plants, vascular-plants, vegetation
CREATE TABLE pacn_eips_contacts_lookup (
"recordedby" VARCHAR,
"custom_organization" VARCHAR,
"dynamicproperties" VARCHAR
);CREATE TABLE pacn_eips_cover_class_data (
"samplingprotocol" VARCHAR,
"year" BIGINT,
"custom_cycle" BIGINT,
"custom_unitcode" VARCHAR,
"custom_plantcommunity" VARCHAR,
"custom_samplingframe" VARCHAR,
"custom_transecttype" VARCHAR,
"custom_transectnumber" VARCHAR,
"decimallatitude" DOUBLE,
"decimallongitude" DOUBLE,
"geodeticdatum" VARCHAR,
"custom_startdate" TIMESTAMP,
"custom_enddate" TIMESTAMP,
"custom_eventtimestart" VARCHAR,
"custom_eventtimeend" VARCHAR,
"recordedby" VARCHAR,
"eventremarks" VARCHAR,
"custom_segment" VARCHAR,
"occurrenceremarks" VARCHAR,
"custom_coverclass" VARCHAR,
"custom_dead" BIGINT,
"custom_cf" BIGINT,
"identificationqualifier" VARCHAR,
"custom_speciescode" VARCHAR,
"scientificname" VARCHAR,
"vernacularname" VARCHAR,
"custom_lifeform" VARCHAR,
"establishmentmeans" VARCHAR,
"custom_certified" BIGINT,
"custom_certifiedby" VARCHAR,
"custom_certifieddate" TIMESTAMP,
"eventid" VARCHAR,
"locationid" VARCHAR
);CREATE TABLE pacn_eips_image_data (
"samplingprotocol" VARCHAR,
"year" BIGINT,
"custom_cycle" BIGINT,
"custom_unitcode" VARCHAR,
"custom_plantcommunity" VARCHAR,
"custom_samplingframe" VARCHAR,
"custom_transecttype" VARCHAR,
"custom_transectnumber" VARCHAR,
"custom_startdate" TIMESTAMP,
"custom_enddate" TIMESTAMP,
"custom_eventtimestart" VARCHAR,
"custom_eventtimeend" VARCHAR,
"recordedby" VARCHAR,
"eventremarks" VARCHAR,
"custom_imagepoint" VARCHAR,
"decimallatitude" VARCHAR,
"decimallongitude" VARCHAR,
"geodeticdatum" VARCHAR,
"coordinateuncertaintyinmeters" VARCHAR,
"dynamicproperties" VARCHAR,
"custom_photo" VARCHAR,
"custom_imagelabel" VARCHAR,
"custom_imagedate" VARCHAR,
"custom_imagetime" VARCHAR,
"associatedmedia" VARCHAR,
"occurrenceremarks" VARCHAR,
"custom_certified" BIGINT,
"custom_certifiedby" VARCHAR,
"custom_certifieddate" TIMESTAMP,
"eventid" VARCHAR,
"locationid" VARCHAR
);CREATE TABLE pacn_eips_taxon_lookup (
"acceptednameusageid" VARCHAR,
"order" VARCHAR,
"family" VARCHAR,
"genus" VARCHAR,
"scientificname" VARCHAR,
"taxonrank" VARCHAR,
"scientificnameauthorship" VARCHAR,
"references" VARCHAR,
"custom_speciescode" VARCHAR
);CREATE TABLE pacn_eips_transect_location_data (
"samplingprotocol" VARCHAR,
"custom_unitcode" VARCHAR,
"custom_sitename" VARCHAR,
"custom_plantcommunity" VARCHAR,
"custom_samplingframehawaiian" VARCHAR,
"custom_samplingframeenglish" VARCHAR,
"custom_transecttype" VARCHAR,
"custom_transectnumber" VARCHAR,
"decimallatitude" DOUBLE,
"decimallongitude" DOUBLE,
"geodeticdatum" VARCHAR,
"georeferenceprotocol" VARCHAR,
"coordinateuncertaintyinmeters" VARCHAR,
"custom_azimuth" VARCHAR,
"minimumelevationinmeters" VARCHAR,
"maximumelevationinmeters" VARCHAR,
"locationremarks" VARCHAR,
"custom_map" BIGINT,
"custom_mapdate" VARCHAR,
"custom_maprevisedby" VARCHAR,
"custom_transectcertified" BIGINT,
"custom_transectcertifiedby" VARCHAR,
"custom_transectcertifieddate" VARCHAR,
"locationid" VARCHAR
);Anyone who has the link will be able to view this.