You can specify multiple languages for the label service:
# All subclasses of a class example
# here all subclasses of P279 Organization (Q43229)
SELECT ?item ?itemLabel ?itemDescription ?itemAltLabel
WHERE
{
?item wdt:P279 wd:Q43229.
SERVICE wikibase:label { bd:serviceParam wikibase:language
"en,de,fr,ja,cn,ru,es,sv,pl,nl,sl,ca,it" }
}
ORDER BY ASC(LCASE(?itemLabel))Link: https://query.wikidata.org/#%23%20All%20subclasses%20of%20a%20class%20example%0A%23%20here%20all%20subclasses%20of%20P279%20Organization%20%28Q43229%29%0ASELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3FitemAltLabel%0AWHERE%0A%7B%0A%20%3Fitem%20wdt%3AP279%20wd%3AQ43229.%0A%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cde%2Cfr%2Cja%2Ccn%2Cru%2Ces%2Csv%2Cpl%2Cnl%2Csl%2Cca%2Cit%22%20%7D%0A%7D%0AORDER%20BY%20ASC%28LCASE%28%3FitemLabel%29%29 I’ve also changed the query to sort the results case-insensitively. (Note: the query seems to occasionally take a very long time for me, 180 seconds – I’m not sure if the many label languages cause the slowdown or if it’s just my internet connection.) Cheers, Lucas On 23.02.2017 02:57, Rick Labs wrote: > > I'm running into some major label gaps, as are others. > > My area of interest is the Company data project. I'm new to SPARQL and > here is my working query: > > # All subclasses of a class example > # here all subclasses of P279 Organization (Q43229) > SELECT ?item ?itemLabel ?itemDescription ?itemAltLabel > WHERE > { > ?item wdt:P279 wd:Q43229 . > SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } > } > ORDER BY ASC(?itemLabel) > > Background > > https://www.wikidata.orB/wiki/Wikidata:WikiProject_Companies seems > most interested in https://www.wikidata.org/wiki/Q4830453 business > enterprise. So I write the above SPARQL to see how "business > enterprise" fits under its immediate parent - P279 Organization. I > want to learn about all "brother/sister" level objects under > "Organization." > > If you run the above you will see how many "Organization" children > objects have no English label. This greatly impedes understanding what > is considered a "business enterprise" and what is not. (Yes - this > part of the ontology seems to need some serious tuning up too!) When > we go to build out a reasonable starter ontology under the "company > data project" we want the structure sound prior to filling it in with > a considerable volume of data. > > For example, a key goal is the company data needs to "add up" to > economic data. Any entity that has a proprietor, partners, or any > payroll counts in economic data. Government offices, schools, non > profits, etc. all produce goods or services - all contribute to > economic output (GDP). So, much of the "company data project" is > directly relevant to entities that are more general than just > "business entities". > > Is there a way I can run a SPARQL query that outputs the EN label if > available (as above), and any other label in any other language > (including a column for language code) if not? Ideally I'd like to > have only one additional language reported if EN is not available, and > I'd like to have it report according to my preference (German if > available, French if not, then Japanese, Chinese on down the line. It > would also be beneficial to have a column for the longer description, > if available. > > For my analysis purposes now I'm happy to work with simple language > translations done by machine. Even if they are slightly off they are > probably good enough for my purposes of reviewing and trying to > understand the standing ontology. I don't plan on inserting the > translations back into WikiData myself, but might try to rally up > humans with those specific language skills to double check the machine > translations and once verified, insert the translated labels back into > WikiData. > > I'm not at all familiar with other tools that might be available > relevant to "the missing label challenge". Right now SPARQL, SERVICE > wikibase:label, and Google Translate seem like the way to go. But, all > ideas are most welcome. > > Thanks! > > Rick > > > On 2/19/2017 11:00 AM, Romaine Wiki wrote: >> Hi all, >> >> If you look in the recent changes, most items have labels in English >> and those are shown in the recent changes and elsewhere (so we know >> what the item is about without opening first). But not all items have >> labels, and these items without English label are often items with >> only a label in Chinese, Arabic, Cyrillic script, Hebrew, etc. This >> forms a significant gap. >> >> Is there a way to easily make a transcription from one language to >> another? >> Or alternatively if there is a database that has such transcriptions? >> >> >> Also the other way round might be helpful for users of Wikidata that >> use/read it in Chinese, Arabic, Cyrillic script, Hebrew, etc. >> >> Thanks! >> >> Romaine >> >> >> _______________________________________________ >> Wikidata mailing list >> Wikidata@lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/wikidata > > > _______________________________________________ > Wikidata mailing list > Wikidata@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikidata
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
