New answers tagged


If you want to take advantage of ST_DWithin, you'll need to specify a cutoff radius to limit the expansion of clusters. (It's possible to have a set of inputs where a user's cluster is the entire table). Say we have a user at (-80, 40), and we want to limit the search radius to 15km. That can be done with this modification: SELECT row_number() over () ...

Top 50 recent answers are included