Le 26/06/2015 13:54, Jonathan Moules a écrit :
I have sets of points (up to 250,000 in a set) and I want to get the
furthest distance between any of them.
In theory the simplest way is to use
ST_MinimumBoundingCircle(ST_Collect(geography) and then get the diameter
of that.
You can cross join to create the cartesian product of them and use it to
calculate the distance of each with regards to the other:
select a.id,b.id, st_distance(a.geom,b.geom) d from points a cross join
points b order by d desc limit 1;
ofc that will take forever because it will have to create
Hm,
I don't understand your problem.
The circle seems to be the perfect solution.
Do you mean the function returns nothing?
Maybe you could try to scale down you points(scaling down centered of
centroid of your points )?.
Cheers,
Rémi-C
2015-06-26 13:54 GMT+02:00 Jonathan Moules
Hi List,
I have sets of points (up to 250,000 in a set) and I want to get the furthest
distance between any of them.
In theory the simplest way is to use
ST_MinimumBoundingCircle(ST_Collect(geography) and then get the diameter of
that.
The problem is - I don't seem to be able to get the