--- a/maxious-canberra-transit-feed/04-locatebetweenpoints.osm.xml.php +++ b/maxious-canberra-transit-feed/04-locatebetweenpoints.osm.xml.php @@ -1,1 +1,40 @@ + + +"; +$conn = pg_connect("dbname=openstreetmap user=postgres password=snmc"); +if (!$conn) { + echo "An error occured.\n"; + exit; +} +$result_stops = pg_query($conn, "Select * FROM current_node_tags INNER JOIN current_nodes ON +current_node_tags.id=current_nodes.id WHERE v LIKE '%bus%' "); +if (!$result_stops) { + echo "An stops retirieve error occured.\n"; + exit; +} + +while ($stop = pg_fetch_assoc($result_stops)) { +$stop['latitude'] = $stop['latitude']/10000000; +$stop['longitude'] = $stop['longitude']/10000000; + +echo "\n"; + $result_stopkeys = pg_query($conn, "SELECT * from current_node_tags where id = {$stop['id']};"); + if (!$result_stopkeys) { + echo "An stops keys retirieve error occured.\n"; + exit; + } + $name = ""; + while ($stopkeys = pg_fetch_assoc($result_stopkeys)) { + echo "\n"; + } + echo "\n"; +} + +echo "\n\n"; +?>