query-610d771f56a70581fe3d9f7bc3b5261c
Cycle sport events: move claims from length (P2043) to event distance (P3157) and remove unreferenced bounds from values, if existingI request a bot run to do the following: However, plenty claims still have bounds as a leftover from the time when we were not able to use quantities without bounds. I therefore request to remove all “±0” bounds, if no reference is given in the P2043 statement. It might be worth to consider removing all “±[0.]1” bounds as well, but I am not fully sure about that (could be repaired manually otherwise as well). claims. Quantity amount values and units, as well as existing qualifiers and references should be kept.(P3157)event distance claims by (P2043)length , so basically sports competition items) replace all (Q13406554)sports competition (instances of subclasses of ?item wdt:P31/wdt:P279 wd:Q13406554In items which have This bot run will affect in total around 2634 claims:
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?length ?upperBound ?lowerBound ?diff {
?item p:P2043 [ psv:P2043 ?value ] . # items that use P2043 (length)
?value wikibase:quantityAmount ?length .
OPTIONAL {
?value wikibase:quantityUpperBound ?upperBound; wikibase:quantityLowerBound ?lowerBound .
BIND(?upperBound - ?lowerBound AS ?diff) .
}
?item wdt:P31/wdt:P279* wd:Q13406554 . # and have P31 with subclass of sport competition (Q13406554)
# MINUS { # activate this to filter away items that are related to cycle sport
# VALUES ?cyclingClasses { wd:Q15091377 wd:Q18131152 }
# ?item wdt:P31/wdt:P279* ?cyclingClasses . # but not P31 with subclass of cycling race (Q15091377) or stage (Q18131152)
# }
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}