GIS in Environmental and Water Resources Engineering

1
GIS in Environmental and Water Resources
Engineering

• Research Progress Report
• March 10, 1999

2
Research Areas

• Texas data and water modeling Hudgens, Mason,
  Davis Jonsdottir, Gu, Niazi
• Environmental Risk Assessment Hay-Wilson,
  Romanek, Kim
• Global runoff Asante, Lear

• Nonpoint source pollution Melancon, Osborne
• Flood hydrology and hydraulics Ahrens,
  Andrysiak, Azagra, Perales, Tate
• Internet Favazza,Wei

3
Research Areas

• Texas data and water modeling Hudgens, Mason,
  Davis Jonsdottir, Gu, Niazi
• Environmental Risk Assessment Hay-Wilson,
  Romanek, Kim
• Global runoff Asante, Lear

• Nonpoint source pollution Melancon, Osborne
• Flood hydrology and hydraulics Ahrens,
  Andrysiak, Azagra, Perales, Tate
• Internet Favazza,Wei

4
Brad Hudgens

• Geospatial Data Development for Water
  Availability Modeling

5
Quality Control(the good)
6
Quality Control(the bad)
7
Quality Control(the ugly)
8
WRAP
9
David Mason

• Geospatial Data Development for Water
  Availability Modeling

10
Progress on WAM

• Finished parameter calculations for Nueces Basin
• Finished parameter calculations for San Antonio
  Basin (except for one point..see next slide)
• Half way through parameter calculations for
  Guadalupe Basin......but......

11
New Problems

• Discovered discrepency in area numbers of
  Guadalupe basin
• Error is most likely due to resolution of DEM
  used.
• Currently waiting for 30m DEM to redo parameter
  calcs.

Areas for Guadalupe Gages
12
Trinity River TMDL

• Subtask on Network AnalystKim Davis

13
Underway

• HydroNet Programming
• Exciting new ways to sort river networks
• Avenue QUERY command is hard to use
• Lists are inefficient
• TMDL
• Use Arc/Info to check network integrity
• Investigating RIT

14
Reach Indexing Tool

• Dynamic Segmentation Tool for ArcView developed
  at the Research Triangle Institute in North
  Carolina
• Will be digging into it in the next couple of
  weeks
• Snap Assessment
• Labor Intensive
• Easy to Use

15
Arc/Info 8.0 Beta Class

• Arc/Info will look like ArcView--GUI
• All the good analysis properties of Arc/Info are
  maintained
• Super-easy data management
• Move Stuff
• Rename Stuff
• Project on the fly (from anything to anything)

16
Jona Finndis Jonsdottir

• Geospatial Data for Total Maximum Daily Loads

17
Checking the Connectivity of the River Network
By using the trace function in Arc Info all arcs
connected to the endpoint could be
identified. White and yellow arcs form together
the river network for the Trinity Basin. The
yellow lines represent the arcs connected to the
outlet point of the basin. The white lines
represent branches of the network that were not
connected to the main stem of the network because
of small gaps. Then by comparing the picture to
a similar view in Arc View, small gaps were
identified and filled.
18
After filling some gaps, the network is ready!
According to the trace function in Arc Info, we
now have a single line connected river network
for the Trinity basin!
19
Addtopo Txmesh
I improved my script, Addtopo. By using Addtopo
along with the grid Txmesh and the hotlink option
in Arc View, DRGs can be added to the view with
one click! Each maps extent have been cut down
so that two or more DRGs can be viewed without
disturbing borders...
20
And where to get Addtopo Txmesh!
Its all on my website
http//www.ce.utexas.edu/stu/jonsdoj/research/hotl
ink.html
If you want the program and the grid then go to
my website, and click the icons for Addtopo and
Txmesh. Addtopo contains the Avenue code Txmesh
contains a zipped grid of Texas in geographic,
utm 14 and utm 15 projections. Instructions on
how to use this are also on the website.
21
Building a Time-Series Data Bases for TxRR
Precipitation-Runoff Model

