Timeline for Find the points within radius using PostgreSQL
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 1, 2023 at 17:28 | comment | added | Nick Q. | This is also supported with a supplied module in vanilla Postgres: postgresql.org/docs/current/earthdistance.html | |
| May 4, 2020 at 8:19 | vote | accept | Kiran Veera | ||
| Apr 30, 2020 at 12:55 | answer | added | JGH | timeline score: 3 | |
| Apr 30, 2020 at 9:46 | comment | added | CL. | Furthermore, with PostGIS, you can answer the more useful question what the N nearest points are (independent of any arbitrary radius), and it has geographic indexes so that you can get these answers in a reasonable amount of time even for large tables. | |
| Apr 30, 2020 at 5:03 | comment | added | Vince | Well, it's not impossible, but it's so oppressively difficult that you really ought to just use PostGIS. And be sure to name your "long" column "lon". | |
| Apr 30, 2020 at 5:01 | history | edited | Vince | CC BY-SA 4.0 |
naming
|
| Apr 30, 2020 at 4:30 | history | asked | Kiran Veera | CC BY-SA 4.0 |