[postgis-users] Forming a BAND around a linestring

pcreso at pcreso.com pcreso at pcreso.com
Fri Mar 2 10:15:23 PST 2012

ST_Buffer(<linestring>, distance)


Note that if your data is lat/long (such as EPSG:4326) with units in degrees, then you will get somewhat distorted buffer distances, and a better result by transforming your linestring to a more suitable projection for the buffer operation, then transform it back.


ST_Transform(ST_Buffer(ST_Transform(<linestring>, SRID), distance),4326)


   Brent Wood
--- On Fri, 3/2/12, Ed Linde <edolinde at gmail.com> wrote:

From: Ed Linde <edolinde at gmail.com>
Subject: [postgis-users] Forming a BAND around a linestring
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Date: Friday, March 2, 2012, 11:17 PM

Hi All,I have a set of points with (x,y) co-ordinates that belong to a single object ex: a segment in a road network.If we made a LINESTRING that connected these points (x,y), then I would like to have a BAND or RANGE
around the linestring of say 10 meters wide that would probably make it look more like a polygon or some area. How can I achieve this in postgis 2.0? Do I need to use some library like GDAL in order to achieve this?


-----Inline Attachment Follows-----

postgis-users mailing list
postgis-users at postgis.refractions.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120302/6d8f0d91/attachment.html>

More information about the postgis-users mailing list