3 REGULAR ANALYSIS GRID
A regular grid is frequently utilized in geotechnical
analysis. In statistical analysis, for instance, point
density is based on statistical units of equal size.
Another application is the organization of tiles of a
digital terrain model with equal sizes.
Based on the coordinate reference system LAEA-
Sevilla described above, a regular grid with three
zoom levels is defined. Zoom level 1 uses a 10 x 10
km cell size starting each cell at rounded coordinates
(Figure 3: top). The numbering of each cell refers to
the coordinate values of the upper left corner, rounded
to 10 km. Grid cell 5030, for example, covers the
range in x between 500000m and 510000m and in y
from 290000m to 300000m. A coordinate-based
numbering system is the most flexible option, as a
10km grid can be extended, without the need to
rename existing cells if necessary.
Figure 3: Definition of a regular grid with three zoom
levels: Level 1 (10x10km), Level 2 (2x2km), Level 3 (400
x400m). The grid based on the coordinate reference system
LAEA-Sevilla.
Each cell of Zoom level 1 is subdivided into 25
cells with a size of 2km x 2km (Zoom level 2). The
cells labeled with characters starting with ‘A’ in the
NW corner and continuing row by row from north to
south until character ‘Z’. Character ‘I’ is not used to
avoid any confusion with character ‘J’ (Figure 3:
bottom left).
For large scale studies a third Zoom level 3 is used
with a cell size of 400x400m. The 25 cells are labelled
through numerical codes in such a way, that the first
number refers to the relative cell position in the y-
direction and the second number refers to the position
in x-direction. Therefore, labelling of Zoom level 3
starts with ‘11’ and ends with ‘55’ (Figure 3: bottom
right).
The combination of the label for each zoom level
provides the complete information about the position
of the cell. Grid cell 5030 A 51, for example, covers
the square area from point (500000.00, 298000.00) in
the SW corner to point (500400.00, 298400.00) in the
NE corner.
Per definition, locations falling exactly between
two cells are assigned to the eastern cell and the
southern cell, respectively. This means, for example,
that a point at location (500000.00, 300000.00) falls
into cell 5030 A 11.
4 ELEVATION DATA
There are two primary sources of altitude information
for the urban area of Sevilla and the surrounding
countryside: cadastral survey points and LiDAR
measurements taken from an airplane (Centro
Nacional de Información Geográfica, 2020). Based
on LiDAR measurements from 2012 to 2022
(containing UTM coordinates and ellipsoidal heights)
a DTM has been created by the National Geographic
Institute and the National Center for Geographic
Information in Spain (Instituto Geográfico Nacional
(IGN) / Centro Nacional de Información Geográfica
(CNIG) (Mº Fomento)). Only filtered ground points
have been used to calculate the DTM, interpolating
the elevation values of areas covered by non-ground
points. In addition, satellite measurements and the
digital surface models derived from them are also
available: SRTM (National Aeronautics and Space
Agency -NASA-, 2013), ALOS AW3D (Japan
Aerospace Exploration Agency -JAXA-, 2021) and
MERIT (Global Hydrology Group, 2018). These
measurements can be used to determine the elevation
of boreholes (Table 1).
The vertical accuracy of global Digital Elevation
Models (DEMs) is partially dependent on the slope
(Uuemaa et al., 2020). For this reason, the MERIT
DEM was also used as a data source, as it removes
multiple error components and a comparison of
global DEMs has shown that in flat terrain the
MERIT DEM is more accurate than SRTM
(Yamazaki et al., 2017) and AW3D (Uuemaa et al.,
2020, p. 9). Comparing the LiDAR based DTM with
MERIT DEM results into a standard deviation of
±3.2m (1-sigma range; total grid coverage); the range