Development of Standard Geodatabase Model and its Applications for Municipal Water and Sewer Infrastructure
Files
TR Number
Date
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
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.