Skip to main content
Log in

Rosetta, a tool for linking accelerometric recordings and macroseismic observations: description and applications

  • Original Research Paper
  • Published:
Bulletin of Earthquake Engineering Aims and scope Submit manuscript

Abstract

Investigating relationships between macroseismic intensity and strong-motion data requires the existence of these two records for the same seismic event and site. In Italy, this comparison is feasible through the cross-matching of the Italian Macroseismic Database (DBMI) and the Italian Strong-Motion Database (ITACA) which are the most comprehensive sources of both data. However, the two databases lack a direct link which would allow performing joint analysis of macroseismic data points and strong-motion recordings, making the comparison a time consuming job for the researcher. This paper demonstrates the usefulness of cross-database identifiers, and presents their use in a web-tool called Rosetta, an initial proof-of-concept that helped testing linking procedures among DBMI and ITACA, and user friendly visual solutions. The development allowed the working group to exchange expertise on their respective database structures and workflows, laying the groundwork for a consistent, low-maintenance, and durable solution that will be easily updatable each time a new version of DBMI or ITACA will be released.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10

Similar content being viewed by others

References

  • Allen TI, Wald DJ (2009) Evaluation of ground-motion modelling techniques for use in global ShakeMap: a critique of instrumental ground motion prediction equations, peak ground motion to macroseismic intensity conversions, and macroseismic intensity predictions in different tectonic settings. Open-File Report 2009-1047, U.S. Geological Survey, p 114

  • Bilal M, Askan A (2014) Relationships between felt intensity and recorded ground-motion parameters for Turkey. Bull Seismol Soc Am 104(1):484–486. doi:10.1785/0120130093

    Article  Google Scholar 

  • Camassi R (2004) Catalogues of historical earthquakes in Italy. Ann Geophys 47(2–3):645–657. doi:10.4401/ag-3329

    Google Scholar 

  • Camassi R, Galli P, Tertulliani A, Castenetto S, Lucantoni A, Molin D, Naso G, Peronace E, Bernardini F, Castelli V, Cavaliere A, Ercolani E, Salimbeni S, Tripone D, Vannucci G, Arcoraci L, Berardi M, Castellano C, Del Mese S, Graziani L, Leschiutta I, Maramai A, Massucci A, Rossi A, Vecchi M, Azzaro R, D'Amico S, Ferrari F, Mostaccio N, Platania R, Scarfì L, Tuvé T, Zuccarello L, Carlino S, Marturano A, Albini P, Gomez Capera AA, Locati M, Meroni F, Pessina V, Piccarreda C, Rovida A, Stucchi M, Buffarini G, Paolini S, Verrubbi V, Mucciarelli M, Gallipoli MR, Barbano MS, Cecić I, Godec M (2009) Macroseismic investigation: methodology, earthquake parameters, unresolved issues. Progettazione Sismica, Special Issue 03:47–53. ISSN 1973-7462

  • Caprio M, Tarigan B, Worden CB, Wiemer S, Wald DJ (2015) Ground motion to intensity conversion equations (GMICEs): a global relationship and evaluation of regional dependency. Bull Seismol Soc Am 105(3):1476–1490. doi:10.1785/012014286

    Article  Google Scholar 

  • Castello B, Selvaggi G, Chiarabba C, Amato A (2006) CSI Catalogo della sismicità italiana 1981–2002, versione 1.1. INGV-CNT, Roma. http://csi.rm.ingv.it/. Accessed Dec 2015

  • Cecić I, Musson RMW (2004) Macroseismic surveys in theory and practice. Nat Hazards 31:39–61. doi:10.1023/B:NHAZ.0000020255.00986.37

    Article  Google Scholar 

  • Chiarabba C, Amato A, Anselmi M, Baccheschi P, Bianchi I, Cattaneo M, Cecere G, Chiaraluce L, Ciaccio GM, De Gori P, De Luca G, Di Bona M, Di Stefano R, Faenza L, Govoni A, Improta L, Lucente FP, Marchetti A, Margheriti L, Mele F, Michelini A, Monachesi G, Moretti M, Pastori M, Piana Agostinetti N, Piccinini D, Roselli P, Seccia D, Valoroso L (2009) The 2009 L’Aquila (Central Italy) Mw 6.3 earthquake: main shock and aftershocks. Geophys Res Lett. doi:10.1029/2009GL039627

    Google Scholar 

  • CSTI Working Group (2005) Catalogo Strumentale dei Terremoti Italiani dal 1981 al 1996 (Versione 1.1). http://gaspy.df.unibo.it/paolo/gndt/Versione1_1/Leggimi.htm. Accessed Dec 2015

  • Cua G, Wald DJ, Allen TI, Garcia D, Worden CB, Gerstenberger M, Lin K, Marano K (2010) “Best Practices” for using macroseismic intensity and ground-motion-intensity conversion equations for hazard and loss models in GEM1, GEM technical report 2010-4, GEM Foundation, Pavia, Italy

  • De Rubeis V, Gasparini C, Tosi P (1992) Determination of the macroseismic field by means of trend and multivariate analysis of questionnaire data. Bull Seismol Soc Am 82(3):1206–1222

    Google Scholar 

  • Faccioli E, Cauzzi C (2006) Macroseismic intensities for seismic scenarios estimated from instrumentally based correlations. In: Proceedings of the first European conference on earthquake engineering and seismology, Geneva, Switzerland, 3–8 September, paper no. 569

  • Faenza L, Michelini A (2010) Regression analysis of MCS intensity and ground motion parameters in Italy and its application in ShakeMap. Geophys J Int 180:1138–1152. doi:10.1111/j.1365-246X.2009.04467.x

    Article  Google Scholar 

  • Faenza L, Michelini A (2011) Regression analysis of MCS intensity and ground motion spectral accelerations (SAs) in Italy. Geophys J Int 186:1415–1430

    Article  Google Scholar 

  • Fäh D, Giardini D, Kästli P, Deichmann N, Gisler M, Schwarz-Zanetti G, Álvarez-Rubio S, Sellami S, Edwards B, Allmann B, Bethmann F, Wössner J, Gassner-Stamm G, Fritsche S, Eberhard D (2011) ECOS-09 earthquake catalogue of Switzerland release 2011 report and database. Swiss Seismological Service ETH Zurich, Report SED/RISK/R/001/20110417, pp 42+ Appendices. http://hitseddb.ethz.ch:8080/ecos09. Accessed Dec 2015

  • Felicetta C, D’Amico M, Lanzano G, Puglia R, Russo E, Luzi L (2016) Site characterization of Italian accelerometric stations. Bull Earthq Eng, accepted to BEE special issue project S2-2014

  • Galli P, Camassi R, Azzaro R, Bernardini F, Castenetto S, Molin D, Peronace E, Rossi A, Vecchi M, Tertulliani A (2009) Il terremoto aquilano del 6 aprile 2009: rilievo macrosismico, effetti di superficie ed implicazioni sismotettoniche. Il Quat Italian J Quat Sci 22(2):235–246 (in Italian)

    Google Scholar 

  • Gasparini C, De Rubeis V, Tertulliani A (1992) A method for the analysis of macroseismic questionnaires. Nat Hazards 5(2):169–177. doi:10.1007/BF00127004

    Article  Google Scholar 

  • Gomez Capera AA, Albarello D, Gasperini P (2007) Aggiornamento relazioni fra l’intensità macrosismica e PGA. Technical report, DPC-INGV Project S1, Task 2, Deliverable D11, Istituto Nazionale di Geofisica e Vulcanologia, Sezione di Milano-Pavia, http://esse1.mi.ingv.it/d11.html. Accessed Dec 2015 (in Italian)

  • Gomez Capera AA, Locati M, Fiorini E, Bazzurro P, Luzi L, Massa M, Puglia R, Santulin M (2015) D3.1 Macroseismic and ground motion: site-specific conversion rules. DPC-INGV-S2 Project-2015, Deliverable 3.1, https://sites.google.com/site/ingvdpc2014progettos2/deliverables/. Accessed Dec 2015

  • Grünthal G (ed) (1998) European Macroseismic Scale 1998 (EMS-98). Cahiers du Centre Européen de Géodynamique et de Séismologie 15, Centre Européen de Géodynamique et de Séismologie, Luxembourg. ISBN:2-87977-008-4

  • Guidoboni E, Stucchi M (1993) The contribution of historical records of earthquakes to the evaluation of seismic hazard. Ann Geophys 36(3–4):201–215. doi:10.4401/ag-4264

    Google Scholar 

  • International Seismological Centre (ISC) On-line bulletin, http://www.isc.ac.uk, Internatl. Seis. Cent., Thatcham. http://www.isc.ac.uk/iscbulletin/. Accessed Dec 2015

  • Istituto Nazionale di Geofisica (ING) (1982–1996) Bollettino Macrosismico, Istituto Nazionale di Geofisica, Roma

  • Istituto Nazionale di Geofisica e Vulcanologia (INGV) (1983–2008) Bollettino Sismico Strumentale, Istituto Nazionale di Geofisica e Vulcanologia, Roma. http://legacy.ingv.it/roma/reti/rms/bollettino/. Accessed Dec 2015

  • Locati M, Camassi R, Stucchi M (eds) (2011) DBMI11, the 2011 version of the Italian Macroseismic Database. Istituto Nazionale di Geofisica e Vulcanologia, Milano, Bologna. doi:10.6092/INGV.IT-DBMI11

  • Luzi L, Felicetta C, Puglia R, Russo E, Pacor F, D’Amico M, Lanzano G, Task2 Working Group (Albarello D, Barani S, Barnaba C, Castellaro S, Gallipoli M, Laurenzano G, Massa M, Moscatelli M) (2015) D2.1—site-specific characterization of selected ITACA stations. DPC-INGV-S2 Project-2015, Deliverable 2.1. https://sites.google.com/site/ingvdpc2014progettos2/deliverables/. Accessed Dec 2015

  • Luzi L, Hailemikael S, Bindi D, Pacor F, Mele F, Sabetta F (2008) ITACA (ITalian ACcelerometric Archive): a web portal for the dissemination of Italian strong-motion data. Seismol Res Lett 79(5):716–722. doi:10.1785/gssrl.79.5.716

    Article  Google Scholar 

  • Margottini C, Molin D, Serva L (1992) Intensity versus ground motion: a new approach using Italian data. Eng Geol 33(1):45–58. doi:10.1016/0013-7952(92)90034-V

    Article  Google Scholar 

  • Medvedev S, Sponheuer W, Karník V (1964) Neue seismische Skala Intensity scale of earthquakes, 7. Tagung der Europäischen Seismologischen Kommission vom 24.9. bis 30.9.1962. In: Jena, Veröff. Institut für Bodendynamik und Erdbebenforschung in Jena, Deutsche Akademie der Wissenschaften zu Berlin, vol 77, pp 69–76 (in German)

  • Ministero dell’Ambiente e della Tutela del Territorio e del Mare (MATTM) (2012) Ortofoto a colori, anno 2012. Geoportale Nazionale. http://www.pcn.minambiente.it/GN/en/. Accessed Dec 2015

  • Molin D (2003) Considerazioni sull’eventuale adozione in Italia della scala macrosismica europea (EMS-1998). In: Atti del 22° convegno nazionale GNGTS. ISBN/ISSN:88-900385-9-4 (in Italian)

  • Molin D, Peronace E, Castenetto S, Galli P (2010) Terremoto aquilano del 6 Aprile 2009: rilievo dei danni a Sant’Eusanio Forconese e stima dell’intensità macrosismica secondo la scala EMS-98. Proceedings, 29° Convegno Nazionale GNGTS, Prato (Italy), 26–28 Oct 2010, pp 77–79 (in Italian)

  • Monachesi G, Stucchi M (1997) DOM4.1, un database di osservazioni macrosismiche di terremoti di area italiana al di sopra della soglia del danno. Internal report, Gruppo Nazionale per la Difesa dai Terremoti (GNDT), Milano-Macerata. http://emidius.mi.ingv.it/DOM/. Accessed Dec 2015 (in Italian)

  • MPS Working Group (2004) Redazione della mappa di pericolosità sismica prevista dall’Ordinanza PCM del 20 marzo 2003 n.3274 All. 1. Rapporto conclusivo per il Dipartimento della Protezione Civile. Istituto Nazionale di Geofisica e Vulcanologia, Milano-Roma. http://zonesismiche.mi.ingv.it/. Accessed Dec 2015 (in Italian)

  • Musson RMW, Cecić I (2012) Intensity and intensity scales. In: Bormann P (ed) New manual of seismological observatory practice 2 (NMSOP-2), Potsdam, Deutsches GeoForschungsZentrum GFZ, pp 1–41. doi:10.2312/GFZ.NMSOP-2_ch12

  • Musson RMW, Grünthal G, Stucchi M (2009) The comparison of macroseismic intensity scales. J Seismol 14(2):413–428. doi:10.1007/s10950-009-9172-0

    Article  Google Scholar 

  • National Earthquake Information Center (NEIC) PDE bulletin, preliminary determinations of epicenters, monthly listing. http://earthquake.usgs.gov/data/pde.php. Accessed Dec 2015

  • Pacor F, Paolucci R, Luzi L, Sabetta F, Spinelli A, Gorini A, Nicoletti M, Marcucci S, Filippi L, Dolce M (2011) Overview of the Italian strong motion database ITACA 1.0. Bull Earthq Eng 9(6):1723–1739. doi:10.1007/s10518-010-9240-4

    Article  Google Scholar 

  • Paolucci R, Pacor F, Puglia R, Ameri G, Cauzzi C, Massa M (2011) Record processing in ITACA, the new Italian strong-motion database. In: Akkar S, Gülkan P, Van Eck T (eds) Earthquake data in engineering seismology: predictive models, data management, and networks. Springer, The Netherlands, pp 99–113. doi:10.1007/978-94-007-0152-6

    Chapter  Google Scholar 

  • Rovida A, Camassi R, Gasperini P, Stucchi M (eds) (2011) CPTI11, the 2011 version of the Parametric Catalogue of Italian Earthquakes. Istituto Nazionale di Geofisica e Vulcanologia, Milano, Bologna. doi:10.6092/INGV.IT-CPTI11

  • Sandvi B (2013) Converting terrain data to a WebGL-friendly format, Terrain building with three.js. Blog. http://thematicmapping.org/. Accessed Dec 2015

  • Schorlemmer D, Wyss A, Maraini S, Wiemer S, Baer M (2004) QuakeML—an XML schema for seismology. ORFEUS Newslett. http://www.orfeus-eu.org/organization/Organization/Newsletter/vol6no2/quakeml.shtml. Accessed Dec 2015

  • Schorlemmer D, Euchner F, Kästli P, Saul J (2011) QuakeML: status of the XML-based seismological data exchange format. Ann Geophys 54(1):59–65. doi:10.4401/ag-4874

    Google Scholar 

  • Scotti O, Baumont D, Quenet G, Levret A (2004) The French macroseismic database SISFRANCE: objectives, resultsand perspectives. Ann Geophys 47(2–3):571–581. doi:10.4401/ag-3323

    Google Scholar 

  • Sieberg A (1930) Geologie der Erdbeben. Handbuch der Geophysik 2(4):552–555 (in German)

    Google Scholar 

  • Stucchi M, Albini A (1991) New developments in macroseismic investigation. In: Proceedings of the international workshop on seismology and earthquake engineering, Mexico City, pp 47–70

  • Stucchi M, Camassi R, Rovida A, Locati M, Ercolani E, Meletti C, Migliavacca P, Bernardini F, Azzaro R (2007) DBMI04, il database delle osservazioni macrosismiche dei terremoti italiani utilizzate per la compilazione del catalogo parametrico CPTI04. Quaderni di Geofisica, vol 49 (in Italian)

  • Tarquini S, Isola I, Favalli M, Mazzarini F, Bisson M, Pareschi MT, Boschi E (2007) TINITALY/01: a new triangular irregular network of Italy. Ann Geophys 50(3):407–425. doi:10.4401/ag-4424

    Google Scholar 

  • Tarquini S, Vinci S, Favalli M, Doumaz F, Fornaciai A, Nannipieri L (2012) Release of a 10-m-resolution DEM for the Italian territory: comparison with global-coverage DEMs and anaglyph-mode exploration via the web. Comput Geosci 38:168–170. doi:10.1016/j.cageo.2011.04.018

    Article  Google Scholar 

  • Tertulliani A, Galli P (2012) Scale macrosismiche a confronto. Il caso del rilievo dei terremoti del maggio 2012 (ML 5.9, 5.8 E 5.3) nella pianura padano-emiliana. In: Atti del 31° convegno nazionale GNGTS. ISBN/ISSN:88-900385-9-4 (in Italian)

  • Tselentis G, Danciu L (2008) Empirical relationships between modified Mercalli intensity and engineering ground-motion parameters in Greece. Bull Seismol Soc Am 98(4):1863–1875. doi:10.1785/0120070172

    Article  Google Scholar 

Download references

Acknowledgments

The authors acknowledge the support provided by the Italian Department of Civil Protection to the project INGV-DPC S2-2014 “Constraining Observations into Seismic Hazard”. This paper does not necessarily represent DPC official opinion and policies. We are grateful to the coordinators, Laura Peruzza, Francesca Pacor, and Agostino Goretti, for granting the opportunity to actively participate in the project, and Marco Massa for his useful advices. We thank Paolo Galli and an anonymous reviewer for their constructive comments that greatly improved the overall manuscript quality and readability.

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Mario Locati.

Electronic supplementary material

Below is the link to the electronic supplementary material.

Supplementary material 1 (PDF 1598 kb)

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Locati, M., Gomez Capera, A.A., Puglia, R. et al. Rosetta, a tool for linking accelerometric recordings and macroseismic observations: description and applications. Bull Earthquake Eng 15, 2429–2443 (2017). https://doi.org/10.1007/s10518-016-9955-y

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10518-016-9955-y

Keywords

Navigation