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.
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
Camassi R (2004) Catalogues of historical earthquakes in Italy. Ann Geophys 47(2–3):645–657. doi:10.4401/ag-3329
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
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
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
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
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
Faenza L, Michelini A (2011) Regression analysis of MCS intensity and ground motion spectral accelerations (SAs) in Italy. Geophys J Int 186:1415–1430
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)
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
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
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
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
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
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
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
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
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
Sieberg A (1930) Geologie der Erdbeben. Handbuch der Geophysik 2(4):552–555 (in German)
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
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
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
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
Corresponding author
Electronic supplementary material
Below is the link to the electronic supplementary material.
Rights and permissions
About this article
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
Received:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s10518-016-9955-y