Abstract
This paper describes the development of a GIS-based geotechnical system designed to face challenges on urban geology in a Spanish mid-sized city. Its multipurpose nature is based on a relational database that holds a wide variety of georeferenced ground data, mostly extracted from geotechnical reports or acquired during fieldwork. At present it includes, among other unpublished information, more than 2000 site investigations and the results from 5000 tests carried out on rock, soil and groundwater samples. This desk tool provides a better understanding of the bedrock and superficial geology through the spatial analysis of the collected subsurface data. The main achievements include the classification and mapping of man-made grounds, fluvial sediments and residual soils; the identification of unreported faults; the review and detailed study of geotechnical parameters and properties of the rocks and soils; and the hydrogeological characterization of the permeable units. It also provided the surface geological mapping of the urban area; the development of a geo-engineering map based on lithological, geotechnical and construction criteria; and the creation of a preliminary 3D layer-based ground model of the city centre, where the subsurface contains stone used for heritage buildings listed by UNESCO.
Similar content being viewed by others
Avoid common mistakes on your manuscript.
Introduction
Databases implemented in Geographic Information Systems (GIS) are an efficient way to manage geographically referenced data. They present well-known advantages for handling of ground investigation data, providing a wide range of functionalities. For instance, GIS enables capturing and integrating a great variety of information gathered from unrelated sources. The geodata are usually incorporated into a multilayered database, sharing a common spatial referencing system, allowing data from various sources to be easily manipulated, updated or shared through Web-based systems (Chang and Park 2004; Kunapo et al. 2005). Spatial and non-spatial queries are performed in the databases, and GIS software has significant spatial analysis capabilities such as geoprocessing tools. The data might be shown in a number of ways, including 3D modelling and visualization, both important research topics of modern geology (Culshaw 2005).
GIS is widely used for thematic mapping related to natural hazards such as landslides (e.g. Chacon et al. 2006), earthquakes (e.g. Chung and Rogers 2010), karstified areas (e.g, Yilmaz 2007; Galve et al. 2009), liquefaction potential (e.g. Kolat et al. 2006), volcanic areas (e.g. Alberico et al. 2005), or coastal management (e.g. Debaine and Robin 2012; Flor-Blanco et al. 2015; Domínguez-Cuesta et al. 2015) and climate change (Aranda et al. 2020; Simonovic 2017). These maps help public administrations to optimize regional and local development; they facilitate the selection of suitable sites for housing and infrastructure construction from the geological viewpoint; and improve the design of ground investigations for engineering projects. There is a greater awareness of the importance of inputting field data into digital databases (Culshaw et al. 2006): for example, the national geotechnical databases developed by some European geological surveys (e.g. BGS, GSI, IGME, TNO) which contain thousands of survey sites. This preserves the results of the investment fieldwork and laboratory tests that might be lost in the future. The storage within relational databases is the most common and, currently, the best option (Veeger et al. 2004).
At the urban scale, GIS-based technology addresses the need to store and manage ground data, especially in metropolitan areas where the construction of large infrastructure provides a wide range of new subsurface data (e.g. tunnelling). Thus, the databases are becoming increasingly more important in the management and visualization of geotechnical data (Orhan and Tosun 2010; Wan-Mohamad and Abdul-Ghani 2011), which is enhanced by the software improvements (Chadwick et al. 2006). Therefore, they are very useful tools for geo-engineering and geo-environmental evaluation related to urban planning and redevelopment of brownfield sites (Dai et al. 2001).
A brief overview of trends in urban geology and databases illustrates the broad field of interests for geologists and engineers, among others: geological setting (structural contour maps and 3D subsurface models), hydrogeological research (groundwater flow trends, water quality and spreading of pollutants), hazard management (e.g. expansive soils, natural or man-induced subsidence), geo-engineering zoning (i.e. mapping of geotechnical properties and constructive conditions), and more recently the analysis of the effects of climate and future climate change. In Europe, there are among others, GIS-related research projects and databases at urban areas from countries such as Austria (Pfleiderer and Hofmann 2004), Belgium (Devleeschouwer and Pouriel 2009), UK (Ford et al. 2008; Royse et al. 2009), Finland (Vähäaho 1998), France (Marache et al. 2009; Thierry et al. 2009), Germany (Neber et al. 2004; Neumann et al. 2009), Greece (Koukis and Sabatakakis 2000), Italy (Rienzo et al. 2009; Ciotoli et al. 2015), Norway (De Beer et al. 2012), Portugal and Scotland (Campbell et al. 2010). The integration of subsurface urban environment in land-use planning and management was investigated and promoted by the COST Sub-Urban project, a European network involving geological surveys, local authorities and research partners (Campbell et al. 2014). In general, geotechnical databases have been produced in cities with large metropolitan areas, but some are national.
In this case, the aim is the creation of a GIS-based geotechnical information system designed to provide geological and geotechnical information for a medium-sized Spanish city. The development of such tools has reported good results in other cities (e.g. Entwisle et al. 2016). Oviedo has an important architectural heritage dating back to the ninth century that must be protected when infrastructure is built in the vicinity. It includes monuments listed as UNESCO World Heritage Sites, and more than 20 buildings that are declared Sites of Cultural Interest, the highest protection in the Spanish Historical Heritage Law. However, the geological and geotechnical features of the urban subsurface determine changing conditions for excavation and foundation works, which, in some cases, have led to severe structural damage and with economic consequences (e.g. Gutiérrez Claverol et al. 2004; González-Fernández et al. 2010).
This research focuses on addressing some unresolved challenges of the subsurface of Oviedo, which responds to local needs, from the management of ground data stored in a digital database. This means paying closer attention to: (i) the Quaternary deposits, which are more permeable, weaker, and have lower bearing capacity than the bedrock, and whose mapping has been incomplete due to the absence of outcrops; (ii) the characterization of karst phenomena in carbonate rocks and gypsum, which cause construction issues; (iii) the investigation of faults in the built-up area, as the distribution is insufficiently known; (iv) a better understanding of underground water flow and the potential interaction with the construction of infrastructure; (v) a detailed analysis of the main geotechnical properties of rocks and soils, to assist geotechnical investigations related to civil engineering and building projects.
Study area
Oviedo/Uviéu is the capital city of the Principality of Asturias and its population is around 215,000. The urban centre, situated 350 km north of Madrid (Fig. 1a), covers an area of 15 km2. The city is built on an undulating topography where slope angles are commonly 5° and locally as high as 15°, while the elevations—from NE to SW—range between 160 and 330 m above sea level (Fig. 2). To the north of the urban area, the relief is more rugged and the highest elevations are over 600 m.a.s.l.
The city is on sedimentary rocks of Mesozoic–Palaeogene age. The rock sequence forms parts of a basin gently folded in an ENE–WSW oriented synclinal structure (Fig. 1b), resting nonconformably on the basement of strongly folded Devonian and Carboniferous formations. The Cretaceous series consists of alternating carbonate and siliciclastic units (González Fernández et al. 2004), two of them outcropping in much of the urban area: the La Argañosa Formation and the Oviedo Formation (Fig. 1c). The former, below, is a succession mostly composed of sands that constitute an important regional aquifer, and the latter, above, corresponds to yellowish-brown limestone affected by karst producing a varied palaeorelief. Below the two Cretaceous units is the San Lázaro Fm., comprising carbonate rocks (Table 1). This unit occurs near surface and some geotechnical ground investigations reach it. In the unconformable Paleogene series of fluvial–lacustrine origin, three major lithological units were identified (Gutiérrez Claverol and Torres Alonso 1995): the lower one is mainly composed of marl and limestone layers (Fig. 1d; the middle unit consists mostly of marly clay; and clay and sand deposits dominate the upper unit. Finally, the Quaternary is mainly represented by fluvial sediments (a rooftop sequence of gravels, sands and clays) linked to the Nora River in the northeaster margin of the city, and other minor deposits related to ancient streams and small lakes obscured during urban growth, obliterating the geomorphological evidence of their existence.
The structures in basement rocks reflect the deformation that occurred during the development of the Variscan belt, an orogeny that in the Iberian peninsula was mostly active during the Carboniferous (e.g. Pérez-Estaún et al. 1991). The faults and folds (Fig. 1a, b) affecting the Mesozoic and Palaeogene rocks relate to the formation of the Cantabrian Mountains during the Paleogene, as part of the Alpine belt in north Iberia. The Alpine convergence involved major steeply dipping reverse faults and minor steeply dipping subvertical faults, trending either NW–SE or SW–NE, some of which reactivate previous Variscan thrusts (Alonso et al. 2009). The Monte Naranco hill, to the north of the city, constitutes the hanging wall of an east-oriented reverse fault (Fig. 1b). The landscape and the geomorphology of the area are dominated by fluvial processes, but has been greatly altered by human activity in some parts of the city. In fact, the natural erosion of the tectonically uplifted block to the north of the city has been obscured by the earthmoving works during the northward expansion of the city, as will be seen later. Other currently active natural phenomena with impact on the geotechnical characteristics of sedimentary rocks, such as the dissolution of carbonate rocks and gypsum resulting in the formation of karstic features, are concealed in the built-up area below residual soils, fluvial deposits and man-made fills.
Methodology
Data and information collection and addition to the GIS
Two types of geological information were compiled: data obtained during this research and data supplied by external sources. The first consisted in fieldwork, oral communications and site visits to building works (excavation and foundation stages) and other construction works including pipe burial or pavement renewal. It involved the examination of more than 700 sites (Fig. 2) and more than 2000 photographs. The secondary data came from dissimilar storage systems and formats (hard copy documents, computer file, etc.). More than 400 documents from the past 60 years were collected (Table 2). Private consultants and contractors provided most of them, which were reviewed with confidentiality requirements. Additional data about the subsurface were obtained from public and private archives, public libraries and local newspapers’ libraries. A wide range of multiscale maps were also compiled to provide spatial support to the subsurface data. Survey authorities such as the National Geographic Institute, the Geological and Mining Institute of Spain, the Principality of Asturias Government, and the City Council provided the documents. Around 270 maps and images were stored in either vector or raster formats with scales varying between 1:25,000 and 1:1000 (Table 2). Since their varied origin and wide variety of scales and updates, different types of checks were performed to ensure their quality and spatial consistency and compatibility. The corrective measures applied depending on the case were assignment of the geodetic system, projection transformations and georeferencing.
A GIS-based relational database was then designed using ArcGIS Pro v. 2.7 (from ESRI). This software provided the necessary capabilities: standardized input and integration of multidisciplinary geodata; storage, manipulation and retrieval of data; content updating; analysis and processing tools; and varied graphical outputs. All the geographic items and geodata must have an unequivocal spatial location (X, Y, Z) within a common frame of reference, so geodesic datum and the Universal Transverse Mercator grid system were selected. The content, i.e. ground data, was mainly provided from ground investigations. Boreholes and dynamic probing location plans were usually available in hard copy format, so more than 250 paper maps without grid references were scanned and georeferenced. The procedure was based on image rectification of the location plans through rubber-sheeting process using checkpoints on vector-based maps. Thereby, more than 1500 site investigation points were spatially located with the highest possible planimetric precision (Fig. 2). This consisted of 1159 rotary drill holes providing 18,800 m of logged material; 68 trial pits with average depth of 3.3 m; 315 super heavy dynamic probing (DPSH) and other probing tests representing more than 2 km of penetration recording in soils and very weak rocks; 30 geophysical surveys using seismic refraction, electric techniques (vertical electrical sounding, electrical profiling and electrical resistivity tomography) and ground penetrating radar. The results of field and laboratory testing were also obtained from the documents. This included 1128 on-site tests (standard penetration tests, pressure meters and permeability tests) and laboratory testing over 1634 disturbed and undisturbed samples of rocks and soils and groundwater samples. Only those tested according to Spanish (UNE and NLT) and ASTM standards were selected. This produced directly around 4000 geotechnical values.
A good knowledge of the local geology is essential to distinguish the information extracted from geotechnical reports that are integrated within the database, and it is critical to identify data inconsistencies. This required defining at first a representative stratigraphic column of the near surface geology (general vertical section) based on Gutiérrez Claverol and Torres Alonso (1995) and then a careful check of the boreholes’ log description and the corresponding core images. The geological attribution was carried out by a local geological expert. This enforced the lithostratigraphic consistency in the database. Moreover, ground data without reliable local location data, or with confusing data (e.g. borehole starting height inconsistent), were discarded. Unfortunately, no data were available in a digital data transfer format. Then, the data tabulated in GIS software were grouped into six thematic sections formed by feature classes and non-spatial tables (Fig. 3), which contain one or more common key fields to link the data: (i) general information about the compiled documents; (ii) general data about the site investigations indicating the thicknesses of the geological units identified in each prospection; (iii) location of water sources, depth to groundwater, hydraulic testing and water quality (sensory properties, physicochemical parameters, ion concentrations, bacteriological content and chemical corrosiveness according to the Spanish code on structural concrete); (iv) geotechnical properties from field and laboratory tests (e.g. weight–volume relationships, soil grain size distribution, Atterberg limits, chemical testing, soils classifications, corrosivity, mechanical properties, abrasivity, etc.); (v) additional data related to construction works and information about extractive activities. Currently, the tabulated information exceeds 41,000 cells.
Data analysis
Quaternary deposits
The geometry of artificial grounds was evaluated from landscape transformations that occurred during the period of greatest expansion of the city (e.g. Luberti 2018), not by borehole log-based interpolation of the basal surface of the anthropogenic deposits. The topographic data were derived from 1:5000 scale city maps. Digital elevation models (DEMs) were constructed from the contours and spot heights of the city maps that dated from 1869 to the present. Altitude deviations were checked against control points whose elevation has remained constant; and subtraction operations between DEMs were carried out. The fluvial deposits were mapped from the reconstruction of the hydrographic network now masked below the built-up area. The fluvial network was identified from historical maps and other documents (e.g. Lucchesi and Giardino 2015). From 14 topographic maps dating from the mid-nineteenth century to 2003, the distribution, profile and temporal evolution of the main streams were analysed. Once the configuration was known, it was used to select the geological survey points within the database that are closer to the natural stream distribution, to inform the boreholes to be used to identify the distribution and characterize the fluvial deposits.
Faults
One of the main uncertainties about the subsurface in Oviedo has been in identifying faults. It is well known that the absence of direct observations often restricts the number of faults represented on geological mapping of cities (e.g. Aldiss 2013). The method used in Oviedo to identify the presence of faults consisted of interpolating the conformable contact between Oviedo and La Argañosa formations (Fig. 1c) from borehole data, analysing its spatial variations in depth. The procedure was first carried out at basin scale to detect the larger faults. This involved 160 borehole data around the basin. Through local polynomial interpolation, the stratigraphic boundary was identified from which a slope map was also produced. To assess the orientation and inclination of this lithological boundary, this surface was compared with almost 200 measures (dip and dip direction) taken of the bedding plains of the Oviedo Formation. At the urban centre, spatial analysis was conducted to identify faults with less vertical displacement in areas with high density of borehole data. The procedure was based on trend-surface analysis adapted from Mei (2009). It allows the separation of local features with respect to regional component when investigating the structural setting. The trend modelling was performed under local polynomial regression, and after analysing the residual data, inverse distance weighting (IDW) and kriging were applied to create the best-fit surface in each specific study area.
Hydrogeology
Groundwater has caused problems in excavations (e.g. unexpected flooding in excavations or unstable slopes). Also, the area has a relatively high annual rainfall (mean 1025 mm/year between 1976 and 2020), which contributes to a significant water recharge. Thus, the investigation of the main permeable units involved: ranges of hydraulic conductivities (estimated from field and laboratory data); sources of recharge; the depths to perched and the main water table; groundwater flow paths; chemical characteristics; and corrosion potential for structural concrete.
Geotechnical data
Based on the results of field and laboratory tests, the identification, physicochemical and mechanical parameters collected were analysed using methods for instance percentiles plotted in box and whisker plots. The main properties that define the mechanical behaviour were also studied for each geological unit to complete the geotechnical assessment: plasticity, strength, stiffness, consistency, compressibility, expansivity and collapsibility. Properties such as plasticity required a specific style of plot. In several cases, it included assessing the variation with depth below ground surface of the parameters and properties.
3D model
The geological setting of the city centre was preliminarily virtualized through a 3D layer-based model. The upper surface was provided by a digital elevation model (2 m cell size) generated from 1:1000 topographic mapping and LiDAR data. The boundaries between geological units (Cretaceous formations, Paleogene and man-made fills) were interpolated by radial basis functions from the data provided by the boreholes.
Results and discussion
The preparation of the database was conditioned by many factors. When entering data from multiple sources, most difficulties arise regarding the interpretation of the reviewed information, which differs in origin, quality or resolution. Thus, the nature of the input data was particularly heterogeneous given that much of the information came from geotechnical reports, some produced more than 30 years ago. Another constraint was the availability of new data, as it is difficult to ensure continuity in the input of information. Currently, the database is maintained and updated by the researchers from the University of Oviedo. For the moment, the tool is not publicly accessible, and it has been used exclusively for research purposes. In any case, it was possible to achieve a good spatial distribution of site investigations, and to recover and exploit many ground data that might be lost. The structure of the database, which is neither advanced nor complex and which will be improved in the future, allowed the different spatial analysis procedures to be carried out. As planned, the processing of the collected geodata led to study separately specific challenges on the urban geology, as discussed below.
Artificial grounds
The results of the map algebra showed the ground elevation gains and losses occurred during different periods of urban development. This information was then combined with historical land uses, through the interpretation of aerial photography and the revision of old maps. After that, a review of more than 950 borehole logs was conducted for the identification of man-made grounds with a varied lithology, consistency and density, and an average thickness of 1.9 m (median of 1.2 m and maximum value of 25 m). Man-made ground was then mapped and classified into four categories according to their origin: (i) earthworks related to urban development; (ii) ground modified by civil engineering projects; (iii) ground modified by quarrying activities; (iv) dumping sites. The areas most transformed for each category were analysed in detail using DEMs with even higher resolution and quality to generate more accurate isoline maps of excavated and filled areas (Fig. 4). These models were validated using borehole data, achieving good fit between the thicknesses estimated beneath map algebra and those provided by borehole logs.
An important contribution was the identification of fills and voids related to old quarries, which have now disappeared because urban development took over these areas and integrated them into the city. Their geographic delimitation showed significant changes of the relief caused by the extractive activities (mainly quarrying limestone, sand and clay). The extent of some quarries, abandoned for hundreds of years, was identified during fieldwork (Gutiérrez Claverol et al. 2012). Although there was documentary references about them since the thirteenth century, no previous cartographic data on their location or extension in the historical archives were found. They had great historical significance, supplying building stone for monuments some of which are UNESCO World Heritage Sites.
Fluvial deposits
From the above-mentioned procedure, the first reconstruction of the old hydrographic network in Oviedo was obtained (Fig. 5a). This led to identify fluvial deposits in 282 boreholes, showing these sediments to have an average thickness of 4.7 m and a maximum value of 14.7 m. Then, isopachs and depth-to-bedrock maps were interpolated by IDW in areas with major accumulations of fluvial deposits. This procedure not only provided their extent and geometry, but also served to identify residual soils previously mapped as fluvial sediments. They are sometimes confused with highly weathered carbonate rocks (e.g. sand associated with weathering of Cretaceous limestone). For the above reason and given the absence of outcrops, the correct mapping of Quaternary deposits within the urban core has always been difficult. Because of the above, it was possible to classify correctly the nature of some soil samples collected that had been interpreted as being of fluvial origin when they were added to the database. This was essential to improve the study of the geotechnical properties of the Quaternary cover. Moreover, and as a complementary result not previously expected, some accumulations of fluvial sediment revealed to form the fill of buried sinkholes (Fig. 5b). This is important because these features are karstic subsidence phenomena (Pando et al. 2013).
Fault identification
The spatial analysis procedure revealed basin-scale outliers, as abrupt inflections of the interpolated surface and identified much higher than the usual dip range for Cretaceous units (5°–15°). These anomalies have been interpreted as possible faults due to their linear patterns, and the directions are also consistent with the NW–SE and NE–SW trends of well-known dip-slip faults in the basin (Julivert and Marcos 1973). Their vertical displacements have been calculated to exceed 10 m. Furthermore, examining the cartographic extension of several of these faults outside the main urban centre (where there are no Cretaceous formations), they are compatible with the layout of Variscan faults affecting the Palaeozoic basement. This supports the hypothesis that the Alpine orogeny reactivated these previous faults according to Alonso et al. (1995).
The study of the local trend of the Cretaceous contact in areas of the city with a high density of boreholes (Fig. 6a) proved useful to search for faults with less vertical displacement. After refining the results by cross-validation and after being reviewed by a geologist, some of the fitted surfaces showed anomalies likely caused by faulting not previously mapped (Fig. 6b). As with the procedure applied to the basin, some faults already mapped were verified, but others were not as no vertical displacement of the presumed fault plane was identified. The results were promising, but they should be used with caution, since the representativeness depends largely on data density, the spatial distribution of boreholes and the method of modelling. The presence of some of the faults were tested by the changes in thickness of the Paleogene that were interpreted as caused by faults in previous maps (Beroiz et al. 1973; Martínez-Álvarez et al. 1975). Since no faults have been identified, they are probably related to the irregularity of the palaeorelief of the Cretaceous formations.
Hydrogeology
In Oviedo’s subsurface, there are both geological units that are exploitable aquifers, and units with very low overall permeability but which occasionally have interbedded water-bearing layers. In relation to the most permeable units, the La Argañosa Fm. forms a multilayer of aquifers (when sand predominates), aquitards (fines content over 40%) and aquicludes (clay layers) whose thicknesses rarely exceed a few meters. Piezometric contour maps led to the identification of the preferred paths of the groundwater flow, toward the ENE under the urban area, which is consistent with the trends predicted at basin scale (González Fernández et al. 2005). Figure 7 shows an example of such a trend, estimated in this area from this research using piezometric data from a highway burial project. In the case of Oviedo Formation, the detailed review of borehole logs and piezometric data led to the local identification of hydraulic independence with the aforementioned multilayer system, due to low permeability clay layers and carbonate-cemented microconglomerates at the top of La Argañosa Fm.
The fluvial–lacustrine series has usually been interpreted as forming an aquiclude that overlies the Cretaceous aquifers; in fact, permeability values are as low as 10–11 m/s. However, this research highlighted three geological settings with hydrogeological importance: (i) a karstic aquifer related to gypsum located in the north-eastern part of the city, sometimes confined, with a very high sulfate content (occasionally over 1 g/l); (ii) aquifers linked to sand layers or marl beds partially decalcified by weathering; (iii) circulations through karst conduits and fissures in the rock mass. The location of sulfate-rich groundwater was also used to inform the distribution of gypsiferous layers.
Geotechnical properties
The analysis of geotechnical parameters and properties produced reference values (typical, extreme…) for each geological unit, as well as guidelines on the geotechnical behaviour of the different geological units and their lithologies. The availability of this information will be useful for future studies in the city. However, a further contribution has been the review of the lithological variations within the Paleogene deposits. The great lithological variability and the scarcity of outcrops complicate the grouping of materials into homogenous geological units; this key issue was recurrent in previous studies (e.g. Truyols Santonja and García-Ramos 1991). The mechanical behaviour also varies (e.g. uniaxial compressive strength ranges between 80 kPa to 120 MPa). However, in this research the availability of data and their spatial analysis led to propose a new lithostratigraphic division within the urban: five units instead of the three suggested by Gutiérrez Claverol and Torres Alonso (1995). This setting was based on several criteria: dominant lithologies, geotechnical properties, stratigraphic superposition and mapping. Additionally, the distribution of evaporitic rocks was better known, reinforcing the mapping of karst phenomena responsible for constructive problems.
Engineering geology map
The production of an engineering geology map was not a specific objective of the research, as it emerged after obtaining the results already presented. The interpretation of the data and information led to a new surface model for the city, according to the methodology of Díaz-Díaz et al. (2017), but with more data and information and at larger scale (1:15,000). The preparation required updating the geological map; processing the geotechnical parameters; evaluating the experience gained with different subsurface exploration methods; and integrating the geotechnical and hydrogeological behaviour of the ground observed during fieldwork. The establishment of geotechnical zones was based mainly on the dominant materials and their geotechnical properties. For this, three basic types of materials were considered: rock, soil (uniaxial compressive strength below 1 MPa), and mixed rock–soil. Twelve geotechnical units were then differentiated and mapped in the urban subsurface (Table 3). In turn, they were divided into non-mappable subunits formed by competent/weak rocks, and coarse/fine soils. In addition, areas likely to contain hazardous or difficult engineering conditions were mapped: (i) karstified areas; (ii) high sulfate content; (iii) very plastic soils; (iv) high organic matter content.
The ground behaviour related to building sites was studied by theoretical modelling using the compiled geotechnical parameters. By slope stability analysis based on limit equilibrium methods, feasible inclinations for different heights of slope in open excavations were proposed. For shallow foundations, the bearing capacity was evaluated using analytical and empirical methods. Soil properties with significant influence on foundations such as compressibility, swelling due to water content increase and collapsibility were taken into account. To validate predictions with real experiences, more than 150 construction sites were visited during excavation or at the stage of setting the foundation works. In addition, the most common building damage related to excavations and foundations in the city (e.g. wall cracks) were reviewed to analyse their origin and the construction actions taken. They were mainly caused by slope failures in excavations; unsuitable geotechnical design of retaining walls; loss of lateral confinement of nearby foundations; and settlements due to groundwater extraction. Field monitoring, mainly involving topographical methods, inclinometers, extensometers and piezometers, provided valuable information on the ground behaviour. Various recommendations on the most suitable methods to be used during geotechnical investigations completed the geo-engineering map.
3D model
The geological model corresponding to an area of 3 km2 (Fernández-Álvarez and Pando 2019) was also incorporated. The aboveground three-dimensional representation of roads, buildings (with differentiation of uses), green areas and other urban elements is shown in Fig. 8. The underground space includes basements, underground parking lots and railway tunnels. This recreation provides guidelines on the geometry of the units up to a maximum depth of 168 m, and it is prepared as a starting point for future models based on volumetric units. However, and despite its relative simplicity, the integration of the subsurface environment and the anthropic infrastructure already provides a visually effective model, which offers great versatility for the interpretation and dissemination of results and to inform planning of future structures.
Conclusions
The aim of building a relational database as the core of the geotechnical system was achieved, allowing the retrieval of an unprecedented amount of ground data in the city. Data analysis using GIS-based functionalities addressed the investigation of specific underground features in Oviedo, providing a better understanding of the bedrock and superficial geology.
The study of artificial grounds led to the classification and mapping of man-made fills and excavated areas. Their distribution showed the influence of ancient quarries with great historical significance for the local architectural and monument heritage. The mapping of fluvial deposits was improved, making it easier to distinguish them from soils formed by weathering of the bedrock, whose nature and distribution were also investigated. Concerning the structural setting, the spatial analysis based on borehole data led to the identification of vertical offset of stratigraphic contacts compatible with faulting. Faults previously mapped were validated, but others could not be verified, and previously unknown faults were interpreted. Some of the slip-dip faults seems to be related to the Alpine reactivation of Variscan structures. Also, the general features of the main permeable units in both bedrock and soils were analysed for the first time at urban scale, highlighting the hydrogeological impact of some layers within the fluvial–lacustrine series.
The geotechnical parameters compiled can be used for reference, and the geo-engineering properties are useful to predict ground behaviour during future engineering projects as part of the desk study. The analysis of these properties along with other criteria resulted in the proposal of a new lithostratigraphic division within the Paleogene units. The integration of all subsurface data allowed updating of the superficial geological map and the production of a new engineering geology map for the city that includes the distribution of particularly problematic areas for construction. As an additional resource, a preliminary 3D layer-based model of the urban centre was generated. It integrates the underground environment and the urban infrastructure, providing a valuable visualization tool that can be used by a number of different users.
This case study shows the broad scope of use of a GIS-based geotechnical system in a medium-sized city like Oviedo, obtaining significant contributions on the geological setting. These results, based on an exportable methodology, can encourage similar research in other cities of comparable size with availability of ground data.
Data availability
Not applicable.
Code availability
Not applicable.
References
Alberico I, Petrosino P, Zeni G, D’Andrea F, Lirer L (2005) GEOCITY: a drill-hole database as a tool to assess geological hazard in Napoli urban area. Environ Geol 47(6):751–762
Aldiss DT (2013) Under-representation of faults on geological maps of the London region: reasons, consequences and solutions. Proc Geol Assoc 124(6):929–945
Alonso JL, Pulgar JA, García-Ramos JC, Barba P (1995) Tertiary basins and alpine tectonics in the cantabrian mountains (NW Spain). In: Friend PF, Dabrio C (eds) Tertiary basins of Spain tectonics, climate and sea-level changes. Cambridge University Press, Cambridge, pp 214–227
Alonso JL, Marcos A, Suárez A (2009) Paleogeographic inversion resulting from large out of sequence breaching thrusts: the León Fault (Cantabrian Zone, NW Iberia) A new picture of the external Variscan Thrust Belt in the Ibero-Armorican. Arc Geol Acta 7:451–473
Aranda M, Gracia FJ, Peralta G, Flor-Blanco G (2020) The application of high-resolution mapping for the analysis of recent eco-geomorphological changes in the saltmarshes of San Vicente de la Barquera Estuary (North Spain). J Coast Res 95(sp1):341–345
Beroiz C, Pignatelli R, Felgueroso C, Ramírez del Pozo J, Giannini G, Gervilla M (1973) Map and explanatory memory of sheet 29 (Oviedo) of the Geological Map of Spain at scale 1:50,000. Geological and Mining Institute of Spain, Madrid
Campbell SDG, Merritt JE, Dochartaigh BEO, Mansour M, Hughes AG, Fordyce FM, Entwisle DC, Monaghan AA, Loughlin SC (2010) 3D geological models and their hydrogeological applications: supporting urban development - a case study in Glasgow-Clyde. UK Z Dt Ges Geowiss 161(2):251–262
Campbell D, De Beer J, Lawrence D, Van der Meulen M, Mielby S, Hay D, Scanlon R, Van Campenhout I, Taugs R, Eriksson I (2014) Sub-urban–transforming relationships between geoscientists and urban decision-makers (COST Action TU1206). In: Proceedings of the 14th world conference of associated research centers for the urban underground space (ACUUS 2014), Seoul, pp 284–289
Chacon J, Irigaray C, Fernandez T, El Hamdouni R (2006) Engineering geology maps: landslides and geographical information systems. Bull Eng Geol Environ 65(4):341–411
Chadwick NC, Pickles AC, Sekulski EM (2006) Data transfer and the practical application of geotechnical databases. In: GeoCongress, Geotechnical Engineering in the Information Technology Age American Society of Civil Engineers, Atlanta, pp 1–6
Chang Y-S, Park H-D (2004) Development of a web-based geographic information system for the management of borehole and geological data. Comput Geosci UK 30:887–897
Chung JW, Rogers JD (2010) GIS-based virtual geotechnical database for the St Louis metro area. Environ Eng Geosci 16(2):143–162
Ciotoli G, Stigliano F, Mancini M, Marconi F, Moscatelli M, Cavinato GP (2015) Geostatistical interpolators for the estimation of the geometry of anthropogenic deposits in Rome (Italy) and related physical-mechanical characterization with implications on geohazard assessment. Environ Earth Sci 74:2635–2658
Culshaw MG (2005) From concept towards reality: developing the attributed 3D geological model of the shallow subsurface. Q J Eng Geol Hydrogeol 38:231–284
Culshaw MG, Jackson I, Giles JRA (2006) The provision of digital spatial data for engineering geologists. Bull Eng Geol Environ 65(2):185–194
Dai FC, Lee CF, Zhang XH (2001) GIS-based geo-environmental evaluation for urban land-use planning: a case study. Eng Geol 61(4):257–271
De Beer J, Price SJ, Ford JR (2012) 3D modelling of geological and anthropogenic deposits at the World Heritage Site of Bryggen in Bergen, Norway. Quatern Int 251:107–116
de Rienzo F, Oreste P, Pelizza S (2009) 3D GIS supporting underground urbanisation in the city of Turin (Italy). Geotech Geol Eng 27(4):539–547
Debaine F, Robin M (2012) A new GIS modelling of coastal dune protection services against physical coastal hazards. Ocean Coast Manag 63:43–54
Devleeschouwer X, Pouriel F (2009) Brussels Urban Geology (BUG): a 2D and 3D model of the underground by means of GIS. In: Culshaw MG, Reeves HJ, Jefferson I, Spink TW (eds) Engineering geology for tomorrow’s cities, Engineering Geology Special Publication 22. Geological Society, London, paper 420
Díaz-Díaz LM, Pando L, Arias D, López-Fernández C (2017) Geotechnical map of a coastal and industrialized urban area (Avilés, NW Spain). J Maps 13(2):777–786
Domínguez-Cuesta MJ, Jiménez-Sánchez M, González-Fernández JA, Quintana L, Flor G, Flor-Blanco G (2015) GIS as a tool to detect flat erosional surfaces in coastal areas: a case study in North Spain. Geol Acta 13(2):97–106
Entwisle DC, Culshaw MG, Hulbert AG, Shelley WA, Self AJ, Dobbs MR (2016) The Glasgow (Scotland) geotechnical GIS: a desk study tool. In: Eggers MJ, Griffiths JS, Parry S, Culshaw MG (eds) Developments in engineering geology. Geological Society of London, London, pp 63–80
Fernández-Álvarez P, Pando L (2019) Development of a 3D geological model in the urban center of Oviedo (Asturias). Bol Geol Min 130(3):489–504
Flor-Blanco G, Pando L, Morales JA, Flor G (2015) Evolution of beach–dune fields systems following the construction of jetties in estuarine mouths (Cantabrian coast, NW Spain). Environ Earth Sci 73(3):1317–1330
Ford JR, Burke H, Royse K, Mathers SJ (2008) The 3D geology of London and the Thames Gateway: a modern approach to geological surveying and its relevance in the urban environment. In: Cities and their underground environment—11th European e-conference of International Association for Engineering Geology, Madrid, pp 15–19
Galve JP, Gutiérrez J, Remondo J, Bonachea J, Lucha P, Cendrero A (2009) Evaluating and comparing methods of sinkhole susceptibility mapping in the Ebro Valley evaporite karst (NE Spain). Geomorphology 111:160–172
González Fernández B, Menéndez Casares E, Gutiérrez Claverol M, García-Ramos JC (2004) Litoestratigrafía del sector occidental de la cuenca cretácica de Asturias. Trabajos De Geología 24:43–80
González Fernández B, Gutiérrez Claverol M, Menéndez Casares E (2005) The aquifers of Asturian Cretaceous basin in the surroundings of Oviedo (NW Spain). Bol Geol Min 116(3):231–245
González-Fernández B, Menéndez-Casares E, Meléndez-Asensio M, Gutiérrez-Claverol M (2010) Mining activity and geotechnical and hydrogeological issues related to the presence of gypsum in Asturias (NW Spain). In: Sampson DH (ed) Gypsum: properties production and applications. Nova Publishers, New York, pp 35–68
Gutiérrez Claverol M, Torres Alonso M (1995) Geología de Oviedo. Descripción, recursos y aplicaciones. Paraíso, Oviedo
Gutiérrez Claverol M, Torres M, Pando L, González B (2004) Ground subsidence and collapse in subsoil of Oviedo city owing to karstified gypsum levels. In: Proceedings of the 32nd International Geological Congress, Florence, p 196
Gutiérrez Claverol M, Luque C, Pando L (2012) Canteras históricas de Oviedo. Aportación al patrimonio arquitectónico. Hércules Astur de Ediciones, Oviedo
Julivert M, Marcos A (1973) Superimposed folding under flexural conditions in the Cantabrian zone (Hercynian Cordillera, NW Spain). Am J Sci 273:353–375
Kolat C, Doyuran V, Ayday C, Suzen ML (2006) Preparation of a geotechnical microzonation model using geographical information systems based on multicriteria decision analysis. Eng Geol 87(3–4):241–255
Koukis G, Sabatakakis N (2000) Engineering geological environment of Athens, Greece. Bull Eng Geol Environ 59:127–135
Kunapo J, Dasari GR, Phoon KK, Tan TS (2005) Development of a web-GIS based geotechnical information system. J Comput Civ Eng 19(3):323–327
Luberti GM (2018) Computation of modern anthropogenic-deposit thicknesses in urban areas: a case study in Rome, Italy. Anthr Rev 5(1):2–27
Lucchesi S, Giardino M (2015) Historical archives data for the reconstruction of geomorphological modifications in the urban area of Turin (NW-Italy). In: Lollino G et al (eds) Engineering geology for society and territory, vol 8. Springer International Publishing, Cham, pp 447–452
Marache A, Breysse D, Piette C, Thierry P (2009) Geotechnical modeling at the city scale using statistical and geostatistical tools: the Pessac case (France). Eng Geol 107:67–76
Martínez-Álvarez JA, Gutiérrez-Claverol M, Torres-Alonso M (1975) Map and explanatory memory of sheet 28 (Grado) of the Geological Map of Spain at scale 1:50,000. Geological and Mining Institute of Spain, Madrid
Mei S (2009) Geologist-controlled trends versus computer-controlled trends: introducing a high-resolution approach to subsurface structural mapping using well-log data, trend surface analysis, and geospatial analysis. Can J Earth Sci 46(5):309–329
Neber A, Classon F, Hesemann J, Sobisch HG (2004) An urban subsurface in three dimensions A surveying and modelling concept for the Eastern parts of Cologne. In: Jakobs F, Röhling HG, Uhlmann O (eds) GeoLeipzig 2004—Geowissenschaften sichern Zukunft, Schriftenreihe der Deutschen Geologischen Gesellschaft 34. Leipzig, p 382
Neumann D, Schönberg G, Strobel G (2009) 3D-modeling of ground conditions for the engineering geology map of the city of Magdeburg. In: Culshaw MG, Reeves HJ, Jefferson I, Spink TW (eds) Engineering geology for tomorrow’s cities, Engineering Geology Special Publication 22. Geological Society, London, paper 444
Orhan A, Tosun H (2010) Visualization of geotechnical data by means of geographic information system: a case study in Eskisehir city (NW Turkey). Environ Earth Sci 61(3):455–465
Pando L, Pulgar JA, Gutiérrez-Claverol M (2013) A case of man-induced ground subsidence and building settlement related to karstified gypsum (Oviedo, NW Spain). Environ Earth Sci 68(2):507–519
Pérez-Estaún A, Martínez Catalán JR, Bastida F (1991) Crustal thickening and deformation sequence in the footwall to the suture of the Variscan belt of NW Spain. Tectonophysics 191:243–253
Pfleiderer S, Hofmann T (2004) 3D-visualisation of Vienna's subsurface. In: Schrenk M (ed) Proceedings of the conference CORP 2004 and GeoMultimedia04, 9 internationales Symposion zur Rolle der Informationstechnologie in der Stadt und Regionalplanung sowie zu den Wechselwirkungen zwischen realem und virtuellem Raum, Vienna, pp 367–372
Royse KR, Rutter HK, Entwisle DC (2009) Property attribution of 3D geological models in the Thames Gateway, London: new ways of visualising geoscientific information. Bull Eng Geol Environ 68:1–16
Simonovic SP (2017) Bringing future climatic change into water resources management practice today. Water Resour Manag 31(10):2933–2950
Thierry P, Prunier-Leparmentier AM, Lembezat C, Vanoudheusden E, Vernoux JF (2009) 3D geological modelling at urban scale and mapping of ground movement susceptibility from gypsum dissolution: the Paris example (France). Eng Geol 105(1–2):51–64
Truyols Santonja J, García-Ramos JC (1991) El Terciario de la cuenca de Oviedo y el yacimiento de vertebrados de Llamaquique. Boletín De Ciencias De La Naturaleza 41:77–99
Vähäaho I (1998) From geotechnical maps to three-dimensional models. Tunn Undergr Space Technol 13(1):51–56
Veeger AI, Murray DP, Hermes OD, Boothroyd JC, Hamidzada NA (2004) Harnessing the power of relational databases for managing subsurface geotechnical and geologic data. Environ Eng Geosci 10(4):339–346
Wan-Mohamad WNS, Abdul-Ghani AN (2011) The use of geographic information system (GIS) for geotechnical data processing and presentation. Procedia Eng 20:397–406
Yilmaz I (2007) GIS based susceptibility mapping of karst depression in gypsum: a case study from Sivas basin (Turkey). Eng Geol 90:89–103
Acknowledgements
This research was partially supported by the Principality of Asturias Government (Plan for Science, Technology and Innovation). The authors are grateful to the companies and people that provided ground data allowing this research to go ahead.
Funding
Open Access funding provided thanks to the CRUE-CSIC agreement with Springer Nature. Partial financial support was received from the Principality of Asturias Government (Plan for Science, Technology and Innovation).
Author information
Authors and Affiliations
Contributions
All authors contributed to the study conception and design. Material preparation, data collection and analysis were mainly performed by Pando and Flor-Blanco. Dr. Llana-Fúnez provided specific observations on the research and collaborated in the writing of the manuscript. All authors commented on previous versions of the manuscript and read and approved the final paper.
Corresponding author
Ethics declarations
Conflict of interest
Not applicable.
Additional information
Publisher's Note
Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.
Rights and permissions
Open Access This article is licensed under a Creative Commons Attribution 4.0 International License, which permits use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons licence, and indicate if changes were made. The images or other third party material in this article are included in the article's Creative Commons licence, unless indicated otherwise in a credit line to the material. If material is not included in the article's Creative Commons licence and your intended use is not permitted by statutory regulation or exceeds the permitted use, you will need to obtain permission directly from the copyright holder. To view a copy of this licence, visit http://creativecommons.org/licenses/by/4.0/.
About this article
Cite this article
Pando, L., Flor-Blanco, G. & Llana-Fúnez, S. Urban geology from a GIS-based geotechnical system: a case study in a medium-sized city (Oviedo, NW Spain). Environ Earth Sci 81, 193 (2022). https://doi.org/10.1007/s12665-022-10287-y
Received:
Accepted:
Published:
DOI: https://doi.org/10.1007/s12665-022-10287-y