Title page for ETD etd-02172010-151518

Type of Document

Master's Thesis

Author

Vemulapally, Rahul

Author's Email Address

vemu007@vt.edu

URN

etd-02172010-151518

Title

Development of Standard Geodatabase Model and its Applications for Municipal Water and Sewer Infrastructure

Degree

Master of Science

Department

Civil Engineering

Advisory Committee

Advisor Name	Title
Sinha, Sunil K.	Committee Chair
Deane, Jason K.	Committee Member
Dymond, Randel L.	Committee Member

Keywords

Standard Data Model
GIS
Geodatabase
Risk Visualization
Web Application
Google earth simulation

Date of Defense

2010-02-03

Availability

unrestricted

Abstract

Availability of organized data is required for accurate prediction of structural or functional
deterioration in sewer and water pipes. Toward this end, GIS provides a means for viewing,
understanding, interpreting, and visualizing complex geographically referenced information to
reveal data relationships, patterns, and trends. The primary objective of this research is to
develop a standard GIS data model and applications of the model. In the future, these can be used to develop protocols and methods for predicting the remaining life of water and wastewater assets.
The source data for this study is the utility data and other publicly available data from resources such as USGS, SSURGO etc. Field mapping files are generated from the source files and the
standard data model. These are then programmed to the common Extensible markup Language (XML) file developed as a base which is then converted to the data model where the final form of utility data is stored. The data taken from the utilities is cleansed and analyzed to match the standard data model which is then uploaded through the common XML and stored in the data warehouse as a geospatial database. The geospatial database is an aggregated water and wastewater infrastructure data consisting of the utility data in standard data model format. The data warehouse is developed for utilities to store their data at a centralized server, such as the San Diego Super Computer Center.
Web applications demonstrate the publishing, querying and visualization of aggregated data in a
map-based browser application. This aggregation of data of multiple utilities will help in
providing timely access to asset management information and resources that will lead to more
efficient programs. This tool also furnishes the public with a convenient tool to learn about
municipal water and wastewater infrastructure systems. This document gives an overview of
how this process can be achieved using the above mentioned tools and methodologies.

Files

Filename		Size	Approximate Download Time (Hours:Minutes:Seconds)
Filename		Size	28.8 Modem	56K Modem	ISDN (64 Kb)	ISDN (128 Kb)	Higher-speed Access
	Vemulapally_R_T_2010.pdf	3.55 Mb	00:16:25	00:08:26	00:07:23	00:03:41	00:00:18