Fantastic Sebastian - thanks once again for all your help. I will definitely
check out the other sites that you suggest.
Best wishes,
Chris
-----Original Message-----
From: Sebastian Hellmann <[email protected]>
Date: Wed, 15 Sep 2010 09:45:01
To: Christopher Kelly<[email protected]>
Cc: <[email protected]>
Subject: Re: [Dbpedia-discussion] Simple Infobox_Disease query
Hello Christopher,
I created a site here:
http://wiki.dbpedia.org/GetHelp
It is quite new so you haven't found it before and nobody can blame you
for asking the list.
Could you do me a favor and post your question on semanticoverflow.com
or stackoverflow.com and tag it dbpedia.
(this is not to annoy you but rather a good way that will help others to
find answers and help)
If you do not want to: the answer is to include OPTIONAL {?s
dbpedia2:meshid ?meshid}
Cheers,
Sebastian
Am 14.09.2010 23:32, schrieb Christopher Kelly:
> Ah great - thanks - makes sense. Still learning SPARQL here...apologies.
>
> Just one final question (sorry), if I wanted to adjust your query
> below to display "dbpedia2:meshid" values if a disease has it stored
> (but not to exclude them if it's missing, like I did originally), how
> would I adjust the query?
>
> SELECT count(*) WHERE {
> ?s a <http://dbpedia.org/ontology/Disease>
> }
>
> Thank you once again!
>
> Best wishes,
> Chris
>
>
> On Tue, Sep 14, 2010 at 9:20 PM, Sebastian Hellmann
> <[email protected]
> <mailto:[email protected]>> wrote:
>
> Ah ok, there lies the hare in the pepper.
> The query you assembled gives you all articles using the certain
> infobox AND having the property meshid.
>
> For diseases you could use this:
> SELECT count(*) WHERE {
> ?s a <http://dbpedia.org/ontology/Disease>
> }
> http://mappings.dbpedia.org/index.php/OntologyClass:Disease
>
> http://mappings.dbpedia.org/index.php/Special:WhatLinksHere/OntologyClass:Disease
> (you can register to edit the Wiki)
>
>
> Another way might be to try this tool, we at AKSW created:
> http://hanne.aksw.org
> it will be released in a few days. We are working on some bugs and
> will add some features (such as exporting the sparql query)
> You can try it, if you want, we are creating manual and tutorial
> and bugfixes, so please have patience, All saved concepts will be
> lost, because we have to upgrade it.
> Cheers,
> Sebastian
>
> Am 14.09.2010 21:34, schrieb Christopher Kelly:
>> Thank you very much indeed for your help Kingsley and Sebastian!
>> Very much appreciated.
>>
>> The 4600 quote was found at
>> http://wiki.dbpedia.org/Datasets where it states "The DBpedia
>> knowledge base currently describes more than 3.4 million things,
>> ...including 4,600 diseases...". I presume that the majority of
>> this info is from the wikipedia infoboxes, hence thought this
>> would be a good way of filtering? So I was just trying to get a
>> handle on as much of this as possible for a medical education
>> project (for which this kind of data - linking disease names /
>> mesh / emedicine / wikipedia etc is just ideal!).
>>
>> I wonder if the other 3900 diseases (I'm getting 947 diseases
>> from the "count" query below?) are not from the infoboxes then?
>>
>> Thanks again,
>>
>> Best wishes,
>> Chris
>>
>>
>>
>>
>> On Tue, Sep 14, 2010 at 4:21 PM, Kingsley Idehen
>> <[email protected] <mailto:[email protected]>> wrote:
>>
>> On 9/14/10 1:38 AM, Sebastian Hellmann wrote:
>>> Hi,
>>> the queries seem to be identical, what is the difference?
>>> Using sparql instead of snorql.
>>
>> The point was about using sparql endpoint rather than snorql .
>>
>>
>>> It has a double ?name variable, which doesn't seem to add a lot.
>> Maybe typo, since it was cut and paste once the count exceed
>> the limits claimed etc..
>>
>>
>>> Actually this query brings a little bit more:
>>>
>>> SELECT count(*) WHERE {
>>> ?name dbpedia2:wikiPageUsesTemplate ?infobox .
>>> ?name dbpedia2:meshid ?meshid .
>>> Filter (?infobox IN (
>>> <http://dbpedia.org/resource/Template:Infobox_Disease> ,
>>> <http://dbpedia.org/resource/Template:Infobox_disease> ) ).
>>> }
>> Yes, I did the count before sending the sparql endpoint link,
>> as per comments above.
>>
>>
>> Kingsley
>>
>>>
>>> @Christopher
>>> The problem is that Template: values are stored as the
>>> appear in the Wikipedia page, which has good reasons (once
>>> you normalize them, you can't go back).
>>> So you might need to find more variants.
>>> How did you find the info that there are 4600 infoboxes?
>>> The overview WhatLinksHere also includes all Templates that
>>> redirects to Infobox_disease .
>>>
>>>
>>> Cheers,
>>> Sebastian
>>>
>>>
>>> Am 14.09.2010 03:30, schrieb Kingsley Idehen:
>>>> On 9/13/10 7:01 PM, Christopher Kelly wrote:
>>>>> SELECT ?name ?meshid WHERE {
>>>>> ?name dbpedia2:wikiPageUsesTemplate
>>>>> <http://dbpedia.org/resource/Template:Infobox_Disease> .
>>>>> ?name dbpedia2:meshid ?meshid .
>>>>> }
>>>>
>>>> Try:
>>>>
>>>> http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&should-sponge=&query=PREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+dc%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%3E%0D%0APREFIX+%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0APREFIX+dbpedia2%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fproperty%2F%3E%0D%0APREFIX+dbpedia%3A+%3Chttp%3A%2F%2Fdbpedia.org%2F%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0A%0D%0ASELECT++%3Fname+%3Fname+%3Fmeshid+WHERE+%7B+%0D%0
>>>>
>>>> A+++++%3Fname+dbpedia2%3AwikiPageUsesTemplate+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FTemplate%3AInfobox_Disease%3E+.%0D%0A+++++%3Fname+dbpedia2%3Ameshid+%3Fmeshid+.%0D%0A%7D+&format=text%2Fhtml&debug=on&timeout=
>>>>
>>>> <http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&should-sponge=&query=PREFIX+owl%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0D%0APREFIX+xsd%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+dc%3A+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%3E%0D%0APREFIX+%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2F%3E%0D%0APREFIX+dbpedia2%3A+%3Chttp%3A%2F%2Fdbpedia.org%2Fproperty%2F%3E%0D%0APREFIX+dbpedia%3A+%3Chttp%3A%2F%2Fdbpedia.org%2F%3E%0D%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0D%0A%0D%0ASELECT++%3Fname+%3Fname+%3Fmeshid+WHERE+%7B+%0D%0A+++++%3Fname+dbpedia2%3AwikiPageUsesTemplate+%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FTemplat%0Ae%3AInfobox_Disease%3E+.%0D%0%0AA+++++%3Fname+dbpedia2%3Ameshid+%3Fmeshid+.%0D%0A%7D+&format=text%2Fhtml&debug=on&timeout=>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Regards,
>>>>
>>>> Kingsley Idehen
>>>> President& CEO
>>>> OpenLink Software
>>>> Web:http://www.openlinksw.com
>>>> Weblog:http://www.openlinksw.com/blog/~kidehen
>>>> <http://www.openlinksw.com/blog/%7Ekidehen>
>>>> Twitter/Identi.ca: kidehen
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Start uncovering the many advantages of virtual appliances
>>>> and start using them to simplify application deployment and
>>>> accelerate your shift to cloud computing.
>>>> http://p.sf.net/sfu/novell-sfdev2dev
>>>>
>>>>
>>>>_______________________________________________
>>>> Dbpedia-discussion mailing list
>>>> [email protected]
>>>> <mailto:[email protected]>
>>>> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>>>>
>>>
>>>
>>> --
>>> Dipl. Inf. Sebastian Hellmann
>>> Department of Computer Science, University of Leipzig
>>> Homepage:http://bis.informatik.uni-leipzig.de/SebastianHellmann
>>> Research Group:http://aksw.org
>>>
>>
>>
>> --
>>
>> Regards,
>>
>> Kingsley Idehen
>> President& CEO
>> OpenLink Software
>> Web:http://www.openlinksw.com
>> Weblog:http://www.openlinksw.com/blog/~kidehen
>> <http://www.openlinksw.com/blog/%7Ekidehen>
>> Twitter/Identi.ca: kidehen
>>
>>
>>
>>
>>
>>
>>
>
>
> --
> Dipl. Inf. Sebastian Hellmann
> Department of Computer Science, University of Leipzig
> Homepage:http://bis.informatik.uni-leipzig.de/SebastianHellmann
> Research Group:http://aksw.org
>
>
>
--
Dipl. Inf. Sebastian Hellmann
Department of Computer Science, University of Leipzig
Homepage: http://bis.informatik.uni-leipzig.de/SebastianHellmann
Research Group: http://aksw.org
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
