[postgis-users] Making circles

Nicolas Ribot nicky666 at gmail.com
Thu Jun 21 04:16:11 PDT 2007

>     I´m reading the WKT chapters in the PostGis Manual and there i can find
> constructors for basic geometries ( lines, polygons, and all stuff). I want
> to make a circle, so, is there any function or constructors for usually used
> geometry as circles, n-side-regular-polygons, etc..?
>     Thanks in advance,

You can achieve this with the buffer function acting on a POINT:

select astext(buffer(pointfromtext('POINT ( 5 5)', -1), 10, 8));

second buffer parameter (10) is the buffer distance, third (8) is the
number of segments to approximate the circle, per quadrant.


More information about the postgis-users mailing list