• By Richard Gu

22
Source data

• daily precipitation data
• daily stream flow data

23
Database Software HEC-DSS

• Main components
• DSSUTL import export, copy, delete, or edit
  data in a DSS file.
• DSPLAY display data from a DSS file in a tabular
  or graphical form.
• REPGEN retrieval and representation of data from
  a DSS file.
• DSSMATH mathematically manipulating DSS data.

24
Implementation of Pre-processing
Source Data CD
Spatial Information of gages
Rainfall data Stream flow data
Watershed Region Definition
Text file
Arcview GIS
DSS import DSSUTL
Develop Thiessen Polygons
DSS file
Export weighted area percentage for each gage.
(gagearea)
DSS
25
DSS
Rainfall stream flow, area
DSPLAY Macro
NEW DSS file with Average rainfall stream
flow data for each watershed
DSPLAY
DSSMATH
DSPLAY Macro
REPGEN
Data Retrieval
Customized Reports
Text file converter
TxRR Input File
26
Future work

• Short term goal Implement the GIS DSS function
  components
• Final goal Software Integration
• Simple approach MS-DOS batch file
• Challenge C system calls and user interfaces
  development with Visual C

27
Announcement

• I have installed HEC-DSS system on C drive
  of one PC at PRWR under directory \HECDATA\
  \HECEXE\. Please do not delete them.

28
Surface/Subsurface Modeling

• Progress Report
• Shiva Niazi
• 3/10/99

29
Bureau of Economic Geology ProjectArea of
Interest
Carrizo-Wilcox Aquifer Bastrop, Lee and Milam
Counties Underlying HUC8 Subwatersheds Colorado
River Brazos River Area of Interest
30
Progress
NPS Analysis/ Accumulated Flow
CRWR Pre-Pro
DEM
Flow Dir. Grid

Accumulated Flow Grid
Runoff Grid
31
Current Work

• Locating river gages and flow rates immediately
  upstream of area
• Obtaining DOQs for analysis of river widths

32
Research Areas

• Texas data and water modeling Hudgens, Mason,
  Davis Jonsdottir, Gu, Niazi
• Environmental Risk Assessment Hay-Wilson,
  Romanek, Kim
• Global runoff Asante, Lear

• Nonpoint source pollution Melancon, Osborne
• Flood hydrology and hydraulics Ahrens,
  Andrysiak, Azagra, Perales, Tate
• Internet Favazza,Wei

33
Lesley Hay Wilson

• Spatial Environmental Risk Assessment

34
Current Research Status

• Still working on the site conceptual model
• COC list completed (80 chemicals)
• developing the receptor areas for the lube plant
  site conceptual model
• formatting Excel calculation sheet and moving
  some tables (e.g., receptor characteristics,
  chemical properties) into the SCM access database
• Other SCM database changes for pathway
  completeness tracking

35
MHR project team

• Working on database issues (team)
• meeting February 22nd
• additional refinements to the measurements
  database
• team CD May 1999
• PaDEP Meeting March 10th
• presented the spatial site conceptual model
• other UT projects presented
• new PaDEP CD and workshop August 1999

36
Andrew Romanek

• Building the Foundation for Environmental Risk
  Assessment at the Marcus Hook Refinery Using
  Geographic Information Systems
• March 12, 1999

37
Activities

• Database meeting in Atlanta
• Job search
• THESIS
• Now I am going skiing

38
Spatial Analysis of Sources and Source Areas on
Marcus Hook

• Progress report by Julie Kim
• Friday, March 12, 1999

39
Current Work

• Contoured April/May 1996 and December 1998 COC
  measurements for 8 COCs in groundwater for 3
  sections of the refinery
• Lube Plant
• North of the railroads
• South of the railroads
• Used each section as
  barriers when contouring

