Chapter 19. Hierarchical Triangular Mesh
Most of us are used to locating positions on earth with (longitude, latitude) pairs. But this traditional system has problems as you get closer to either the North or South Pole and the math involved uses spherical trigonometry.
An alternative system is the Hierarchical Triangular Mesh, or HTM for short. While (longitude, latitude) pairs are based on establishing a point in a two-dimensional coordinate system on the surface of the earth, HTM is based on dividing the surface into almost-equal sized triangles with a unique identifier to locate something by a containing polygon.
If you have seen a geodesic dome or Buckminster Fuller’s maps, you have some feeling for this approach. HTM start with an octahedron ...

Get Joe Celko's Data, Measurements and Standards in SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.