Hi Scott, One way to do that would be to get the language code label list from WDQS with this: http://tinyurl.com/y9p7q9l2 SELECT ?label WHERE {?s wdt:P424 ?code; rdfs:label ?label filter (lang(?label) = "en").}
and then stream the list to LDF client [1] requests https://tinyurl.com/ycc3dyce ldf-client https://query.wikidata.org/bigdata/ldf http://fragments.dbpedia.org/2015-10/en "SELECT * WHERE {?s rdfs:label "+ language + "@en . ?s owl:sameAs ?link }" The results would be in JSON from the client. It should give a relatively complete list of WIkidata language code entity corresponding resources in DBpedia Also, an simple way to get a dbpedia resource with TPF is with the entity label which is one of the properties that is the same for both datasets. So, SELECT * WHERE { ?s rdfs:label "German"@en . } will return the matching dbpedia and wikidata resources for that label. This could also perhaps be done with a federated query in WDQS.(untested). Christopher Johnson [1] https://github.com/LinkedDataFragments/Client.js > Message: 3 > Date: Sun, 29 Apr 2018 17:48:10 -0700 > From: Scott MacLeod <worlduniversityandsch...@gmail.com> > To: Discussion list for the Wikidata project > <wikidata@lists.wikimedia.org> > Subject: Re: [Wikidata] How to find the Dbpedia data for a Wikidata > item? > Message-ID: > <CADy6Cs8pVNqEQu909Y64DXFOq7SBJs4M3stvzPD7GQ3AMZNBkw@mail. > gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hi Paris Writers' News/PWN, Markus, and Wikidatans, > > Based on your example (http://tinyurl.com/yahwql2n), Markus, I'm seeking > to > learn how to do a similar query for all languages. > > In Wikidata I found a Q item # for "language" - Q34770 ( > https://www.wikidata.org/wiki/Q34770) - and plugged this into your query, > replaced the word "countries" with "languages," etc. but didn't get a > result, where your query yields 209 countries, Markus. > > In a parallel way, how would one compute them from the names of the > articles in Wikipedia? > > Thanks, > Scott > > > > > > > > On Fri, Apr 27, 2018 at 2:31 PM, Markus Kroetzsch < > markus.kroetz...@tu-dresden.de> wrote: > > > Hi, > > > > (English) DBpedia URIs are basically just (English) Wikipedia URIs with > > the first part exchanged. So one can compute them from the names of the > > articles. Example: a query for DBpedia URIs for all countries: > > > > http://tinyurl.com/yahwql2n > > > > """ > > SELECT ?dbpediaId > > WHERE > > { > > ?item wdt:P31 wd:Q6256 . # for the example: get IDs for all countries > > ?sitelink schema:about ?item ; > > schema:isPartOf <https://en.wikipedia.org/> . > > > > BIND(URI(CONCAT("http://dbpedia.org/resource/",SUBSTR( > STR(?sitelink),31))) > > as ?dbpediaId) > > } > > """ > > > > Of course, depending on your use case, you can do the same offline > > (without requiring SPARQL to rewrite the id strings for you). > > > > In theory, one could use federation to pull in data from the DBpedia > > endpoint, but in practice I could not find an interesting query that > > completes within the timeout (but I did not try for very long to debug > > this). > > > > Best regards, > > > > Markus > > > > > > > > > > On 23/04/18 06:41, PWN wrote: > > > >> If one knows the Q code (or URI) for an entity on Wikidata, how can one > >> find the Dbpedia Id and the information linked to it? > >> Thank you. > >> > >> Sent from my iPad > >> _______________________________________________ > >> 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 > > > > > > > -- > > -- > - Scott MacLeod - Founder & President > - World University and School > - http://worlduniversityandschool.org > > - 415 480 4577 > - http://scottmacleod.com > > > - CC World University and School - like CC Wikipedia with best STEM-centric > CC OpenCourseWare - incorporated as a nonprofit university and school in > California, and is a U.S. 501 (c) (3) tax-exempt educational organization. > > > IMPORTANT NOTICE: This transmission and any attachments are intended only > for the use of the individual or entity to which they are addressed and may > contain information that is privileged, confidential, or exempt from > disclosure under applicable federal or state laws. If the reader of this > transmission is not the intended recipient, you are hereby notified that > any use, dissemination, distribution, or copying of this communication is > strictly prohibited. If you have received this transmission in error, > please notify me immediately by email or telephone. > > World University and School is sending you this because of your interest in > free, online, higher education. If you don't want to receive these, please > reply with 'unsubscribe' in the body of the email, leaving the subject line > intact. Thank you. > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: <https://lists.wikimedia.org/pipermail/wikidata/ > attachments/20180429/a0648368/attachment-0001.html> > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > Wikidata mailing list > Wikidata@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikidata > > > ------------------------------ > > End of Wikidata Digest, Vol 77, Issue 18 > **************************************** >
_______________________________________________ Wikidata mailing list Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata