US Long-Term Ecological Research Network
Please select what columns you would like to include from Wisconsin Lake Plants Database - AQUAPLT2 - Macrophyte Sample Data
Column Definition Unit
mwbc Master Water Body Code; If the MWBC begins with M the water body is the Mississippi River. The number after the M refers to the river mile. Data source is USGS Biological Resources Division Onalaska WI
lake_unique lake identification code; Code used based on old General Waters File lake identification by Wisconsin DNR. The first two numbers are county identification from 1-72 alphabetically. The remaining numbers are lake identification within the county generally alphabetical.
lakename lake name
county name of county (WI)
county_id county id number; assigned alphabetically 1=Adams 72=Wood 0=Miss River
month month of the year nominalMonth
year4 year nominalYear
spcode macrophyte species code; Generally consists of the first 3 letters of the genus and first 2 letters of the species. If the first 5 letters of two species are identical a 6th letter is added.
aqstano unique number assigned to each sampling point; Generally a combination of the transects number and then the quadrat number along that transect
visual_abundance plant abundance at sampling point; Based on a 1-5 rating system following Wisconsin DNR protocol originally based on the criteria of Jesson and Lound 1962
Please choose any filters you would like to add.