Projects

Fountains

https://water-fountains.org

RoadMap https://github.com/mmmatthew/proximap/wiki/Roadmap

Sources

• GIT:
  • https://github.com/mmmatthew/datablue
  • https://github.com/mmmatthew/proximap

WikiData

fountainsWVZ dataSet https://www.wikidata.org/wiki/Q53629101

https://github.com/mmmatthew/import2wikidata (old https://github.com/opendata-zurich/wikidata/blob/master/fountains/)

How to find a single fountain in WD

1. ) go to https://query.wikidata.org/
2. ) Enter

SELECT ?place ?placeLabel ?location ?date ?catalog_code ?catalogLabel ?operator
WHERE
{
  # Enter coordinates
  SERVICE wikibase:box {
    ?place wdt:P625 ?location .
    bd:serviceParam wikibase:cornerWest "Point(8.45960259979614 47.3229261255644)"^^geo:wktLiteral.
    bd:serviceParam wikibase:cornerEast "Point(8.61940272745742 47.431119712250506)"^^geo:wktLiteral.
  } .
  # Is a water well or fountain or subclass of fountain
  FILTER (EXISTS { ?place wdt:P31/wdt:P279* wd:Q43483 } || EXISTS { ?place wdt:P31/wdt:P279* wd:Q483453 }).
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de" .
  } 
  OPTIONAL { ?place p:P528 ?catalog_code.
            ?catalog_code pq:P972 ?catalog.}
  OPTIONAL { ?place wdt:P571 ?date.}
  OPTIONAL { ?place wdt:P137 ?operator.}
}

3) switch to map and pick the one you want

Links

Back to Main Page