[postgis-users] Buffer generation & drawing problem

Luis Floreani lucholaf at gmail.com
Tue Oct 16 13:28:55 PDT 2007


Hi, this my situation, I'm using postgis to generate buffers in order
to draw them in google or yahoo maps. The problem is that when they
are drawn, they are elliptical (taller) instead of plain circles.

The column is named 'the_geom', it's a 2D Point and its SRID is 4326.
Here's the SQL:

select astext(buffer(the_geom, 0.1)) from mytable where ...

note: 0.1 is related with the size of the buffer.

here's a typical output:

"POLYGON((-82.600775 27.902917,-82.6026964719596
27.8834079677989,-82.6083870467484 27.8646486567645 ...... etc etc))"

I parse this string in my script language and generate a proper KML
containing all the points of the buffer, but when I open it with
google earth, google maps or even yahoo maps (use another structure of
XML), the buffer is a little elliptical instead of being a simple
perfect circle.

any clue on this?

Thanks in advance,

Luis



More information about the postgis-users mailing list