Volume 14
Issue 1
Geodesy and Cartography
JOURNAL OF
POLISH
AGRICULTURAL
UNIVERSITIES
Available Online: http://www.ejpau.media.pl/volume14/issue1/abs-03.html
MYSQL SPATIAL AND POSTGIS – IMPLEMENTATIONS OF SPATIAL DATA STANDARDS
Adam Piórkowski
Department of Geoinfomatics and Applied Computer Science,
AGH University of Science and Technology, Cracow, Poland
ABSTRACT
Spatial databases have become a very important domain of databases recently. A standardization of the storing and analyzing methods provides consistency of data, makes it easier to combine these data and allows to integrate projects.
There is a problem of standardization for leading public domain databases with spatial extensions described in this article. The two main standards – OGC OpenGIS and SQL/MM are presented. The consideration focuses primarily on two databases: PostgreSQL + PostGIS and MySQL Spatial. The problem of standard implementation is the main issue. The way of integration spatial extension with database system is described. The level of standard implementation is discussed. Examples for analytical functions are given. Several available language constructions of creating queries are presented.
The integration and implementation level of presented spatial extensions differs. MySQL Spatial is well integrated, but realizes only part of OGC OpenGIS standard. PostGIS implements two standards almost entirely, but there way of spatial database creating is much more complicated. The considerations are illustrated with examples in SQL.
Key words: spatial data, spatial databases, ogc, opengis, sql, sql/mm spatial, postgresql, postgis, mysql spatial.
Adam Piórkowski
Department of Geoinfomatics and Applied Computer Science,
AGH University of Science and Technology, Cracow, Poland
email: pioro@agh.edu.pl
Responses to this article, comments are invited and should be submitted within three months of the publication of the article. If accepted for publication, they will be published in the chapter headed 'Discussions' and hyperlinked to the article.