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

dont_lemmee_down, 1 month ago

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.

<span style="color:#323232;">SELECT ?user (COUNT(*) AS ?count) WHERE {
</span><span style="color:#323232;">  ?bench osmt:amenity "bench";
</span><span style="color:#323232;">                osmm:user "Ludrol".
</span><span style="color:#323232;">}
</span><span style="color:#323232;">GROUP BY ?user
</span><span style="color:#323232;">
</span><span style="color:#323232;">LIMIT 2
</span>

Which returns 60 :)

mannivu, 1 month ago

@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, 1 month ago

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

@mannivu

temmink, 1 month ago

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

dont_lemmee_down, 1 month ago

I ran this in Sophox :)

pietervdvn, 1 month ago

The link is sophox.org