OSM Overpass API Abfrage mit PHP SimpleXML / XPath - Beispiel & Frage

[say_hello]

Hallo communtiy,

mit diesem Code hole ich vom Endpunkt der OSM Overpass API Daten.

<?php
/**
 * OSM Overpass API with PHP SimpleXML / XPath
 *
 * PHP Version: 5.4 - Can be back-ported to 5.3 by using 5.3 Array-Syntax (not PHP 5.4's square brackets)
 */
//
// 1.) Query an OSM Overpass API Endpoint
//

$query = 'node
  ["amenity"~".*"]
  (-54.5247541978, 2.05338918702, 9.56001631027, 51.1485061713);
out;';

$context = stream_context_create(['http' => [
    'method'  => 'POST',
    'header' => ['Content-Type: application/x-www-form-urlencoded'],
    'content' => 'data=' . urlencode($query),
]]);

# please do not stress this service, this example is for demonstration purposes only.
$endpoint = 'http://overpass-api.de/api/interpreter';
libxml_set_streams_context($context);
$start = microtime(true);

$result = simplexml_load_file($endpoint);
printf("Query returned %2\$d node(s) and took %1\$.5f seconds.\n\n", microtime(true) - $start, count($result->node));

//
// 2.) Work with the XML Result
//

# get all school nodes with xpath
$xpath = '//node[tag[@k = "amenity" and @v = "school"]]';
$schools = $result->xpath($xpath);
printf("%d School(s) found:\n", count($schools));
foreach ($schools as $index => $school)
{
# Get the name of the school (if any), again with xpath
list($name) = $school->xpath('tag[@k = "name"]/@v') + ['(unnamed)'];
list($website) = $school->xpath('tag[@k = "website"]/@v') + ['(no website)'];
list($email) = $school->xpath('tag[@k = "contact:email"]/@v') + ['(no email)'];
printf("#%02d: ID:%' -10s  [%s,%s]  %s %s %s\n", $index, $school['id'], $school['lat'], $school['lon'], $name, $website, $email);
}


//node[tag[@k = "amenity" and @v = "school"]]
//tag[@k = "name"]/@v'

$query = 'node
  ["addr:postcode"~"RM12"]
  (51.5557914,0.2118915,51.5673083,0.2369398);
   node
  (around:1000)
  ["amenity"~"fast_food"];
           out;';

$context = stream_context_create(['http' => [
    'method'  => 'POST',
    'header' => ['Content-Type: application/x-www-form-urlencoded'],
    'content' => 'data=' . urlencode($query),
]]);

$endpoint = 'http://overpass-api.de/api/interpreter';
libxml_set_streams_context($context);

$result = simplexml_load_file($endpoint);
printf("Query returned %2\$d node(s) and took %1\$.5f seconds.\n\n", microtime(true) - $start, count($result->node));

# Get the name of the school (if any), again with xpath
list($name) = $school->xpath('tag[@k = "name"]/@v') + ['(unnamed)'];
list($website) = $school->xpath('tag[@k = "contact:website"]/@v') + ['(no website)'];
list($email) = $school->xpath('tag[@k = "contact:email"]/@v') + ['(no email)'];
printf("#%02d: ID:%' -10s  [%s,%s]  %s %s %s\n", $index, $school['id'], $school['lat'], $school['lon'], $name, $website, $email);

Die Ausgaben... :

