[pgrouting-users] latitude longitude of an intersection

Valeria Muñoz valemunoz at gmail.com
Wed Apr 1 15:15:15 EDT 2009


Stephen

values:

select
AsText(st_intersection('0105000020B30F0000010000000102000000020000003ECC434576CC51C0B6DAC9ABFD973EC076B222C86FCC51C02657CB7AF0973EC0','0105000020B30F00000100000001020000000200000025D0A9826DCC51C06259114D2E973EC0507AE4AE6ECC51C0F871CB570B973EC0'))

RG
2009/3/30 Stephen Woodbridge <woodbri at swoodbridge.com>

> Valeria,
>
> It would be helpful if you posted the values for your two streets.
>
> 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.
>
> You probably want to look at st_dump() which lets you get at the individual
> pieces in a collection.
>
> Since your collection is EMPTY it is likely that your two geometries did
> not intersect.
>
> -Steve W
>
> Valeria Muñoz wrote:
>
>> Hi daniel
>>    I have problems with st_intersection function, for any query the result
>> is "GEOMETRYCOLLECTION EMPTY"
>>  my query:
>> select AsText(st_intersection('".$geom_ini."','".$geom_ter."'))
>>  $geom_ini: is the AsText(the_geom) from street A and $geom_ter: is the
>> AsText(the_geom) from the street B
>>
>> I think I'm completely lost
>>  RG
>> 2009/2/25 Daniel Kastl <kastl at orkney.co.jp <mailto:kastl at orkney.co.jp>>
>>
>>    Hi Valeria,
>>
>>    This should be possible with PostGIS.
>>    Probably you're looking for this function:
>>
>>    ST_Intersection(geometry, geometry)
>>
>>
>> http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2746133
>>
>>    Daniel
>>
>>
>>    Valeria Muñoz schrieb:
>>
>>>    HI!!
>>>        i have a questions: can i get the latitude longitude of an
>>>    intersection?, for example latitude longitude of street1 with street2
>>>
>>>    RG
>>>
>>>        _______________________________________________
>>>    Pgrouting-users mailing list
>>>    Pgrouting-users at lists.postlbs.org <mailto:
>>> Pgrouting-users at lists.postlbs.org>
>>>    http://lists.postlbs.org/mailman/listinfo/pgrouting-users
>>>
>>>
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.postlbs.org
>> http://lists.postlbs.org/mailman/listinfo/pgrouting-users
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20090401/a14b814c/attachment.html


More information about the Pgrouting-users mailing list