Wisconsin DNR received a grant to migrate its biological and habitat grant to the Water Quality Exchange WQX Network.
| Support macroinvertebrate fieldwork and results through hosting in SWIMS and sharing on the WQX. |
Location coordinates for macro-invertebrate sampling sites of high and documented quality. |
12/07 |
DONE
(Ongoing)
|
The ability to geospatially relate water quality information with aquatic macro-invertebrate information
This item is ongoing as results flow into SWIMS. Biologists trained to use the system to geolocate bug monitoring locations and UWSP modified its tables to accept the necessary data. |
Aquatic macroinvertebrate data available through SWIMS |
12/07 |
DONE
|
Important in-situ biological metrics available for environmental analysis
UI queries on fieldwork events, individual parameter results, and oracle discoverer queries now available. |
Macroinvertebrate Metric Calculation from individual species count data
(in-house calculation rather than external calculation and migration) |
6/08 |
Not Started |
Program all bug metric calculations for all parameters that we currently display in SWIMS from Stevens Point.
Necessary to assume all data support functions in SWIMS. |
Analyze, set parameters and map associated habitat and physical data from bug surveys into SWIMS. |
6/08 |
Not Started |
Data associated with bug fieldwork should be migrated to “field results” are of fieldwork events and incorporated as part of the routine data migration program. |
Work with UWSP to modify processes so that SWIMS receives individual results (bugs, physical and habitat) and the data is entered one time only (rather than flowing the data) |
10/08 |
Not Started |
Coordination, training and cooperative process design work in progress but end result not anticipated until FY09. |
Send bug and associated habitat data to the WQX as project data. |
12/08 |
Started |
Pilot work on WQX Bug/Habitat Schema; will wait for MN outcome to learn from their experience. |
| Enhance SWIMS WQX flow with habitat data and summary metrics |
Analysis and design of moving habitat data to WQX. |
09/08 |
Not Started |
In WI, three levels of habitat data exist: a) data associated with bug surveys; b) qualitative surveys, and c) quantitative surveys. Strategic analysis and planning to design a data flow/sharing procedure for habitat data will be developed with bug survey related habitat data “paving the way”. |
Habitat data and summary metrics are maintained in SWIMS or Fish DB and web services are enabled to DNR oracle tables - and exchanged through new WQX data flow. |
12/08 |
Not Started |
Design of webservices set up to allow flow of data from Fish DB habitat data (where quantitative and qualitative data is stored) to DNR Oracle servers and/or WQX. |
WI HUC data analyzed, adopted and incorporated into enterprise data tables. |
09/09 |
04/08
DONE |
Data standards promote high data quality
HUC data has been written up and adopted by Water Division managers; DNRSDE enterprise feature classes have been created (BTS) and Oracle HUC Tables created and soon to be migrated into the enterprise table structure.
|
SWIMS and other systems include HUCs as GIS and tabular data |
09/09 |
Not Started |
Important connectivity for state and federal partnerships based on data and assessment tools.
|
Report on custodial framework. |
09/09 |
Ongoing |
Partnership with USGS, USFS, and EPA in important connectivity between DNR and NHD.
Ongoing communication in place regarding analysis and design of GEO Database Framework (NHD) and elements to be adopted by the WI 24K Hydrography database design. |
Analysis and design of master waterbody table to hold NHD elements and provide a linkage to Wisconsin datasets and the NHD identifiers. |
09/09 |
Ongoing |
Pilot work for master waterbody table is in place. Discussions are ongoing and design and implementation work anticipated for FY09. |
