SPARQL: Entries with no label in one lang - Wikidata - lists.wikimedia.org

List overview All Threads
Download

SPARQL: Entries with no label in one lang

data access for Wikiversity on May...

Deployment date for the...

Toni Hermoso Pulido

29 Apr 2016 29 Apr '16

7:24 a.m.

Hello, I'm trying to retrieve via SPARQL those entries missing a label in a certain language (e.g. "de"). Example from this query: http://tinyurl.com/zazewyx How this could be done straight from a SPARQL query? Thanks, -- Toni Hermoso Pulido http://www.cau.cat http://www.similis.cc

Reply

Show replies by date

Jerven Tjalling Bolleman

29 Apr 29 Apr

9:19 a.m.

This seems to work. SELECT distinct ?h ?label ?ll WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . ?h wdt:P19 ?birthplace . ?birthplace wdt:P31*/wdt:P131* wd:Q5720 . ?h rdfs:label ?label . FILTER (NOT EXISTS { BIND (lang(?label) as ?ll) FILTER ( ?ll = "de" ) . }) } ORDER BY ?label LIMIT 100 On 29/04/16 09:24, Toni Hermoso Pulido wrote:

Hello, I'm trying to retrieve via SPARQL those entries missing a label in a certain language (e.g. "de"). Example from this query: http://tinyurl.com/zazewyx How this could be done straight from a SPARQL query? Thanks,

-- ------------------------------------------------------------------- Jerven Bolleman Jerven.Bolleman(a)sib.swiss SIB Swiss Institute of Bioinformatics Tel: +41 (0)22 379 58 85 CMU, rue Michel Servet 1 Fax: +41 (0)22 379 58 58 1211 Geneve 4, Switzerland www.sib.swiss - www.uniprot.org Follow us at https://twitter.com/#!/uniprot -------------------------------------------------------------------

Reply

Toni Hermoso Pulido

11:07 a.m.

Hi Jerven, I tried with: SELECT distinct ?h ?label ?ll WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . ?h wdt:P19 ?birthplace . ?birthplace wdt:P31*/wdt:P131* wd:Q5720 . ?h rdfs:label ?label . FILTER (NOT EXISTS { BIND (lang(?label) as ?ll) FILTER ( ?ll = "ca" ) . }) } ORDER BY ?label LIMIT 100 and I would expect that one of the results: h label ll wd:Q377947 <http://www.wikidata.org/entity/Q377947> Adrián Palomares wd:Q5660653 <http://www.wikidata.org/entity/Q5660653> Agustín Galiana wd:Q5662450 <http://www.wikidata.org/entity/Q5662450> Alba Rico wd:Q5663315 <http://www.wikidata.org/entity/Q5663315> Alberto Mira wd:Q3753762 <http://www.wikidata.org/entity/Q3753762> Alberto Miralles wd:Q451736 <http://www.wikidata.org/entity/Q451736> Amadeo Gabino wd:Q3779647 <http://www.wikidata.org/entity/Q3779647> Ambrós wd:Q5673275 <http://www.wikidata.org/entity/Q5673275> Amparo Valle wd:Q3326138 <http://www.wikidata.org/entity/Q3326138> Ana Duato wd:Q2844983 <http://www.wikidata.org/entity/Q2844983> Ana Juan wd:Q5673898 <http://www.wikidata.org/entity/Q5673898> Ana María Drack https://www.wikidata.org/wiki/Q5673275 would not have a 'ca' label... but it seems to have. El 04/29/2016 a les 11:19 AM, Jerven Tjalling Bolleman ha escrit:

This seems to work. SELECT distinct ?h ?label ?ll WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . ?h wdt:P19 ?birthplace . ?birthplace wdt:P31*/wdt:P131* wd:Q5720 . ?h rdfs:label ?label . FILTER (NOT EXISTS { BIND (lang(?label) as ?ll) FILTER ( ?ll = "de" ) . }) } ORDER BY ?label LIMIT 100 On 29/04/16 09:24, Toni Hermoso Pulido wrote:

