[postgis-users] Forming a BAND around a linestring

Simon Greener simon at spatialdbadvisor.com
Fri Mar 2 02:44:38 PST 2012

Try ST_Buffer - http://www.postgis.org/docs/ST_Buffer.html
On Fri, 02 Mar 2012 21:17:13 +1100, Ed Linde <edolinde at gmail.com> wrote:

> 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 somearea. How can I achieve this in postgis 2.0? Do I need to use some library like GDAL in order to achieve this?
> Cheers,
> Ed

Holder of "2011 Oracle Spatial Excellence Award for Education and Research."
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radius Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
Email: simon at spatialdbadvisor.com
Voice: +61 362 396397
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147° 12' 18" E)
Latitude: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120302/0ab611a8/attachment.html>

More information about the postgis-users mailing list