40
2. Choose appropriate output extent
1. Select points to contour
3. Select barrier that is identical to your
output extent
4. Final result contours end at the railroads,
creek, and river
41
Left Contours of benzene for each section
WITHOUT using each section as barriers
Right Contours of benzene for each section USING
each section as barriers
42
Future Work

• Focus on the hydrology project
• Analyze soil data for the 40 COCs detected in the
  Lube Plant
• Analyze any COCs detected in NAPL in the Lube
  Plant
• Work on tasks outlined in the Marcus Hook Action
  Plan

43
Research Areas

• Texas data and water modeling Hudgens, Mason,
  Davis Jonsdottir, Gu, Niazi
• Environmental Risk Assessment Hay-Wilson,
  Romanek, Kim
• Global runoff Asante, Lear

• Nonpoint source pollution Melancon, Osborne
• Flood hydrology and hydraulics Ahrens,
  Andrysiak, Azagra, Perales, Tate
• Internet Favazza,Wei

44
Global Runoff RoutingEstimating Flow Velocity
Kwabena Asante
45
Dispersion in Routing

• Checked the effect of decomposing a reach
• Coded dispersion into source to sink model
• Working on dispersion type cell to cell code
  using the same approach as source to sink

46
Diffusion Type Routing
Perform routing from upstream cells using
flow accumulation do define order of computation
Calculate response from each cell to the next
cell downstream
Sample response coefficients and apply to inflow
to get discharge For each cell, aggregate
discharge from all upstream cells (convolve in
time and space)
47
(No Transcript)
48
(No Transcript)
49
Mary Lear

• Flow Direction Data from Fine
• to Coarse Resolution

50
Wonderful Work

• Big meeting with researchers from UNH
• More Goals include
• Finding Diagonals, Flat Histogram
• Creating River Networks
• Reaching the Ocean
• Determining Flow Length
• Solving Connectivity Problems

51
Global T42 Mesh
The river network with 2.8? cells for the Niger
River Basin illustrates areas of continued work.
52
Research Areas

• Texas data and water modeling Hudgens, Mason,
  Davis Jonsdottir, Gu, Niazi
• Environmental Risk Assessment Hay-Wilson,
  Romanek, Kim
• Global runoff Asante, Lear

• Nonpoint source pollution Melancon, Osborne
• Flood hydrology and hydraulics Ahrens,
  Andrysiak, Azagra, Perales, Tate
• Internet Favazza,Wei

53
Patrice Melancon

• Pollutant Loading Model for Tillamook Bay

54
Patrices Progress(not to be confused with
Pilgrims Progress of Little Women fame)

• Draft Thesis has been submitted
• Appendices 85 complete, but not completely
  transferred to thesis
• Have been learning ins and outs of HMS and RAS
  in Hydraulic Engr Design class helping students
  during lab time
• Interviews coming along nicely

55
Still to Come...

• Reformat report to meet TBNEP reqmts
• Burn final CDROM to submit with report
• Finishing touches to graduate
• Incorporate readers comments
• Final printing/binding
• All the paperwork
• Update webpage

56
Katherine Osborne

• Water Quality Master Planning for Austin

57
Review Steps

• Compile land use maps for area.
• City of Austin will be providing them on Monday.
• Collect all maps and coverages necessary to
  create draft model of Barton Creek.
• Almost complete
• Also, set up Data Dictionary and Progress Report
  on web page to keep COA up to date.

58
Model Ingredients (Inputs)
DEMS (and subsequent CRWR-PrePro manipulations
flow direction, flow accumulation, etc)
Land use shapefiles
Impervious Cover Grid
USGS Station locations
Precipitation Data Files
59
Using Christines Recipes (Scripts) with fresh
ingredients
Runoff, Flow, and Watershed Grids with Stations
Shapefile.
60
Next Steps

• Investigate Christines scripts and assumptions,
  as well as Avenue.
• Move onto loads and BMP removals.
• Obtain most up to date shapefiles from COA
• BMP locations, Recharge zones, EII sites, Water
  quality exempt zones and Water quality protection
  zones
• COA meeting March 26.

