Ludrol@szmer.info to OpenStreetMap community@lemmy.mlEnglish · 5 months agoIs there a way to see how many amenity=bench I have created?message-squaremessage-square2fedilinkarrow-up11arrow-down10file-text
arrow-up11arrow-down1message-squareIs there a way to see how many amenity=bench I have created?Ludrol@szmer.info to OpenStreetMap community@lemmy.mlEnglish · 5 months agomessage-square2fedilinkfile-text
minus-squaredont_lemmee_down@lemm.eelinkfedilinkEnglisharrow-up0·5 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-squaretemmink@feddit.delinkfedilinkEnglisharrow-up0·5 months agoWhich database are you querying? I only knew of Overpass QL. Is this a database of the OSM data?
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 :)
Which database are you querying? I only knew of Overpass QL. Is this a database of the OSM data?