CARVIEW

MOTORHOMES

Select Language

HTTP/2 302 server: nginx date: Mon, 22 Dec 2025 16:14:31 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20090208151233 location: https://web.archive.org/web/20090208151233/https://forge.mysql.com/wiki/GIS_Functions server-timing: captures_list;dur=1.162201, exclusion.robots;dur=0.097893, exclusion.robots.policy;dur=0.081723, esindex;dur=0.014675, cdx.remote;dur=48.215969, LoadShardBlock;dur=420.246932, PetaboxLoader3.resolve;dur=114.137062, PetaboxLoader3.datanode;dur=276.307405 x-app-server: wwwb-app28-dc8 x-ts: 302 x-tr: 542 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: wb-p-SERVER=wwwb-app28; path=/ x-location: All x-as: 14061 x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Mon, 22 Dec 2025 16:14:32 GMT content-type: text/html; charset=UTF-8 x-archive-orig-date: Sun, 08 Feb 2009 15:14:38 GMT x-archive-orig-server: Apache/2.2.4 (Ubuntu) DAV/2 SVN/1.4.4 PHP/5.2.3-1ubuntu6.4 x-archive-orig-x-powered-by: PHP/5.2.3-1ubuntu6.4 x-archive-orig-set-cookie: mysqlforge_mw__session=deleted; expires=Sat, 09-Feb-2008 15:14:37 GMT; path=/; domain=forge.mysql.com x-archive-orig-set-cookie: mysqlforge_mw_UserName=deleted; expires=Sat, 09-Feb-2008 15:14:37 GMT; path=/; domain=forge.mysql.com x-archive-orig-set-cookie: mysqlforge_mw_UserID=deleted; expires=Sat, 09-Feb-2008 15:14:37 GMT; path=/; domain=forge.mysql.com x-archive-orig-set-cookie: mysqlforge_mw_Token=deleted; expires=Sat, 09-Feb-2008 15:14:37 GMT; path=/; domain=forge.mysql.com x-archive-orig-set-cookie: mysqlforge_mw_LoggedOut=20090208151438; expires=Mon, 09-Feb-2009 15:14:38 GMT; path=/; domain=forge.mysql.com x-archive-orig-content-language: en x-archive-orig-vary: Accept-Encoding,Cookie x-archive-orig-expires: Thu, 01 Jan 1970 00:00:00 GMT x-archive-orig-cache-control: private, must-revalidate, max-age=0 x-archive-orig-last-modified: Mon, 02 Feb 2009 12:12:12 GMT x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Sun, 08 Feb 2009 15:12:33 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: 51_8_20090208131558_crawl102-c/51_8_20090208151005_crawl103.arc.gz server-timing: captures_list;dur=1.339715, exclusion.robots;dur=0.048912, exclusion.robots.policy;dur=0.029415, esindex;dur=0.016270, cdx.remote;dur=13.884162, LoadShardBlock;dur=467.597073, PetaboxLoader3.resolve;dur=210.439347, PetaboxLoader3.datanode;dur=344.804111, load_resource;dur=140.598023 x-app-server: wwwb-app28-dc8 x-ts: 200 x-tr: 738 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-as: 14061 x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip GIS Functions - MySQL Forge Wiki

Categories: MySQLDevelopment | Software Preview

GIS Functions

1 Introduction
2 References
3 Download
- 3.1 Binary packages
- 3.2 Sources
4 Known/reported Bugs
5 Contact
6 Related Links

[edit] Introduction

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 MySQL Developer 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 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.

[edit] References

This work is documented as WorkLog task WL#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!

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

Note: The previous existing functions have been prefixed with MBR, to indicate the difference in operation. For example, the original Intersects() function is now called MBRIntersects()

[edit] Download

[edit] Binary packages

On 2007-10-29 a first batch of preview builds has been released for a number of platforms (Linux, Mac OS X, Solaris, Windows). The packages are available for download from https://downloads.mysql.com/forge/mysql-5.1.23-beta-GIS/

Note: these packages still include the bugs reported below! Currently, you need to compile from the source tree to work around these.

[edit] Sources

The source tree (based on the MySQL 5.1 code base) is now available from our public Bazaar trees at https://code.launchpad.net/mysql-server .

You can check out a local copy of the source tree by running the following command (assuming you have bzr installed):

 bzr branch lp:~mysql/mysql-server/mysql-5.1-wl1326

Please consult the reference manual for more information on how to build a MySQL binary from a source tree.

[edit] Known/reported Bugs

If you discovered and reported a bug in the new functionality, please add it to the list below, to avoid duplicate reports by other users:

~~Bug#31753~~: Buffer/area functions only return first row of set
~~Bug#32032~~: Contains() does not work on MultiPolygons, may force a disconnect and/or result in extremely long query times.
~~Bug#32100~~: contains, intersects functions never return. Query disconnects or times out.
~~Bug#33035~~: Intersection function returns 'Function doesn't exist' error
~~Bug#41481~~: Buffer function never returns, cpu 100%, system locks up

Note: If a bug has been striked through, it means that is has been fixed and commited to the source tree already. However, the latest preview binaries don't contain this fix yet! The list of known bugs will be reset, once a new preview release has been published.

[edit] Contact

To discuss the new GIS functionality, please use our GIS Forum and help us by Reporting Bugs at our public Bug Database! For convenience, please tag your Bug reports with "openGIS extensions".