Skip navigation links

MySQL Forums :: GIS :: New openGIS functionality in MySQL available for testing


Advanced Search

New openGIS functionality in MySQL available for testing
Posted by: Lenz Grimmer ()
Date: June 24, 2007 03:39PM

While MySQL already provides some functionality to store and operate on geospatial data, the functionality leaves quite a lot to be desired and is far from providing full OpenGIS compatibility. Most notably is that all functions that query spatial data only operate on MBRs (minimum bounding rectangles), to simplify the operations.

Thanks to my colleague Alexey "Holyfoot" Botchkov from Izhevsk, Russia, some of the spatial relation functions like INTERSECTS and WITHIN now work in the way they are described by OpenGIS and not by using MBR's as it used to be. He has been working on improving the GIS functionality as a side project and the work has now reached a level at which he is ready to give it some public testing and solicit feedback about it.

Currently these new features have not been slated for inclusion in any upcoming MySQL major release. But the more feedback and testing this code receives, the faster it will reach a maturity level that makes it a potential feature candidate for new versions of MySQL.

In addition to improving already existing functionality, Holyfoot also implemented some new precise geospatial functions - the following functions are available now and use precise operations instead of MBRs:

* BUFFER(g1 geometry, d numeric) returns a Geometry defined by buffering a distance d around g1 where d is the distance units for the Spatial Reference of g1
* DIFFERENCE(g1 geometry, g2 geometry) returns a Geometry that is the closure of the set difference of g1 and g2
* DISTANCE(g1 geometry, g2 geometry) returns distance between g1 and g2
* INTERSECTION(g1 geometry, g2 geometry) returns a Geometry that is the set intersection of g1 and g2
* SYMDIFFERENCE(g1 geometry, g2 geometry) returns a Geometry that is the closure of the set symmetric difference of g1 and g2 (logical XOR of space)
* UNION(g1 geometry, g2 geometry) returns a Geometry that is the set union of g1 and g2

This work is documented as WorkLog task #1326 "Precise spatial operations", which is a subtask of WL#2377 "Add all missing GIS features to MySQL" - feel free to review and comment on these specifications and make sure to test the new functionality!

The source tree (based on the MySQL 5.1 code base) is now available from our public BitKeeper trees at http://mysql.bkbits.net/ - please consult the reference manual for more information on how to build a MySQL binary from a source tree.

To discuss the new GIS functionality, please use this GIS Forum and make sure to report bugs at our public Bug Database!

Lenz Grimmer - MySQL Community Relations Manager - http://de.sun.com/
Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten, DE
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels
Vorsitz d. Aufsichtsrates: Martin Haering AG Muenchen: HRB161028



Edited 2 time(s). Last edit at 12/06/2007 06:49AM by Lenz Grimmer.

Options: ReplyQuote


Subject Views Written By Posted
New openGIS functionality in MySQL available for testing 13083 Lenz Grimmer 06/24/2007 03:39PM
Re: New openGIS functionality in MySQL available for testing 3216 John Powell 10/17/2007 04:00AM
Re: New openGIS functionality in MySQL available for testing 2526 John Zastrow 11/25/2007 03:20PM
Re: New openGIS functionality in MySQL available for testing 2484 Lenz Grimmer 11/26/2007 05:30AM
Re: New openGIS functionality in MySQL available for testing 3528 Daniel Zburivsky 04/04/2008 11:29AM
Re: New openGIS functionality in MySQL available for testing 2975 John Powell 04/21/2008 06:46AM
Re: New openGIS functionality in MySQL available for testing 2220 Lenz Grimmer 09/15/2008 05:18AM
Re: New openGIS functionality in MySQL available for testing 2345 John Powell 12/17/2007 04:07AM
Re: New openGIS functionality in MySQL available for testing 2404 John Zastrow 12/30/2007 03:14PM
Re: New openGIS functionality in MySQL available for testing 2427 Lenz Grimmer 01/09/2008 03:46AM
Re: New openGIS functionality in MySQL available for testing 2574 Max 03/02/2008 09:53AM
Re: New openGIS functionality in MySQL available for testing 2086 Mark Haberle 09/25/2008 11:29AM
Re: New openGIS functionality in MySQL available for testing 2210 John Powell 10/10/2008 07:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.