fantastic 😂

@frodrigo

I may try myself to run an QLever OSM Data Items instance. It is the database I want the more query on.

that would be useful! Currently data items are not widespread (and risk even getting slashed), but I think has also to do with the inability to use them in queries with updated data. If it was usable through SPARQL it could simplify many OSM-related tasks. I think setting it up would require as first step to dump the data items as RDF but I can’t find any documentation on that in the wiki.

@westnordost

is it a bug that if I export this query https://qlever.cs.uni-freiburg.de/osm-planet/bEcHTr to CSV, I get this: … while if I export it to TSV, I get this: …

Yes, those are the export formats defined by the SPARQL standard

Now, StreetComplete users will get up to date suggestions in the atm operator, clothes container operator and charging station operator quests again :-)

Cool!

@CloCkWeRX cool idea!

@westnordost Currently QLever has not yet implemented centroid calculation so it’s not currently possible. If it implemented geoSPARQL this could be obtained by using the geof:aggCentroid aggregate function:

PREFIX osmkey: <https://www.openstreetmap.org/wiki/Key:>
PREFIX geo: <http://www.opengis.net/ont/geosparql#>
PREFIX geof: <http://www.opengis.net/def/function/geosparql/>

SELECT ?operator (geof:aggCentroid(?geometry) AS ?centroid)
WHERE {
  ?element osmkey:amenity "recycling" ;
           osmkey:recycling_type "container" ;
           osmkey:operator ?operator ;
           geo:hasGeometry ?geometry .
}
GROUP BY ?operator

“Italia in miniatura” (Italy in miniature): https://www.openstreetmap.org/way/424278187#map=19/44.09090/12.51457

I’m receiving 504 as well on relation 9942289

Ottimo elenco!