Roads and Bridges - Drogi i Mosty
23, 1, 2024, 45-72

Concept of unification of mutually incompatible information models and data stored in relational databases of road administrations

Karel Pospisil Mail
https://orcid.org/0000-0002-4773-0428
Brno University of Technology, Institute of Forensic Engineering, 118 Purkynova St., Brno, 61200, Czechia
Michal Janku Mail
https://orcid.org/0000-0003-2588-2655
Transport Research Centre (CDV), 33a Lisenska St., Brno, 63600, Czechia
Josef Stryk Mail
https://orcid.org/0000-0002-8289-6028
Transport Research Centre (CDV), 33a Lisenska St., Brno, 63600, Czechia
Vitezslav Pospisil Mail
https://orcid.org/0009-0006-8895-2429
Janeway, Limited Liability Company., 79 Kainarova St., Brno, 61600, Czechia
Dagmar Pospisilova Mail
https://orcid.org/0000-0002-1300-7290
Transport Research Centre (CDV), 33a Lisenska St., Brno, 63600, Czechia
Published: 2024-04-10

Abstract

Road Administrations (RAs) implement Building Information Modelling (BIM) through pilot projects developed for new or reconstructed structures. Each model is processed with respect to BIM standards and practices valid at the time of its creation. Consequently, models are incompatible and cannot be interconnected to create a combined model of the managed network or even its selected parts. Existing structures are often not included in the BIM effort until some major repair is planned. In addition, RAs usually store data on fixed and variable parameters of structures in relational databases. This results in a situation in which a relatively small number of structures are included in mutually incompatible models and data regarding the majority of structures is contained in relational databases. It creates a heterogeneous data environment for RAs. The goals of the paper are as follows: to analyse the described problem, to propose a method of model unification models, a method of creation of simplified compatible information models using data on existing structures stored in relational databases and a method of storing data at the level of the managed network, to support RA asset management systems which can be treated as a dynamic part of BIM.

Keywords


asset management system, BIM, BMS, PMS, relational database, road network model.

Full Text:

PDF

References


Borrmann A., Konig M., Koch C., Beetz J.: Building Information Modeling: Why? What? How? In: Borrmann A., Konig M., Koch C., Beetz J. (Eds.): Building Information Modeling, Springer, Cham, 2018, 1-24, DOI: 10.1007/978-3-319-92862-3_1

Wang J., Zhang S., Fenn P., Luo X., Liu Y., Zhao L.: Adopting BIM to facilitate dispute management in the construction industry: A conceptual framework development. Journal of Construction Engineering and Management, 149, 1, 2023, ID article: 03122010, DOI: 10.1061/(ASCE)CO.1943-7862.0002419

Eneyew D.D., Capretz M.A.M., Bitsuamlak G.T.: Toward Smart-Building Digital Twins: BIM and IoT Data Integration. IEEE Access, 10, 2022, 130487-130506, DOI: 10.1109/ACCESS.2022.3229370

Lu Q., Xie X., Heaton J., Parlikad A.K., Schooling J.: From BIM Towards Digital Twin: Strategy and Future Development for Smart Asset Management. In: Borangiu T., Trentesaux D., Leiăto P., Giret Boggino A., Botti V. (Eds.): Service Oriented, Holonic and Multi-agent Manufacturing Systems for Industry of the Future, Springer, Cham, 2020, 392-404, DOI: 10.1007/978-3-030-27477-1_30

Wernerova E., Endel S., Kuta D.: Implementation of the BIM Method at the VSB – Technical University of Ostrava. International Journal of Engineering Research in Africa, 47, 2020, 133-138, DOI: 10.4028/www.scientific.net/JERA.47.133

Munir M., Kiviniemi A., Finnegan S., Jones S.W.: BIM business value for asset owners through effective asset information management. Facilities, 38, 3/4, 2020, 181-200, DOI: 10.1108/F-03-2019-0036

Farghaly K., Abanda F.H., Vidalakis C., Wood G.: Taxonomy for BIM and Asset Management Semantic Interoperability. Journal of Management in Engineering, 34, 4, 2018, DOI: 10.1061/(ASCE)ME.1943-5479.0000610

Farghaly K., Abanda F.H., Vidalakis C., Wood G.: BIM-linked data integration for asset management. Built Environment Project and Asset Management, 9, 4, 2019, 489-502, DOI: 10.1108/BEPAM-11-2018-0136

