CHow can I create a table that is capable of location based queries (Geospatial)
I would like to be able to query by distance, and sort closest to farthest, as can be done in mongodb or postgis.
I can use some trickery to locate lat/lon coordinates 'near-ish' by treating them as floats and using greater than and less than in a pseudo between query, and then sort/filter in TS using the haversine formulae. I don't mind doing that as a work around for now.
But Geo queries would be a fantastic feature!
I can use some trickery to locate lat/lon coordinates 'near-ish' by treating them as floats and using greater than and less than in a pseudo between query, and then sort/filter in TS using the haversine formulae. I don't mind doing that as a work around for now.
But Geo queries would be a fantastic feature!
