Transcript GIS Tools for Non-Point Source Pollution Management

Web-Based GIS for Sediment
TMDL Implementation in the
Imperial Valley, California
University of Redlands
The Redlands Institute
Serene Ong
Nate Strout
Project Objectives and
Process
Presentation
Overview
Review Preliminary GIS
Database
Review prototype web-based
tools
Imperial Valley – Geographic Context
Los Angeles
Arizona
California
Palm Springs
Salton Sea
Colorado River
San Diego
U.S.
Mexico
Calexico
Mexicali
Tijuana
Pacific Ocean
Gulf of California
Watershed Assessment
•6,257 fields
•1,406 miles of drainage
channels
•175 drain discharge
points
•100 miles of river
Whitewater River 7%
Other inflow 1%
•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
Alamo River 45%
Rainfall 3%
Agricultural Drains 8%
Agricultural runoff
New River 32%
Groundwater 4%
Urban runoff
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
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
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
•Incorporate data from various
agencies
Database Design
Objectives
•Comply with the State Water
Resources Control Board (SWRCB)
Surface Water Ambient Monitoring
Program (SWAMP) standards
•Support analysis and reporting
requirements
Database Development
Process
•
•
•
•
•
•
•
•
•
•
•
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
Stakeholder
Survey
Database Development
Process – Data Sources
Stakeholder
Survey
Data
Inventory and
Assessment
Over 300 Unique
Datasets Identified
Database Development
Process
Stakeholder
Survey
Sample
Frequency
Sample Method
Type
Subtype
Constituent/Parameter
Field Name
Units
Water extract
Hydrologic
Flow
Flow
Value_
cubic feet/sec
Location
Daily
Border
Daily
Border
Start Date
1943
Water extract
Hydrologic
Water Flow
Alamo at Inatl
Boundary in cubic m/scubic m/s
Water extract
Hydrologic
Water Flow
New at Inatl Boundary
in cubic m/s
cubic m/s
Water extract
Hydrologic
Flow
Discharged
Discharged
Water extract
Hydrologic
Flow
Flow (Monthly sum)
Monthly_Fl
Water extract
Physical/Chemical
Other
Accute Toxicity
Accute_Tox
Varies
Water extract
Physical/Chemical
General
Alkalinity
Alkalinity
Varies
Salton Sea
Water extract
Physical/Chemical
Nutrients
Ammonia
Ammonia
Varies
Salton Sea
Water extract
Organisms
Bacterial
Antero-cocci
Antero_Coc
Varies
Salton Sea
Water extract
Organisms
Other
Other Biology
Bio_Other
Varies
Salton Sea
Water extract
Physical/Chemical
Other
Biochemical Oxygen Demand
BOD
Varies
Salton Sea
Bot_Sed
Varies
cubic feet/sec
End Date
2004
Years Records
62
Features
56606
Reformatting
data for GIS
1947
2003
57
20576
4
1
1947
2003
57
20576
1
Salton Sea
1994
2005
12
4281
38
Salton Sea
1994
2005
12
4281
38
Salton Sea
1945
2000
55
1222
1222
1945
2000
55
1222
1222
1945
2000
55
1222
1222
1945
2000
55
1222
1222
1945
2000
55
1222
1222
1945
2000
55
1222
1222
Salton Sea
1945
2000
55
1222
1222
Coding flow
direction
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
Fixing errors in
spatial data
Water quality
data index
Creating basic
metadata
Data
Inventory and
Assessment
Data
Compilation/
Conversion
Database Development
Process
Conceptual Database Schema
Stakeholder
Survey
Data
Inventory and
Assessment
Data
Compilation/
Conversion
Database
Design/
Development
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
Schema diagram
Cadastral Owner Operator
Agricultural
Practices
Hydrology Network
Features
Water Quality
Analysis
Database Development
Process
Stakeholder
Survey
Load Duration
Curves
Data
Inventory and
Assessment
Time Series
Animations
Data
Compilation/
Conversion
TSS and
Turbidity
Trends
Database
Design/
Development
GIS Database
Poster
Analysis and
Visualization
Products
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
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
Next Steps
Process for
data update
and
maintenance
Policies for
data sharing/
reporting and
security
Feedback and
refinement of
draft GIS
Web-GIS
deployment/
testing
Web-based
GIS and TMDL
analysis tools
Training and
hand-over to
long-term
steward
Document
future data
and analysis
needs
Outreach/
training
materials
Thank you
http://www.institute.redlands.edu/ivsdi
Serene Ong
[email protected]
Nathan Strout
[email protected]