* Phil! Gold <phi...@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 ---- --- -- _______________________________________________ Talk-us mailing list Talk-us@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-us