<div>Hi daniel</div>
<div> I have problems with st_intersection function, for any query the result is "GEOMETRYCOLLECTION EMPTY"</div>
<div> </div>
<div>my query:</div>
<div>select AsText(st_intersection('".$geom_ini."','".$geom_ter."'))</div>
<div> </div>
<div>$geom_ini: is the AsText(the_geom) from street A and $geom_ter: is the AsText(the_geom) from the street B</div>
<div><br>
<div id="result_box" dir="ltr" style="TEXT-ALIGN: left">I think I'm completely lost</div>
<div dir="ltr" style="TEXT-ALIGN: left"> </div></div>
<div>RG</div>
<div class="gmail_quote">2009/2/25 Daniel Kastl <span dir="ltr"><<a href="mailto:kastl@orkney.co.jp">kastl@orkney.co.jp</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div text="#000000" bgcolor="#ffffff">Hi Valeria,<br><br>This should be possible with PostGIS.<br>Probably you're looking for this function:<br><br><span>ST_Intersection(geometry, geometry)<br><br><a href="http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2746133" target="_blank">http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2746133</a><br>
<br>Daniel<br><br></span><br>Valeria Muņoz schrieb:
<blockquote type="cite">
<div class="im">
<div>HI!!</div>
<div> </div>
<div>i have a questions: can i get the latitude longitude of an intersection?, for example latitude longitude of street1 with street2</div>
<p>RG</p></div><pre><hr width="90%" size="4">
_______________________________________________
Pgrouting-users mailing list
<a href="mailto:Pgrouting-users@lists.postlbs.org" target="_blank">Pgrouting-users@lists.postlbs.org</a>
<a href="http://lists.postlbs.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.postlbs.org/mailman/listinfo/pgrouting-users</a>
</pre></blockquote><br></div></blockquote></div><br>