Web-Based GIS for Sediment TMDL Implementation in the

Imperial Valley, California

University of RedlandsThe Redlands Institute

Serene OngNate Strout

Presentation Overview

Project Objectives and Process

Review Preliminary GIS Database

Review prototype web-based tools

Los Angeles

San Diego

Tijuana

Mexico

U.S.

Pacific Ocean

Gulf of California

Palm Springs

Arizona

California

Colorado River

Salton Sea

Calexico

Mexicali

Imperial Valley – Geographic Context

Groundwater 4%Urban runoff

Agricultural runoffRainfall 3%

Whitewater River 7%Other inflow 1%

Alamo River 45%

New River 32%

Agricultural Drains 8%

Watershed Assessment•6,257 fields•1,406 miles of drainagechannels•175 drain dischargepoints•100 miles of river

•500 square miles ofsurface area of the SaltonSea (326,000 acres)• No outlet from the Salton

Sea• State implemented TMDL

for TSS of 200 mg/L in 2001/02

• 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

Stakeholders

Anticipated Outcomes• 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

Project Objectives• 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

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

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

Database Development Process – Data Sources Stakeholder

Survey

Data Inventory and Assessment

Over 300 Unique Datasets Identified

Database Development Process Stakeholder

Survey

Data Inventory and Assessment

Data Compilation/ Conversion

Sample Method Type Subtype Constituent/Parameter Field Name UnitsSample Frequency Location Start Date End Date Years Records Features

Water extract Hydrologic Flow Flow Value_ cubic feet/sec 1943 2004 62 56606 4

Water extract Hydrologic Water FlowAlamo at Inatl Boundary in cubic m/s cubic m/s Daily Border 1947 2003 57 20576 1

Water extract Hydrologic Water FlowNew at Inatl Boundary in cubic m/s cubic m/s Daily Border 1947 2003 57 20576 1

Water extract Hydrologic Flow Discharged Discharged Salton Sea 1994 2005 12 4281 38

Water extract Hydrologic Flow Flow (Monthly sum) Monthly_Fl cubic feet/sec Salton Sea 1994 2005 12 4281 38

Water extract Physical/Chemical Other Accute Toxicity Accute_Tox Varies Salton Sea 1945 2000 55 1222 1222

Water extract Physical/Chemical General Alkalinity Alkalinity Varies Salton Sea 1945 2000 55 1222 1222

Water extract Physical/Chemical Nutrients Ammonia Ammonia Varies Salton Sea 1945 2000 55 1222 1222

Water extract Organisms Bacterial Antero-cocci Antero_Coc Varies Salton Sea 1945 2000 55 1222 1222

Water extract Organisms Other Other Biology Bio_Other Varies Salton Sea 1945 2000 55 1222 1222

Water extract Physical/Chemical Other Biochemical Oxygen Demand BOD Varies Salton Sea 1945 2000 55 1222 1222

Bot_Sed Varies Salton Sea 1945 2000 55 1222 1222

Water extract Pesticides Carbamates Carbamates Varies Salton Sea 1945 2000 55 1222 1222

Water extract Pesticides Chlorinated Herbicides Chlor_Herb Varies Salton Sea 1945 2000 55 1222 1222

Water extract Physical/Chemical Other Chronic Toxicity Chronic_TO Varies Salton Sea 1945 2000 55 1222 1222

Water extract Physical/Chemical General Water color Color Varies Salton Sea 1945 2000 55 1222 1222

Water extract Physical/Chemical Other Dissolved Carbon Dis_Carbon Varies Salton Sea 1945 2000 55 1222 1222

Water quality data index

Fixing errors in spatial data

Coding flow direction

Reformatting data for GIS

Creating basic metadata

Database Development Process Stakeholder

Survey

Data Inventory and Assessment

Data Compilation/ Conversion

Database Design/

Development

Conceptual Database Schema

• 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

Making a Database Compliant

Schema diagram

Water Quality Analysis

Hydrology Network Features

Agricultural Practices

Cadastral - Owner - Operator

Database Development Process Stakeholder

Survey

Data Inventory and Assessment

Data Compilation/ Conversion

Database Design/

Development

Analysis and Visualization

Products

Load Duration Curves

Time Series Animations

TSS and Turbidity Trends

GIS Database Poster

Statistical analysis of BMP-TSS

relationships

GIS Database Orientation

Hydrology Features• Schema based on

NHD• Compilation of

Imperial Irrigation District (IID) and NHD linework

• Rivers• Canals• Drains• Flow Direction

Agricultural Features

• Gates – Inflow point

• Tailwater Boxes– Runoff point to

drain• Plot delineation

– Land fed by a single gate

Monitoring Stations

• Location Sources:– RWQCB:Region 7– SWAMP– Imperial

Irrigation District (IID)

– USGS (flow)

Drainsheds

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

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/

Demo of Web-based GIS and reporting tools

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

http://www.institute.redlands.edu/ivsdi

Next Steps

Web-GIS deployment/

testing

Policies for data sharing/ reporting and

security

Outreach/ training

materials

Web-based GIS and TMDL analysis toolsFeedback and

refinement of draft GIS

Process for data update

and maintenance

Document future data and analysis

needs

Training and hand-over to

long-term steward

Thank you

http://www.institute.redlands.edu/ivsdi

Serene Ongserene_ong@redlands.edu

Nathan Stroutnathan_strout@redlands.edu