Ludrol@szmer.info to OpenStreetMap community@lemmy.mlEnglish · 4 months agoIs there a way to see how many amenity=bench I have created?message-squaremessage-square6fedilinkarrow-up123arrow-down11file-text
arrow-up122arrow-down1message-squareIs there a way to see how many amenity=bench I have created?Ludrol@szmer.info to OpenStreetMap community@lemmy.mlEnglish · 4 months agomessage-square6fedilinkfile-text
minus-squaredont_lemmee_down@lemm.eelinkfedilinkEnglisharrow-up14·4 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-24 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·4 months agohttps://overpass-turbo.eu/s/1JWu Modified it slightly to output the raw number instead of list of benches @[email protected]
minus-squaretemmink@feddit.delinkfedilinkEnglisharrow-up2·4 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·4 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 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
@[email protected]
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 :)