GIS in Environmental and Water Resources Engineering

1. GIS in Environmental and Water Resources Engineering Research Progress Report Nov 20, 1998

2. Texas data and water modeling: Hudgens, Mason, Davis Jonsdottir, Gu, Azagra, Niazi Environmental Risk Assessment: Hay-Wilson, Romanek, Kim Global runoff: Asante, Lear Nonpoint source pollution: Melancon, Osborne Flood hydrology and hydraulics: Ahrens, Bigelow, Perales, Tate Internet: Favazza,Wei Research Areas

3. Texas data and water modeling: Hudgens, Mason, Davis Jonsdottir, Gu, Azagra, Niazi Environmental Risk Assessment: Hay-Wilson, Romanek, Kim Global runoff: Asante, Lear Nonpoint source pollution: Melancon, Osborne Flood hydrology and hydraulics: Ahrens, Bigelow, Perales, Tate Internet: Favazza,Wei Research Areas

4. Brad Hudgens Geospatial Data Development for Water Availability Modeling

5. Status • Sulphur : re-model w/ new CPs by Dec 2 • Neches : have TNRCC review data, need CPs from F&N • Nueces : TNRCC working location review • Guadalupe : TNRCC wants DRG database • San Antonio : • Prepro : working on network connectivity • Water for Texas Conference : presentation by Nov 27

6. 90m DEM limitations

7. David Mason Geospatial Data Development for Water Availability Modeling

8. Building the River Network • Objective is to create a single-line network • Must remove open water features • use Query tool to select only R,S, and T streams • use USGS open water centerlines to define a linear “transport path” • Using Arcview, manually delineate necessary streams not represented by rf3 • Place an outlet point at each water right location using CRWR-Prepro

9. Correct stream identified Water Right location (red dot) Digitizing Streams

10. “The Holdup” • The water right locations to be used as control points for the watershed delineation process must first be reviewed by TNRCC for accuracy.

11. Trinity River TMDL Subtask on Network AnalystKim Davis

12. ArcView Network Analyst Routing Tying Points to Network Avenue scripts developed by Zechuan Ye Ties points to network within tolerance Accessory scripts for manual corrections Tools Used

13. Prepared Stream Network

14. Add Points of Interest

15. SOLVING

16. Route Solution

17. AREAS

18. Current Work • Problems Encountered • RF3 • Avenue • Network Analyst

19. Future Work • Finish method development for point data • Figure out code/script issues • Is it on a stream we have? • Apply to the Trinity Basin • Attribute Pollution Sources

20. Jona Finndis Jonsdottir Geospatial Data for Total Maximum Daily Loads

21. Good to understand and correct the river network Can be added to the view using hot link Topographic Maps, DRGs

22. In Quads attribute table, add a field with the file names of the DRGs Write an appropriate script Activate the hot link in Theme Properties Hot Link • Click on the cell where you want the topographic map

23. But what is the best way to add the field with the file names to the attribute table? Does someone have a god idea? How to do this?

24. New Tool Development for Water Modeling Richard Gu

25. Problems need to be solved • Calculate the drainage area of user-defined control points • Build stream network relations

26. Create a user-defined input point theme • The point coverage contains different type of point. • The user can define the ID of the control points. • The input ID will be unique.

27. Implementation: Addpnt_new.ave • Script: Addpnt_new.ave. • User interface: options={"Diversion point", "Stream gage"} choise=msgbox.choiceasstring(options,"Choose the type of control point:","Select") id_number=msgbox.input("Enter the ID number:","Input control point","0")

28. Calculate the user defined drainage area • Grid solution: • Identified the “Stream gage” points from the input coverage. • Make a multipoint object from the points identified. • Extract the points from the Flow-Direction grid and make them NODATA. • Run Flow-Accumulation. • Implementation: NewFdrCreat.ave

29. Build up stream network relations • Algorithm: get a multi-point coverage, a line coverage; check all the points of the point coverage are on the stream arcs; if(a point is not a node)then {split the arc at this point; make the point fnode of the downstream; make the point tnode of the upstream};

30. 7 8 7 8 7 8 6 6 7 6 5 4 4 3 3 2 1 1 1

31. Esteban Azagra Surface Water Modeling

32. Rainfall runoff Run HEC-PrePro Topographic Hydrologic Topologic GIS Parameters Calibration Comparison HMS Field Data

33. Progress Report: Surface-Subsurface Modeling Shiva Niazi Ann Dennis November 20, 1998

34. Model Domain Defined by LBG Guyton

35. Model Domain

36. Standard Hydrologic Grid

37. Texas data and water modeling: Hudgens, Mason, Davis Jonsdottir, Gu, Azagra, Niazi Environmental Risk Assessment: Hay-Wilson, Romanek, Kim Global runoff: Asante, Lear Nonpoint source pollution: Melancon, Osborne Flood hydrology and hydraulics: Ahrens, Bigelow, Perales, Tate Internet: Favazza,Wei Research Areas

38. Lesley Hay Wilson Spatial Environmental Risk Assessment

39. Current Research Status • Revising draft dissertation proposal based on comments from Dr. Charbeneau • Objective is to develop the spatial risk assessment methodology with emphasis on application to large, complex sites • Proposal defense scheduled for Dec 11th • Beginning work on presentation for the defense

40. Other Activities • Completing paper for the 1999 CSIRO Remediation Conference (team) • IGERT NSF proposal activities • working with Dr. Katz on the “capstone” course outline • preparing a Marcus Hook project summary • Participating in development of a work plan with Dr. Loehr’s research team to implement environmentally acceptable endpoint studies at Marcus Hook • Drafting paper abstract for EPA conference: “Environmental Problem Solving with GIS”

41. Andrew Romanek Surface Representation of the Marcus Hook Refinery

42. Activities • Since last time: • Seminar • ESP Poster • COC Transport Extension • Review of nearby facility data • For next two weeks: • Hydrology project -> develop transient recharge rate for GW model

43. Point Sources Flow and Load Grids Accumulated Flow and Load Grids Predicted Concentration Grid Load = Flow * Concentration COC Transport Extension • 4 step extension to surface water model to characterize COC transport • Conservative - no decay except from additional flow • Compare to WQS • Waiting on data - will complete by Jan. ‘99

44. Spatial Analysis of Sources and Source Areas on Marcus Hook Progress report by Julie Kim Friday, November 20, 1998

45. Tanks Historical Features ponds storage tanks process areas storage areas loading/unloading areas Former RCRA Features EPA AOC’s Lube Plant Area

46. Fields from database Coverage number Coverage ID Fcode Location ID Location label Environmental condition Reference New fields added Materials stored Volume stored Time of operation Releases Data classification number Lube Area Data Spreadsheet

47. Data Classification 1-Specific release with volume and date or time 2-Anecdotal evidence describing release but no time or data specified; visual observation of standing oil or stained soils 3-Oily stains, discoloration or other evidence based on historical photos or reports 4-No releases identified; not a source feature

48. Spreadsheet With New Fields

49. Future Work • Compare concentration data in spreadsheet with data in environmental database • Look for patterns in releases • Edit info in Releases Field • Join data with attributes table in Arcview • Use releases with best info to see if they correlate with data in environmental database • For #4 classification, look through historical reports for more info

50. Texas data and water modeling: Hudgens, Mason, Davis Jonsdottir, Gu, Azagra, Niazi Environmental Risk Assessment: Hay-Wilson, Romanek, Kim Global runoff: Asante, Lear Nonpoint source pollution: Melancon, Osborne Flood hydrology and hydraulics: Ahrens, Bigelow, Perales, Tate Internet: Favazza,Wei Research Areas