ikona ikona
ORCID: 0000-0003-1005-5323
EMAIL: ilbam@uek.krakow.pl
Google Scholar: Mateusz Ilba
GitHub: MateuszIlba
LAB PHONE: (+48) 12-293-59-72
ROOM: 418 bldg. F
ADDRESS: Rakowicka 27 31-510 Krakow, Poland

Hello!

I am Assistant Professor at the Department of Socioeconomic Geography at the Cracow University of Economics. My scientific and research work focuses on various analyses using GIS systems, implementing parallel calculations in diverse application environments and programming related to spatial and economic analyses. Other interests include renewable energy in the context of spatial and economic analyses. Acquainted with CAD software packages (Autodesk, Bentley), graphics programs (Blender, GIMP), GIS software (ArcGIS, QGIS), and SQL data bases (PostGIS, SpatiaLite).

Key interests:
» GIS;
» Spatial Databases;
» Python;
» Solar Energy;
» Urban planning.

Conducted academic courses:
» Basics of Geodesy;
» Spatial Data Collection Methods;
» Land Information Systems (LIS);
» Spatial Visualization and Designing.

Awards and research projects:
» 2013 - Scott Lofgren Student Design Competition
» 2015 - Scholarship Anna Pasek


zeszyt

Publications

Please write to e-mail if you need a digital version of the selected publication
2021

Photovoltaic Solar Energy from Urban Sprawl: Potential for Poland
A. Hołuj, M. Ilba, P. Lityński, K. Majewski, M. Semczuk, P. Serafin
Journal: Energies 14(24)
Show abstract Hide abstract
Urban sprawl is a process that shapes contemporary urban spaces. Generally, this process is associated with negative effects due to the generation of high costs. However, not all the effects of urban sprawl should be considered in the context of the increasing costs of the use of space; some of them should be regarded as cost cutting factors, for example, the possibility of the use of roofed areas in generating energy from sunlight. Solar energy is believed to be one of the sources of clean energy that reduce pollution and greenhouse gas emissions into the atmosphere. However, solar energy generation necessitates the development of large areas for the purpose of installing photovoltaic modules and substantial funds for creating large solar farms. For this reason, a significant role in state energy policies is played by small dispersed installations mounted on the roofs of buildings. There is a gap in existing research on the assessment of urban sprawl in terms of the potential use of rooftops for solar installations in suburban areas. This research gap has not yet been filled, either conceptually and methodologically. Hence, the contribution of the research to the development of the current state of knowledge involves the identification of economic and environmental benefits of usually negatively perceived urban sprawl. The proposal of a method for the identification of suburban housing potential for solar energy generation constitutes another addition to the state of knowledge. The main objective of this article is to analyse the energy generating potential of buildings located in suburban and urban areas characterised by the confirmed occurrence of urban sprawl phenomena. CityGML data were used to conduct an analysis of the exposure of roofs to sunlight using algorithms based on vector data. The authors estimated the dynamics of changes in time and referred the existing photovoltaic installations to the total potential of a selected area. The use of the energy potential of the analysed roofs of buildings was used to evaluate the external costs and benefits of spatial planning. The discussion presented the current conditions of the energy sector and energy policies in Poland and the EU. In addition, recommendations were proposed for local spatial policies concerning the mitigation of the effects of suburbanization in the context of developing the system of PV micro-installations.

Parallel algorithm for improving the performance of spatial queries in SQL: The use cases of SQLite/SpatiaLite and PostgreSQL/PostGIS databases
M. Ilba
Journal: Computers & Geosciences, Volume 155
Show abstract Hide abstract
This paper proposes an open-source algorithm that performs parallel processing of spatial queries, during which an initial selection of objects to be subjected to spatial relationship tests is done using a spatial index. These data are then further subdivided by the use of the OFFSET and LIMIT clauses into still smaller subgroups, to which spatial relationship tests utilizing complex calculations are assigned, thereby creating multiple processes running in parallel. This algorithm was tested using data from the SQLite/SpatiaLite and PostgreSQL/PostGIS database. In processing spatial relationship queries involving six threads, the algorithm yielded a 3.6X maximum speed-up increase in performance compared to single-thread processing on SQLite/SpatiaLite database and 5.1X maximum speed-up on PostgreSQL/PostGIS database. In single-layer analyses (e.g., area calculation, buffer generation), a 5X speed-up time in query processing was observed.

Identifying the location of odour nuisance emitters using spatial GIS analyses
M. Wojnarowska, M. Ilba, J. Szakiel, P. Turek, M. Sołtysik
Journal: Chemosphere, Volume 263
Show abstract Hide abstract
The primary objective of the article was to establish the location of odour emitters with the use of spatial GIS analyses. The odour emitter location analysis based on measurements was carried out using QGIS software tools. The algorithm of the procedure was developed by analysing vector elements, including simulated odour streaks (in the form of wedge buffer surfaces) and a regular grid of points needed to determine the presence of a given buffer in a given location. Statistical analysis was performed in ArcGIS software. The detailed aim of the conducted study was to analyse the nuisance of odours from the measurement data on the basis of IDW interpolation and the arrangement of buildings. An innovative element of the developed analysis is the application of the inversed method of fragrance streak propagation. Identifying a streak from the measuring point towards the blowing wind is very likely to determine the approximate location of the odour emitter measured. The described method should provide better results at the location of emitters than the above mentioned methods using interpolation, because of taking into account wind direction and speed. In addition, it is a method that can be applied over a large open area where methods based on simulation and particle propagation would not be efficient or highly impossible to apply due to extensive and complex analysis. It was necessary to conduct field studies in order to meet the main goal, which resulted in sensory evaluation of the intensity of odour nuisance in an urbanised area. Odour concentration tests using field olfactometry with NasalRanger olfactometer were taken.

2018

Flood Risk of the City of Krakow in the Context of Spatial Planning Policy
M. Ilba
Journal: World of Real Estate Journal 105 (3/2018)

2016

Estimating the daily solar irradiation on building roofs and facades using Blender Cycles path tracing algorithm
M. Ilba
Journal: E3S Web of Conferences

2015

An Analysis and 3D Visualization of Shading of Urban Spatial Objects with the Use of the Phython Programming Language in the Blender Application
M. Ilba
Journal: Geomatics and Environmental Engineering