Fisheries Inventory, Trout Data, At Rocky Mountain National Park 2021-2022 - Open Format Dataset
Department of the Interior
@usgov.doi_gov_fisheries_inventory_trout_at_rocky_mountain_na_e19e1e7e
Department of the Interior
@usgov.doi_gov_fisheries_inventory_trout_at_rocky_mountain_na_e19e1e7e
CREATE TABLE romofish_troutdata_occurrence (
"occurrenceid" VARCHAR,
"eventid" VARCHAR,
"basisofrecord" VARCHAR,
"taxonid" VARCHAR,
"scientificname" VARCHAR,
"recordedby" VARCHAR,
"individualcount" BIGINT,
"organismquantity" BIGINT,
"organismquantitytype" VARCHAR,
"occurrencestatus" VARCHAR,
"publicdisplay" VARCHAR,
"dataaccess" VARCHAR,
"pass" VARCHAR,
"length" VARCHAR,
"mass" VARCHAR,
"geneticssampled" VARCHAR,
"occurrenceremarks" VARCHAR
);
CREATE TABLE romofish_troutdata_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
);
Anyone who has the link will be able to view this.