Help
Difference between revisions of "SPARQL for maintenance"
SPARQL for maintenance gather some SPARQL queries which help to monitors errors and bring fix to our resources.
| Line 102: | Line 102: | ||
|} | |} | ||
| − | === ✅ Speakers → | + | === ✅ Speakers → Undefined place of residence === |
| + | :''The following may need precision.'' | ||
| + | {| style="width:100%" | ||
| + | |- style="vertical-align:top;" | ||
| + | |style="padding: 0 3em;width:60%"| | ||
| + | <syntaxhighlight lang="sparql"> | ||
| + | SELECT ?item ?itemLabel ?filledGenderLabel | ||
| + | WHERE { | ||
| + | ?item prop:P2 entity:Q3 . # Filter: is Q3 `speaker` | ||
| + | ?item prop:P14 . # Filter: missing P14 `place of residence` <------------------------------------- | ||
| + | # Add labels to each variable used. | ||
| + | SERVICE wikibase:label { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | } | ||
| + | } | ||
| + | </syntaxhighlight> | ||
| + | | | ||
| + | <query _pagination="6" item="Property" itemLabel="Values"> | ||
| + | SELECT ?item ?itemLabel ?filledGenderLabel | ||
| + | WHERE { | ||
| + | ?item prop:P2 entity:Q3 . # Filter: is Q3 `speaker` | ||
| + | ?item prop:P14 . # Filter: missing P14 `place of residence` <------------------------------------- | ||
| + | # Add labels to each variable used. | ||
| + | SERVICE wikibase:label { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | } | ||
| + | } | ||
| + | </query> | ||
| + | |} | ||
| + | |||
| + | |||
| + | === ✅ Speakers → Undefined gender === | ||
:''The following may need a merge'' | :''The following may need a merge'' | ||
{| style="width:100%" | {| style="width:100%" | ||
| Line 108: | Line 139: | ||
|style="padding: 0 3em;width:60%"| | |style="padding: 0 3em;width:60%"| | ||
<syntaxhighlight lang="sparql"> | <syntaxhighlight lang="sparql"> | ||
| − | + | SELECT ?item ?itemLabel ?filledGenderLabel | |
| + | WHERE { | ||
| + | ?item prop:P2 entity:Q3 . | ||
| + | { ?item prop:P8 entity:Q608982 . } # Filter: 'gender' is 'agender' | ||
| + | UNION | ||
| + | { ?item prop:P8 entity:Q710460 . } # Filter: 'gender' is 'not documented' | ||
| + | # UNION | ||
| + | # { ?item prop:P8 entity:? . } # Filter: 'gender' is missing | ||
| + | ?item prop:P8 ?filledGender . | ||
| + | # Add labels to each variable used. | ||
| + | SERVICE wikibase:label { | ||
| + | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
| + | } | ||
| + | } | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| | | | ||
Revision as of 22:10, 18 January 2022
Speakers
✅ Speakers → Username containing reserved sign `-`
- See also T297635
SELECT *
WHERE {
?id prop:P2 entity:Q3 .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
?id rdfs:label ?name .
}
BIND (regex(STR(?name),"-") AS ?has_separator)
}
ORDER BY DESC (?has_separator)
|
|
SELECT ?has_separator (COUNT(?has_separator) AS ?found)
WHERE {
?id prop:P2 entity:Q3 .
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
?id rdfs:label ?name .
}
BIND (regex(STR(?name),"-") AS ?has_separator)
# filter( regex(?name, "-" ))
}
#ORDER BY DESC (?has_separator)
GROUP BY (?has_separator)
|
|
✅ Speakers → Speakers of `zho` to change to `cmn`
- Should be maintained to 0.
SELECT ?langLabel ?isoLabel (SUBSTR(STR(?speaker),32) AS ?speaker) ?speakerLabel
WHERE {
?speaker prop:P4 entity:Q130 . # Filter: P4 language is Q130 zho ;
?speaker prop:P2 entity:Q3 . # Filter: speakers
?speaker prop:P4 ?lang .
?lang prop:P13 ?iso .
# Add Labels
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
} ORDER BY ASC(?isoLabel)
# Helper: Chinese writing zho:Q130/wd:Q7850 ; Chinese mandarin cmn:Q113/wd:Q9192 .
|
|
✅ Speakers → Undefined place of residence
- The following may need precision.
SELECT ?item ?itemLabel ?filledGenderLabel
WHERE {
?item prop:P2 entity:Q3 . # Filter: is Q3 `speaker`
?item prop:P14 . # Filter: missing P14 `place of residence` <-------------------------------------
# Add labels to each variable used.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}
}
|
|
✅ Speakers → Undefined gender
- The following may need a merge
SELECT ?item ?itemLabel ?filledGenderLabel
WHERE {
?item prop:P2 entity:Q3 .
{ ?item prop:P8 entity:Q608982 . } # Filter: 'gender' is 'agender'
UNION
{ ?item prop:P8 entity:Q710460 . } # Filter: 'gender' is 'not documented'
# UNION
# { ?item prop:P8 entity:? . } # Filter: 'gender' is missing
?item prop:P8 ?filledGender .
# Add labels to each variable used.
SERVICE wikibase:label {
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
}
}
|
|
Recordings
✅ Recordings → With ISO-639-3 `zho` to change to `cmn`
SELECT ?langLabel ?isoLabel (SUBSTR(STR(?audio),32) AS ?Audio) ?audioLabel
WHERE {
?audio prop:P4 entity:Q130 . # Filter: P4 language is Q130 zho ;
?audio prop:P2 entity:Q2 . # Filter: audios
?audio prop:P4 ?lang .
?lang prop:P13 ?iso .
# Add Labels
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
} ORDER BY ASC(?isoLabel)
# Helper: Chinese writing zho:Q130/wd:Q7850 ; Chinese mandarin cmn:Q113/wd:Q9192 .
|
|
SELECT ?isoLabel (COUNT(?iso) AS ?found)
WHERE {
?audio prop:P4 entity:Q130 . # Filter: P4 language is Q130 zho ;
?audio prop:P2 entity:Q2 . # Filter: audios
?audio prop:P4 ?lang .
?lang prop:P13 ?iso .
# Add Labels
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }
} GROUP BY ?isoLabel
# Helper: Chinese writing zho:Q130/wd:Q7850 ; Chinese mandarin cmn:Q113/wd:Q9192
|
|