330 likes | 504 Views
Civil and Environmental Engineering Applications. Geospatial Database: a set of compatible data layers or themes. Relational Linkages. Spatial Attributes. Water Right Locations. Descriptive Attributes. Digital Elevation Model. Watershed Delineation. Raster. Vector. Real World.
E N D
Geospatial Database: a set of compatible data layers or themes
Relational Linkages Spatial Attributes Water Right Locations Descriptive Attributes
Raster Vector Real World Raster-Vector Data Model
Map-Based Hydrology and Hydraulics ArcView Input Data DEM ArcView Flood plain maps CRWR-PrePro HEC-RAS Water surface profiles HEC-HMS Flood discharge
Engineering Design • Evaluate impact of building a dam • Determine elevation of spillway • Determine aerial extent of reservoir • Delineate contributing watershed • Generate 3D view of reservoir • Givens • Approximate location of dam • Normal capacity of 50 Mm3 (40,500 acre-ft) • Flood capacity of 100 Mm3 (81,000 acre-ft)
Data Requirements ElevationData 1:24,000 DEM (Digital Elevation Model) 1:100,000 paper topographic map DRG 1:24,000 DRG (Digital Raster Graphic)
Digital Elevation Model Raster or grid data Scale 1:24,000 (30m)
Digital Raster Graphics Raster data Scannedtopographicmap Scale 1:24,000 (30m)
Separate Up/Downgradient • Draw polygon • to remove area • downgradient • of dam • Limits volume • calculation to • reservoir area Location of Dam
Vector Data • Used to represent discrete objects • Point data - monuments, cities • Line data - roads, rivers • Vector data - boundaries, soil type • Composed of distinct nodes & vertices
Generate TIN • TIN - Triangular Irregular Network • Stores elevations, or other continuous • data, by creating triangles in 3D space • More efficient data storage • Estimate volume for cut and fill operations
Separate Up/Downgradient • Creates two TINs • Upgradient TIN • can be used to • determine dam • elevation
Determine Dam Elevation • Surface - Area and Volume Statistics • Elevation • Area above or below
Dam Elevation Elevation Volume Area ft m3 m2 224 50,656,491 12,117,735 227.1 100,777.495 18,487,230 Elevations determined by trial and error
Generate Reservoir Image Map Algebra Allows user to alter grid data using mathematical tools
Generate Reservoir Image Boolean Image If (Elevation < 224, 1, 0)
Generate Reservoir Image Boolean Image If (Elevation < 227.1, 1, 0)
Normal vs Flood Stage Estimated reservoirs can be compared relative to each other…..
Normal vs Flood Stage … merged with a DRG ...
Normal vs Flood Stage … or compared to the entire watershed
Generating 3D Image 2D View Surface Elevation
3D Image Vertical Exaggeration Factor = 5
3D Image Vertical Exaggeration Factor = 5
3D Image Vertical Exaggeration Factor = 5
E. coli Geometric Mean 126 cfu/100 mL Not-to-Exceed 394 cfu/100 mL Fecal coliform Geometric Mean 200 cfu/100 mL Not-to-Exceed 400 cfu/100 mL GIS for Water Quality
WWTP Sampling Sampled WWTP
Storm Sewer Sampling EC (MPN/100 mL) 0-394 > 394
“Computing is not about computers any more. It is about living.” Nicholas Negroponte, Founding Director of MIT’s Media Lab. Being Digital (1995), p. 6.