1 / 23

Web-Based GIS for Sediment TMDL Implementation in the Imperial Valley, California

Web-Based GIS for Sediment TMDL Implementation in the Imperial Valley, California. University of Redlands The Redlands Institute Serene Ong Nate Strout. Presentation Overview. Project Objectives and Process Review Preliminary GIS Database Review prototype web-based tools.

nida
Download Presentation

Web-Based GIS for Sediment TMDL Implementation in the Imperial Valley, California

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Web-Based GIS for Sediment TMDL Implementation in the Imperial Valley, California University of Redlands The Redlands Institute Serene Ong Nate Strout

  2. Presentation Overview Project Objectives and Process Review Preliminary GIS Database Review prototype web-based tools

  3. Imperial Valley – Geographic Context Arizona Los Angeles California Palm Springs Salton Sea Colorado River San Diego Calexico U.S. Mexicali Mexico Tijuana Pacific Ocean Gulf of California

  4. Watershed Assessment • •6,257 fields • •1,406 miles of drainage • channels • •175 drain discharge • points • •100 miles of river • •500 square miles of • surface area of the Salton • Sea (326,000 acres) • No outlet from the Salton Sea • State implemented TMDL for TSS of 200 mg/L in 2001/02 Whitewater River 7% Other inflow 1% Alamo River 45% Agricultural runoff Rainfall 3% Agricultural Drains 8% New River 32% Groundwater 4% Urban runoff

  5. Stakeholders • State Water Resources Control Board (SWRCB) • Regional Water Quality Control Board (RWQCB) • Imperial Irrigation District (IID) • Imperial County Farm Bureau (ICFB) • Communities and wildlife around Imperial Valley and Salton Sea

  6. Project Objectives Anticipated Outcomes • Support SWRCB, RWQCB, IID and ICFB with sediment TMDL implementation and compliance. • Provide better access to water quality and farm practices data. • Develop GIS database and web map application, custom query and report tools • More efficient use of existing information • Increased use of monitoring and related data for TMDL management/research • Standard methods for collecting, formatting and reporting water quality related data

  7. Database Design Objectives • Incorporate data from various agencies • Comply with the State Water Resources Control Board (SWRCB) Surface Water Ambient Monitoring Program (SWAMP) standards • Support analysis and reporting requirements

  8. Database Development Process Stakeholder Survey • Bureau of Reclamation • Department of Pesticide Regulation • California Department of Water Resources • State Water Resources Control Board • Imperial County Agricultural Commission • Imperial County Farm Bureau • Imperial Irrigation District • International Boundary and Waters Commission • Regional Water Quality Control Boards (3, 5, 7) • Salton Sea Authority • University of California Davis Cooperative Extension

  9. Database Development Process – Data Sources Stakeholder Survey Data Inventory and Assessment Over 300 Unique Datasets Identified

  10. Database Development Process Stakeholder Survey Data Inventory and Assessment Reformatting data for GIS Coding flow direction Data Compilation/ Conversion Fixing errors in spatial data Water quality data index Creating basic metadata

  11. Database Development Process Stakeholder Survey Conceptual Database Schema Data Inventory and Assessment Data Compilation/ Conversion Database Design/ Development

  12. Making a Database Compliant • Obtain the data • Process the data • Code flow direction, map field names and data types to SWAMP standard fields and data types • Crosswalk data from various tables • Include all required SWAMP tables and fields • Create links and relationships among tables

  13. Schema diagram Cadastral - Owner - Operator Hydrology Network Features Water Quality Analysis Agricultural Practices

  14. Database Development Process Stakeholder Survey Data Inventory and Assessment Load Duration Curves Data Compilation/ Conversion Time Series Animations TSS and Turbidity Trends Database Design/ Development GIS Database Poster Analysis and Visualization Products Statistical analysis of BMP-TSS relationships

  15. GIS Database Orientation

  16. Hydrology Features • Schema based on NHD • Compilation of Imperial Irrigation District (IID) and NHD linework • Rivers • Canals • Drains • Flow Direction

  17. Agricultural Features • Gates • Inflow point • Tailwater Boxes • Runoff point to drain • Plot delineation • Land fed by a single gate

  18. Monitoring Stations • Location Sources: • RWQCB:Region 7 • SWAMP • Imperial Irrigation District (IID) • USGS (flow)

  19. Drainsheds • Collection of plots monitored by a single RWQCB water quality monitoring station

  20. Agricultural Practice Information • Reported by farmers to Imperial County Farm Bureau under the ICFB Voluntary TMDL Compliance Program • Owner & operator information • Best Management Practices (BMPs) • Crop types • NPS problems • Site conditions For more information on the TMDL Compliance Program please visit http://www.ivtmdl.com/

  21. http://www.institute.redlands.edu/ivsdi • Technical Details: • Application developed using ArcGIS Server.NET Web ADF 9.2 • Data stored in ArcSDE 9.2 on SQL Server 2005 • *This is a Beta application Demo of Web-based GIS and reporting tools

  22. Next Steps Process for data update and maintenance Policies for data sharing/ reporting and security Web-GIS deployment/ testing Web-based GIS and TMDL analysis tools Outreach/ training materials Feedback and refinement of draft GIS Training and hand-over to long-term steward Document future data and analysis needs

  23. Thank youhttp://www.institute.redlands.edu/ivsdi Serene Ong serene_ong@redlands.edu Nathan Strout nathan_strout@redlands.edu

More Related