The EEE database
The EEE database (mdb format) is formed with four tables,
following the basic concepts of EEE scale. Therefore, each record
in the table “Earthquake” is associated with
one-to-many records in the “Locality” sub-table and
each record in “Locality” is associated to one-to-many
records in its “EEE Sites” sub-table.
The main table “Earthquake” is intended to present
general information on the seismic event, including surface
faulting parameters and total area of secondary EEEs. In the
“Locality” table should be reported all the information
about the characteristics of the locality where one or many
coseismic effects have occurred, i.e. location (coordinates,
altitude) and local expression of the earthquake (local
macroseismic intensity). In the “Site” table should be
reported all the characteristics of the site (location,
geomorphological environment, etc.) and the type of effect (local
surface faulting, slope movements, ground cracks, ground
settlements, hydrological anomalies, etc.). Information about the
effect size, as requested in the EEE scale, can be archived in
detail according to the type of effect.
Since the characteristics and the size of one effect do not
change significantly, it is possible to archive them in one single
record (for example, numerous ground cracks similar in length and
width and located very close). Furthermore, information about
damages on man-made structures (buildings, bridges, roads, etc.) in
the same site can be archived in a proper table.
In order to standardize the descriptions of the effect and the
site (i.e. to call the same object with the same name) it was
established to enhance the data input through the selection of
attributes from a predefined menu.
At the end of the detailed description of a single site it is
possible to assess the range of EEE intensities (minimum and
maximum values) compatible to the size of the effect and the
associated feature. As the data input for a locality has been
completed, it is possible to evaluate the EEE intensity for that
locality on the basis of all EEE effects occurred in that locality.
Finally, the EEE database allows to generate a table of localities
with coordinates and EEE local intensities that can be exported and
loaded on a GIS project, in order to map the field of EEE
intensities.
A preliminary version of the EEE database web interface is still
under construction
