<div>Stephen</div>
<div> </div>
<div>values:</div>
<div> </div>
<div>select AsText(st_intersection('0105000020B30F0000010000000102000000020000003ECC434576CC51C0B6DAC9ABFD973EC076B222C86FCC51C02657CB7AF0973EC0','0105000020B30F00000100000001020000000200000025D0A9826DCC51C06259114D2E973EC0507AE4AE6ECC51C0F871CB570B973EC0'))</div>
<div> </div>
<div>RG</div>
<div class="gmail_quote">2009/3/30 Stephen Woodbridge <span dir="ltr"><<a href="mailto:woodbri@swoodbridge.com">woodbri@swoodbridge.com</a>></span><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Valeria,<br><br>It would be helpful if you posted the values for your two streets.<br><br>st_intersection(), I believe, always returns a geometry collection. This is because the intersection of two polylines could be a collections of points and line segments.<br>
<br>You probably want to look at st_dump() which lets you get at the individual pieces in a collection.<br><br>Since your collection is EMPTY it is likely that your two geometries did not intersect.<br><br>-Steve W<br><br>
Valeria Muñoz wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="im">Hi daniel<br> I have problems with st_intersection function, for any query the result is "GEOMETRYCOLLECTION EMPTY"<br> my query:<br>select AsText(st_intersection('".$geom_ini."','".$geom_ter."'))<br>
$geom_ini: is the AsText(the_geom) from street A and $geom_ter: is the AsText(the_geom) from the street B<br><br>I think I'm completely lost<br> RG<br></div>2009/2/25 Daniel Kastl <<a href="mailto:kastl@orkney.co.jp" target="_blank">kastl@orkney.co.jp</a> <mailto:<a href="mailto:kastl@orkney.co.jp" target="_blank">kastl@orkney.co.jp</a>>>
<div class="im"><br><br> Hi Valeria,<br><br> This should be possible with PostGIS.<br> Probably you're looking for this function:<br><br> 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><br> Valeria Muñoz schrieb:<br></div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="im"> HI!!<br> i have a questions: can i get the latitude longitude of an<br> intersection?, for example latitude longitude of street1 with street2<br><br> RG<br><br> _______________________________________________<br>
Pgrouting-users mailing list<br></div> <a href="mailto:Pgrouting-users@lists.postlbs.org" target="_blank">Pgrouting-users@lists.postlbs.org</a> <mailto:<a href="mailto:Pgrouting-users@lists.postlbs.org" target="_blank">Pgrouting-users@lists.postlbs.org</a>>
<div class="im"><br> <a href="http://lists.postlbs.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.postlbs.org/mailman/listinfo/pgrouting-users</a><br> <br></div></blockquote><br><br><br>------------------------------------------------------------------------
<div class="im"><br><br>_______________________________________________<br>Pgrouting-users mailing list<br><a href="mailto:Pgrouting-users@lists.postlbs.org" target="_blank">Pgrouting-users@lists.postlbs.org</a><br><a href="http://lists.postlbs.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.postlbs.org/mailman/listinfo/pgrouting-users</a><br>
</div></blockquote><br></blockquote></div><br>