Stream: geospatial

Topic: Why are coordinates of type TEXT and not FLOAT?


view this post on Zulip Balázs Pataki (Dec 11 2023 at 09:55):

I wonder why westLongitude, eastLongitude, etc. are of type TEXT and not FLOAT? Is there any specific reason for this? And what would happen if I changed it to FLOAT while there are already metadata stored that has been saved using the TEXT type (but compatible in format with FLOATs)?

view this post on Zulip Philip Durbin 🚀 (Dec 11 2023 at 13:24):

You're right. They should be float. On a related note, this recently merged PR checks for float values:

Add validation for entered coordinate values in Geospatial metadata #10142

view this post on Zulip Philip Durbin 🚀 (Dec 11 2023 at 13:26):

You're very welcome to play around with changing them to float. We should clean this up some day.

view this post on Zulip Balázs Pataki (Dec 11 2023 at 14:37):

Good to know, thanks! We will see then what will blow up if we change to floats. :exploding_head:


Last updated: Jan 09 2026 at 14:18 UTC