Baselight
Sign In

Acadia National Park Herpetological Inventory 2001 - Data Package

Department of the Interior

@usgov.doi_gov_acadia_national_park_herpetological_inventory__de4b9bab

Loading...
Loading...

About this Dataset

Acadia National Park Herpetological Inventory 2001 - Data Package

Under a National Park Service/Wildlife Conservation Society Cooperative Agreement, an inventory of amphibians and reptiles at Acadia National Park (ACAD) in Maine was conducted from March through September 2001. Seven standardized sampling methods were employed; anuran call counts, egg-mass counts, time-constrained search, coverboards, turtle trapping, minnow trapping, and drift fence arrays. In addition, animals encountered outside of standardized surveys (temporally or spatially) were recorded as incidental encounters. Eighteen species were documented including six frog/toad, five salamander, two turtle, and five snake species. These species represent 82% of the species believed to have occurred historically in the park.
Organization: Department of the Interior
Last updated: 2025-05-11T05:03:27.502701
Tags: amphibians, coverboards, drift-fences, frogs, herpetological, incidental-observations, lizards, minnow-traps, reptiles, salamanders, snakes, stream-salamanders, time-constrained-searches, toads, turtle-traps, turtles

Tables

ACAD Amphibian Call Counts

@usgov.doi_gov_acadia_national_park_herpetological_inventory__de4b9bab.acad_amphibian_call_counts
  • 37.6 KB
  • 132 rows
  • 40 columns
Loading... 

CREATE TABLE acad_amphibian_call_counts (
  "locality" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventdate" TIMESTAMP,
  "eventdate_flag" VARCHAR,
  "scientificname" VARCHAR,
  "scientificname_flag" VARCHAR,
  "taxonrank" VARCHAR,
  "verbatimidentification" VARCHAR,
  "vernacularname" VARCHAR,
  "namepublishedin" VARCHAR,
  "custom_taxonomicnotes" VARCHAR,
  "recordedby" VARCHAR,
  "individualcount" VARCHAR,
  "custom_callindex" BIGINT,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "custom_decimallatitudeend" VARCHAR,
  "custom_decimallongitudeend" VARCHAR,
  "coordinate_flag" VARCHAR,
  "geodeticdatum" VARCHAR,
  "verbatimcoordinates" VARCHAR,
  "custom_verbatimcoordinatesend" VARCHAR,
  "verbatimcoordinatesystem" VARCHAR,
  "verbatimsrs" VARCHAR,
  "coordinateuncertaintyinmeters" DOUBLE,
  "locationid" VARCHAR,
  "locationremarks" VARCHAR,
  "eventid" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "custom_airtemperatureincelsius" VARCHAR,
  "custom_watertemperatureincelsius" VARCHAR,
  "custom_windspeed" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_ph" VARCHAR,
  "custom_eventstarttime" VARCHAR,
  "custom_eventendtime" VARCHAR,
  "custom_program" VARCHAR,
  "custom_recordid" BIGINT,
  "custom_sensitiverecord" BOOLEAN
);

ACAD Amphibian Egg Counts

@usgov.doi_gov_acadia_national_park_herpetological_inventory__de4b9bab.acad_amphibian_egg_counts
  • 32.43 KB
  • 31 rows
  • 41 columns
Loading... 

CREATE TABLE acad_amphibian_egg_counts (
  "locality" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventdate" TIMESTAMP,
  "eventdate_flag" VARCHAR,
  "scientificname" VARCHAR,
  "scientificname_flag" VARCHAR,
  "taxonrank" VARCHAR,
  "verbatimidentification" VARCHAR,
  "vernacularname" VARCHAR,
  "namepublishedin" VARCHAR,
  "custom_taxonomicnotes" VARCHAR,
  "recordedby" VARCHAR,
  "individualcount" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "custom_decimallatitudeend" VARCHAR,
  "custom_decimallongitudeend" VARCHAR,
  "coordinate_flag" VARCHAR,
  "geodeticdatum" VARCHAR,
  "verbatimcoordinates" VARCHAR,
  "custom_verbatimcoordinatesend" VARCHAR,
  "verbatimcoordinatesystem" VARCHAR,
  "verbatimsrs" VARCHAR,
  "coordinateuncertaintyinmeters" DOUBLE,
  "locationid" VARCHAR,
  "locationremarks" VARCHAR,
  "eventid" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "custom_airtemperatureincelsius" VARCHAR,
  "custom_watertemperatureincelsius" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_ph" VARCHAR,
  "custom_eventstarttime" VARCHAR,
  "custom_eventendtime" VARCHAR,
  "custom_program" VARCHAR,
  "custom_recordid" BIGINT,
  "custom_gosnerstage" VARCHAR,
  "custom_mortalityinpercent" VARCHAR,
  "custom_eggmasscolor" VARCHAR,
  "custom_sensitiverecord" BOOLEAN
);

