Re: [postgis-users] Distance between two furthest points of a group

2015-06-26 Thread Arnaud Lesauvage
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.

Re: [postgis-users] Partitionning using geometry

2015-04-03 Thread Arnaud Lesauvage
Hi Rémi, have you taken a look at ST_GeoHash ? It might be a good candidate for your constraint exclusion check. There are restrictions though. Coordinates must be in lat/lon for instance. http://postgis.net/docs/ST_GeoHash.html Arnaud Le 3/04/2015 10:49, Rémi Cura a écrit : Now postgres