Freshwater Snail Inventory Of Upper Delaware Scenic And Recreational River 2022-2023 - Open Format Dataset by US Government | Environmental and Climate Sciences

About this Dataset

Freshwater Snail Inventory Of Upper Delaware Scenic And Recreational River 2022-2023 - Open Format Dataset

The Upper Delaware Scenic and Recreational River (UPDE) unit of the National Park Service partnered with the Academy of Natural Sciences of Drexel University (ANS) to perform a freshwater snail inventory within the park. ANS and UPDE teams conducted field research in July and August of 2022 and 2023 using a combination of kick sampling and hand-picking methods to determine the abundance and diversity of freshwater snail populations. Fifty-four sites were surveyed along the 73 miles of the Delaware River within UPDE and included cold-water and warmwater fisheries zones. In 2022, field collections occurred at 30 sites along the river edge from Hancock, NY to the No. 2 railroad bridge near Mill Rift, PA. In 2023, field work occurred at 24 sites in relatively disturbed areas and within unique river features that were not sampled in 2022. Snails were identified using traditional morphological taxonomy and DNA barcoding of the CO1 (Cytochrome c oxidase I) gene. Additional environmental DNA (eDNA) was analyzed from water collected at ten eDNA Atlas Sites. Based on genetic analysis, 27 species of gastropods were identified, one of which is a non-native species, the Japanese Mystery Snail (Cipangopaludina japonica); previous studies found 18 species and identified the mystery snail as the Chinese (Cipangopaludina chinensis). There were more snails below the Cannonsville Reservoir influence in the warmwater zone. A better understanding of the snail community and the ecosystem has been gained with the results of this inventory which will inform effective and responsible river management plans.
Organization: Department of the Interior
Last updated: 2025-05-23T06:19:54.441503
Tags: abundance, cold-water, data-package-type-darwin-core-archive-dwc-a, diversity, freshwater-snail, imd, japanese-mystery-snail, national-park-service, nps, nps-inventory-and-monitoring-division, nps-species-inventory-program, open-format, warmwater

Tables

UPDE SnailInventory Events

@usgov.doi_gov_freshwater_snail_inventory_of_upper_delaware_s_6dfbde47.upde_snailinventory_events

27.61 KB
197 rows
35 columns


CREATE TABLE upde_snailinventory_events (
  "eventid" VARCHAR,
  "parenteventid" VARCHAR,
  "samplingprotocol" VARCHAR,
  "samplesizevalue" BIGINT,
  "samplesizeunit" VARCHAR,
  "samplingeffort" VARCHAR,
  "startdatetime" TIMESTAMP,
  "enddatetime" TIMESTAMP,
  "waterfeaturename" VARCHAR,
  "countrycode" VARCHAR,
  "stateprovince" VARCHAR,
  "county" VARCHAR,
  "habitatdescription" VARCHAR,
  "verbatimlatitude" DOUBLE,
  "verbatimlongitude" DOUBLE,
  "verbatimlatitudestart" VARCHAR,
  "verbatimlongitudestart" VARCHAR,
  "verbatimlatitudestop" VARCHAR,
  "verbatimlongitudestop" VARCHAR,
  "verbatimcoordinatesystem" VARCHAR,
  "verbatimsrs" VARCHAR,
  "verbatimdatum" VARCHAR,
  "coordinateuncertaintyinmeters" BIGINT,
  "coordinateprecision" DOUBLE,
  "publicdisplay" VARCHAR,
  "dataaccess" VARCHAR,
  "fieldnumber" VARCHAR,
  "fieldnotes" VARCHAR,
  "eventremarks" VARCHAR,
  "verbatimelevation" VARCHAR,
  "verbatimdepth" VARCHAR,
  "waterfeaturesubstrate" VARCHAR,
  "locationremarks" VARCHAR,
  "footprintwkt" VARCHAR,
  "footprintsrs" VARCHAR
);

UPDE SnailInventory Occurrence

@usgov.doi_gov_freshwater_snail_inventory_of_upper_delaware_s_6dfbde47.upde_snailinventory_occurrence

35.07 KB
918 rows
29 columns


CREATE TABLE upde_snailinventory_occurrence (
  "occurrenceid" VARCHAR,
  "eventid" VARCHAR,
  "basisofrecord" VARCHAR,
  "taxonid" VARCHAR,
  "scientificname" VARCHAR,
  "recordedby" VARCHAR,
  "individualcount" BIGINT,
  "organismquantity" BIGINT,
  "organismquantitytype" VARCHAR,
  "publicdisplay" VARCHAR,
  "dataaccess" VARCHAR,
  "lifestage" VARCHAR,
  "sex" VARCHAR,
  "reproductivecondition" VARCHAR,
  "behavior" VARCHAR,
  "covariatesample" VARCHAR,
  "preparations" VARCHAR,
  "identifiedby" VARCHAR,
  "dateidentified" VARCHAR,
  "identificationreferences" VARCHAR,
  "identificationremarks" VARCHAR,
  "identificationqualifier" VARCHAR,
  "identificationverificationstatus" VARCHAR,
  "occurrence_institutioncode" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "materialsampleid" VARCHAR,
  "recordnumber" VARCHAR,
  "organismremarks" VARCHAR,
  "identificationid" VARCHAR
);

UPDE SnailInventory Taxon

@usgov.doi_gov_freshwater_snail_inventory_of_upper_delaware_s_6dfbde47.upde_snailinventory_taxon

24.23 KB
36 rows
32 columns


CREATE TABLE upde_snailinventory_taxon (
  "taxonid" VARCHAR,
  "scientificnameid" VARCHAR,
  "scientificname" VARCHAR,
  "acceptednameusage" VARCHAR,
  "kingdom" VARCHAR,
  "phylum" VARCHAR,
  "class" VARCHAR,
  "order" VARCHAR,
  "family" VARCHAR,
  "genus" VARCHAR,
  "subgenus" VARCHAR,
  "specificepithet" VARCHAR,
  "infraspecificepithet" VARCHAR,
  "taxonrank" VARCHAR,
  "scientificnameauthorship" VARCHAR,
  "vernacularname" VARCHAR,
  "nomenclaturalcode" VARCHAR,
  "taxonomicstatus" VARCHAR,
  "nomenclaturalstatus" VARCHAR,
  "taxonremarks" VARCHAR,
  "parentnameusage" VARCHAR,
  "originalnameusage" VARCHAR,
  "nameaccordingto" VARCHAR,
  "namepublishedin" VARCHAR,
  "namepublishedinyear" VARCHAR,
  "higherclassification" VARCHAR,
  "acceptednameusageid" VARCHAR,
  "parentnameusageid" VARCHAR,
  "originalnameusageid" VARCHAR,
  "nameaccordingtoid" VARCHAR,
  "namepublishedinid" VARCHAR,
  "taxonconceptid" VARCHAR
);