[postgis-users] making Hexagoan from coordinate x, y and using distance

[Mike Toews]

Hi Anurag,

Almost there! Quadsegs needs to be 2 (i.e. 2 * quad = oct):

SELECT ST_Buffer(ST_MakePoint(0, 0), 1000, 2);

And if you are looking for a octagon that looks like a stop sign, then
rotate it by 22.5 degrees, or pi/8 radians. It's a bit more
complicated, since it needs a point of origin to rotate around:

SELECT ST_Rotate(ST_Buffer(pt, 1000, 2), pi()/8, pt)
FROM (SELECT ST_MakePoint(0, 0) AS pt) AS f;

-Mike


On 6 December 2013 19:04, anurag singh <anurag.gsdl at gmail.com> wrote:
> Hi everyone!!!!!
>
> This is my first question on this site. I am developing a small application
> where there is a requirement for generating a buffer in form of regular
> hexagon.
> I have already created the circle using ST_Buffer(ST_MakePoint("x1"," y1"),
> 1000, 4 )  but not getting that how i can create a regular hexagon. I am
> stuck on this point
> please help me .
>
>
> --
> Thank's & Regard's
> Anurag Singh
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users