Herpetofauna Inventory At Buck Island Reef National Monument In 2001 – Open Format Dataset
Department of the Interior
@usgov.doi_gov_herpetofauna_inventory_at_buck_island_reef_nat_ad25c521
Department of the Interior
@usgov.doi_gov_herpetofauna_inventory_at_buck_island_reef_nat_ad25c521
CREATE TABLE buis_herp_cleaned_public (
"locality" VARCHAR,
"type" VARCHAR,
"basisofrecord" VARCHAR,
"eventdate" TIMESTAMP,
"eventdate_flag" VARCHAR,
"scientificname" VARCHAR,
"scientificname_flag" VARCHAR,
"taxonrank" VARCHAR,
"vernacularname" VARCHAR,
"namepublishedin" VARCHAR,
"custom_taxonomicnotes" VARCHAR,
"recordedby" VARCHAR,
"decimallongitude" VARCHAR,
"decimallatitude" VARCHAR,
"coordinate_flag" VARCHAR,
"geodeticdatum" VARCHAR,
"verbatimcoordinates" VARCHAR,
"verbatimcoordinatesystem" VARCHAR,
"verbatimsrs" VARCHAR,
"coordinateuncertaintyinmeters" BIGINT,
"lifestage" VARCHAR,
"sex" VARCHAR,
"verbatimlocality" VARCHAR,
"stateprovince" VARCHAR,
"point_id" VARCHAR,
"samplingprotocol" VARCHAR,
"occurrenceremarks" VARCHAR,
"order" VARCHAR,
"family" VARCHAR,
"genus" VARCHAR,
"specificepithet" VARCHAR,
"infraspecificepithet" VARCHAR,
"scientificnameauthorship" VARCHAR,
"establishmentmeans" VARCHAR,
"eventremarks" VARCHAR,
"custom_speciescode" VARCHAR,
"custom_sensitiverecord" BOOLEAN,
"custom_captureid" BIGINT,
"custom_snouttoventlengthinmm" BIGINT,
"custom_substrate" VARCHAR,
"informationwithheld" VARCHAR,
"datageneralizations" VARCHAR,
"footprintwkt" VARCHAR
);
Anyone who has the link will be able to view this.