Ah, POINT(avg(X), avg(Y))...
On Tue, Nov 24, 2009 at 9:38 AM, Kevin Neufeld <[email protected]> wrote: > Maxime van Noppen wrote: >> >> Paul Ramsey wrote: >>> >>> Use ST_Centroid() then. It's just the mid-point of the bbox, so it's >>> fast to calculate. >> >> It might be outside the polygon though. >> > > In which case, if it matters, use ST_PointOnSurface(). > > Paul, just a clarification, I believe centroid calculates the geometric > centre of a geoemtry or "centre of mass" and not the mid-point of the bbox. > Here are a few pictorial examples: > http://postgis.org/documentation/manual-1.5SVN/ST_Centroid.html > > -- Kevin > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