ACAD Drift Fence Surveys

@usgov.doi_gov_acadia_national_park_herpetological_inventory__de4b9bab.acad_drift_fence_surveys
  • 37.45 KB
  • 1266 rows
  • 39 columns
Loading... 

CREATE TABLE acad_drift_fence_surveys (
  "locality" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventdate" TIMESTAMP,
  "eventdate_flag" VARCHAR,
  "scientificname" VARCHAR,
  "scientificname_flag" VARCHAR,
  "taxonrank" VARCHAR,
  "verbatimidentification" VARCHAR,
  "vernacularname" VARCHAR,
  "namepublishedin" VARCHAR,
  "custom_taxonomicnotes" VARCHAR,
  "recordedby" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "coordinate_flag" VARCHAR,
  "geodeticdatum" VARCHAR,
  "verbatimcoordinates" VARCHAR,
  "verbatimcoordinatesystem" VARCHAR,
  "verbatimsrs" VARCHAR,
  "coordinateuncertaintyinmeters" DOUBLE,
  "locationid" VARCHAR,
  "locationremarks" VARCHAR,
  "eventid" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "custom_airtemperatureincelsius" BIGINT,
  "custom_watertemperatureincelsius" VARCHAR,
  "custom_rain" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_ph" VARCHAR,
  "custom_eventstarttime" VARCHAR,
  "custom_eventendtime" VARCHAR,
  "custom_program" VARCHAR,
  "custom_recordid" BIGINT,
  "custom_trapnumber" VARCHAR,
  "custom_numberofmales" VARCHAR,
  "custom_numberoffemales" VARCHAR,
  "custom_numberofunknownsex" VARCHAR,
  "custom_sensitiverecord" BOOLEAN
);

ACAD Incidental Observations

@usgov.doi_gov_acadia_national_park_herpetological_inventory__de4b9bab.acad_incidental_observations
  • 83.15 KB
  • 724 rows
  • 40 columns
Loading... 

CREATE TABLE acad_incidental_observations (
  "locality" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventdate" VARCHAR,
  "eventdate_flag" VARCHAR,
  "scientificname" VARCHAR,
  "scientificname_flag" VARCHAR,
  "taxonrank" VARCHAR,
  "verbatimidentification" VARCHAR,
  "vernacularname" VARCHAR,
  "namepublishedin" VARCHAR,
  "custom_taxonomicnotes" VARCHAR,
  "recordedby" VARCHAR,
  "individualcount" VARCHAR,
  "lifestage" VARCHAR,
  "decimallatitude" VARCHAR,
  "decimallongitude" VARCHAR,
  "custom_decimallatitudeend" VARCHAR,
  "custom_decimallongitudeend" VARCHAR,
  "coordinate_flag" VARCHAR,
  "geodeticdatum" VARCHAR,
  "verbatimcoordinates" VARCHAR,
  "custom_verbatimcoordinatesend" VARCHAR,
  "verbatimcoordinatesystem" VARCHAR,
  "verbatimsrs" VARCHAR,
  "coordinateuncertaintyinmeters" VARCHAR,
  "georeferenceremarks" VARCHAR,
  "locationid" VARCHAR,
  "locationremarks" VARCHAR,
  "eventid" VARCHAR,
  "eventremarks" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "custom_airtemperatureincelsius" VARCHAR,
  "custom_watertemperatureincelsius" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_eventstarttime" VARCHAR,
  "custom_eventendtime" VARCHAR,
  "custom_program" VARCHAR,
  "custom_recordid" BIGINT,
  "custom_sensitiverecord" BOOLEAN
);

ACAD Minnow Traps

@usgov.doi_gov_acadia_national_park_herpetological_inventory__de4b9bab.acad_minnow_traps
  • 43.04 KB
  • 368 rows
  • 40 columns
Loading... 

