2019 - Spatial Support in MySQL

MySQL 8.0 was a huge step in terms of spatial support -- a step up from flat Cartesian coordinate systems to ellipsoidal geography. In this talk we'll go on a quick tour of the spatial support in MySQL. We'll cover data types, functions, indexes, coordinate reference systems and other core topics. We'll look at both the big design decisions and practical use. What can MySQL do? How does it work? What are the limitations? Join us for answers to these questions and more!

None

Norvald H. Ryeng

[umair-anwar]

We are storing longitude and latitude as Decimal(12, 8) columns. The query then tries to find locations in a square area;
SELECT *
FROM `table1`
WHERE
(
`latitude` < '59.665287534969' AND
`latitude` > '-8.2989238835999' AND
`longitude` < '-32.26454375' AND
`longitude` > '-160.58485625'
)

Any suggestion? on how it can be improved.