Xlakes_master_lakeinfo.xls created October 13 2004 by Anna Sugden-Newbery, who was advised by monica turner and worked on the biocomplexity project. It combines data from five sources:
1. WILakesfromKWebster.xls (details below) - A spread sheet with general characteristics of lakes including Vilas County lakes.
2. Big_lakes.shp which was created from the coverage vilas_lakes (metadata available from LTER) by selecting all polygons with an area greater than 100 acres and manually removing polygons in the resulting shapefile that looked like rivers or non-natural lakes (eg squares and rectangles near round lake).
3. Big_lake_buff-with_attributes which contains 100 m buffers around all of the lakes in big_lakes.shp with all of the attributes from big_lakes.shp added in.
4. Vilas_buildings is a point coverage containing the locations of all buildings in vilas county, based on a 1996 air photo. Metadata available from LTER spatial data archive. Based on Jill Schnaiberg's (Schnaiberg, J., et al., Explaining Human Settlement Patterns in a Recreational Lake District: Vilas County, WI USA. Environmental Management, 2002. 30(1): p. 24-34.) description of this data set, I believe that "FTYPE" relates to the size of the building, and based on the relative abundance she reported for each type I believe FTYPE 2011= small (0-1000 sq ft) ,2012= medium (1000 - 3000 sq ft) and 2013 = large buildings (> 3000).
5. wetland_lengths.xls is a spreadsheet exported from arcview and used to calculate the length of shoreline in wetland.
62 lakes were sampled for the cross-lake comparison project. Nominally the selection criteria for these lakes were 100 acres in size and 14 ft deep. However, some lakes are smaller than that and thus don't have any data in the worksheet "big_vilas_lakes".
Data for Johnson Lake, Arrowhead lake, Camp Lake, Nebish, Indian, Little Rock was pulled directly from WILakesfromKWebster.xls, vilas_lakes and buff_of_small_biocom_lakes.shp according to the methods for the larger lakes.
Area of the two basins of little rock lake was calculated by Michele Woodford using the original VCC coverages. Anna Sugden-Newbery calculated the area in acrea and hectares.
|
LAKEID - LTER database Lake abbreviation
|
a two letter code used for chemistry and fish data stored in the LTER Oracle database (does not always match LAKE ABR)
|
|
LAKE NAME
|
the Full name of each lake
|
|
LAKE #
|
a numeric code for each lake (internal to the biocom project)
|
|
LAKE ABR BIOCOM
|
A two or three letter code for each lake
|
|
WBIC
|
Water Body Indentification Code
|
|
LakeName_DNR
|
The DNR's official lake name
|
|
Lakename_local
|
An alternate lake name(s) used by locals.
|
|
County
|
Vilas for all these lakes
|
|
Twn_Range_Section
|
The Public Land Survey Township, Range and Section that the lake occurs in (handy for lakes with common names)
|
|
hydrology_type
|
Hydrology Type - from the wisconsin lakes book SE = Seepage lake no inlet no outlet; SP = spring lake no inlet, but an outlet - groundwater fed; DG drainage lakes with an inlet and an outlet; DN drained lakes with no inlet but an outlet - rain fed
|
|
DEPTH_MAX
|
Maximun depth of the lake in feet - from WILakesfromKWebster
|
|
DEPTH_MEAN
|
Mean depth of the lake in feet - from the wisconsin lakes book note: most lakes are missing this data. They're indicated with a 9999
|
|
Perimeter(km)
|
Perimeter of the lake in km, converted in excel using the formula km = feet/5280 * 1.6093
|
|
AREA
|
Area in hectares calculated in arcmap using xtools pro from the vilas_lakes coverage in the vcc projection
|
|
Secchi_biocom
|
Secchi depth in meters as measured in the field by the cross-lakes field crews (average of two values) data downloaded From the North Temperate Lakes LTER database at: Mon Oct 11 16:54:40 CDT 2004
|
|
Conductance_biocom
|
Specific conductance as measured in the field by the cross-lakes field crews (average of two values) data downloaded From the North Temperate Lakes LTER database at: Mon Oct 11 16:54:40 CDT 2004
|
|
Cond quint
|
1 = 0 - 29 µmohs; 2 = 29-59 µmohs; 3 = 29 - 77 µmohs; 4= 77-90 µmohs and 5 = 90-178 µmohs. values equal to the cut-off were labeled as the lower category
|
|
Lake_Access
|
In 2003 half of the lakes we sampled had no public boat landing (aka "private") all lakes sampled in other years had public access
|
|
WET_LENGTH
|
From the worksheet "Wetland_lengths.xls" the length in meters of shoreline that is wetland according to S. Gergel's wetland data
|
|
WET%
|
same as above, as a percent of the total shoreline
|
|
Build2011
|
The number of Buildings with FTYPE= 2011 which fall within the 100 m buffer around a given lake. Buildings in two or more buffers are counted for each buffer they occur in. Calculated using "Count Points in Polys" tool in Hawth's Analysis Tools version 2.10 (contact hawthorne bayer - hawthorne@spatialecology.com - for more info)
|
|
Build2012
|
Number of Buildings with FTYPE= 2012 in the buffer calculated as above.
|
|
Build2013
|
Number of Buildings with FTYPE = 2013 in the buffer calculated as above
|
|
Number_Buildings
|
The total number of buildings inside the buffer, should equal the sum of previous three columns
|
|
Building_Per_km
|
"Number of buildings" divided by "Perimeter (km)"
|
|
Building_Per_km_quintile
|
1 = 0 - 2.65; 2 = 2.65-6.17; 3= 6.17- 10.56; 4 = 10.56-16.03; 5 = 16.03-40.9 buildings/km. values equal to the cut-off were labeled as the lower category
|
LTER Keywords
Protocol Format
Process
Protocol ID
biocom_additional_metadata1
Protocol Type
field
