Towards a spatio-temporal OQL for the four dimensional spatial database system Hawks

Author(s):  
S. Kuroki ◽  
A. Makinouchi ◽  
K. Ishizuka
1999 ◽  
Vol 10 (2) ◽  
pp. 110-111
Author(s):  
Venkatesh Raghavan ◽  
Shinji Masumoto ◽  
Kiyoji Shiono

2018 ◽  
Vol 37 (3) ◽  
pp. 25-34
Author(s):  
Robert Kostecki

Abstract 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.


2013 ◽  
Vol 416-417 ◽  
pp. 1899-1903
Author(s):  
Shao Jian Shi ◽  
Liang Xun Shuo ◽  
Xing Tao Cui

We should construct a spatial database system for mineral resource reserve in Hebei province based on the database with the application of GIS spatial database technology based on the MapGIS software platform. Combined with the construction process of the database, this paper summarizes the problems and the solutions encountered in the construction of large database, and analyzes some techniques the departments of land and resources often use in basic geographic data to discuss with colleagues to further improve the quality and efficiency of database construction.


Sign in / Sign up

Export Citation Format

Share Document