Ludrol@szmer.info to OpenStreetMap community@lemmy.mlEnglish · 7 months agoIs there a way to see how many amenity=bench I have created?message-squaremessage-square6fedilinkarrow-up122arrow-down11file-text
arrow-up121arrow-down1message-squareIs there a way to see how many amenity=bench I have created?Ludrol@szmer.info to OpenStreetMap community@lemmy.mlEnglish · 7 months agomessage-square6fedilinkfile-text
minus-squaredont_lemmee_down@lemm.eelinkfedilinkEnglisharrow-up13·7 months agoDefinetly! 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 :)
minus-squareManuel 🦡🦡@livellosegreto.itlinkfedilinkarrow-up2·edit-27 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
minus-squareLudrol@szmer.infoOPlinkfedilinkEnglisharrow-up1·7 months agohttps://overpass-turbo.eu/s/1JWu Modified it slightly to output the raw number instead of list of benches @mannivu@livellosegreto.it
minus-squaretemmink@feddit.delinkfedilinkEnglisharrow-up1·7 months agoWhich database are you querying? I only knew of Overpass QL. Is this a database of the OSM data?
minus-squarepietervdvn@lemmy.mlMlinkfedilinkEnglisharrow-up2·7 months agoThe link is https://sophox.org/
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 2Which returns 60 :)
@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
https://overpass-turbo.eu/s/1JWu Modified it slightly to output the raw number instead of list of benches
@mannivu@livellosegreto.it
Which database are you querying? I only knew of Overpass QL. Is this a database of the OSM data?
The link is https://sophox.org/
I ran this in Sophox :)