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)
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
Journal: Computers & Geosciences, Volume 155
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
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.
Flood Risk of the City of Krakow in the Context of Spatial Planning Policy
Journal: World of Real Estate Journal 105 (3/2018)
Estimating the daily solar irradiation on building roofs and facades using Blender Cycles path tracing algorithm
Journal: E3S Web of Conferences
An Analysis and 3D Visualization of Shading of Urban Spatial Objects with the Use of the Phython Programming Language in the Blender Application
Journal: Geomatics and Environmental Engineering