61
Research Areas

• Texas data and water modeling Hudgens, Mason,
  Davis Jonsdottir, Gu, Niazi
• Environmental Risk Assessment Hay-Wilson,
  Romanek, Kim
• Global runoff Asante, Lear

• Nonpoint source pollution Melancon, Osborne
• Flood hydrology and hydraulics Ahrens,
  Andrysiak, Azagra, Perales, Tate
• Internet Favazza,Wei

62
Seth Ahrens

• Flood Forecasting in Houston

63
Digitizing Streams
64
Other Activities

• Sent final models to HEC
• Sent DRG data to HEC
• Finished tweaking ModClark code
• THESIS

65
Peter Andrysiak

• Flood Risk Assessment

66
Computation of Expected Annual Damage
Q
D
H
Q
D
f3(DH)
f1(Qp)
H
dp
p
p
H
Q

• For interval,dp, find damage D(H(Q(p)))
• Integrate over p with (1)
• Repeat this with sufficient realizations to get
  stable statistics for mean De and 25 and 75
  values

• Expected annual damage

(1)

• Generate a realization
• 2 random numbers for m,s for f1(Qp)
• 1 number for shift in f2(HQ)
• 1 number for shift in f3(DH)

67
Improvement using GIS
Q
H
Q
f1(Qp)
dp
p
p
Q

• GIS-based calculation of flood likelihood and
  damage at each location
• Risk-based flood plain boundary zone

68
Esteban Azagra

• Regional Hydraulic Model for the City of Austin

69
Current Work

• Procedure for floodplain mapping
• HEC-RAS and previous works
• Define area of study Bull Creek

70
Current Work

• 30 m vs. 10 m DEM
• Merge and project to UTM

71
Current Work

• Cross-Sections length, elevation

72
Future Activities

• Line coverage of the stream centerline digital
  orthophotograph
• Cross-sections
• Run Pre-pro?

73
Incorporating the Green-Ampt Method for
Infiltration into CRWR-prepro

• Jerome Perales

74
Variables in the Green-Ampt Infiltration Model

• The Green-Ampt method allows for an
  approximate physical theory of infiltration with
  an exact analytical solution where

75

• By using a look up table related to the
  soil types of a given region, the Green-Ampt
  method can be applied to calculate infiltration

76
USDA Soil Classes

• There are 719 STATSGO texture names. They have
  all been assigned one of the 12 USDA classes and
  one category called other. The parameters of the
  other category are to be determined.

77
Eric Tate

• Mapping Flood Water Surface Elevation

78
Recent Activities

• Finalizing thesis first draft
• Wrote last Avenue script used for delineating a
  grid-based floodplain. Users can view the
  floodplain extent with an orthophoto base map,
  and click on the grid to also determine flood
  depth.

79
Waller Creek 100 Year Floodplain
80
Research Areas

• Texas data and water modeling Hudgens, Mason,
  Davis Jonsdottir, Gu, Niazi
• Environmental Risk Assessment Hay-Wilson,
  Romanek, Kim
• Global runoff Asante, Lear

• Nonpoint source pollution Melancon, Osborne
• Flood hydrology and hydraulics Ahrens,
  Andrysiak, Azagra, Perales, Tate
• Internet Favazza,Wei

81
David Favazza

• Map-Based Modeling on the Internet

82
LCRA Service Area Online (Part 1)

• Meeting at LCRA
• Dynamic Chart Creation option completed, works
  well

83
(No Transcript)
84
(No Transcript)
85
LCRA Service Area Online (Part 2)

• Recognized limitations of MO/VB technology for
  user inputs and database retrieval
• Learning Visual InterDev 6

86
(No Transcript)
87
Kevin Wei

• Displaying Environmental Maps on the Internet

88
Kevin Wei 03/12/99
Finished the seminar on 02/24 Name ltInternet GIS
Application in Environmental Information
Distributiongt Working on my report. Hopefully it
can be turned in on Wednesday 03/17