Work

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

Year: 2026
Type: preprint
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.
Language: English
Open Access status: green
OpenAlex ID: W7235215581
Cites: 14
Cited by:
Related to: 10