Indiana Water Quality Atlas: Integration of LTHIA and AIMS Data

1. Indiana Water Quality Atlas LTHIA Integrationhttp://iwqa.idem.in.gov/ John Buechler February 19,2008

2. Indiana Water Quality Atlas • Partners • The Polis Center at IUPUI • Center for Advanced Applications of Geographic Information Systems (CAAGIS) • Indiana Department of Environmental Management • Primary Audience • Watershed Managers • Resource Managers (IDEM, NRCS) • General Public • Funding • IDEM – EPA 319 Grant

3. What is the IWQA? • Web Implementation of the Assessment Information Management System (AIMS) • Web Visualization of AIMS data • Graphing of AIMS data • Download of AIMS data • Integrated Watershed Modeling tool • Watershed Delineation • LTHIA • Other CAAGIS capabilities

4. IWQA ESRI ArcIMS Services Services IWQA State and Federal Data Access State of Indiana MIddleware Web GUI(s) Indiana Department of Environmental Management IDEM IDEM Water Quality Data (AIMS) Indiana University Statewide Orthophotography Purdue University LTHIA Output

5. IWQA Middleware • Use of registry services for identification of available web data services and connection to identified ArcIMS data and mapping servers • Identification and selection of desired data and mapping services and selection of individual raster and vector layers for display • Re-projection on-the-fly of both vector and raster layers • Individually reordering of the overlay of vector and raster layers • Querying of distributed vector layers

6. Server Registry

7. Individual Layer Rendering

8. Assessment Information Management System Assessment Branch Office of Water Quality Indiana Department of Environmental Management

9. VISIONProvidewater quality information anddevelopthe environmental indicators that provide information necessary toprotecthuman health and the environment in Indiana MISSIONImplementa surface water quality monitoring strategythatassessesthe quality of Indiana surface water and its abilityto support designated uses, and effectivelycommunicatethis information to internal and external customers Surface Water Quality Monitoring Strategy

10. Water Quality Monitoring Sites Represented in the AIMS Database

