Saint Croix National Scenic Riverway Invertebrate Data Package By The Great Lakes Inventory And Monitoring Network
Department of the Interior
@usgov.doi_gov_saint_croix_national_scenic_riverway_invertebr_97da3c54
Department of the Interior
@usgov.doi_gov_saint_croix_national_scenic_riverway_invertebr_97da3c54
CREATE TABLE glkn_inverts (
"abl_nps_lab_record_no" BIGINT,
"year" BIGINT,
"waterbody" VARCHAR,
"station_name" VARCHAR,
"station_id" VARCHAR,
"retrieval_date" TIMESTAMP,
"sample_type" VARCHAR,
"lab" VARCHAR,
"class" VARCHAR,
"order" VARCHAR,
"family" VARCHAR,
"subfamily" VARCHAR,
"genus" VARCHAR,
"subgenus" VARCHAR,
"species" VARCHAR,
"taxon_id_expert" VARCHAR,
"taxon_id_notes" VARCHAR,
"tsn_lookup" VARCHAR,
"tsn_source" VARCHAR,
"tsn" VARCHAR,
"larva" VARCHAR,
"pupa" VARCHAR,
"adult" VARCHAR,
"total" VARCHAR,
"tval" VARCHAR,
"tfunct" VARCHAR,
"ecoftn" VARCHAR,
"ecoftn_rheophilly" VARCHAR,
"ecoftn_thermal" VARCHAR,
"ecoftn_habit" VARCHAR,
"ecoftn_trophic" VARCHAR,
"taxonomic_reference" VARCHAR,
"condition" VARCHAR,
"notes" VARCHAR
);
CREATE TABLE glkn_inverts_geography (
"location" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE
);
Anyone who has the link will be able to view this.