|
<?php |
|
function getPage($url) |
|
{ |
|
$ch = curl_init($url); |
|
curl_setopt( $ch, CURLOPT_RETURNTRANSFER, 1 ); |
|
curl_setopt( $ch, CURLOPT_HEADER, 0 ); |
|
$page = curl_exec($ch); |
|
curl_close($ch); |
|
return $page; |
|
} |
|
// |
|
// http://developers.cloudmade.com/wiki/geocoding-http-api/Documentation |
|
$conn = pg_connect("dbname=bus user=postgres password=snmc"); |
|
if (!$conn) { |
|
echo "An error occured.\n"; |
|
exit; |
|
} |
|
$sql = "Select * from stops where name is null"; |
|
$result_stops = pg_query($conn, $sql); |
|
if (!$result_stops) { |
|
cho("Error in SQL query: " . pg_last_error() ."<br>\n"); |
|
} |
|
while ($stop = pg_fetch_assoc($result_stops)) { |
|
echo "Processing ".$stop['geohash'] . " ... "; |
|
$url = "http://geocoding.cloudmade.com/daa03470bb8740298d4b10e3f03d63e6/geocoding/v2/find.js?around=".($stop['lat']/10000000).",".($stop['lng']/10000000)."&distance=closest&object_type=road"; |
|
$contents = json_decode(getPage($url)); |
|
$name = $contents->features[0]->properties->name; |
|
echo "Saving $name ! <br>" ; |
|
$result_save = pg_query($conn, "UPDATE stops set name = '".pg_escape_string($name)."' where geohash = '{$stop['geohash']}' "); |
|
if (!$result_save) { |
|
echo("Error in SQL query: " . pg_last_error() ."<br>\n"); |
|
} |
|
flush(); |
|
} |
|
|
|
?> |
|
|
|
|