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

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.

[1]  Roberto Paolucci,et al.  Record Processing in ITACA, the New Italian Strong-Motion Database , 2011 .

[2]  Giulio Selvaggi,et al.  CSI Catalogo della sismicità italiana 1981-2002, versione 1.1 , 2006 .

[3]  David J. Wald,et al.  Evaluation of Ground-Motion Modeling 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 , 2009 .

[4]  Alberto Michelini,et al.  Regression analysis of MCS intensity and ground motion spectral accelerations (SAs) in Italy , 2011 .

[5]  Claudio Margottini,et al.  Intensity versus ground motion: A new approach using Italian data , 1992 .

[6]  G-Akis Tselentis,et al.  Empirical Relationships between Modified Mercalli Intensity and Engineering Ground-Motion Parameters in Greece , 2008 .

[7]  Aysegul Askan,et al.  Relationships between Felt Intensity and Recorded Ground‐Motion Parameters for Turkey , 2014 .

[8]  R. Musson,et al.  Intensity and Intensity Scales , 2012 .

[9]  Alberto Michelini,et al.  The 2009 L'Aquila (central Italy) MW6.3 earthquake: Main shock and aftershocks , 2009 .

[10]  L. Faenza,et al.  Regression analysis of MCS intensity and ground motion parameters in Italy and its application in ShakeMap , 2010 .

[11]  Stefan Wiemer,et al.  Ground Motion to Intensity Conversion Equations (GMICEs): A Global Relationship and Evaluation of Regional Dependency , 2015 .

[12]  Simone Tarquini,et al.  TINITALY/01: a new Triangular Irregular Network of Italy , 2007 .

[13]  Patrizia Tosi,et al.  Determination of the macroseismic field by means of trend and multivariate analysis of questionnaire data , 1992 .

[14]  M. Locati,et al.  DBMI15, the 2015 version of the Italian Macroseismic Database , 2016 .

[15]  Andrea Tertulliani,et al.  A method for the analysis of macroseismic questionnaires , 1992 .

[16]  Rodolfo Puglia,et al.  Site characterization of Italian accelerometric stations , 2016, Bulletin of Earthquake Engineering.

[17]  Oona Scotti,et al.  The French macroseismic database SISFRANCE: objectives, resultsand perspectives , 2004 .

[18]  Lucia Luzi,et al.  ITACA (ITalian ACcelerometric Archive): A Web Portal for the Dissemination of Italian Strong-motion Data , 2008 .

[19]  Polat Gülkan,et al.  Earthquake Data in Engineering Seismology , 2011 .

[20]  Mauro Dolce,et al.  Guest editorial: L’Aquila earthquake: seismic sequence of 6th April 2009, Abruzzo, Italy , 2011 .

[21]  Romano Camassi,et al.  DBMI04, il database delle osservazioni macrosismiche dei terremoti italiani utilizzate per la compilazione del catalogo parametrico CPTI04 , 2007 .

[22]  Massimiliano Stucchi,et al.  CPTI11, the 2011 version of the Parametric Catalogue of Italian Earthquakes , 2011 .

[23]  Dario Albarello,et al.  Aggiornamento relazioni fra l'intensità macrosismica e PGA. Progetto INGV-DPC S1, Deliverable D11. , 2007 .

[24]  Roger M. W. Musson,et al.  The comparison of macroseismic intensity scales , 2010 .

[25]  Danijel Schorlemmer,et al.  QuakeML: status of the XML-based seismological data exchange format , 2011 .

[26]  Roger M.W. Musson,et al.  Macroseismic Surveys in Theory and Practice , 2004 .

[27]  Romano Camassi,et al.  Catalogues of historical earthquakes in Italy , 2004 .

[28]  Danijel Schorlemmer,et al.  QuakeML - An XML Schema for Seismology , 2004 .

[29]  E. Guidoboni,et al.  The contribution of historical records of earthquakes to the evaluation of seismic hazard , 1993 .

[30]  Fawzi Doumaz,et al.  Release of a 10-m-resolution DEM for the Italian territory: Comparison with global-coverage DEMs and anaglyph-mode exploration via the web , 2012, Comput. Geosci..

[31]  Roberto Paolucci,et al.  Overview of the Italian strong motion database ITACA 1.0 , 2010 .