A series of 760 points (each representing a specific lake described in WSB43) were created and moved to correspond with the DNR Hydro polygon layer. Each point was given a value in the DNR_CD field to describe the accuracy of the match. By virtue of the point being within the boundaries of the appropriate polygon, users can create a spatial join or other spatial overlay that will allow them to apply the attributes of the WSB43 to their polygon hydro layer of choice.
There are six tables that relate to the main GIS feature class attribute table (wsb43_points) using the WSB43_CD field. The wsb43_main and wsb43_wq1 tables have separate metadata describing only the attributes and their definitions. Since the other wsb43_wq* tables share the same attribute definitions as the wsb43_wq1 table, metadata for wsb43_wq1 can be applied to the other water quality tables. The following is a summary of the related tables and what they contain:
1) wsb43_main: Contains the information that appears in the physical data, cultural data, and remarks sections of WSB43. 2) wsb43_wq1: Contains the water quality data for sample site 1 (if present). 3) wsb43_wq2: Contains the water quality data for sample site 2 (if present). 4) wsb43_wq3: Contains the water quality data for sample site 3 (if present). 5) wsb43_wq4: Contains the water quality data for sample site 4 (if present). 6) wsb43_wq5: Contains the water quality data for sample site 5 (if present).
While Philip Bloch is the primary contact for this dataset, Chris Snyder (WADNR) is avalable to answer questions about technical methodology. His email is chris.snyder@wadnr.gov.