[postgis-users] create 10m buffer using input data in EPSG4326

[karsten]

Greetings, I am working on creating 10m buffers around roads:
 
SELECT 10 AS score, ST_Difference(
 ST_Union(ST_Buffer(roads.the_geom, 10)),
 ST_Union(ST_Buffer(roads.the_geom, 0))
 )
AS the_geom
FROM geodata.roads2012_ca roads
GROUP BY score
 
So far I have the roads in dd (EPSG 4326) and was wondering how I could pass
the distances in meters into the buffer function (without necessarily
creating a new column with projected geometries). I guess could use some
geography data type function .. but how ?
 
Thanks
Karsten

Karsten Vennemann
Principal

Terra GIS LTD
2119 Boyer Ave E 
Seattle, WA  98112
USA 
 <http://www.terragis.net/> www.terragis.net

Phone ++1 206 905 1711
Fax      ++1 925 905 1711

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130522/2d364f7d/attachment.html>