My Oracle Support Banner

MySQL Server: GIS Datatypes and Spatial Functions (Doc ID 1497788.1)

Last updated on FEBRUARY 27, 2020

Applies to:

MySQL Server - Version 5.0 and later
Information in this document applies to any platform.

Purpose

 This document outlines the GIS and spatial capabilities that are support by MySQL Server and the known limitations.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 Q. Which GIS model is used to implement the spatial features in MySQL Server?
 Q. What storage engines support GIS data types?
 Q. What storage engines support spatial indexing?
 Q. What is a GIS data type and which ones are supported by MySQL?
 Q. Does MySQL support object boundaries or just minimum bounding rectangles (MBR's) when comparing spatial objects?
 Q. Which OpenGIS spatial functions are not yet implemented in MySQL? 
 Q. Why do I see garbage in a result set when selecting from a table with spatial data types?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.