Ait-Lamallam S., Yaagoubi R., Sebari I., Doukari O.: Extending the IFC Standard to Enable Road Operation and Maintenance Management through OpenBIM. ISPRS International Journal of Geo-Information, 10, 8, 2021, ID article: 496, DOI: 10.3390/ijgi10080496

PIARC – World Road Association: Indicators for bridge performance and prioritization of bridge actions. PIARC, La Défense, 2003

PIARC – World Road Association: Indicators representative of the condition of geotechnical structures for road asset management. PIARC, La Défense, 2008

PIARC – World Road Association: Asset Management Manual. PIARC, La Défense, 2023, https://road-asset.piarc.org/en, 03.10.2023

Federal Highway Administration (FHWA): Asset management. 2023, https://www.fhwa.dot.gov/asset/, 02.10.2023

Ředitelství silnic a dálnic (RSD): Overall summary of data monitored in the Information System on the Road and Motorway Network of the Czech Republic as of 1 July 2021. RSD, Prague, 2022 (in Czech)

Arndt W., Doge N., Fathejalali A., Kämpfer R.: Erstellung einer Geodatenbank aller Brücken und Straßen Deutschlands in kommunaler Baulast auf Basis von Open-Street-Map-Daten. Deutsches Institut für Urbanistik, Berlin, 2015

Ředitelství silnic a dálnic (RSD): Geoportal of road and highway network, https://geoportal.rsd.cz/web, 03.10.2023, (in Czech)

Andriejauskas T., Biswas S., Wright A.: Call 2018 Building Information Modelling (BIM) Final Programme Report. Conference of European Directors of Roads (CEDR), Brussels, 2022, https://cedr.eu/docs/view/639748b2a936c-en, 03.10.2023

Sejnoha J.: Use of the BIM method on road infrastructure projects of the Czech Road Directorate. Presentation to the Technical Board of the Czech Road Directorate, Prague, 2023

Seitner M., Probst R., Borrmann A., Vilgertshofer S.: Building Information Modeling (BIM) im Brückenbau. Berichte der Bundesanstalt für Straßenwesen, Brücken- und Ingenieurbau Heft B 182. Bundesanstalt für Straßenwesen (BASt), Bergisch Gladbach, 2022

Jiang S., Jiang L., Han Y., Wu Z., Wang N.: OpenBIM: An Enabling Solution for Information Interoperability. Applied Sciences, 9, 24, 2019, ID article: 5358, DOI: 10.3390/app9245358

Musella C., Serra M., Salzano A., Menna C., Asprone D.: Open BIM Standards: A Review of the Processes for Managing Existing Structures in the Pre- and Post-Earthquake Phases. CivilEng, 1, 3, 2020, 291-309, DOI: 10.3390/civileng1030019

BuildingSmart: IFC Specifications Database, https://technical.buildingsmart.org/standards/ifc/ifc-schema-specifications/, 03.10.2023

ISO 16739-1:2018 Industry Foundation Classes (IFC) for data sharing in the construction and facility management industries – Part 1: Data schema

ISO 10303-11:2004 Industrial automation systems and integration – Product data representation and exchange – Part 11: description methods: The EXPRESS Language Reference Manual

W3C Recommendation, https://www.w3.org/TR/xmlschema-0/, 03.10.2023

ISO 10303-28:2007 Industrial automation systems and integration – Product data representation and exchange – Part 28: Implementation methods: XML representations of EXPRESS schemas and data, using XML schemas

ISO 10303-21:2002 Industrial automation systems and integration – Product data representation and exchange – Part 21: Implementation methods: Clear text encoding of the exchange structure

Beck F., Borrmann A., Kolbe T.H.: The need for a differentiation between heterogenous information integration approaches in the field of “BIM-GIS integration”: A Literature review. ISPRS Annals of the Photogrammetry, Remote Sensing and Spatial Information Sciences, VI-4/W1-2020, 2020, 21-28, DOI: 10.5194/isprs-annals-VI-4-W1-2020-21-2020

Winkels H., Meerkerk J., Koehorst B.: Technical report 2017-05: Utilising BIM for NRAs. Conference of European Directors of Roads (CEDR), Brussels, 2017, https://cedr.eu/docs/view/6063251879c9a-en, 03.10.2023

