<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.16576"></HEAD>
<BODY>
<DIV><SPAN><SPAN class=143141620-22052013>Greetings, </SPAN>I am working on
creating 10m buffers around roads<SPAN
class=143141620-22052013>:</SPAN></SPAN></DIV>
<DIV><SPAN><SPAN class=143141620-22052013><SPAN
class=kw1> </SPAN></SPAN></SPAN></DIV>
<DIV><SPAN><SPAN class=143141620-22052013><SPAN class=kw1><FONT color=#000080
size=2 face=Arial>SELECT 10 AS score,
ST_Difference(<BR> ST_Union(ST_Buffer(roads.the_geom,
10)),<BR> ST_Union(ST_Buffer(roads.the_geom, 0))<BR> )<BR>AS
the_geom<BR>FROM geodata.roads2012_ca roads<BR>GROUP BY
score</FONT></SPAN></DIV></SPAN></SPAN>
<DIV><FONT color=#000080><SPAN></SPAN></FONT> </DIV>
<DIV><FONT color=#000080><SPAN><FONT color=#000000>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
?</FONT></SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial></FONT> </DIV>
<DIV><SPAN class=143141620-22052013><FONT color=#000080 size=2
face=Arial>Thanks</FONT></SPAN></DIV>
<DIV><SPAN class=143141620-22052013><FONT color=#000080 size=2
face=Arial>Karsten</FONT></SPAN></DIV>
<DIV align=left>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Verdana','sans-serif'">Karsten
Vennemann<BR></SPAN><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Verdana','sans-serif'">Principal<BR><BR><SPAN
style="COLOR: #003264">Terra GIS LTD<BR>2119 Boyer Ave E
<BR>Seattle, WA 98112<BR>USA <BR><A
title=blocked::http://www.terragis.net/ href="http://www.terragis.net/"><FONT
color=#0000ff>www.terragis.net</FONT></A></SPAN></SPAN><?xml:namespace prefix =
"o" ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Verdana','sans-serif'; COLOR: #003264">Phone
++1 206 905 1711<BR>Fax ++1 925 905
1711</SPAN><o:p></o:p></P></DIV>
<DIV> </DIV></BODY></HTML>