Hello, I'm trying to retrieve via SPARQL those entries missing a label in a certain language (e.g. "de"). Example from this query: http://tinyurl.com/zazewyx How this could be done straight from a SPARQL query? Thanks,

-- Toni Hermoso Pulido http://www.cau.cat http://www.similis.cc

Reply

Toni Hermoso Pulido

3 May 3 May

6:57 p.m.

Hello all, Finally I think I solved it. A query with 11 results at the time of writing http://tinyurl.com/hofewk3 Entries with 'de' lang in label: Uncomment: #FILTER EXISTS { # ?h rdfs:label ?label . # FILTER ( langMatches(lang(?label), 'de' ) ) #} Entries missing 'de' lang in label: Uncomment: #FILTER NOT EXISTS { # ?h rdfs:label ?label . # FILTER ( langMatches(lang(?label), 'de' ) ) #} Thanks for all! El 29/04/16 a les 13:07, Toni Hermoso Pulido ha escrit:

Hi Jerven, I tried with: SELECT distinct ?h ?label ?ll WHERE { ?h wdt:P31 wd:Q5 . ?h wdt:P569 ?date . ?h wdt:P19 ?birthplace . ?birthplace wdt:P31*/wdt:P131* wd:Q5720 . ?h rdfs:label ?label . FILTER (NOT EXISTS { BIND (lang(?label) as ?ll) FILTER ( ?ll = "ca" ) . }) } ORDER BY ?label LIMIT 100 and I would expect that one of the results: h label ll wd:Q377947 <http://www.wikidata.org/entity/Q377947> Adrián Palomares wd:Q5660653 <http://www.wikidata.org/entity/Q5660653> Agustín Galiana wd:Q5662450 <http://www.wikidata.org/entity/Q5662450> Alba Rico wd:Q5663315 <http://www.wikidata.org/entity/Q5663315> Alberto Mira wd:Q3753762 <http://www.wikidata.org/entity/Q3753762> Alberto Miralles wd:Q451736 <http://www.wikidata.org/entity/Q451736> Amadeo Gabino wd:Q3779647 <http://www.wikidata.org/entity/Q3779647> Ambrós wd:Q5673275 <http://www.wikidata.org/entity/Q5673275> Amparo Valle wd:Q3326138 <http://www.wikidata.org/entity/Q3326138> Ana Duato wd:Q2844983 <http://www.wikidata.org/entity/Q2844983> Ana Juan wd:Q5673898 <http://www.wikidata.org/entity/Q5673898> Ana María Drack https://www.wikidata.org/wiki/Q5673275 would not have a 'ca' label... but it seems to have. El 04/29/2016 a les 11:19 AM, Jerven Tjalling Bolleman ha escrit: > This seems to work. > > SELECT distinct ?h ?label ?ll > WHERE > { > ?h wdt:P31 wd:Q5 . > ?h wdt:P569 ?date . > ?h wdt:P19 ?birthplace . > ?birthplace wdt:P31*/wdt:P131* wd:Q5720 . > ?h rdfs:label ?label . > FILTER (NOT EXISTS { > BIND (lang(?label) as ?ll) > FILTER ( ?ll = "de" ) . > }) > } > ORDER BY ?label LIMIT 100 > > On 29/04/16 09:24, Toni Hermoso Pulido wrote: >> Hello, >> >> I'm trying to retrieve via SPARQL those entries missing a label in a >> certain language (e.g. "de"). >> Example from this query: http://tinyurl.com/zazewyx >> >> How this could be done straight from a SPARQL query? >>

-- Toni Hermoso Pulido http://www.cau.cat http://www.similis.cc

Reply

2908

days inactive

2912

days old

wikidata@lists.wikimedia.org

Manage subscription

3 comments

2 participants

tags (0)

participants (2)

Jerven Tjalling Bolleman
Toni Hermoso Pulido