2026-03-29 10:01 UTC
About to embark on a project involving GeoJSON. The data my client has is currently a bunch of points/markers but they want to be able to do lines, polygons, etc. Trying to decide if we want to keep the point data as just a table with X and Y integer columns in the DB or if I want to learn the built-in MySQL/MariaDB geometry stuff. Anyone have any experience with it?
Replies (1)
-
@Albright@phpc.social 2026-03-29 10:04
One concern I have is that the points have X/Y int coords rather than lat/lng coords (as the "map" is actually basically just a large flat image and not actually the planet Earth) but I think I'd have to store them as lat/lng rather than converting them before they get loaded into MapLibre. Conversion between X/Y and lat/lng and back again would probably be "lossy"/end up giving different numbers if repeated so I'd really prefer to just store it as only (or also) X/Y. Hmm.