1 / 63

An Environmental Flows Information System for Texas

An Environmental Flows Information System for Texas. Eric S. Hersh The University of Texas at Austin Center for Research in Water Resources December 14, 2009 TCEQ. Outline. EFIS background, concept, and contents EFIS site: design and use Interactive Map Viewer Digital Repository

patsy
Download Presentation

An Environmental Flows Information System for Texas

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. An Environmental Flows Information System for Texas Eric S. Hersh The University of Texas at Austin Center for Research in Water Resources December 14, 2009 TCEQ

  2. Outline • EFIS background, concept, and contents • EFIS site: design and use • Interactive Map Viewer • Digital Repository • HydroPortal • Calculator for Low Flows • What’s Next • HydroDesktop

  3. Motivation “The State should be encouraged to mount a comprehensive review and digitization project to recover all of this data and make it available to stream ecologists and other scientists.” -Science Advisory Committee (2004) “With detailed ecological/environmental flow information for just one reach of one river, the ability of the TRG to fulfill its fundamental goal of evaluating the appropriateness of various desk-top methods, including the Lyons Method, for estimating environmental flow requirements for stream and ecological conditions across the State has, at the least, been substantially impaired.” -Technical Review Group (Draft, 2008) “All available data and study reports related to the hydrologic, biologic, geomorphic, water quality, and connectivity of the study area will be assembled.” -Texas Instream Flow Studies: Technical Overview (2008)

  4. Trinity/San Jacinto/Galveston BBEST NWF Meeting Summary, 2/27/09 Available Information and Knowledge Gaps “The BBEST acknowledged that the only complete data set for instream flows at their disposal is hydrologicaland therefore the geographic scope of their recommendations will be critical.”

  5. Background • Primary Goal: • data and integration to help TCEQ in establishing environmental flow requirements in Texas • Added Benefit: • Support for SB2/SB3 • Stakeholders, BBESTs, tri-agencies • Other efforts: • Bio data collection, basin lit reviews, SAC, HEFR/MBFIT

  6. Acknowledgements • TCEQ • CRWR: James Seppi, Tim, Whiteaker, Clark Siler, Stephanie Johnson, Bryan Enslein, Fernando Salas, Harish Sangireddy, Wendy Harrison, David Maidment • Cockrell School of Engineering – ITS (CRWR as a data center) • TWDB • CUAHSI • UTDR • TDL • Data providers

  7. EFIS Concepta diversity of disciplines and data types means no one solution • A blend of old & new technologies • A person interacting with a website and downloading a file • A PC interacting with a server, retrieving and analyzing data

  8. EFIS Concept (2) • A blend of GIS & HIS • Geographic Information Systems with geographic data models • Hydrologic Information Systems with relational data models • A “system of systems” Water Environment - Geospatial data layers • Water • - Observations data layers CUAHSI ODM and web services ArcGIS Geodatabase

  9. EFIS Contents • Four disciplines: • Hydrology • Water Quality • Biology • Geomorphology & Physical Processes Plus, • Tools & Guidance

  10. Point of departure: TCEQ ‘Wish List’

  11. EFIS Organization • Six information types: • Point observations data (eg: WaterML/ODM ) • Geographic (shapefile, feature class, KML, WFS/etc) • Documents (DSpace digital archive) • Tables (conservation status, guilds) • Tools (CALF, TSA, HydroExcel) • Links (Fishes of Texas, IHA, SAC)

  12. EFIS Use • Four access types: • Web Page • Interactive Map Viewer • Digital Library • HydroPortal

  13. EFIS Contributors (n = 25+) • State: TCEQ, TWDB, TPWD, TCOON, TIFP, TNRIS, TXDOT • Federal: USGS, EPA, NWS, USACOE HEC, NOAA, USFWS, NAS NRC • Academic: UT-CRWR, TAMU, TAMU-Galveston, TX State – San Marcos, TAMUCC, Univ. of New Orleans, Texas Natural History Museum, CUAHSI • NGO: WWF, TNC • River Authorities: SARA 97 components in all!

  14. http://efis.crwr.utexas.edu

  15. EFIS Demo • Interactive Map Viewer • Basemap from ESRI, Redlands, CA • Data from CRWR, Austin, TX • Additional data from TCOON and TAMUCC, Corpus Christi, TX • Tutorial for using SQL ODM databases • Digital Repository • HydroPortal • Calculator for Low Flows (CaLF) tool • Installation and use • About • BioODM, Controlled Vocabulary/Ontology • Contacts

  16. Harish Sangireddy, CRWR

  17. EFIS From Robert Vertessy, CSIRO, Australia Pre Conference Seminar

  18. What’s Next • More data (always!) • Finishing touches: • By Basin (thoughts?) • Upload User’s Manual and these slides • Environmental Flow Regimes project • Workflow for env. flows models (MBFIT, HEFR) • Extension of flow regime prescriptions from gaged to ungaged locations • HydroDesktop

  19. Internet operation for text-based information

  20. Services-Oriented Architecture for Water Data (2009)

  21. HydroDesktop – Access and Analyze Data

  22. HydroDesktop Demo Tim Whiteaker, CRWR • MapWindow GIS interface • Data search • From HIS Central • From HydroPortals

  23. (blank)

  24. Additional Information • CUAHSI water data services • Biological data: issues and examples • Texas Digital Libraries • BioODM • Texas water data services • Ontology for biological data

  25. Additional Information • CUAHSI water data services • Biological data: issues and examples • Texas Digital Libraries • BioODM • Texas water data services • Ontology for biological data

  26. CUAHSI Hydrologic Information System • 50 observation networks • 1.75 million sites • 342 million data values Mission: To enhance hydrologic science by facilitating user access to more and better data for testing hypotheses and analyzing hydrologic processes http://his.cuahsi.org NWIS STORET TCEQ

  27. CUAHSI Water Data Services 43 services 15,000 variables 1.8 million sites 9 million series 4.3 billion data

  28. Data Services • Data Loading • Put into the CUAHSI Observations Data Model • Data Publishing • Provide web services via WaterML • Data Indexing • Summarize in a centralized catalog • Data Discovery • Make it known to other users • Data Access • Provide the data to those users

  29. Horsburgh et al (2008)

  30. Publishing an ODM Water Data Service TPWD Coastal Fisheries Raw Data TWDB Coastline Raw Data TIFP Lower Sabine Ingest Data From Different Sources SQL Server Integration Services Transform Data into Uniform Format with SSIS Scripts WaterML Load Newly Formatted Data into ODM Tables in MS SQL/Server Observations Data Model (ODM) TPWD ODM TWDB ODM TIFP ODM Wrap ODM with WaterML Web Services for Online Publication

  31. Publishing a Hybrid Water Data Service TCOON Metadata are Transferred from XML to the ODM WaterML TCOON DataValues TCOON METADATA ODM Web Services can both Query the ODM for Metadata and use a Web Scraper for Data Values TCOON Water Data Service Metadata From: ODM Database in Austin Data From: TCOON Web Site in Corpus Christi http://lighthouse.tamucc.edu/TCOON/ GetSites GetSiteInfo Get Variables GetVariableInfo Calling the WSDL Returns Metadata and Data Values as if from the same Database Get Values http://his.crwr.utexas.edu/tcoonts/tcoon.asmx?WSDL

  32. Additional Information • CUAHSI water data services • Biological data: issues and examples • Texas Digital Libraries • BioODM • Texas water data services • Ontology for biological data

  33. GIS ESRI, TNRIS, etc

  34. Water Resources USGS, NWS, etc

  35. Aquatic Ecology Traditionally: You! Now: EFIS, etc

  36. -Sabine River: 165 samples were collected at 8 study reaches over 8 days of field work in 2006; 147 samples yielded fish -5,811 fish were observed, representing 58 species -each sample yielded an average of 40 fish Across all sites, 889 Centrarchids (sunfish, bass, and crappies) were observed with a relative abundance of 22% ± 24% (mean ± SD)

  37. -Three blue suckers (Cycleptus elongatus) observed; a state-listed threatened species -The only fish non-native to the Sabine River Basin observed was the inland silverside (Menidia beryllina). -192 silversides total, ranging from 0-90% of the sample population with a mean of 3% ± 12%

  38. Distribution: Originally found in coastal waters and upstream in coastal streams along the Atlantic and Gulf coasts; widely introduced into freshwater impoundments (Hubbs et al. 1991) http://www.bio.txstate.edu/~tbonner/txfishes/menidia%20beryllina.htm

  39. Inland Silverside Menidia beryllina Non-native species distribution

  40. Fishes of Texas Project Dean Hendrickson Texas Natural Science Center Univ. of Texas at Austin • 5,700 sites • 67,000 samples • 2,000,000 specimens • 34 institutions • 373 taxa • 1851-2006

  41. Percent non-native (170 of 2206 records, 7.7%) Fishes of the San Antonio Basin 3 services - TRACS, Fish Atlas, TIFP 2206 records - 1455 TRACS - 571 TIFP - 34 FishAtlas

  42. Conservation status (3 species of concern, 46 records) Regionalized IBIs Non-natives: Tilapia spp.

  43. GIS • Data: • Static in time • Complex in space • Standardized formats Water Resources • Data: • Dynamic in time (time series) • Simple in space (points) • No standardized formats Aquatic Ecology • Data: • Event-based in time (irregular) • Complex in space (3-D) • “Compound” (data interplay) • No standardized formats

  44. The Data Cube – “What-where-when” Time, T “When” t A data value D “Where” s Space, S Vi “What” Variables, V

  45. EFIS Data Cube • Data value = f (Space, Time, Variable, Species) • space/time/species are attributes • Descriptors are variables • ITIS for species • Hierarchical taxonomy (KPCOFGS) http://www.itis.gov/

  46. Additional Information • CUAHSI water data services • Biological data: issues and examples • Texas Digital Libraries • BioODM • Texas water data services • Ontology for biological data

  47. http://www.tdl.org/

  48. KML map links to both the data and the document

  49. Trinity River-San Jacinto River-Galveston Bay Document Management System

  50. Additional Information • CUAHSI water data services • Biological data: issues and examples • Texas Digital Libraries • BioODM • Texas water data services • Ontology for biological data

More Related