Apr 18, 2019, 5:40 AM by yuriastrak...@gmail.com: > Andy, you could also use one of the example queries in > sophox.org > <http://sophox.org>> to find all objects that are usually tagged with > brand:wikidata=* (e.g. have more than 10 instances of that), and find all > other objects that use that same value for wikidata tag. The query currently > finds over 15,000 such objects, so it runs a ~minute, but limiting it to a > 1000 shows up much faster -- > http://tinyurl.com/y5n42qlx > <http://tinyurl.com/y5n42qlx> > Note that this query finds mostly objects with operator:wikidata (and operator:wikipedia tags) what is wrong only for franchises. For example https://www.openstreetmap.org/node/2592353066 <https://www.openstreetmap.org/node/2592353066> https://www.openstreetmap.org/way/191158292 <https://www.openstreetmap.org/way/191158292> https://www.openstreetmap.org/way/241947392 <https://www.openstreetmap.org/way/241947392> https://www.openstreetmap.org/node/3300180823 <https://www.openstreetmap.org/node/3300180823> https://www.openstreetmap.org/node/2356411906 > A random look at some of those features shows that many have both wikidata > and brand:wikidata set to the same value (which is surprising). > Is it something that may be a correct tagging in some situation? Maybe adding it to a JOSM/iD validator would be a good idea. Happens 4801 times - http://tinyurl.com/yxg3x3fc <http://tinyurl.com/yxg3x3fc> (sorry for using suspicious link shortener, full link is quite long and I see no option to use a better link shortener like with Overpass Turbo). https://sophox.org/#%23defaultView%3AMap%0ASELECT%20%3FosmId%20%3Flocation%20%3Fbwd%20%3FbwdLabel%20%3FbwdDescription%20WHERE%20%7B%0A%0A%20%20%23%20Subquery%20finds%20brand%3Awikidata%20IDs%20used%20more%20than%2010%20times%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fbwd%20%28count%28%2a%29%20as%20%3Fcount%29%20WHERE%20%7B%0A%20%20%20%20%20%20%3Fo%20osmt%3Abrand%3Awikidata%20%3Fbwd%20.%0A%20%20%20%20%7D%0A%20%20%20%20group%20by%20%3Fbwd%0A%20%20%20%20having%20%28%3Fcount%20%3E%2010%29%0A%20%20%7D%0A%0A%20%20%23%20Find%20OSM%20objects%20where%20wikidata%20or%20operator%3Awikidata%20tag%0A%20%20%23%20is%20one%20of%20the%20common%20brand%3Awikidata%20IDs%0A%20%20VALUES%20%3Ftag%20%7B%20osmt%3Awikidata%20%7D%0A%0A%20%20%3FosmId%20%3Ftag%20%3Fbwd%20%3B%0A%20%20%20%20%20%20%20%20%20osmm%3Aloc%20%3Flocation%20.%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%2Cfr%2Cru%2Ces%2Cde%2Czh%2Cja%22.%20%7D%0A%7D
_______________________________________________ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk