[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] create 10m buffer using input data in EPSG4326
From: Jo <winfixit () gmail ! com>
Date: 2013-05-22 21:21:10
Message-ID: CAJ6DwMCyneyE8fEhxmAqFm=4q84zLTm4OGjgtA5ZiFo5r8dGfQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
I'm sorry if this is wrong, but there is another function where casting
thegeom to geography helps with that.
ST_Union(ST_Buffer(roads.the_geom::geography , 10))
I'm rather new at all this, so maybe it's bad advice.
Jo
2013/5/22 karsten <karsten@terragis.net>
> **
> 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
> www.terragis.net******
>
> Phone ++1 206 905 1711
> Fax ++1 925 905 1711****
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
[Attachment #5 (text/html)]
I'm sorry if this is wrong, but there is another function where casting thegeom \
to geography helps with that.<br><br><span><span><span><font color="#000080" \
face="Arial">ST_Union(ST_Buffer(roads.the_geom::</font></span></span></span><span><span><span><font \
color="#000080" face="Arial">geography , \
10))</font></span></span></span><br><br>I'm rather new at all this, so maybe \
it's bad advice.<br><br>Jo<br><br><div class="gmail_quote">2013/5/22 karsten \
<span dir="ltr"><<a href="mailto:karsten@terragis.net" \
target="_blank">karsten@terragis.net</a>></span><br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><u></u>
<div>
<div><span><span>Greetings, </span>I am working on
creating 10m buffers around roads<span>:</span></span></div>
<div><span><span><span> </span></span></span></div>
<div><span><span><span><font color="#000080" 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></span></span></div>
<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" face="Arial"></font> </div>
<div><span><font color="#000080" face="Arial">Thanks</font></span></div>
<div><span><font color="#000080" 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/" target="_blank"><font \
color="#0000ff">www.terragis.net</font></a></span></span><u></u><u></u><u></u></p> <p \
class="MsoNormal"><span \
style="FONT-SIZE:9pt;FONT-FAMILY:'Verdana','sans-serif';COLOR:#003264">Phone \
<a href="tel:%2B%2B1%20206%20905%201711" value="+12069051711" target="_blank">++1 \
206 905 1711</a><br>Fax ++1 925 905 1711</span><u></u><u></u></p></div>
<div> </div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
<br></blockquote></div><br>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic