universeodon.com is part of the decentralized social network powered by Mastodon.
Be one with the #fediverse. Join millions of humans building, creating, and collaborating on Mastodon Social Network. Supports 1000 character posts.

Administered by:

Server stats:

3.5K
active users

Learn more

John Beales

Following up on this, I found this gem in the MySQL docs:

“By default, geographic coordinates (latitude, longitude) are interpreted as in the order specified by the spatial reference system of geometry arguments.”
- dev.mysql.com/doc/refman/8.4/e

So it seems that the WKT for a point isn’t always POINT(x y) and I need to look up the order that WGS 84 expects.

dev.mysql.comMySQL :: MySQL 8.4 Reference Manual :: 14.16.3 Functions That Create Geometry Values from WKT Values