DOI: 10.5281/zenodo.18240913
title: STATION Database SQL Dump

description: This product represents the database schema of the STATION (Seismic sTATion and sIte amplificatiON) service (https://distav.unige.it/rsni/station2025.php; Tarchini et al., 2024), a web-based platform for the dissemination and exchange of seismological products related to seismic stations. The schema documents the structure adopted to store earthquake metadata, station information, and waveform-derived products used for seismic station and site characterization.

The database schema provides a clear description of how seismological information—such as local magnitude (Ml) estimates, Ml residuals, ground-motion parameters, and spectral products computed on S-phase and noise windows—is organized and related within the service. While the schema reflects the structure used in the operational STATION database, the actual data content is not distributed as part of this product.

The dataset is distributed as a PostgreSQL (https://www.postgresql.org/) database dump and is organized into four main tables, described in detail below.





eventi: earthquake catalog and event metadata.




stazioni: seismic station metadata and aggregated station-level products.




eventi_staz: event–station measurements and waveform-derived products.




parametri: processing parameters used for spectral analyses.
description: eventi contains metadata for each seismic event included in the dataset.





event_id is the unique identifier of the earthquake in the format YYMMDDHHMMSS.




ingv_id is the event identifier provided by the Istituto Nazionale di Geofisica e Vulcanologia (INGV) seismic catalog.




other_id is an alternative event identifier, when available.




rif_id indicates the reference catalog from which event information is derived.




t0 is the origin time of the earthquake [YYYY-MM-DD HH:MM:SS].




lat is the latitude of the earthquake in decimal degrees [°].




lon is the longitude of the earthquake [°].




dpt is the hypocentral depth of the event [km].




mag is the reference magnitude of the earthquake.




stdmag is the standard deviation associated with the reference magnitude.




ns is the number of S-phase picks available for the event.




nn is the number of noise windows available for the event.




nfreq is the number of frequency samples used in the spectral analysis.
description: stazioni contains station metadata and station-level aggregated products derived from multiple seismic events.





rete is the seismic network code of the station.




sigla is the station code.




loc is the location code of the station.




lat is the station latitude [°].




lon is the station longitude [°].




elev is the station elevation above sea level [m].




dataini is the start date of station operation.




datafin is the end date of station operation.




fdsn is the FDSN (https://www.fdsn.org/) station identifier [rete.sigla.loc].




hv_dist_min and hv_dist_max define the minimum and maximum epicentral distances of events used for horizontal-to-vertical spectral ratios (HVSR) computation [km].




hv_mag_min and hv_mag_max define the magnitude range of events used for HVSRs computation.




hv_s_*_mean, hv_s_*_plus_std, hv_s_*_minus_std are the mean, mean plus one standard deviation, and mean minus one standard deviation of HVSRs computed on S-phase windows, for the vertical (Z), north–south (N), and east–west (E) components.




hv_n_*_mean, hv_n_*_plus_std, hv_n_*_minus_std are the mean, mean plus one standard deviation, and mean minus one standard deviation of HVSRs computed on noise windows, for the Z, N, and E components.




spec_*_mean, spec_*_plus_std, spec_*_minus_std are the mean, mean plus one standard deviation, and mean minus one standard deviation of noise spectral amplitudes, for the Z, N, and E components.




stdv_s_*_mean, stdv_n_*_mean, stdv_spec_*_mean represent the standard deviation of spectral values at each frequency, computed across all events contributing to the station-level aggregates.




numb_s_* is the number of S-phase windows for the Z, N, and E components used to compute mean HVSRs.




numb_n_* is the number of noise windows for the Z, N, and E components used to compute mean HVSRs.




numb_spec_* is the number of noise spectral amplitudes for the Z, N, and E components used to compute mean spectra.




event_ids_s_* is the list of event identifiers used to compute mean S-phase HVSRs.




event_ids_n_* is the list of event identifiers used to compute mean noise HVSRs.




event_ids_spec_* is the list of event identifiers used to compute mean noise spectra.




t_min_* and t_max_* define the temporal range (earliest and latest event identifiers) of the events used.




canali lists the available channels at the station.




mask is a quality-control flag used to exclude stations from specific analyses when needed.




luogo is a textual description of the station location.
description: eventi_staz contains measurements and waveform-derived parameters computed for each event–station pair.





event_id is the unique identifier of the earthquake [YYMMDDHHMMSS].




net is the seismic network code of the station.




staz is the station code.




loc is the location code of the station.




fdsn is the FDSN station identifier [net.staz.loc].




chan is the channel code of the station.




dur is the duration of the analyzed signal window [s].




epicdist is the epicentral distance between the event and the station [km].




hypodist is the hypocentral distance between the event and the station [km].




azim is the azimuth from the event to the station [°].




bazim is the back-azimuth from the station to the event [°].




magstaz is the Ml estimated at the station for the event.




magresstaz is the station Ml residual, computed as the difference between station Ml and reference magnitude mag.




flagmag is a boolean quality flag indicating the validity of the station magnitude estimate.




pga_z is the peak ground acceleration measured on the Z component [cm].




pga_n is the peak ground acceleration measured on the N component [cm].




pga_e is the peak ground acceleration measured on the E component [cm].




pgv_z is the peak ground velocity measured on the Z component [cm].




pgv_n is the peak ground velocity measured on the N component [cm].




pgv_e is the peak ground velocity measured on the E component [cm].




hv_s_z is the spectral amplitude array computed on the S-phase window for the Z component.




hv_s_n is the spectral amplitude array computed on the S-phase window for the N component.




hv_s_e is the spectral amplitude array computed on the S-phase window for the E component.




hv_n_z is the spectral amplitude array computed on the noise window for the Z component.




hv_n_n is the spectral amplitude array computed on the noise window for the N component.




hv_n_e is the spectral amplitude array computed on the noise window for the E component.




exist_s indicates whether a valid S-phase window is available for the record.




exist_n indicates whether a valid noise window is available for the record.




log10hv_s_z is the base-10 logarithm of the HVSR computed on the S-phase window, where the horizontal term is defined as the average of the N and E components.




log10hv_s_n is the base-10 logarithm of the HVSR computed on the S-phase window using the N component.




log10hv_s_e is the base-10 logarithm of the HVSR computed on the S-phase window using the E component.




log10hv_n_z is the base-10 logarithm of the HVSR computed on the noise window, where the horizontal term is defined as the average of the N and E components.




log10hv_n_n is the base-10 logarithm of the HVSR computed on the noise window using the N component.




log10hv_n_e is the base-10 logarithm of the HVSR computed on the noise window using the E component.
description: parametri contains parameters used during spectral processing.





freq is the frequency vector used for spectral analysis [Hz].




dur is the duration of the reference time window analyzed [s].




k0_smooth is the smoothing parameter.