GIS in Environmental and Water Resources Engineering

1
GIS in Environmental and Water Resources
Engineering

• Research Progress Report
• Nov 20, 1998

2
Research Areas

• 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

3
Research Areas

• 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

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
  FN
• 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
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
Tools Used

• 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

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
Topographic Maps, DRGs

• Good to understand and correct the river network
• Can be added to the view using hot link

22
Hot Link

• 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

• Click on the cell where you want the
  topographic map

23
How to do this?

• But what is the best way to add the field with
  the file names to the attribute table?
• Does someone have a god idea?

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"
• choisemsgbox.choiceasstring(options,"Choose the
  type of control point","Select")
• id_numbermsgbox.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
7
8
6
8
6
7
6
5
4
4
3
3
2
1
1
1
31
Esteban Azagra

• Surface Water Modeling

32
Rainfall runoff
Run HEC-PrePro
GIS
Topographic Hydrologic Topologic
Parameters Calibration
HMS
Comparison
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
Research Areas

• 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

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. Loehrs 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 -gt develop transient recharge
  rate for GW model

43
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
Lube Plant Area

• Tanks
• Historical Features
• ponds
• storage tanks
• process areas
• storage areas
• loading/unloading areas
• Former RCRA Features
• EPA AOCs

46
Lube Area Data Spreadsheet

• 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

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
Research Areas

• 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

51
Global Runoff Routing

• Kwabena Asante

52
Comparison of Old and New Delineations
53
Flow Length Zones for Each Watershed
54
(No Transcript)
55
(No Transcript)
56
Grid Cell Translation from High to Low Resolution

• Mary Lear
• November 20, 1998

57
Project Description

• Make a tool to translate fine resolution grids to
  any specified coarse resolution mesh
• Write the tool using Arc Macro Language (AML)
• GOAL Identify downstream polygon in a new field
  in Value Attribute Table (VAT)

58
Sample Area
Niger River Basin
2.3 million km2

• Well studied area
• Variety of climatic regions
• Variety of rainfall values

59
Grid and Mesh
FINE RESOLUTION Flow Direction Grid 1km x
1km
COARSE RESOLUTION Fishnet (Polygons) 30km x
30km
60
Output - Method I

• Simple Method
• Eight Direction Output!
• Cardinal Directions
• Preferred

61
Output - Method II
FLOW DIRECTION GRID 3 Directions out of 8
Pourpoint Method
62
Output - Method II
Inability to Choose Diagonal Directions
63
Puzzles to Solve

• Eight Pour-Point Direction
• Diagonal Directions
• Translating the output to Geographic Coordinates

64
Research Areas

• 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

65
Patrice Melancon

• Pollutant Loading Model for Tillamook Bay

66
Patrices Progress to 20 Nov 1998

• Draft of Methodology Chapter has been turned in
• Requirements for metatdata are being reviewed
  starting to look at MetaMaker
• Downloaded FDGC standard - printed and bound -
  available at CRWR
• Transferred all currrent final coverages and
  grids to Pacific
• Finalized hydrology and bactimodel project files
• Bactimodel.apr sent to ODEQ for beta testing at
  their request

67
EMC Values

• Still looking for articles to support EMC values
  for general ag/cropland and for all baseflow
  values
• Have found several articles with values that may
  be of use for sediment part of model

68
Goals for Next Meeting - 11 Dec

• Draft of Intro/Background
• Draft of Results/Conclusions Chapter
• Finish metadata for all final data sets
• Finish literature search to support EMC values
• Decide how to handle sediment model

69
Katherine Osborne

• Water Quality Master Planning for Austin

70
Review Steps

• Import DEMs using ArcInfo
• Used ArcView after finding metadata for DEMs
• Received Seamless DEMS from EROS
• Add USGS Gauge points
• Used points from Christines work
• Obtain stream file from City of Austin
• Delineate watersheds
• Submit these watersheds to COA
• Read Urban Model material
• Ok, began reading.
• Attend GIS class in CRP

71
Seamless 30m DEM
72
Difference between seamless and compiled 30m DEMs
73
Delineated watersheds using 10,000 cell threshold
74
Next Steps

• Decide on which DEMs to use.
• Submit delineated watersheds to COA.
• Read Urban Model material.
• Work with CAPCO data to develop more accurate
  watersheds.

75
Research Areas

• 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

76
Seth Ahrens

• Flood Forecasting in Houston

77
Final Version of Model
78
Comparison of Gauge Areas (km2)
79
Airborne LIDAR Topographic Mapping System

• Developed by the Houston Advanced Research Center
  (HARC)
• Ten-foot DEM resolution
• Vertically accurate to within six inches
• Nearly all of Harris County complete
• Several other metro areas by 12/99
• 133 Mb per Quarter Quad Sheet

80
Example Data Set
81
Image Map from DOQQ Data
Aerial View of Addicks Reservoir
Click on blue dots to view pictures and text.
82
Ben Bigelow

• Midwest Flood Frequency Analysis

83
Research Update

• Wrote two more chapters of research report
• Writing Results and Conclusions for report
• Gave presentation at interagency meeting in St.
  Louis (USACE,FEMA,states, and many others)
• GIS display capabilities
• Relationship between discharge and area
• very well received

84
Design Discharge Profile, Mississippi River
Iowa-Cedar
Rock
Contribution of Des Moines River Alone 128,000
cfs Tributary 49,000 cfs
Des Moines
1-day, 100-yr peak flow
Des Moines
Mean Daily Discharge (cfs)
Distance (miles)
University of Texas at Austin
85
Jerry Perales

• GIS-Based Infiltration Modeling

86
Tenkiller Watershed
87
Research Seanns Thesis and Prior Work

• Research Seanns Dissertation with focus on the
  Method section
• Research A GIS Procedure for Merging NEXRAD
  Precipitation Data and Digital Elevation Models
  to Determine Rainfall-Runoff Modeling Parameters,
  CRWR Online Report 95-3, September 1995.

88
Data Needed

• The STATSGO soil databases for Oklahoma and
  Arkansas have been downloaded
• The NEXRAD image needs to be converted to a cell
  mesh
• The DEM for the watershed is needed.

89
Eric Tate

• Mapping Flood Water Surface Elevation

90
Recent Activities

• Interim research report for TxDOT
• Media interviews
• HEC-RAS 2.2 a better output solution?
• Finished background chapter of thesis
• Experimentation with City of Austin
  photogrammetry data to create TINs

91
3D Terrain Modeling Example
92
Research Areas

• 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

93
David Favazza

• Map-Based Modeling on the Internet

94
(No Transcript)
95
ESRIs ArcExplorer

• View maps via Internet and pan/zoom/querry as a
  local user would with ArcView
• Maps are currently being served from Ganges using
  ESRIs Internet Map Server for AE use
• Advantages More reliable than MapCafe also
  allows user to download user-specified portions
  of maps
• Downers Requires user to download AE and run it
  locally - time intensive download Not as
  powerful as MapObjects

96
Kevin Wei

• Displaying Environmental Maps on the Internet

97
Overview of my research Project
Publishing database on the Internet 1.
DataBase Environmental Monitoring data
(tabular format) in Pantex Facility. Six
Chemicals. Data processing Using MS
Access. 2. Evaluate different Internet GIS
approaches. ArcView Internet Map
Server(IMS) Map Object Internet Map
Server(IMS) ArcExplore which approach
is more efficient and reliable.
98
Data Processing.
Key field
Using Easting and Northing data to build up a
point coverage. How to? Using loc_cod as key
field to associate attributes with GIS shape file.
99
Run Query in Access and import the query result
into ArcView
Only 40 wells geo information are given, so
build up a query to pick up the data only from
these 40 wells.
100
ArcView Access 1. Set up ODBC driver, select
mdb file. 2. In Arcview, go to SQL connect,
import database into ArcView. 3. Go to View and
Add event theme to build up a new theme using
Easting and Northing data. 4. Convert the new
theme to a shape file. So you have a shape file
with the information you are interested
in. Next step Working on the Internet Map
Servers. Arcview IMS can directly serve ArcView
project. MapObject IMS and ArcExplore are
primarily working with ESRI shape files.
101
MapObjects and MOIMS 2.0 MapObjects is ESRI
component software for adding mapping and GIS
capabilities to Windows applications. The
development environments can be VB, Visual
C MapObject IMS2.0 is IMS extension to
MapObjects. It provides ready-to use software
components that enable you to run MapObjects
applications and ArcExplore.aep file on the
Internet. In machine Rimac, Volta, Viper, we
installed MOIMS2.0
Next time I ll give more detailed information
about MOIMS
102
Research Review

• Next Research Progress Report
• Friday Dec18, 1998, 2PM, ECJ 9.236