CREATE TABLE acad_minnow_traps (
  "locality" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR,
  "custom_eventstartdate" TIMESTAMP,
  "custom_eventenddate" TIMESTAMP,
  "eventdate_flag" VARCHAR,
  "scientificname" VARCHAR,
  "scientificname_flag" VARCHAR,
  "taxonrank" VARCHAR,
  "verbatimidentification" VARCHAR,
  "vernacularname" VARCHAR,
  "namepublishedin" VARCHAR,
  "custom_taxonomicnotes" VARCHAR,
  "recordedby" VARCHAR,
  "individualcount" VARCHAR,
  "lifestage" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "custom_decimallatitudeend" VARCHAR,
  "custom_decimallongitudeend" VARCHAR,
  "coordinate_flag" VARCHAR,
  "geodeticdatum" VARCHAR,
  "verbatimcoordinates" VARCHAR,
  "custom_verbatimcoordinatesend" VARCHAR,
  "verbatimcoordinatesystem" VARCHAR,
  "verbatimsrs" VARCHAR,
  "coordinateuncertaintyinmeters" DOUBLE,
  "locationid" VARCHAR,
  "locationremarks" VARCHAR,
  "eventid" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "custom_airtemperatureincelsius" VARCHAR,
  "custom_watertemperatureincelsius" VARCHAR,
  "custom_ph" VARCHAR,
  "custom_eventstarttime" VARCHAR,
  "custom_eventendtime" VARCHAR,
  "custom_program" VARCHAR,
  "custom_recordid" BIGINT,
  "custom_trapnumber" BIGINT,
  "custom_sensitiverecord" BOOLEAN
);

ACAD Stream Salamander Surveys

@usgov.doi_gov_acadia_national_park_herpetological_inventory__de4b9bab.acad_stream_salamander_surveys
  • 33.82 KB
  • 70 rows
  • 42 columns
Loading... 

CREATE TABLE acad_stream_salamander_surveys (
  "locality" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventdate" TIMESTAMP,
  "eventdate_flag" VARCHAR,
  "scientificname" VARCHAR,
  "scientificname_flag" VARCHAR,
  "taxonrank" VARCHAR,
  "verbatimidentification" VARCHAR,
  "vernacularname" VARCHAR,
  "namepublishedin" VARCHAR,
  "custom_taxonomicnotes" VARCHAR,
  "recordedby" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "custom_decimallatitudeend" DOUBLE,
  "custom_decimallongitudeend" DOUBLE,
  "coordinate_flag" VARCHAR,
  "geodeticdatum" VARCHAR,
  "verbatimcoordinates" VARCHAR,
  "custom_verbatimcoordinatesend" VARCHAR,
  "verbatimcoordinatesystem" VARCHAR,
  "verbatimsrs" VARCHAR,
  "coordinateuncertaintyinmeters" DOUBLE,
  "georeferenceremarks" VARCHAR,
  "locationid" VARCHAR,
  "locationremarks" VARCHAR,
  "eventid" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "custom_airtemperatureincelsius" VARCHAR,
  "custom_watertemperatureincelsius" VARCHAR,
  "custom_windspeed" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_ph" VARCHAR,
  "custom_eventstarttime" VARCHAR,
  "custom_eventendtime" VARCHAR,
  "custom_program" VARCHAR,
  "custom_recordid" BIGINT,
  "lifestage" VARCHAR,
  "custom_samplezone" VARCHAR,
  "custom_substrate" VARCHAR,
  "custom_sensitiverecord" BOOLEAN
);

ACAD Time Constrained Searches

@usgov.doi_gov_acadia_national_park_herpetological_inventory__de4b9bab.acad_time_constrained_searches
  • 48.44 KB
  • 260 rows
  • 51 columns
Loading... 

CREATE TABLE acad_time_constrained_searches (
  "locality" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventdate" TIMESTAMP,
  "eventdate_flag" VARCHAR,
  "scientificname" VARCHAR,
  "scientificname_flag" VARCHAR,
  "taxonrank" VARCHAR,
  "verbatimidentification" VARCHAR,
  "vernacularname" VARCHAR,
  "namepublishedin" VARCHAR,
  "custom_taxonomicnotes" VARCHAR,
  "recordedby" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "custom_decimallatitudeend" VARCHAR,
  "custom_decimallongitudeend" VARCHAR,
  "coordinate_flag" VARCHAR,
  "geodeticdatum" VARCHAR,
  "verbatimcoordinates" VARCHAR,
  "custom_verbatimcoordinatesend" VARCHAR,
  "verbatimcoordinatesystem" VARCHAR,
  "verbatimsrs" VARCHAR,
  "coordinateuncertaintyinmeters" DOUBLE,
  "georeferenceremarks" VARCHAR,
  "locationid" VARCHAR,
  "locationremarks" VARCHAR,
  "eventid" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "custom_airtemperatureincelsius" VARCHAR,
  "custom_watertemperatureincelsius" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_ph" VARCHAR,
  "custom_utmxcorner1" VARCHAR,
  "custom_utmycorner1" VARCHAR,
  "custom_coordinateuncertaintycorner1" VARCHAR,
  "custom_utmxcorner2" VARCHAR,
  "custom_utmycorner2" VARCHAR,
  "custom_coordinateuncertaintycorner2" VARCHAR,
  "custom_utmxcorner3" VARCHAR,
  "custom_utmycorner3" VARCHAR,
  "custom_coordinateuncertaintycorner3" VARCHAR,
  "custom_utmxcorner4" VARCHAR,
  "custom_utmycorner4" VARCHAR,
  "custom_coordinateuncertaintycorner4" VARCHAR,
  "custom_eventstarttime" VARCHAR,
  "custom_eventendtime" VARCHAR,
  "custom_program" VARCHAR,
  "custom_recordid" BIGINT,
  "sex" VARCHAR,
  "custom_sensitiverecord" BOOLEAN
);

