Full-text resources of CEJSH and other databases are now available in the new Library of Science.
Visit https://bibliotekanauki.pl

Results found: 4

first rewind previous Page / 1 next fast forward last

Search results

Search:
in the keywords:  spatial database
help Sort By:

help Limit search:
first rewind previous Page / 1 next fast forward last
EN
Developments in big data technology, wireless networks, Geographic information system (GIS) technology, and internet growth has increased the volume of data at an exponential rate. Internet users are generating data with every single click. Geospatial metadata is widely used for urban planning, map making, spatial data analysis, and so on. Scientific databases use metadata for computations and query processing. Cleaning of data is required for improving the quality of geospatial metadata for scientific computations and spatial data analysis. In this paper, we have designed a data cleaning tool named as GeoWebCln to remove useless data from geospatial metadata in a user-friendly environment using the Python console of QGIS Software.
EN
The main aim of the study was to introduce a spatial database application for the estimation of changes in shoreline position. The open-source PostgreSQL database system with the PostGIS spatial extension was used as the data store for digitalised shorelines. The solution to calculations of the shoreline changes was based on the functions written in the PL/SQL language and geospatial functions provided by the PostGIS extension. The traditional baseline and transects method was used to quantify the distances and rate of shoreline movement. Outputs of the calculations were stored in the database table and simply visualised using graphical functions in the R software environment or in GIS Desktop software. The advantage of presented method is the application of SQL language in the analysis of the relation between the geometry of shorelines stored in the database table, which, compared to other similar solutions, gives the user fully open, simple analytical code and enable selecting custom parameters of analysis, modifying code and performing additional calculations
EN
The main aim of the study was to introduce a spatial database application for the estimation of changes in shoreline position. The open-source PostgreSQL database system with the PostGIS spatial extension was used as the data store for digitalised shorelines. The solution to calculations of the shoreline changes was based on the functions written in the PL/SQL language and geospatial functions provided by the PostGIS extension. The traditional baseline and transects method was used to quantify the distances and rate of shoreline movement. Outputs of the calculations were stored in the database table and simply visualised using graphical functions in the R software environment or in GIS Desktop software. The advantage of presented method is the application of SQL language in the analysis of the relation between the geometry of shorelines stored in the database table, which, compared to other similar solutions, gives the user fully open, simple analytical code and enable selecting custom parameters of analysis, modifying code and performing additional calculations
EN
ABSTRACT: The aim of this study is to present methods for the harmonization and integration of detailed planning data for the use of them to analyse the determinants of development at the local level. The study is based on the data for the municipalities of the district of Poznan. Each of the planning documents was georefernced using topographic maps. The next step was the vectorization of individual polygons giving them a value consistent with those in the legend and the description of each of the studies. Harmonisation between the municipalities were done in order to enable analysis on a regional scale.
PL
ABSTRAKT: Celem opracowania jest przedstawienie metod harmonizacji i integracji szczegółowych danych planistycznych na potrzeby zastosowania ich do analizy uwarunkowań rozwoju na poziomie lokalnym. W opracowaniu wykorzystano dane dla gmin powiatu poznańskiego. Każdemu ze studiów uwarunkowań i kierunków zagospodarowania przestrzennego nadano georeferencje, korzystając z podkładów topograficznych. Następnym krokiem była wektoryzacja poszczególnych wydzieleń oraz nadanie im wartości zgodnych z zawartymi w legendzie i opisie każdego ze studiów. W celu umożliwienia analiz w skali lokalnej dokonano harmonizacji wydzieleń pomiędzy poszczególnymi gminami.
first rewind previous Page / 1 next fast forward last
JavaScript is turned off in your web browser. Turn it on to take full advantage of this site, then refresh the page.