Is there a way to see how many amenity=bench I have created?

I wonder how many I have already mapped.

21 points · 6 comments · view on lemmy.world

6 Comments

dont_lemmee_down@lemm.ee · 14 pts · 2y (5 replies)

Definetly! You can use SPARQL to query the database! Kinda new to the whole thing, but I think this at least shows how many benches you have edited as the last person.

SELECT ?user (COUNT(*) AS ?count) WHERE {
  ?bench osmt:amenity "bench";
                osmm:user "Ludrol".
}
GROUP BY ?user

LIMIT 2

Which returns 60 :)

mannivu@livellosegreto.it · 3 pts · 2y (1 reply)

@dont_lemmee_down @Ludrol knowing which bench you edited as last person can be done easily with overpass-turbo.eu too https://overpass-turbo.eu/s/1JVw . More difficult is to know which you created.

@openstreetmap

Ludrol@szmer.info · 1 pts · 2y

https://overpass-turbo.eu/s/1JWu Modified it slightly to output the raw number instead of list of benches

@mannivu@livellosegreto.it

temmink@feddit.de · 2 pts · 2y (2 replies)

Which database are you querying? I only knew of Overpass QL. Is this a database of the OSM data?

pietervdvn@lemmy.ml · 3 pts · 2y

The link is https://sophox.org/

dont_lemmee_down@lemm.ee · 2 pts · 2y

I ran this in Sophox :)