Józef Szpikowski
Current Organizations / Institutes
The organizations/institutes from the scholar's latest article
Research Subjects
Research Interests
Józef Szpikowski has a total of 20 co-authors. Here are the top co-authors by number of shared publications:
- Andrzej Kostrzewski
Adam Mickiewicz University in Poznan
3 shared publications - Mikołaj Majewski
Institute of Geoecology and Geoinformation, Faculty of Geographical and Geological Sciences, Adam Mickiewicz University in Poznań, ul. Krygowskiego 10, 61-680 Poznań, Poland
3 shared publications Monika Domańska
3 shared publications- Grażyna Szpikowska2 shared publications
- Marek Marciniak
Adam Mickiewicz University in Poznan
2 shared publications Andrzej Kostrzewski
1 shared publication
Latest Publications
- Open Access
- 17 September 2025
- Published by Adam Mickiewicz University Poznan in Quaestiones Geographicae
- Vol. 44 (3) , 159-173
Integrating PostgreSQL and R: Open-source tools for processing and reporting monitoring data
Environmental monitoring requires effective data collection, management and presentation. With the increasing amount of monitoring data, it is becoming increasingly important to develop tools for effective data management and visualisation. This paper explores the potential of integrating the PostgreSQL database system with the R environment to automate the processing, analysis and reporting of multidimensional environmental data. The results of hydrological monitoring conducted as part of the Integrated Monitoring of the Natural Environment (ZMŚP) programme were used as a case study. The basic component of the ZMŚP programme’s IT system is a relational database, where the results of environmental monitoring are stored. This database serves as a data source for the data warehouse. The data processing process, which includes archiving, verification and aggregation, uses Structured Query Language (SQL) and the procedural language PL/pgSQL. In order to generate interactive visualisations and automate reporting, the R programming environment was used in conjunction with the R Markdown tool and the plotly library. The combination of the PostgreSQL system with the plotly package in the R environment offers a number of benefits in terms of data visualisation and analysis, while also serving as an example of the use of Online Analytical Processing (OLAP) tools in the analysis and presentation of environmental data. The use of open-source solutions not only significantly reduces implementation costs but also increases the availability of technology to a wide range of users, including public institutions involved in environmental monitoring.
- 17 September 2025
- Published by Adam Mickiewicz University Poznan in Quaestiones Geographicae
- Vol. 44 (3) , 159-173
Open AccessIntegrating PostgreSQL and R: Open-source tools for processing and reporting monitoring data
Environmental monitoring requires effective data collection, management and presentation. With the increasing amount of monitoring data, it is becoming increasingly important to develop tools for effective data management and visualisation. This paper explores the potential of integrating the PostgreSQL database system with the R environment to automate the processing, analysis and reporting of multidimensional environmental data. The results of hydrological monitoring conducted as part of the Integrated Monitoring of the Natural Environment (ZMŚP) programme were used as a case study. The basic component of the ZMŚP programme’s IT system is a relational database, where the results of environmental monitoring are stored. This database serves as a data source for the data warehouse. The data processing process, which includes archiving, verification and aggregation, uses Structured Query Language (SQL) and the procedural language PL/pgSQL. In order to generate interactive visualisations and automate reporting, the R programming environment was used in conjunction with the R Markdown tool and the plotly library. The combination of the PostgreSQL system with the plotly package in the R environment offers a number of benefits in terms of data visualisation and analysis, while also serving as an example of the use of Online Analytical Processing (OLAP) tools in the analysis and presentation of environmental data. The use of open-source solutions not only significantly reduces implementation costs but also increases the availability of technology to a wide range of users, including public institutions involved in environmental monitoring.
- 3 September 2025
- Published by Elsevier in Geomorphology
- Vol. 489
Assessment of soil erosion by water on agricultural slopes in Poland based on runoff plot measurements
- 3 September 2025
- Published by Elsevier in Geomorphology
- Vol. 489
Assessment of soil erosion by water on agricultural slopes in Poland based on runoff plot measurements
- 1 January 2022
- Published by Bogucki Wydawnictwo Naukowe
- p. 120-132
Geobotaniczne aspekty występowania kenofitów w zlewni górnej Parsęty (Pomorze Zachodnie)
- 1 January 2022
- Published by Bogucki Wydawnictwo Naukowe
- p. 120-132
Geobotaniczne aspekty występowania kenofitów w zlewni górnej Parsęty (Pomorze Zachodnie)
- 1 January 2022
- Published by Bogucki Wydawnictwo Naukowe
- p. 59-71
Założenia i realizacja problematyki monitoringu środowiska przyrodniczego w dydaktyce uniwersyteckiej
- 1 January 2022
- Published by Bogucki Wydawnictwo Naukowe
- p. 59-71
Założenia i realizacja problematyki monitoringu środowiska przyrodniczego w dydaktyce uniwersyteckiej
- 1 January 2022
- Published by Bogucki Wydawnictwo Naukowe
- p. 100-119
Zjawiska ekstremalne w zlewni górnej Parsęty i ich wpływ na funkcjonowanie środowiska geograficznego
- 1 January 2022
- Published by Bogucki Wydawnictwo Naukowe
- p. 100-119
Zjawiska ekstremalne w zlewni górnej Parsęty i ich wpływ na funkcjonowanie środowiska geograficznego
- 1 January 2022
- Published by Bogucki Wydawnictwo Naukowe
- p. 7-12
Przedmowa
- 30 December 2018
- Published by Bogucki Wydawnictwo Naukowe in Landform Analysis
- Vol. 36, 55-69
Conditions for soil erosion by water in the upper Parsęta catchment
The paper presents potential soil erosion risk of the upper Parsęta catchment (Drawskie Lake District, NW Poland). The model considers following conditions affecting the size of soil erosion: slope gradient, LS factor, lithology, land use and land cover. Thematic maps have been reclassified into a 4-degree division. Potential soil erosion risk map was prepared on the basis of thematic maps. Areas with small and moderate susceptibility to soil erosion occupy 71.5% of the catchment area. The 4th class of erosiveness is represented by the river valley slopes, steep slopes of kame and moraine hills, covering 28.5% of the upper Parsęta catchment.
- 30 December 2018
- Published by Bogucki Wydawnictwo Naukowe in Landform Analysis
- Vol. 36, 55-69
Conditions for soil erosion by water in the upper Parsęta catchment
The paper presents potential soil erosion risk of the upper Parsęta catchment (Drawskie Lake District, NW Poland). The model considers following conditions affecting the size of soil erosion: slope gradient, LS factor, lithology, land use and land cover. Thematic maps have been reclassified into a 4-degree division. Potential soil erosion risk map was prepared on the basis of thematic maps. Areas with small and moderate susceptibility to soil erosion occupy 71.5% of the catchment area. The 4th class of erosiveness is represented by the river valley slopes, steep slopes of kame and moraine hills, covering 28.5% of the upper Parsęta catchment.
- 1 August 2014
- Published by Elsevier in Geomorphology
- Vol. 218, 52-62
Character and rate of denudation in a High Arctic glacierized catchment (Ebbaelva, Central Spitsbergen)
- 1 August 2014
- Published by Elsevier in Geomorphology
- Vol. 218, 52-62
Character and rate of denudation in a High Arctic glacierized catchment (Ebbaelva, Central Spitsbergen)