Ludrol to OpenStreetMap community@lemmy.mlEnglish · 11 months agoIs there a way to see how many amenity=bench I have created?message-squaremessage-square7fedilinkarrow-up123arrow-down11file-text
arrow-up122arrow-down1message-squareIs there a way to see how many amenity=bench I have created?Ludrol to OpenStreetMap community@lemmy.mlEnglish · 11 months agomessage-square7fedilinkfile-text
minus-squaredont_lemmee_down@lemm.eelinkfedilinkEnglisharrow-up13·11 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-up3·edit-211 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-squareLudrolOPlinkfedilinkEnglisharrow-up2·11 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-up2·11 months agoWhich database are you querying? I only knew of Overpass QL. Is this a database of the OSM data?
minus-squarepietervdvn@lemmy.mlMlinkfedilinkEnglisharrow-up3·11 months agoThe link is https://sophox.org/
minus-squaredont_lemmee_down@lemm.eelinkfedilinkEnglisharrow-up2·11 months agoI ran this in Sophox :)
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 :)
@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 :)