ACAD Turtle Measurements

@usgov.doi_gov_acadia_national_park_herpetological_inventory__de4b9bab.acad_turtle_measurements
  • 44.83 KB
  • 137 rows
  • 42 columns
Loading... 

CREATE TABLE acad_turtle_measurements (
  "locality" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR,
  "eventdate" TIMESTAMP,
  "eventdate_flag" VARCHAR,
  "scientificname" VARCHAR,
  "scientificname_flag" VARCHAR,
  "taxonrank" VARCHAR,
  "verbatimidentification" VARCHAR,
  "vernacularname" VARCHAR,
  "namepublishedin" VARCHAR,
  "custom_taxonomicnotes" VARCHAR,
  "recordedby" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "coordinate_flag" VARCHAR,
  "geodeticdatum" VARCHAR,
  "verbatimcoordinates" VARCHAR,
  "verbatimcoordinatesystem" VARCHAR,
  "verbatimsrs" VARCHAR,
  "coordinateuncertaintyinmeters" DOUBLE,
  "locationid" VARCHAR,
  "locationremarks" VARCHAR,
  "eventid" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "eventtime" VARCHAR,
  "custom_program" VARCHAR,
  "custom_recordid" BIGINT,
  "custom_notchcode" VARCHAR,
  "samplingprotocol" VARCHAR,
  "custom_vegetationcoverinpercent" VARCHAR,
  "behavior" VARCHAR,
  "sex" VARCHAR,
  "custom_age" VARCHAR,
  "custom_carapacelengthinmillimeters" VARCHAR,
  "custom_carapacewidthinmillimeters" VARCHAR,
  "custom_plastronlengthinmillimeters" VARCHAR,
  "custom_plastronwidthinmillimeters" VARCHAR,
  "custom_weightingrams" VARCHAR,
  "custom_ectoparasites" VARCHAR,
  "custom_gravid" VARCHAR,
  "custom_sensitiverecord" BOOLEAN
);

ACAD Turtle Traps

@usgov.doi_gov_acadia_national_park_herpetological_inventory__de4b9bab.acad_turtle_traps
  • 47.71 KB
  • 869 rows
  • 40 columns
Loading... 

CREATE TABLE acad_turtle_traps (
  "locality" VARCHAR,
  "type" VARCHAR,
  "basisofrecord" VARCHAR,
  "custom_eventstartdate" TIMESTAMP,
  "custom_eventenddate" TIMESTAMP,
  "eventdate_flag" VARCHAR,
  "scientificname" VARCHAR,
  "scientificname_flag" VARCHAR,
  "taxonrank" VARCHAR,
  "verbatimidentification" VARCHAR,
  "vernacularname" VARCHAR,
  "namepublishedin" VARCHAR,
  "custom_taxonomicnotes" VARCHAR,
  "recordedby" VARCHAR,
  "decimallatitude" DOUBLE,
  "decimallongitude" DOUBLE,
  "coordinate_flag" VARCHAR,
  "geodeticdatum" VARCHAR,
  "verbatimcoordinates" VARCHAR,
  "verbatimcoordinatesystem" VARCHAR,
  "verbatimsrs" VARCHAR,
  "coordinateuncertaintyinmeters" DOUBLE,
  "locationid" VARCHAR,
  "locationremarks" VARCHAR,
  "eventid" VARCHAR,
  "occurrenceremarks" VARCHAR,
  "custom_airtemperatureincelsius" VARCHAR,
  "custom_watertemperatureincelsius" VARCHAR,
  "custom_weather" VARCHAR,
  "custom_ph" VARCHAR,
  "custom_eventstarttime" VARCHAR,
  "custom_eventendtime" VARCHAR,
  "custom_program" VARCHAR,
  "custom_recordid" BIGINT,
  "custom_trapnumber" VARCHAR,
  "custom_traptype" VARCHAR,
  "sex" VARCHAR,
  "custom_notchcode" VARCHAR,
  "custom_recapture" VARCHAR,
  "custom_sensitiverecord" BOOLEAN
);

Share link

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