Development of a Water Infrastructure Knowledge Database
This article has been corrected.
VIEW CORRECTIONPublication: Journal of Infrastructure Systems
Volume 20, Issue 1
Abstract
This paper presents a methodology for developing a national database, as applied to water infrastructure systems that include both drinking water and wastewater. The database is branded as WATERiD and can be accessed through internet. Water infrastructure in the United States is aging poorly and municipal governments are struggling to find easy access to comprehensive information about achieving sustainability of their water infrastructure such as condition assessment, renewal engineering, subsurface utility engineering, best management practices, and cost of technologies. There are more than 50,000 water/wastewater utilities in the United States and no two utilities are alike. However, the lessons learned by a utility in the application of the commonly available technologies can be used as knowledge by other utilities. Because there was previously no easily accessible platform through which successful experiences and lessons learned could be shared, common mistakes including unnecessary change of orders are frequently repeated in different locations. The WATERiD database is enabling utilities to share their experiences and lessons learned, and is a single-point information center where all the relevant information about water-infrastructure sustainability can be found. To collect lessons learned and utility experience, more than 100 utilities throughout the United States and 30 additional international utilities were contacted. The data from utilities are compiled, taxonomically classified, and uploaded into WATERiD for sharing between the utilities. This paper describes a process for developing the database including database architecture, database-critical functionalities such as upload and categorization, and future development work. Sustaining and building upon the foundational WATERiD resources will continue to take the cooperation of utilities, organizations, and professionals from across the water-infrastructure industry.
Get full access to this article
View all available purchase options and get full access to this article.
Acknowledgments
Development of the WATERiD was supported by the Innovation and Research for Water Infrastructure for the 21st Century of the EPA/WERF under Project No. INFR9SG09 and Project No. INFR10SG09. The authors gratefully acknowledge the support. In addition, the authors gratefully acknowledge the assistance of the DUG members, who reviewed the development progress on a monthly basis. Many thanks also go to the participating utilities. The efforts of the members of these utilities will benefit the industry for years to come.
References
Allen, F. H., et al. (1979). “The Cambridge crystallographic data centre: Computer-based search, retrieval, analysis and display of information.” Acta Crystallogr., Sect. B: Struct. Crystallogr. Cryst. Chem., 35(10), 2231–2339.
American Water Works Association. (2001). Dawn of the replacement era: Reinvesting in drinking water infrastructure, Denver.
Apache Solr [Computer software]. Apache Software Foundation, Forest Hill, MD.
ASCE. (2009). America’s infrastructure report card, Reston, VA.
ASCE. (2011). Failure to act: The economic impact of current investment trends in water and wastewater treatment infrastructure, Reston, VA.
Barsalou, T. (1989). “An object-based architecture for biomedical expert database systems.” Comput. Methods Programs Biomed., 30(2–3), 157–168.
Berra, P. B., Chen, C. Y. R., Ghafoor, A., Lin, C. C., Little, T. D. C., and Shin, D. (1990). “Architecture for distributed multimedia database systems.” Comput. Commun., 13(4), 217–231.
Boin, A., and McConnell, A. (2007). “Preparing for critical infrastructure breakdowns: The limits of crisis management and the need for resilience.” J. Conting. Crisis Manage., 15(1), 50–59.
Bos, N., et al. (2007). “From shared databases to communities of practice: A taxonomy of collaboratories.” J. Comput.-Mediated Commun., 12(2), 652–672.
Chi, E. H. (2000). “A taxonomy of visualization techniques using the data state reference model.” IEEE Symp. on Information Visualization (InfoVis 2000), Salt Lake City, UT, 69–75.
Costello, S. B., Chapman, D. N., Rogers, C. D. F., and Metje, N. (2007). “Underground asset location and condition assessment technologies.” Tunnelling Underground Space Technol., 22(5–6), 524–542.
Davis, M. (2007). “Integrated water resource management and water sharing.” J. Water Resour. Plann. Manage., 427–445.
Drupal [Computer software]. Free Software Foundation, Boston, MA.
El-Diraby, T. E., and Osman, H. (2011). “A domain ontology for construction concepts in urban infrastructure products.” Autom. Constr., 20(8), 1120–1132.
Ellison, D., et al. (2010). Global review of spray-on structural lining technologies, Water Research Foundation, Denver.
EPA. (2005). Managing for excellence: Analysis of water and wastewater utility management systems, U.S. Environmental Protection Agency Office of Wastewater Management, Washington, DC.
EPA. (2007a). Innovation and research for water infrastructure for the 21st century—Research plan, U.S. Environmental Protection Agency Office of Research and Development, Washington, DC.
EPA. (2007b). FACTOIDS: Drinking water and ground water statistics for 2007, U.S. Environmental Protection Agency Office of Water (4606M), Washington, DC.
EPA. (2008). Clean watersheds needs survey (CWNS) 2008 Rep. to Congress, Washington, DC.
EPA. (2009a). Drinking water infrastructure needs survey and assessment: Fourth Rep. to Congress, U.S. Environmental Protection Agency Office of Water, Washington, DC.
EPA. (2009b). State of technology review report on rehabilitation of wastewater collection and water distribution systems, Cincinnati.
EPA. (2009c). White paper on condition assessment of wastewater collection systems, U.S. Environmental Protection Agency Office of Research and Development, Cincinnati.
EPA. (2010). State of technology for rehabilitation of wastewater collection systems, U.S. Environmental Protection Agency Office of Research and Development, Cincinnati.
EPA. (2011). Field demonstration of condition assessment technologies for wastewater collection systems, U.S. Environmental Protection Agency Office of Research and Development, Cincinnati.
Farroha, B. S., Farroha, D. L., and Whitfield, M. (2009). “Challenges and alternatives in building a secure information sharing environment through a community-driven cross domain infrastructure.” Proc., of IEEE Military Communications Conf., MILCOM 2009, Boston, MA, 1–7.
Gokhale, S., and Graham, J. A. (2004). “A new development in locating leaks in sanitary sewers.” Tunnelling Underground Space Technol., 19(1), 85–96.
Hacigumus, H., Iyer, B., and Mehrotra, S. (2002). “Providing database as a service.” Proc., 18th Int. Conf. on Data Engineering, San Jose, CA, 29–38.
Halfawy, M. R. (2008). “Integration of municipal infrastructure asset management processes: Challenges and solutions.” J. Comput. Civil Eng., 216–229.
Hammitt, S. A. (2010). Toward sustainable stormwater management: Overcoming barriers to green infrastructure, Massachusetts Institute of Technology, Boston.
Hashemi, B. (2011). “Water pipeline renewal evaluation using AWWA class IV CIPP, pipe bursting, and open-cut.” Proc., ICPTT 2011 Sustainable Solutions for Water, Sewer, Gas and Oil Pipelines, Beijing, China, 1257–1266.
Hearst, M. A. (2000). “Next generation web search: Setting our sites.” IEEE Data Eng. Bull., 23(3), 38–48.
Hearst, M. A. (2006). “Design recommendations for hierarchical faceted search interfaces.” Proc., 29th Annual Int. ACM SIGIR Conf. on Research and Development in Information Retrieval (SIGIR’06) Workshop on Faceted Search.
Hearst, M. A., English, J., Sinha, R., Swearingen, K., and Yee, K.-P. (2002). “Finding the flow in web site search.” Commun. ACM., 45(9), 42–49.
Holsheimer, M., and Siebes, A. P. J. M. (1994). “Data mining: The search for knowledge in database.”, Centrum Voor Wiskunde en Informatica, Amsterdam, Netherlands.
Hooper, B. P. (2003). “Integrated water resources management and river basin governance.” Water Resour. Update, 126, 12–20.
Hoover, K. D., and Perez, S. J. (1999). “Data mining reconsidered: Encompassing and the general-to-specific approach to specification search.” Econ. J., 2(2), 167–191.
Housen, V. (2004). “Large diameter pressure pipeline rehabilitation—Limited options and lots of challenges.”, North American Society for Trenchless Technology (NASTT), Liverpool, NY, 1–10.
Jeng, T.-S., and Eastman, C. M. (1998). “A database architecture for design collaboration.” Autom. Constr., 7(6), 475–483.
Joachims, T. (2002). “Optimizing search engines using clickthrough data.” Proc., 8th ACM SIGKDD Int. Conf. on Knowledge Discovery and Data Mining, Association for Computing Machinery, New York, 133–142.
Kim, W., Garza, J. F., Ballou, N., and Woelk, D. (1990). “Architecture of the ORION next-generation database system.” IEEE Trans. Knowl. Data Eng., 2(1), 109–124.
Koo, D.-H., and Ariaratnam, S. T. (2006). “Innovative method for assessment of underground sewer pipe condition.” Autom. Constr., 15(4), 479–488.
Linden, G., Smith, B., and York, J. (2003). “Amazon.com recommendations: Item-to-item collaborative filtering.” Internet Comput., 7(1), 76–80.
Microsoft IIS 7.5 [Computer software]. Microsoft, Redmond, WA.
Microsoft Windows Server 2008 Revision 2 Service Pack 1 [Computer software]. Microsoft, Redmond, WA.
Morrison, R., and Wang, L. (2010). State of technology report for force main rehabilitation, U.S. Environmental Protection Agency National Risk Management Research Laboratory Water Supply and Water Resources Division, Cincinnati.
MySQL [Computer software]. Oracle, Redwood City, CA.
Pearson, L., Coggan, A., Proctor, W., and Smith, T. (2010). “A sustainable decision support framework for urban water management.” Water Resour. Manage., 24(2), 363–376.
Sheth, A. P., and Larson, J. A. (1990). “Federated database systems for managing distributed, heterogeneous, and autonomous database.” ACM Comput. Surv., 22(3), 183–236.
Sinha, S., Edwards, M., Hooker, S., and McCowan, C. (2011). “NIST-VT workshop on aging water infrastructure.” Proc., Pipelines 2011 Conf., Seattle.
Sinha, S., and Graf, W. (2011). “National database for water infrastructure system.” Proc., Pipelines 2011 Conf., Seattle.
Taira, R. K., Stewart, B. K., and Sinha, U. (1991). “PACS database architecture and design.” Comput. Med. Imag. Graph., 15(3), 171–176.
Urban, S. D., Shah, J. J., Rogers, M., Jeon, D. K., Ravi, P., and Bliznakov, P. (1994). “A heterogeneous, active database architecture for engineering data management.” Int. J. Comput. Integr. Manuf., 7(5), 276–293.
Water Infrastructure Network. (2000). Clean and safe water for the 21st century, Washington, DC.
Wells, D. L., Blakeley, J. A., and Thompson, C. W. (1992). “Architecture of an open object-oriented database management system.” IEEE Comput., 25(10), 74–82.
Yee, K.-P., Swearingen, K., Li, K., and Hearst, M. A. (2003). “Faceted metadata for image search and browsing.” Proc., SIGCHI Conf. on Human Factors in Computing Systems (CHI’03), ACM, New York, 401–408.
Information & Authors
Information
Published In
Journal of Infrastructure Systems
Volume 20 • Issue 1 • March 2014
Copyright
© 2013 American Society of Civil Engineers.
History
Received: Jun 2, 2012
Accepted: Apr 17, 2013
Published online: Apr 19, 2013
Published in print: Mar 1, 2014
Discussion open until: May 13, 2014
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.