martin@linux-3645:~/dev/php> php o3.php
Query returned 2799 node(s) and took 9.36001 seconds.
33 School(s) found:
#00: ID:332534486   [39.5018840,16.2722854]  Scuola Elementare (no website) (no email)
#01: ID:1428094278  [39.3320912,16.1862820]  (unnamed) (no website) (no email)
#02: ID:1822746784  [38.9075566,16.5776597]  (unnamed) (no website) (no email)
#03: ID:1822755951  [38.9120272,16.5713431]  (unnamed) (no website) (no email)
#04: ID:2002566438  [39.1349460,16.0736446]  (unnamed) (no website) (no email)
#05: ID:2056891127  [39.4106679,16.8254844]  (unnamed) (no website) (no email)
#06: ID:2056892999  [39.4124687,16.8286119]  (unnamed) (no website) (no email)
#07: ID:2272010226  [39.4481717,16.2894353]  Scuola dell'infanzia San Francesco (no website) (no email)
#08: ID:2272017152  [39.4502366,16.2807664]  Scuola Media (no website) (no email)
#09: ID:2358307794  [39.5015031,16.3905965]  I.I.S.S. Liceo Statale V. Iulia (no website) (no email)
#10: ID:2358307796  [39.4926280,16.3853662]  Liceo Classico (no website) (no email)
#11: ID:2358307797  [39.4973761,16.3858275]  Scuola Media (no website) (no email)
#12: ID:2358307800  [39.5015527,16.3941156]  I.T.C. e per Geometri (no website) (no email)
#13: ID:2358307801  [39.4983862,16.3807796]  Istituto Professionale (no website) (no email)
#14: ID:2448031004  [38.6438417,16.3873106]  (unnamed) (no website) (no email)
#15: ID:2458139204  [39.0803263,17.1291649]  Sacro Cuore (no website) (no email)
#16: ID:2552412313  [39.0765212,17.1224610]  (unnamed) (no website) (no email)
#17: ID:2582443083  [39.0815417,17.1178983]  Liceo Socio Biologico Gravina (no website) (no email)
#18: ID:2585754364  [38.8878393,16.4076323]  Scuola Elementare (no website) (no email)
#19: ID:2585754366  [38.8877600,16.4076216]  Scuola Media (no website) (no email)
#20: ID:3071126720  [38.6022703,16.5554408]  Scuola Media (no website) (no email)
#21: ID:3071127683  [38.6027273,16.5563125]  Scuola Elementare (no website) (no email)
#22: ID:3081362915  [39.2865638,16.2601963]  Convitto Nazionale Bernardino Telesio (no website) (no email)
#23: ID:3081362921  [39.2856714,16.2613594]  Liceo Classico B. Telesio (no website) (no email)
#24: ID:3081362926  [39.2888949,16.2577446]  Scuola (no website) (no email)
#25: ID:3732551794  [39.5132435,16.2863285]  (unnamed) (no website) (no email)
#26: ID:3740289655  [39.5167318,16.2838146]  scuola media (no website) (no email)
#27: ID:3740289656  [39.5164344,16.2821103]  scuola elementare (no website) (no email)
#28: ID:4004532684  [38.7804787,16.5122952]  Liceo Artistico (no website) (no email)
#29: ID:4589289756  [38.6794209,16.1063084]  Scuola Comprensiva Trentacapilli (no website) (no email)
#30: ID:4843966477  [39.0709866,17.1288384]  Pegaso (no website) (no email)
#31: ID:5297629775  [38.5768845,16.3263536]  Scuola Media Statale "Ignazio La Russa" (no website) (no email)
#32: ID:5316865306  [39.0807997,17.1264225]  Enrico Fermi (no website) (no email)
Query returned 3 node(s) and took 9.83496 seconds.
martin@linux-3645:~/dev/php>

Die Ausgangsfrage war: wie kann ich mehr Daten gewinnen - wenigstens aber:

- die Ardesse
- die Webseite
-

Es ist also die Frage, wie ich mehr Daten in die xpath Abfrage einmünden lassen kann.
Habe mich zur Information hier umgesehen Key:contact - OpenStreetMap Wiki

    contact:phone
        contact:fax   
        contact:website
        contact:email

Ziel ist es, die xpath Abfragen in der Foreach-Loop zu erweitern, relativ zu den Schools-Nodes

    tag[@k = "name"]/@v'
    tag[@k = "contact:website"]/@v'
    tag[@k = "contact:email"]/@v'

Freu mich auf einen Tipp.

vg