Winkels H.: Fact sheet 2016: Open information exchange (BIM) of National Road Authorities is of vital importance for Asset management. Conference of European Directors of Roads (CEDR), Brussels, 2016, https://cedr.eu/docs/view/6063218af2184-en, 03.10.2023

Státní Fond Dopravní Infrastruktury (SFDI): Regulation of Building Information Modeling of structures of transport infrastructure. Data Standard for documentation for zoning proceedings, building permits, public tendering and construction execution. SFDI, Prague, 2022, https://www.sfdi.cz/bim-informacni-modelovani-staveb/ 03.10.2023, (in Czech)

Pospisil K., Pospisilova D., Brychtova L.: BIM and Pavement Management System (analysis and recommendation). Janeway, Brno, 2021 (in Czech)

Pospisil K.: Opinion on Strategic plan of further development of Czech Road Administration Road Databank of with a 10-year outlook. Janeway, Brno, 2021 (in Czech)

McArthur J.J.: A Building Information Management (BIM) Framework and Supporting Case Study for Existing Building Operations, Maintenance and Sustainability. Procedia Engineering, 118, 2015, 1104-1111, DOI: 10.1016/j.proeng.2015.08.450

Borrmann A., Konig M., Hochmuth M., Liebich T., Elixmann R.: Die INFRABIM-Reifegradmetrik. Bautechnik, 94, 4, 2017, 215-219, DOI: 10.1002/bate.201700004

Urbański M., Świtała M., Liszewski W., Ślusarczyk B., Piechowicz K.: Road and bridge construction price indexation illustrated with an example of a selected project. Roads and Bridges - Drogi i Mosty, 21, 4, 2022, 365-378, DOI: 10.7409/rabdim.022.021

Pospisil K., Zednik P., Stryk J.: Relationship between deformation moduli obtained using light falling weight deflectometer and static plate test on various types of soil. Baltic Journal of Road and Bridge Engineering, 9, 4, 2014, 251-259, DOI: 10.3846/bjrbe.2014.31

Glinicki M.A., Jóźwiak-Niedźwiedzka D., Antolik A., Dziedzic K., Dąbrowski M., Bogusz K., Lisowski P.: Analysis of causes of damage to single-layer concrete highway pavement. Roads and Bridges - Drogi i Mosty, 21, 3, 2022, 183-201, DOI: 10.7409/rabdim.022.011

Pospisil K., Manychova M., Stryk J., Korenska M., Matula R., Svoboda V.: Diagnostics of Reinforcement Conditions in Concrete Structures by GPR, Impact-Echo Method and Metal Magnetic Memory Method. Remote Sensing, 13, 5, 2021, ID article: 952, DOI: 10.3390/rs13050952

Chmielewski R., Wesołowski M., Waliszewski D.: Review of subgrade bearing capacity tests for airfield pavements. Roads and Bridges - Drogi i Mosty, 21, 2, 2022, 117-131, DOI: 10.7409/rabdim.022.007

Burghardt T.E., Köck B., Pashkevich A., Fasching A.: Skid resistance of road markings: literature review and field test results. Roads and Bridges - Drogi i Mosty, 22, 2, 2023, 141-165, DOI: 10.7409/rabdim.023.007

Korenska M., Pazdera L., Pospisil K., Stryk J., Vyroubal P.: Detection of the reinforcement corrosion in prestressed concrete girders. In: Grum, J. (Ed.): 8th International Conference of the Slovenian Society for Non-Destructive Testing, Conference Proceedings: Application of contemporary non-destructive testing in engineering, Portoroz, Slovenia, 2005, 317-322

Arshad M., Fahad M., Khan A., Adil M., Khan A.: Fatigue load effects on highway bridges of Pakistan using Weigh-In-Motion data. Roads and Bridges - Drogi i Mosty, 21, 1, 2022, 19-37, DOI: 10.7409/rabdim.022.002


Concept of unification of mutually incompatible information models and data stored in relational databases of road administrations

  
Pospisil, Karel et al. Concept of unification of mutually incompatible information models and data stored in relational databases of road administrations. Roads and Bridges - Drogi i Mosty, [S.l.], v. 23, n. 1, p. 45-72, apr. 2024. ISSN 2449-769X. Available at: <>. Date accessed: 26 May. 2024. doi:http://dx.doi.org/10.7409/rabdim.024.003.