Type of Document Master's Thesis Author Vemulapally, Rahul Author's Email Address firstname.lastname@example.org 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
- Risk Visualization
- Web Application
- Google earth simulation
Date of Defense 2010-02-03 Availability unrestricted AbstractAvailability 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.
Filename Size Approximate Download Time (Hours:Minutes:Seconds)
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
If you have questions or technical problems, please Contact DLA.