Smart Data Management of Urban Infrastructure Using Geographic Information Systems
Publication: Journal of Infrastructure Systems
Volume 26, Issue 4
Abstract
Cities all over the world are converting maps of their infrastructure systems from legacy formats [such as paper maps and computer-aided design (CAD) drawings] to geographic information systems (GIS). Compared with CAD, GIS tend to offer more flexibility in terms of managing, updating, analyzing, and processing data. Nonetheless, the conversion process to GIS can be extremely challenging from a technical point of view. Moreover, the original data in a legacy format often contain errors, and pieces of infrastructure are often missing. What is more, even once the conversion process is complete, the maintenance of the data and the fusion of the data set with other data sets can be challenging. Leveraging recent technological advances (such as machine learning and semantic reasoning), this paper proposes a framework to better manage infrastructure data. More specifically, a smart data-management protocol is presented to successfully convert infrastructure maps from CAD to GIS that includes a data-cleaning procedure in CAD and machine-learning algorithmic solutions to validate or suggest edits of the infrastructure once converted to GIS. In addition, the protocol includes elements of version control to keep track of how urban infrastructure evolves over time as well as a procedure to combine GIS infrastructure maps with other data sets (such as sociodemographic data) that can be used for optimal scheduling of asset maintenance and repair.
Get full access to this article
View all available purchase options and get full access to this article.
Data Availability Statement
No data, models, or code were generated or used during the study.
Acknowledgments
The authors thank the following students for the preliminary work related to this framework: Omar Belingheri, Guillemette Fonteix, Nalin Naranjo, and Eric Boria. The authors are also indebted to coinvestigators Michael Siciliano, Roberto Tamassia, and Goce Trajcevski for many helpful discussions. This work was partially supported by NSF awards CNS-1646395, CAREER 155173, III-1618126, and CCF-1331800.
References
Ahmad, N., S. Derrible, and H. Cabezas. 2017. “Using Fisher information to assess stability in the performance of public transportation systems.” R. Soc. Open Sci. 4 (4): 160920. https://doi.org/10.1098/rsos.160920.
Badhrudeen, M., N. Naranjo, A. Mohavedi, and S. Derrible. 2020. “Machine learning based tool for identifying errors in CAD to GIS converted data.” In Vol. 54 of CIGOS 2019, innovation for sustainable infrastructure: Lecture notes in civil engineering, edited by C. Ha-Minh, D. Dao, F. Benboudjema, S. Derrible, D. Huynh, and A. Tang. Singapore: Springer.
Balasubramani, B. S., O. Belingheri, E. S. Boria, I. F. Cruz, S. Derrible, and M. D. Siciliano. 2017. “GUIDES: Geospatial urban infrastructure data engineering solutions.” In Proc., 25th ACM SIGSPATIAL Int. Conf. on Advances in Geographic Information Systems, 90. New York: Association for Computing Machinery.
Balasubramani, B. S., V. R. Shivaprabhu, S. Krishnamurthy, I. F. Cruz, and T. Malik. 2016. “Ontology-based urban data exploration.” In Proc., 2nd ACM SIGSPATIAL Workshop on Smart Cities and Urban Analytics (UrbanGIS’16), 10. New York: Association for Computing Machinery.
Beck, A. R., G. Fu, A. G. Cohn, B. Bennett, and J. G. Stell. 2007. “A framework for utility data integration in the UK.” In Proc., Urban Data Management Society Symp., 261–276. Stuttgart, Germany: Taylor & Francis.
Boria, E. S., M. Badhrudeen, G. Fonteix, S. Derrible, and M. Siciliano. 2020. “A protocol to convert infrastructure data from computer aided design (CAD) to geographic information systems (GIS).” Accessed July 8, 2020. https://arxiv.org/abs/2006.14112.
Cruz, I. F., V. R. Ganesh, C. Caletti, and P. Reddy. 2013. “GIVA: A semantic framework for geospatial and temporal data integration, visualization, and analytics.” In Proc., 21st ACM SIGSPATIAL Int. Conf. on Advances in Geographic Information Systems, 544–547. New York: Association for Computing Machinery.
Derrible, S. 2018. “An approach to designing sustainable urban infrastructure.” MRS Energy Sustainability 5 (E15): 1–15. https://doi.org/10.1557/mre.2018.14.
Derrible, S. 2019. Urban engineering for sustainability. Cambridge, MA: MIT Press.
Everett, S., N. Athigakunagorn, A. M. Roshandeh, S. Labi, and K. C. Sinha. 2015. “Geographic information system tool for enhancing administration of overweight-vehicle permits.” Transp. Res. Rec. 2478 (1): 75–81. https://doi.org/10.3141/2478-09.
Le, Y. 2012. “Challenges in data integration for spatiotemporal analysis.” J. Map Geogr. Libraries 8 (1): 58–67. https://doi.org/10.1080/15420353.2011.622457.
Lee, D., and S. Derrible. 2020. “Predicting residential water demand with machine-based statistical learning.” J. Water Resour. Plann. Manage. 146 (1): 04019067. https://doi.org/10.1061/(ASCE)WR.1943-5452.0001119.
Mohareb, E., S. Derrible, and F. Peiravian. 2016. “Intersections of Jane Jacob’s conditions for diversity and low-carbon urban systems: A look at four global cities.” J. Urban Plann. Dev. 142 (2): 05015004. https://doi.org/10.1061/(ASCE)UP.1943-5444.0000287.
Noy, N. F., and D. L. McGuinness. 2001. “Ontology development 101: A guide to creating your first ontology.” Accessed July 8, 2020. https://protege.stanford.edu/publications/ontology_development/ontology101.pdf.
Saeed, T. U., R. Nateghi, T. Hall, and B. S. Waldorf. 2020. “Statistical analysis of area-wide alcohol-related driving crashes: A spatial econometric approach.” Geogr. Anal. 52 (3): 394–417. https://doi.org/10.1111/gean.12216.
Settles, B. 2009. Active learning literature survey. Madison, WI: Univ. of Wisconsin-Madison.
Wisetjindawat, W., A. Kermanshah, S. Derrible, and M. Fujita. 2017. “Stochastic modeling of road system performance during multihazard events: Flash floods and earthquakes.” J. Infrastruct. Syst. 23 (4): 04017031. https://doi.org/10.1061/(ASCE)IS.1943-555X.0000391.
Information & Authors
Information
Published In
Copyright
© 2020 American Society of Civil Engineers.
History
Received: Jan 4, 2020
Accepted: Jul 21, 2020
Published online: Sep 26, 2020
Published in print: Dec 1, 2020
Discussion open until: Feb 26, 2021
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.