Data Manipulation Languages as an Analytical Visualization Tool in the Geosciences: A Case Study of the Seismic Catalog of the University of São Paulo Seismology Center

Background: Scientific figures are often treated as illustrations, although their evidential value depends on whether they can be traced to, and regenerated from, the underlying data. Methods: We evaluated a catalog of 4986 seismic events recorded by the Seismology Center of the University of São Paulo (USP) between 22 May 2023 and 21 May 2026, stored in a dimensional Data Warehouse and analyzed with SQL-based OLAP queries (aggregations by year, magnitude scale, region, weekday, semester and author; contingency tables; continuous percentiles; Top-N rankings). Results: The queries reproduced well-established seismological patterns: shallow events (≤10 km; 52.2%) of moderate to strong magnitude predominated (median 4.81), epicenters traced plate boundaries, and Brazilian intraplate events were weaker than international ones. The same queries exposed two data-quality problems: duplicated spellings of an author name and eight magnitude scales instead of the six defined in the model. Conclusions: Mediating visualization through data manipulation languages gives figures reproducibility, traceability, computational accuracy and, in principle, scalability, and adds a diagnostic capacity that purely illustrative charts lack. These languages are therefore a central methodological tool for environmental and geological data analysis, with reliability that remains conditional on the quality of data loading and modeling.

Authors

Publication Details

Journal
Preprints.org
Published
2026-11-17
DOI
https://doi.org/10.20944/preprints202611.1611.v1
Primary Topic
Scientific Computing and Data Management
Type
preprint
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
preprint

Data Manipulation Languages as an Analytical Visualization Tool in the Geosciences: A Case Study of the Seismic Catalog of the University of São Paulo Seismology Center

Marcelo Augusto de Araújo
Preprints.org
Scientific Computing and Data Management
preprint

Data Manipulation Languages as an Analytical Visualization Tool in the Geosciences: A Case Study of the Seismic Catalog of the University of São Paulo Seismology Center

Marcelo Augusto de Araújo
preprint en

Abstract

Background: Scientific figures are often treated as illustrations, although their evidential value depends on whether they can be traced to, and regenerated from, the underlying data. Methods: We evaluated a catalog of 4986 seismic events recorded by the Seismology Center of the University of São Paulo (USP) between 22 May 2023 and 21 May 2026, stored in a dimensional Data Warehouse and analyzed with SQL-based OLAP queries (aggregations by year, magnitude scale, region, weekday, semester and author; contingency tables; continuous percentiles; Top-N rankings). Results: The queries reproduced well-established seismological patterns: shallow events (≤10 km; 52.2%) of moderate to strong magnitude predominated (median 4.81), epicenters traced plate boundaries, and Brazilian intraplate events were weaker than international ones. The same queries exposed two data-quality problems: duplicated spellings of an author name and eight magnitude scales instead of the six defined in the model. Conclusions: Mediating visualization through data manipulation languages gives figures reproducibility, traceability, computational accuracy and, in principle, scalability, and adds a diagnostic capacity that purely illustrative charts lack. These languages are therefore a central methodological tool for environmental and geological data analysis, with reliability that remains conditional on the quality of data loading and modeling.

Preprints.org
Scientific Computing and Data Management
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon