How can i get full street from db?

Thanks for reply!

I need to find intersection of two street's.

What i do:

1. Get street as many LINESTRING's

SELECT planet_osm_line.osm_id, planet_osm_line.name, planet_osm_line.way FROM planet_osm_line WHERE planet_osm_line.name LIKE ('%<street_name>%') ORDER BY planet_osm_line.way

2. Try to union (not merge, my mistake!), out = MULTISTRING()

SELECT ST_AsText(ST_Union(ST_GeomFromText(''),ST_GeomFromText('')));

3. Convert MULTISTRING to LINESTRING (LINESTRING need for function ST_Intersection())

SELECT ST_AsText(ST_LineMerge(ST_GeomFromText('')));


Totally, sometimes street pieces (or short lines) go in wrong sequence, and stage 2 is fail.

I can't find data (or rule) in database, on what basis the road can be drawn correctly..

Best regards, Alex.

To find the intersection between two streets of which you know the name, try

SELECT st_intersection(a.way,b.way) FROM planet_osm_line a, planet_osm_line b WHERE a.highway is not null AND b.highway is not null AND a.name='FirstName' AND b.name='SecondName' AND a.way && b.way;

This query will benefit from an index on the "name" column. It could occasionally return empty geometries, or more than one geometry.

Many thanks, it works!:)

If i get more flexible solution, i'll paste it here.

Best regards, Alex.