11. MACROINVERTEBRATE COMMUNITY 1990 Macroinvertebrates 1991 Macroinvertebrates 1992 Macroinvertebrates 1993 Macroinvertebrates 1994 Macroinvertebrates 1995 Macroinvertebrates 1996 Macroinvertebrates 1997 Macroinvertebrates 1998 Macroinvertebrates 1999 Macroinvertebrates 2000 Macroinvertebrates 2001 Macroinvertebrate 2002 Macroinvertebrates SOURCE ID 2000 Big Raccoon Creek Source ID 2000 Brouilletts Creek Source ID 2000 Busseron and Buck Creek 2000 Iroquois Source ID 2000 Kankakee River Bio Imparirment Source ID 2000 Little Raccoon Creek Source ID Study 2000 Otter Creek Source ID 2000 Source ID Dausman Ditch 2000 Source ID East Branch Stoney Run 2000 Source ID Rowan Ditch Tributary 2000 Source ID Thompson/Rowen Ditches 2000 Sugar Creek Source ID at Earl Park 2000 Williams Creek Source ID 2000 Williams Ditch Source ID 2000 Yeoman Ditch Source ID 2001 Blue Creek Source ID 2001 Fish Creek Source ID 2001 Laughery Creek Source ID 2001 Little Pigeon Creek Source ID 2001 Little Sandy Creek Source ID 2001 Miller Fork Source ID 2001 Sugar Creek in Pike County 2001 Yankee Creek Source ID 2001 Yellow Creek Source ID Data Sets (Projects) in AIMS11/13/2002 TMDL -continued 2001 Beanblossom Creek 2001 Cicero Creek Assessment 2001 Conneley Ditch TMDL e.coli 2001 Duck Creek TMDL 2001 Eagle Creek TMDL Assessment 2001 Eel River TMDL 2001 Indian Creek Assessment 2001 Kessinger Ditch Assessment 2001 Killbuck Creek TMDL 2001 Kokomo Creek TMDL Monitoring 2001 Lambs Creek 2001 Lick Creek TMDL 2001 Little Pigeon Creek Assessment 2001 Mather Ditch 2001 Mill Creek upstream of US 40 Assessment 2001 Mud Creek and Orland Ditch Assessment 2001 Orland Ditch Assessment 2001 Pipe Creek TMDL 2001 Plummer Creek Assessment 2001 Richland Creek Assessment 2001 Stony Creek Assessment 2001 W F White R Muncie to Madison Co Assessment 2001 W Fk White River in Hamilton Co Assessment 2001 W fk White River in Madison County 2001 Wabash and Erie Canal TMDL 2001 WF White River White Lick to Buckhall Boat 2001 WF White River White Lick to Buckhall Bridges 2001 WFWR L. Buck Cr.-Wht. Lick Cr. TMDL Asses. 2002 Big Blue R/Rays Crossing Assessment 2002 Clifty Creek Assessment 2002 East Fork Whitewater River TMDL Assessment 2002 First Creek Assessment 2002 Flatrock River E. coli TMDL 2002 Kokomo Creek Assessment Sampling 2002 Mud Creek and Orland Ditch Assessments 2002 Pigeon Creek Assessment 2002 Prairie Creek Assessment 2002 Sugar Creek E.coli 2002 Tiernan Ditch DO (re-sample) 2002 Youngs Cr TMDL Assessment E. COLI 1998 E. coli 1998 USGS E coli 1999 E Coli 1999 USGS E coli 2000 E Coli 2000 USGS E coli 2000 Yellow River E. Coli, Bremen 2001 E. coli -Patoka and Lower WFWR 2001 E. coli-Upper WFWR 2001 E.coli Upper WFWR below Indy 2001 E.coli-Lower WFWR and Eel 2002 E. coli in E.F. White River 2002 E. coli in Whitewater River 2002 E. coli Muscatatuck and Upper EF WR FISH TISSUE 1999 Fish Tissue 2000 Fish Tissue 2001 Fish Tissue 2002 Fish Tissue FIXED STATION 1990 Fixed Station 1991 Fixed Station 1992 Fixed Station 1993 Fixed Station 1994 Fixed Station 1995 Fixed Station 1996 Fixed Station 1997 Fixed Station 1998 Fixed Station 1999 Fixed Station 2000 Fixed Station 2000 Fixed Upstream-Downstream 2001 Fixed Station 2001 Fixed Station Upstream-Downstream 2002 Fixed Station QUALITY ASSURANCE 2000 Field Blank contaminationInvestigation 2002 Lab Water Quality FISH COMMUNITY 1996 FishComm 2000 FishComm SPECIAL STUDIES 2000 Eagle Creek Reservoir 2000 Hartford City 2000 Indy White Rive 2000 Montgomery Ditch 2000 Morgan Foods, Austin 2001 Anderson WWTP 2001 Belmont Study 2001 Morgan Foods, Austin 2001 Wildcat Creek Fish Kill Investigation 2001 William Baker/Shatto Ditch 2002 Clean Sampling and Ultra-Clean Analyses 2002 Greensburg Reservoir 2002 Marsh Lake Conductivity Study 2002 McCormicks Creek School 2002 Morgan Foods, Austin 2002 Rose Acres Farm, Jenn Acres Fac.,Jennings Cty 2002 South Dearborn RSD 2002 Tippecanoe Co. YOCW WQ Monitoring Day 2002 Warsaw WWTP / Walnut Cr Assessment Wolcottville MWTP WLA Verification TMDL 1998 Wildcat 1998 Wildcat Sediments 1999 Cobb Creek/Breyfogel Ditch TMDL 1999 Pine Creek TMDL 1999 Wyatt Ditch 2000 Blue Creek Assessment 2000 Burns Ditch TMDL Assessment 2000 Cedar Creek E. Coli Assessment1 2000 Crawford Ditch Assessment 2000 Cypress Creek Assessment 2000 East Branch Little Calumet River 2000 Garrett City Ditch Assessment 2000 Habegger Ditch Assessment 2000 Little Pigeon Creek Assessment 2000 Lower Elkhart River Assessment 2000 Mather Ditch TMDL 2000 Mud Creek Assessment 2000 Orland Tributary TMDL 2000 Pigeon Creek Assessment 2000 Salt Creek Assessment 2000 Schwartz-Carnahan Ditch Assessment 2000 St. Joseph River 2000 Tiernan Ditch Assessment 2000 Trail Creek Assessment WATERSHED 1996 Synoptic 1996 Watershed 1997 Synoptic 1997 Watershed 1998 Watershed 1999 Watershed 1999 Watershed Extra Site 1999 Watershed Paired Study 2000 Corvallis 2001 Corvallis 2001 Corvallis Biological 2001 Watershed Extra Site 2002 Corvallis PESTICIDES 1997 Pesticides 1998 Pesticides 1999 Pesticides 2000 Pesticides 2001 Pesticides SEDIMENTS 1999 Sediments 2000 Sediment Bio 2001 Sediment Bio 2002 Sediment Bio

13. AIMS GIS Visualization

14. AIMS GIS Visualization

15. AIMS GIS Visualization

16. Watershed Modeling Integration Identify watershed outlet point O

17. Watershed Modeling Integration Identify watershed outlet point O

18. Watershed Modeling Integration

19. Watershed Modeling Integration

20. Watershed Modeling Integration Identify watershed outlet point O

21. Graph AIMS Data

22. Graph AIMS Data

23. AIMS Download

24. What’s Next? • Future initiatives • INTERCAMPUS APPLIED RESEARCH PROGRAM (IARP) • Deployment of Water Quality Decision Support Tools Using Service Oriented Architecture (SOA) and Web 2.0 Development Approach The Modeling results will be displayed over streaming map data from servers at government ( http://gos2.geodata.gov - the National Map ) or commercial sites (maps.google.com).