In MySQL 5.7.5, we introduced new functions for encoding and decoding Geohash data. Geohash is
a system for encoding and decoding longitude and
latitude coordinates in the WGS 84 coordinate system, into a text
string. In this blog post we will take a brief look at a simple
example to explain just how geohash works.
Where on earth is “u5r2vty0″?
Imagine you get a email from your friend, telling you that there
is free food at “u5r2vty0″. But where on earth is
The first step in converting from “u5r2vty0″ to latitude and
longitude data, is decoding the text string into its binary
representation. Geohash uses base32 characters, and you can find
the character mapping on …[Read more]