[postgis-users] polygon with equally spaced points from an existing polygon

[Sandro Santilli]

On Tue, Mar 12, 2013 at 10:16:20AM -0700, Luis Tavares wrote:

> The use case is precisely calculating the polygon´s centroid by averaging the coordinates of all the points of the polygon. In order to perform this I think I need to have equally spaced points. Note that I´m working on the ellipsoid so st_centroid no good to me...and I don´t want to project coordinates.  

ST_Simplify does indeed work on the cartesian plane, but you don't
really need to drop existing vertices for the above computation, do you ?

You can use ST_Segmentize(geography) to augment vertices density on the
ellipsoid.

--strk; 

 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net