Is there a way to see how many amenity=bench I have created? (szmer.info)

submitted 7 months ago by Ludrol@szmer.info to c/openstreetmap@lemmy.ml

6 comments fedilink hide all child comments

I wonder how many I have already mapped.

you are viewing a single comment's thread
view the rest of the comments

[-] dont_lemmee_down@lemm.ee 14 points 7 months 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.

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 points 7 months ago* (last edited 7 months 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@szmer.info 1 points 7 months ago

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 points 7 months ago

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

[-] pietervdvn@lemmy.ml 3 points 7 months ago

The link is https://sophox.org/

[-] dont_lemmee_down@lemm.ee 2 points 7 months ago

I ran this in Sophox :)

this post was submitted on 14 Apr 2024

21 points (95.7% liked)

OpenStreetMap community

4186 readers

28 users here now

Everything #OpenStreetMap related is welcome: software releases, showing of your work, questions about how to tag something, as long as it has to do with OpenStreetMap or OpenStreetMap-related software.

OpenStreetMap is a map of the world, created by people like you and free to use under an open license.

Join OpenStreetMap and start mapping: https://www.openstreetmap.org.

There are many communication channels about OSM, many organized around a certain country or region. Discover them on https://openstreetmap.community

https://mapcomplete.org is an easy-to-use website to view, edit and add points (such as shops, restaurants and others)

https://learnosm.org/en/ has a lot of information for beginners too.

founded 4 years ago

MODERATORS

Ben_on_Lemmy@lemmy.ml