GNGTS 2019 - Atti del 38° Convegno Nazionale

GNGTS 2019 S essione 2.1 293 Architecture of the database. The architecture of the database has been modified in order to archive additional information in 100 tables, managed by the open-source software PostgreSQL (https://www.postgresql.org/) which supersedes MySQL. The software that operates the database is entirely open source: Python (https://www.python.org/) for data archival and management and user authentication and AngularJS (https://angularjs.org/ ) for the web site design. Many routines are based on ObsPy (https://www.obspy.org ), an open-source project with the aim to facilitate rapid application development for seismology providing a common Python framework. The new database architecture enables the association of multiple information related to the same object; for instance, a recording station can be linked to several geological maps and/or ambient noise measurements. In case of multiple sources of information, the database operators always recommend the most reliable one. Website. The graphic interface of the ITACA 3.0 website has been renewed. The website is now available in two languages, Italian and English, and provides various tools to explore the database content (i.e. glossary, pop-up). As in the earlier ITACA versions, the website contains three main sections related to waveforms, events, and recording stations. Each section provides several key fields, organized in thematic sections, to query the database. The queries outcomes are provided as tables or maps. OpenStreetMap is the map layer for the visualization of event and recording stations. The main updates of the section Station are: • A new Seismological Analysis section showing Horizontal-to-Vertical spectral ratio of 5% damped acceleration response spectra (HVRS), Horizontal-to-Vertical spectral ratio of S-phase acceleration Fourier spectra (S-phase HVSR), and Horizontal-to-Vertical spectral ratio of coda acceleration Fourier spectra; • The section Site Parameters has been enriched with new information such as V S,30 estimated from slope angle and corresponding EC8 soil category. NTC18 soil category (Italian Seismic Code, NTC 2018) are assigned when the S-wave velocity profile is available; • The section  Photogallery  collects photos of the recording stations, displaying housing, instrumentation, and surrounding landscape; • The section Documentation  archives the station report, which summarize all the relevant information about stations available in the database, as well as other documents related to local site response. The main updates of the section Events are: • The section  Shakemap  shows the ground motion distribution of the seismic events in terms of Peak Ground Acceleration (PGA), Peak Ground Velocity (PGV), and Spectral Acceleration (SA) for periods 0.3, 1, and 3s. The Shakemaps are reviewed and published by the INGV (http://shakemap.rm.ingv.it/) ; • The section Moment tensor which shows the solutions of the moment tensor, including the beach ball representation; • The section  Source with the information regarding the causative fault geometry and the nucleation point coordinates. The main updates of the section Waveforms regard the display of time histories and spectra and the addition of new key-fields for the waveform selection. Data and Services Access. The User may have access to data and services distributed through the ITACA web site as Anonymous or Registered User by an authentication system. In the former case, just the metadata exploration is allowed; in the latter case, the authentication is mandatory to navigate and/or download waveforms together with related spectra and metadata in two data formats (i.e. ASCII or ASDF https://seismic-data.org/ ). Documentation. In order to guide the User in browsing the ITACA web site, a sidebar has been added. The sidebar contains different levels of information such as general overview of