EJPAU 2011. Piórkowski A. MYSQL SPATIAL AND POSTGIS – IMPLEMENTATIONS OF SPATIAL DATA STANDARDS

Electronic Journal of Polish Agricultural Universities (EJPAU) founded by all Polish Agriculture Universities presents original papers and review articles relevant to all aspects of agricultural sciences. It is target for persons working both in science and industry,regulatory agencies or teaching in agricultural sector. Covered by IFIS Publishing (Food Science and Technology Abstracts), ELSEVIER Science - Food Science and Technology Program, CAS USA (Chemical Abstracts), CABI Publishing UK and ALPSP (Association of Learned and Professional Society Publisher - full membership). Presented in the Master List of Thomson ISI.

2011
Volume 14
Issue 1

Topic:

Geodesy and Cartography

ELECTRONIC
JOURNAL OF
POLISH
AGRICULTURAL
UNIVERSITIES

Piórkowski A. 2011. MYSQL SPATIAL AND POSTGIS – IMPLEMENTATIONS OF SPATIAL DATA STANDARDS, EJPAU 14(1), #03.
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.