Περίληψη:
The challenge in intelligent cities is to recognize the benefits of using big data. The management of big datasets enables efficient data storage and processing to enhance information for the decision-making process. The key aim of this paper is to highlight how geological, engineering geological and geotechnical knowledge can be managed in a well-organized database, which is able to develop various correlations and to present useful information for both the design and construction stages of important projects of civil protection, municipality and technical companies. The present paper demonstrates the implementation of such work in the city of Thessaloniki, northern Greece, where a large amount of geological and geotechnical data for more than 600 boreholes, mainly based on borehole geological information, laboratory testing, geotechnical characterization and in situ field tests collected from fill, Quaternary and Neogene deposits, is stored in a georeferenced database. The presented database, is targeted to the management and processing of geo-engineering datasets for various geotechnical projects but also for the protection against natural hazards. The purpose of the approach, besides incorporating multisource datasets, is to provide a tool to effortlessly and immediately analyze, correlate and display data on maps, tables and diagrams for stakeholders. For this analysis, the present study proposes a geographic information system approach coupling the use of geostatistical techniques along with the cross validation to establish geotechnical zonation maps in order to highlight hazardous areas prone to liquefaction and settlement and to indicate the site's adaptability for different infrastructure projects. In that context, specific value ranges for several physical and mechanical properties are proposed from the assessment and correlation of the information originating from the database and spatial variability, providing geological and geotechnical knowledge in safe urban extensions suitable for construction in the research area environment. However, the key challenge is not only referring to provide each influencing parameter with a quantitative range of values, but also to establish a set of reliable structural and high-precision informative geotechnical models to comprehensively understand the superficial and subsurface conditions of the research area. © 2022 Elsevier B.V.
Λέξεις-κλειδιά:
Boreholes; Data handling; Database systems; Decision making; Digital storage; Engineering geology; Hazards; Information management; Information use; Large dataset; Seismic response, Data storage; Engineering geological database; Geological database; Geostatistical analysis; Geotechnical; Geotechnical parameters; Northern Greece; Research areas; Thessaloniki; Urban geologies, Smart city, assessment method; borehole; correlation; data set; database; geostatistics; geotechnical engineering; GIS; in situ test; smart city; spatial variation; urban planning, Central Macedonia; Greece; Thessaloniki [Central Macedonia]; Thessaloniki [Thessaloniki (DPR)]
