Bighorn Canyon National Recreation Area Herpetological Inventory 2001-2002- Data Package
Department of the Interior
@usgov.doi_gov_bighorn_canyon_national_recreation_area_herpet_3182c2af
Department of the Interior
@usgov.doi_gov_bighorn_canyon_national_recreation_area_herpet_3182c2af
Reptiles and amphibians serve as indicators of ecosystem health, but populations are declining in many natural areas. Frequent inventories of species are important for keeping track of population numbers and determining if intervention is needed. In the summers of 2001 and 2002 a reptile and amphibian inventory was conducted in the Bighorn Canyon National Recreation Area (BICA). Prior to this study two herpetological inventories had been conducted in BICA and provided baselines for this study to be compared against. There were three goals of the 2001-2002 study. First, inventory at least 90% of the amphibian and reptile species in BICA. Second, implement random sampling surveys to assess occurrence, distribution, relative abundance, and species-habitat associations. Third, compare survey results with the previous inventory work. From this inventory there were 364 observations of reptiles and amphibians with 15 species then considered to be present in BICA.
Organization: Department of the Interior
Last updated: 2025-09-14T20:53:55.635024
Tags: amphibian, bighorn-canyon, habitat-relationships, herpetology, occurrence, relative-abundance, reptile, trapping, visual-encounter-survey
CREATE TABLE bica_herps (
"locality" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR,
"eventtime" VARCHAR,
"eventdate" TIMESTAMP,
"eventdate_flag" VARCHAR,
"scientificname" VARCHAR,
"scientificname_flag" VARCHAR,
"taxonrank" VARCHAR,
"verbatimidentification" VARCHAR,
"vernacularname" VARCHAR,
"custom_scientificnameabbreviation" VARCHAR,
"namepublishedin" VARCHAR,
"custom_taxonomicnotes" VARCHAR,
"recordedby" VARCHAR,
"decimallatitude" VARCHAR,
"decimallongitude" VARCHAR,
"coordinate_flag" VARCHAR,
"geodeticdatum" VARCHAR,
"verbatimcoordinates" VARCHAR,
"verbatimcoordinatesystem" VARCHAR,
"verbatimsrs" VARCHAR,
"coordinateuncertaintyinmeters" VARCHAR,
"verbatimelevationinmeters" VARCHAR,
"georeferenceprotocol" VARCHAR,
"samplingprotocol" VARCHAR,
"habitat" VARCHAR,
"locationid" VARCHAR,
"occurrenceremarks" VARCHAR,
"custom_cloudcoverinpercent" VARCHAR,
"custom_sunradiation" VARCHAR,
"custom_windspeedinknots" VARCHAR,
"custom_temperatureindegreescelsius" VARCHAR,
"temperature_flag" VARCHAR,
"custom_sensitiverecord" BOOLEAN
);CREATE TABLE bica_herps_trapping (
"locality" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR,
"custom_eventstartdate" TIMESTAMP,
"custom_eventenddate" TIMESTAMP,
"scientificname" VARCHAR,
"scientificname_flag" VARCHAR,
"taxonrank" VARCHAR,
"verbatimidentification" VARCHAR,
"namepublishedin" VARCHAR,
"custom_taxonomicnotes" VARCHAR,
"individualcount" BIGINT,
"occurrenceremarks" VARCHAR,
"decimallatitude" DOUBLE,
"decimallongitude" DOUBLE,
"coordinate_flag" VARCHAR,
"geodeticdatum" VARCHAR,
"verbatimcoordinates" VARCHAR,
"verbatimcoordinatesystem" VARCHAR,
"verbatimsrs" VARCHAR,
"coordinateuncertaintyinmeters" BIGINT,
"verbatimelevationinmeters" VARCHAR,
"locationid" VARCHAR,
"locationremarks" VARCHAR,
"habitat" VARCHAR,
"custom_numberoftrappingdays" BIGINT,
"samplingprotocol" VARCHAR,
"custom_sensitiverecord" BOOLEAN
);CREATE TABLE bica_herps_ves (
"locality" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR,
"custom_eventstarttime" VARCHAR,
"custom_eventendtime" VARCHAR,
"eventdate" TIMESTAMP,
"eventdate_flag" VARCHAR,
"scientificname" VARCHAR,
"scientificname_flag" VARCHAR,
"taxonrank" VARCHAR,
"verbatimidentification" VARCHAR,
"namepublishedin" VARCHAR,
"custom_taxonomicnotes" VARCHAR,
"recordedby" VARCHAR,
"individualcount" BIGINT,
"occurrenceremarks" VARCHAR,
"decimallatitude" DOUBLE,
"decimallongitude" DOUBLE,
"coordinate_flag" VARCHAR,
"geodeticdatum" VARCHAR,
"verbatimcoordinates" VARCHAR,
"verbatimcoordinatesystem" VARCHAR,
"verbatimsrs" VARCHAR,
"coordinateuncertaintyinmeters" BIGINT,
"locationid" VARCHAR,
"habitat" VARCHAR,
"custom_sensitiverecord" BOOLEAN
);Anyone who has the link will be able to view this.