[Talk-us] Fwd: Re: [OSM-talk] Mapquest launches site based on OSM!

Phil! Gold phil_g at pobox.com
Sun Aug 8 15:03:26 BST 2010


* Phil! Gold <phil_g at pobox.com> [2010-08-08 09:41 -0400]:
>   SELECT road.highway, route.network, route.ref
>     FROM planet_osm_line road
>       JOIN route_members ON road.osm_id = route_members.road_id
>       JOIN planet_osm_line route ON route_members.postgis_id = route.osm_id

I was doing this from memory...  Those JOINs should be LEFT JOINs, of
course, because most roads are not members of route relations.

-- 
...computer contrarian of the first order... / http://aperiodic.net/phil/
PGP: 026A27F2  print: D200 5BDB FC4B B24A 9248  9F7A 4322 2D22 026A 27F2
--- --
PHP is a minor evil perpetrated and created by incompetent amateurs,
whereas Perl is a great and insidious evil, perpetrated by skilled but
perverted professionals.
                       -- Jon Ribbens
---- --- --



More information about the Talk-us mailing list