Join Discord
Powered by
guys not a supabase related question, but... someb...
# sql
t
TremalJack
12/31/2021, 2:39 PM
guys not a supabase related question, but... somebody of u have a postgres function to calc distance (km) betweend 2 coordinates?
s
Scott P
12/31/2021, 2:59 PM
Make sure the PostGIS extensions are enabled, and then the results on Google will work, for example:
https://postgis.net/docs/ST_Distance.html
https://stackoverflow.com/questions/24624257/postgis-distance-calculation
t
TremalJack
12/31/2021, 7:51 PM
I want run a query where the coordinates are below or equal 300km
s
Scott P
12/31/2021, 9:56 PM
That's an entirely different question to the one you originally asked, and I'd suggest Googling for answers
s
Subramanya Chakravarthy
01/01/2022, 1:36 PM
I recently worked on postgis and collected some notes here
https://notes.fyndx.io/Computer+Science/Programming/Database/Postgres/PostGis
t
TremalJack
01/01/2022, 1:55 PM
sorry sometimes my english s*ck xD
TremalJack
01/01/2022, 2:34 PM
awesome article! good job!
Previous
Next