BioHackathon-RDF

提供:TogoWiki

(版間での差分)
移動: 案内, 検索
(SPARQL queries)
(RDF)
 
(間の80版分が非表示)
1行: 1行:
-
[http://ep.dbcls.jp/sparql71tmp test endpoint]
+
== RDF ==
-
[http://wiki.lifesciencedb.jp/mw/images/9/9a/BH10thAnniv.pdf グラフ構造]
+
* [http://biohackathon.org/10years 本番サイト] TODO: ほんとは stanza を http://db-dev.jpostdb.org/ts/stanza/ からこちらのサイトにコピーすべき → 2017/10/3 done (片山・守屋)
-
== SPARQL queries ==
+
* [http://biohackathon.org/sparql 本番endpoint]
 +
 
 +
* [http://ep.dbcls.jp/sparql71tmp test endpoint]
 +
 
 +
* [http://wiki.lifesciencedb.jp/mw/images/9/9a/BH10thAnniv.pdf グラフ構造] (TripleDataProfilerの結果を加工して、GraphVizで描画したもの)
 +
 
 +
[http://wiki.lifesciencedb.jp/mw/images/9/9b/BHRDF2017.png.001.png scheme]
 +
 
 +
== SPARQL ==
 +
==== 一覧表示 ====
 +
* 開催地一覧 [http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0A%0ASELECT+%3Fyear+%3Fregion+%3Flocality+%3Fplace_label+%3Fdays+%3Fbegin_date+%3Fend_date+%3Flocation_label+%3Flongitude+%3Flatitude%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++%3Fbh+a+event%3AEvent+%3B%0A++++++time%3Ayear+%3Fyear+%3B%0A++++++event%3Atime+%3Finterval+%3B%0A++++++event%3Aplace+%3Fplace+.%0A++%3Fplace+rdfs%3Alabel+%3Fplace_label+%3B%0A++++++vcard%3AhasGeo+%3Fgeo+%3B%0A++++++vcard%3Aaddress+%3Flocation+.%0A++%3Flocation+rdfs%3Alabel+%3Flocation_label+%3B%0A++++++vcard%3Alocality+%3Flocality+%3B%0A++++++vcard%3Aregion+%3Fregion+.%0A++%3Finterval+time%3AhasBeginning%2Ftime%3AinXSDDate+%3Fbegin_date+%3B%0A++++++++++++time%3AhasEnd%2Ftime%3AinXSDDate+%3Fend_date+.%0A++%3Fgeo+vcard%3Alongitude+%3Flongitude+%3B%0A+++++++vcard%3Alatitude+%3Flatitude+.%0A++BIND%28%28day%28%3Fend_date%29+-+day%28%3Fbegin_date%29+%2B+1%29+AS+%3Fdays%29%0A%7D+%0AORDER+BY+%3Fyear%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
 +
 
 +
* 各回の参加者数、そのうち海外からの参加者数、計何カ国が参加したかなど [http://sparql-support.dbcls.jp/?query=PREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+bho%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fontology%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0A%0ASELECT+%3Fyear+%3Fregion+%3Fdays+%3Fcountries+%28COUNT%28%3Fagent%29+AS+%3Fparticipants%29+%3Fabroad+%3Fdomestic+%28%28%3Fparticipants+-+%3Fdomestic+-+%3Fabroad%29+AS+%3Fundefined%29+%3Flogo%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++%3Fbh+a+event%3AEvent+%3B%0A++++++time%3Ayear+%3Fyear+%3B%0A++++++event%3Atime+%3Finterval+%3B%0A++++++foaf%3Adepiction+%3Flogo+%3B%0A++++++event%3Aagent+%3Fagent+%3B%0A++++++event%3Aplace%2Fvcard%3Aaddress%2Fvcard%3Aregion+%3Fregion+.%0A++%3Finterval+time%3AhasBeginning%2Ftime%3AinXSDDate+%3Fbegin_date+%3B%0A++++++++++++time%3AhasEnd%2Ftime%3AinXSDDate+%3Fend_date+.%0A++BIND%28%28day%28%3Fend_date%29+-+day%28%3Fbegin_date%29+%2B+1%29+AS+%3Fdays%29%0A++%7B%0A++++++SELECT+%3Fbh+%28COUNT%28%3Fagent%29+AS+%3Fdomestic%29%0A++++++WHERE+%7B%0A%09++%3Fbh+event%3Aagent+%3Fagent+.%0A%09++%3Fagent+bho%3Aaffiliation%2Fvcard%3Acountry-name+%3Fcountry_name+.%0A%09++FILTER%28%3Fcountry_name+%3D+%22Japan%22%29%0A++++++%7D%0A++%7D%0A++%7B%0A++++++SELECT+%3Fbh+%28COUNT%28%3Fagent%29+AS+%3Fabroad%29%0A++++++WHERE+%7B%0A%09++%3Fbh+event%3Aagent+%3Fagent+.%0A%09++%3Fagent+bho%3Aaffiliation%2Fvcard%3Acountry-name+%3Fcountry_name+.%0A%09++FILTER%28%3Fcountry_name+%21%3D+%22Japan%22+%26%26+strlen%28%3Fcountry_name%29+%3E+0%29%0A++++++%7D%0A++%7D%0A++%7B%0A++++++SELECT+%3Fbh+%28COUNT%28DISTINCT+%3Fcountry_name%29+AS+%3Fcountries%29%0A++++++WHERE+%7B%0A%09++%3Fbh+event%3Aagent%2Fbho%3Aaffiliation%2Fvcard%3Acountry-name+%3Fcountry_name+.%0A%09++FILTER%28strlen%28%3Fcountry_name%29+%3E+0%29%0A++++++%7D%0A++%7D%0A%7D+%0AORDER+BY+%3Fyear%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
 +
 
 +
* どのような組織から参加があったか [http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+bho%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fontology%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0A%0ASELECT+%3Faffiliation+%3Flabel+%3Fcountry+%3Fyears+%28COUNT%28%3Fagent%29+AS+%3Fcount%29%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++%3Fbh+a+event%3AEvent+%3B%0A++++++event%3Aagent+%3Fagent+.%0A++%3Fagent+bho%3Aaffiliation+%3Faffiliation+.%0A++%3Faffiliation+rdfs%3Alabel+%3Flabel+%3B%0A++++++vcard%3Acountry-name+%3Fcountry+.%0A++FILTER%28lang%28%3Flabel%29+%3D+%22en%22%29%0A++%7B%0A++++++SELECT+%3Faffiliation+%28GROUP_CONCAT%28DISTINCT+%3Fyear+%3B+SEPARATOR+%3D+%22%2C%22%29+AS+%3Fyears%29%0A++++++WHERE+%7B%0A%09++%3Fevent+event%3Aagent%2Fbho%3Aaffiliation+%3Faffiliation+%3B%0A%09+++++++++time%3Ayear+%3Fyear+.%0A++++++%7D%0A++%7D%0A%7D%0AORDER+BY+%3Fcountry+%3Fyears+DESC%28%3Fcount%29+%3Fname%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
 +
 
 +
 
 +
==== 特定のイベントに関するクエリ ====
* 2011年開催のBioHackathonの情報 [http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0A%0ASELECT+%3Flabel+%28COUNT%28%3Fagent%29+AS+%3Fnumber_of_participants%29+%3Fplace_label+%3Fbegin_date+%3Fend_date+%3Faddress_string+%3Flat+%3Flon%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++%3Fbh+a+event%3AEvent+.%0A++%3Fbh+event%3Aagent+%3Fagent+.%0A++%3Fbh+rdfs%3Alabel+%3Flabel+.%0A++%3Fbh+time%3Ayear+2011+.%0A++%3Fbh+event%3Atime+%3Finterval+.%0A++%3Finterval+time%3AhasBeginning+%3Fbegin+.%0A++%3Fbegin+time%3AinXSDDate+%3Fbegin_date+.%0A++%3Finterval+time%3AhasEnd+%3Fend+.%0A++%3Fend+time%3AinXSDDate+%3Fend_date+.%0A++%3Fbh+event%3Aplace+%3Fplace+.%0A++%3Fplace+rdfs%3Alabel+%3Fplace_label+.%0A++%3Fplace+vcard%3Aaddress+%3Faddress+.%0A++%3Faddress+rdfs%3Alabel+%3Faddress_string+.%0A++%3Fplace+vcard%3AhasGeo+%3Fgeo+.%0A++%3Fgeo+vcard%3Alatitude+%3Flat+.%0A++%3Fgeo+vcard%3Alongitude+%3Flon+.%0A%7D+%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
* 2011年開催のBioHackathonの情報 [http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0A%0ASELECT+%3Flabel+%28COUNT%28%3Fagent%29+AS+%3Fnumber_of_participants%29+%3Fplace_label+%3Fbegin_date+%3Fend_date+%3Faddress_string+%3Flat+%3Flon%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++%3Fbh+a+event%3AEvent+.%0A++%3Fbh+event%3Aagent+%3Fagent+.%0A++%3Fbh+rdfs%3Alabel+%3Flabel+.%0A++%3Fbh+time%3Ayear+2011+.%0A++%3Fbh+event%3Atime+%3Finterval+.%0A++%3Finterval+time%3AhasBeginning+%3Fbegin+.%0A++%3Fbegin+time%3AinXSDDate+%3Fbegin_date+.%0A++%3Finterval+time%3AhasEnd+%3Fend+.%0A++%3Fend+time%3AinXSDDate+%3Fend_date+.%0A++%3Fbh+event%3Aplace+%3Fplace+.%0A++%3Fplace+rdfs%3Alabel+%3Fplace_label+.%0A++%3Fplace+vcard%3Aaddress+%3Faddress+.%0A++%3Faddress+rdfs%3Alabel+%3Faddress_string+.%0A++%3Fplace+vcard%3AhasGeo+%3Fgeo+.%0A++%3Fgeo+vcard%3Alatitude+%3Flat+.%0A++%3Fgeo+vcard%3Alongitude+%3Flon+.%0A%7D+%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
41行: 58行:
 +
* 2011年の参加者一覧 (他の年に参加しているか等も含めて) [http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+bho%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fontology%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0A%0ASELECT+%3Fperson+%3Fname+%3Fcountry+%3Faffiliations+%28GROUP_CONCAT%28%3Fyear+%3B+SEPARATOR+%3D+%22%2C%22%29+AS+%3Fyears%29%0AWHERE+%7B%0A++++%7B%0A++++++++SELECT+%3Fperson+%3Fname+%3Fcountry+%28GROUP_CONCAT%28%3Faffiliation+%3B+SEPARATOR+%3D+%22%2C%22%29+AS+%3Faffiliations%29%0A++++++++FROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0A++++++++WHERE+%7B%0A++++++++++++%3Fevent+a+event%3AEvent+%3B%0A+++++++++++++++++++time%3Ayear+2011+%3B%0A+++++++++++++++++++event%3Aagent+%3Fagent+.%0A++++++++++++%3Fagent+rdfs%3AseeAlso+%3Fperson+%3B%0A%09%09+++bho%3Aaffiliation+%3Faffil+.+++%0A++++++++++++%3Fperson+foaf%3Aname+%3Fname+.%0A++++++++++++OPTIONAL+%7B%0A++++++++++++++++%3Faffil+rdfs%3Alabel+%3Faffiliation+%3B%0A%09%09+++++++vcard%3Acountry-name+%3Fcountry+.%0A++++++++++++%7D%0A%09++++FILTER%28%21bound%28%3Faffiliation%29+%7C%7C+lang%28%3Faffiliation%29+%3D+%22en%22%29%0A++++++++%7D%0A++++%7D%0A++++%3Fevent+a+event%3AEvent+%3B%0A+++++++++++time%3Ayear+%3Fyear+%3B%0A+++++++++++event%3Aagent%2Frdfs%3AseeAlso+%3Fperson+.%0A%7D%0AORDER+BY+%3Fcountry+%3Faffiliations+%3Fyears+%3Fname%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
 +
 +
* 2011年の参加者の所属を集計 [http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+bho%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fontology%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0A%0ASELECT+%28COUNT%28%3Fagent%29+AS+%3Fcount%29+%3Fcountry+%3Faffiliations%0A%7B%0A++++SELECT+%3Fagent+%3Fcountry+%28GROUP_CONCAT%28%3Faffiliation+%3B+SEPARATOR+%3D+%22%2C+%22%29+AS+%3Faffiliations%29%0A++++FROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0A++++WHERE+%7B%0A++++++++%3Fbh+a+event%3AEvent+%3B%0A++++++++++++time%3Ayear+2011+%3B%0A++++++++++++event%3Aagent+%3Fagent+.%0A++++++++%3Fagent+bho%3Aaffiliation+%3Faffi+.%0A++++++++OPTIONAL+%7B%0A++++++++++++%3Faffi+rdfs%3Alabel+%3Faffiliation+%3B%0A++++++++++++vcard%3Acountry-name+%3Fcountry+.%0A++++++++%7D%0A++++++++FILTER%28%21bound%28%3Faffiliation%29+%7C%7C+lang%28%3Faffiliation%29+%3D+%22en%22%29%0A++++%7D%0A%7D%0AORDER+BY+%3Fcountry+%3Faffiliations%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
 +
 +
* 2011年の参加国を集計 [http://sparql-support.dbcls.jp/?query=PREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+bho%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fontology%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0A%0ASELECT+%3Fcountry+%28COUNT%28%3Fcountry%29+AS+%3Fcount%29%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++%3Fbh+a+event%3AEvent+%3B%0A++++++time%3Ayear+2011+%3B%0A++++++event%3Aagent+%3Fagent+.%0A++OPTIONAL+%7B%0A++++%3Fagent+bho%3Aaffiliation%2Fvcard%3Acountry-name+%3Fcountry_name+.%0A++%7D%0A++BIND%28IF%28bound%28%3Fcountry_name%29%2C+%3Fcountry_name%2C+%22-undefined-%22%29+AS+%3Fcountry%29%0A%7D%0AORDER+BY+DESC%28%3Fcount%29%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
 +
 +
 +
==== 参加者に関するクエリ ====
* 参加者一覧(参加回数順)[http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0A%0ASELECT+%3Fperson+%3Fname+%28COUNT%28%3Fbh%29+AS+%3Fbh%29+%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++%3Fbh+event%3Aagent+%3Fparticipant+.%0A++%3Fparticipant+rdfs%3AseeAlso+%3Fperson+.%0A++%3Fperson+foaf%3Aname+%3Fname+.%0A%7D+ORDER+BY+DESC+%28%3Fbh%29%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
* 参加者一覧(参加回数順)[http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0A%0ASELECT+%3Fperson+%3Fname+%28COUNT%28%3Fbh%29+AS+%3Fbh%29+%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++%3Fbh+event%3Aagent+%3Fparticipant+.%0A++%3Fparticipant+rdfs%3AseeAlso+%3Fperson+.%0A++%3Fperson+foaf%3Aname+%3Fname+.%0A%7D+ORDER+BY+DESC+%28%3Fbh%29%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
65行: 90行:
-
* 2017年の参加国一覧 [http://sparql-support.dbcls.jp/?query=PREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+bho%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fontology%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0A%0ASELECT+%3Fcountry+%28COUNT%28%3Fcountry%29+AS+%3Fcount%29%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++%3Fbh+a+event%3AEvent+%3B%0A++++++time%3Ayear+2017+%3B%0A++++++event%3Aagent+%3Fagent+.%0A++OPTIONAL+%7B%0A++++%3Fagent+bho%3Aaffiliation%2Fvcard%3Acountry-name+%3Fcountry_name+.%0A++%7D%0A++BIND%28IF%28bound%28%3Fcountry_name%29%2C+%3Fcountry_name%2C+%22-undefined-%22%29+AS+%3Fcountry%29%0A%7D%0AORDER+BY+DESC%28%3Fcount%29%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
+
* 参加者一覧 (with 国, 参加した年) [http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+bho%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fontology%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0A%0ASELECT+%3Fperson+%3Fname+%3Fcountries+%28GROUP_CONCAT%28%3Fyear+%3B+SEPARATOR+%3D+%22%2C%22%29+AS+%3Fyears%29%0AWHERE+%7B%0A++++%7B%0A++++++++SELECT+%3Fperson+%3Fname+%28GROUP_CONCAT%28DISTINCT+%3Fcountry+%3B+SEPARATOR+%3D+%22%2C%22%29+AS+%3Fcountries%29%0A++++++++FROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0A++++++++WHERE+%7B%0A++++++++++++%3Fevent+a+event%3AEvent+%3B%0A+++++++++++++++++++event%3Aagent+%3Fagent+.%0A++++++++++++%3Fagent+rdfs%3AseeAlso+%3Fperson+.%0A++++++++++++%3Fperson+foaf%3Aname+%3Fname+.%0A++++++++++++OPTIONAL+%7B%0A++++++++++++++++%3Fagent+bho%3Aaffiliation%2Fvcard%3Acountry-name+%3Fcountry_name+.%0A++++++++++++%7D%0A++++++++++++BIND%28IF%28bound%28%3Fcountry_name%29%2C+%3Fcountry_name%2C+%22undef%22%29+AS+%3Fcountry%29%0A++++++++%7D%0A++++%7D%0A++++%3Fevent+a+event%3AEvent+%3B%0A+++++++++++time%3Ayear+%3Fyear+%3B%0A+++++++++++event%3Aagent%2Frdfs%3AseeAlso+%3Fperson+.%0A%7D%0AORDER+BY+%3Fyears+%3Fcountries+%3Fname%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
 +
 
 +
* 特定の組織からの参加履歴 (例: SIB) [http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+bho%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fontology%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0A%0ASELECT+%3Fyear+%28GROUP_CONCAT%28%3Fname+%3B+SEPARATOR%3D%22%2C+%22%29+AS+%3Fnames%29%0A%7B%0A++++SELECT+%3Fyear+%3Fname%0A++++FROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0A++++WHERE+%7B%0A%09%3Fevent+a+event%3AEvent+%3B%0A+++++++++++++++time%3Ayear+%3Fyear+%3B%0A%09+++++++event%3Aagent+%3Fagent+.%0A%09%3Fagent+bho%3Aaffiliation+%3Chttp%3A%2F%2Fpurl.jp%2Fbi0%2F10%2Fbh%2Faffiliation%2F15%3E+%3B%0A+++++++++++++++rdfs%3AseeAlso%2Ffoaf%3Aname+%3Fname+.%0A++++%7D%0A++++ORDER+BY+%3Fname%0A%7D%0AORDER+BY+%3Fyear%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
 +
 
 +
* 特定の人の参加履歴 (例: Rutger) [http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+bho%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fontology%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0A%0ASELECT+%3Fyear+%3Fname+%3Fcounty+%3Flabel%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++++%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fperson%2F37%3E+%5Erdfs%3AseeAlso+%3Fagent+%3B%0A++++++++foaf%3Aname+%3Fname+.%0A++++%3Fbh+event%3Aagent+%3Fagent+%3B%0A++++++++time%3Ayear+%3Fyear+.%0A++++%3Fagent+bho%3Aaffiliation+%3Faffiliation+.%0A++++%3Faffiliation+vcard%3Acountry-name+%3Fcounty+%3B%0A++++++++rdfs%3Alabel+%3Flabel+.%0A%7D%0AORDER+BY+%3Fyear%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
 +
 
 +
 
 +
==== その他のクエリ ====
 +
* ボトル一覧 [http://sparql-support.dbcls.jp/?query=PREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX+skos%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2004%2F02%2Fskos%2Fcore%23%3E%0APREFIX+bho%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fontology%23%3E%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0A%0ASELECT+%3Fcountry+%3Fcategory+%3Fdescription+%3Flabel+%3Fpercentage+%3Fpicture%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++++%3Fbottle+a+bho%3ABottle+%3B%0A++++++++bho%3Abeverage_country+%3Fcountry+%3B%0A++++++++bho%3Abeverage_category+%3Fcategory+%3B%0A++++++++skos%3Adescription+%3Fdescription+%3B%0A++++++++rdfs%3Alabel+%3Flabel+%3B%0A++++++++foaf%3Adepiction+%3Fpicture+.%0A++++OPTIONAL+%7B%0A++++++++%3Fbottle+bho%3Apercentage+%3Fpercentage+.%0A++++%7D%0A%7D%0AORDER+BY+%3Fcountry+%3Fcategory+%3Flabel%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
-
* BioHackathon一覧 [http://sparql-support.dbcls.jp/?query=PREFIX+time%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Ftime%23%3E%0APREFIX+bho%3A+%3Chttp%3A%2F%2Fpurl.jp%2Fbio%2F10%2Fbh%2Fontology%23%3E%0APREFIX+vcard%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2006%2Fvcard%2Fns%23%3E%0APREFIX+event%3A+%3Chttp%3A%2F%2Fpurl.org%2FNET%2Fc4dm%2Fevent.owl%23%3E%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0A%0ASELECT+%3Fyear+%3Fregion+%3Fdays+%3Fparticipants+%3Fabroad+%3Fdomestic+%3Fundefined+%3Fcountries+%3Flogo%0AFROM+%3Chttp%3A%2F%2Fbiohackathon.org%2F%3E%0AWHERE+%7B%0A++%3Fbh+a+event%3AEvent+%3B%0A++++++time%3Ayear+%3Fyear+%3B%0A++++++event%3Atime+%3Finterval+%3B%0A++++++foaf%3Adepiction+%3Flogo+%3B%0A++++++event%3Aplace%2Fvcard%3Aaddress%2Fvcard%3Aregion+%3Fregion+.%0A++%3Finterval+time%3AhasBeginning%2Ftime%3AinXSDDate+%3Fbegin_date+%3B%0A++++++++++++time%3AhasEnd%2Ftime%3AinXSDDate+%3Fend_date+.%0A++BIND%28%28day%28%3Fend_date%29+-+day%28%3Fbegin_date%29+%2B+1%29+AS+%3Fdays%29%0A++%7B%0A++++++SELECT+%3Fbh+%28COUNT%28%3Fagent%29+AS+%3Fparticipants%29%0A++++++WHERE+%7B%0A%09++%3Fbh+event%3Aagent+%3Fagent+.%0A++++++%7D%0A++%7D%0A++%7B%0A++++++SELECT+%3Fbh+%28COUNT%28%3Fagent%29+AS+%3Fdomestic%29%0A++++++WHERE+%7B%0A%09++%3Fbh+event%3Aagent+%3Fagent+.%0A%09++%3Fagent+bho%3Aaffiliation%2Fvcard%3Acountry-name+%3Fcountry_name+.%0A%09++FILTER%28%3Fcountry_name+%3D+%22Japan%22%29%0A++++++%7D%0A++%7D%0A++%7B%0A++++++SELECT+%3Fbh+%28COUNT%28%3Fagent%29+AS+%3Fabroad%29%0A++++++WHERE+%7B%0A%09++%3Fbh+event%3Aagent+%3Fagent+.%0A%09++%3Fagent+bho%3Aaffiliation%2Fvcard%3Acountry-name+%3Fcountry_name+.%0A%09++FILTER%28%3Fcountry_name+%21%3D+%22Japan%22+%26%26+strlen%28%3Fcountry_name%29+%3E+0%29%0A++++++%7D%0A++%7D%0A++BIND%28%28%3Fparticipants+-+%3Fdomestic+-+%3Fabroad%29+AS+%3Fundefined%29%0A++%7B%0A++++++SELECT+%3Fbh+%28COUNT%28DISTINCT+%3Fcountry_name%29+AS+%3Fcountries%29%0A++++++WHERE+%7B%0A%09++%3Fbh+event%3Aagent%2Fbho%3Aaffiliation%2Fvcard%3Acountry-name+%3Fcountry_name+.%0A%09++FILTER%28strlen%28%3Fcountry_name%29+%3E+0%29%0A++++++%7D%0A++%7D%0A%7D+%0AORDER+BY+%3Fyear%0A%0A&endpoint=http%3A%2F%2Fep.dbcls.jp%2Fsparql71tmp exec]
+
== Stanza ==
-
参加者数、そのうち海外からの参加者数、計何カ国かなど
+
* イベント情報
 +
** http://db-dev.jpostdb.org/ts/stanza/bh4/help.html
 +
* 参加者リスト + ソート
 +
** http://db-dev.jpostdb.org/ts/stanza/bh2/help.html
 +
* 年ごとの参加回数stanza
 +
** http://db-dev.jpostdb.org/ts/stanza/bh/help.html
 +
* word cloud + アニメーション
 +
** http://db-dev.jpostdb.org/ts/stanza/bh3/help.html

2017年10月3日 (火) 07:34時点における最新版

目次

RDF

  • グラフ構造 (TripleDataProfilerの結果を加工して、GraphVizで描画したもの)

scheme

SPARQL

一覧表示

  • 開催地一覧 exec
  • 各回の参加者数、そのうち海外からの参加者数、計何カ国が参加したかなど exec
  • どのような組織から参加があったか exec


特定のイベントに関するクエリ

  • 2011年開催のBioHackathonの情報 exec
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix owl: <http://www.w3.org/2002/07/owl#>
prefix xsd: <http://www.w3.org/2001/XMLSchema#>
prefix bh: <http://purl.jp/bio/10/bh/>
prefix bho: <http://purl.jp/bio/10/bh/ontology#>
prefix event: <http://purl.org/NET/c4dm/event.owl#>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix vcard: <http://www.w3.org/2006/vcard/ns#>
prefix time: <http://www.w3.org/2006/time#>
prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
prefix skos: <http://www.w3.org/2004/02/skos/core#>

SELECT ?label (COUNT(?agent) AS ?number_of_participants) ?place_label ?begin_date ?end_date ?address_string ?lat ?lon
FROM <http://biohackathon.org/>
WHERE {
  ?bh a event:Event .
  ?bh event:agent ?agent .
  ?bh rdfs:label ?label .
  ?bh time:year 2011 .
  ?bh event:time ?interval .
  ?interval time:hasBeginning ?begin .
  ?begin time:inXSDDate ?begin_date .
  ?interval time:hasEnd ?end .
  ?end time:inXSDDate ?end_date .
  ?bh event:place ?place .
  ?place rdfs:label ?place_label .
  ?place vcard:address ?address .
  ?address rdfs:label ?address_string .
  ?place vcard:hasGeo ?geo .
  ?geo vcard:latitude ?lat .
  ?geo vcard:longitude ?lon .
} 


  • 2011年の参加者一覧 (他の年に参加しているか等も含めて) exec
  • 2011年の参加者の所属を集計 exec
  • 2011年の参加国を集計 exec


参加者に関するクエリ

  • 参加者一覧(参加回数順)exec
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
prefix owl: <http://www.w3.org/2002/07/owl#>
prefix xsd: <http://www.w3.org/2001/XMLSchema#>
prefix bh: <http://purl.jp/bio/10/bh/>
prefix bho: <http://purl.jp/bio/10/bh/ontology#>
prefix event: <http://purl.org/NET/c4dm/event.owl#>
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix foaf: <http://xmlns.com/foaf/0.1/>
prefix vcard: <http://www.w3.org/2006/vcard/ns#>
prefix time: <http://www.w3.org/2006/time#>
prefix geo: <http://www.w3.org/2003/01/geo/wgs84_pos#>
prefix skos: <http://www.w3.org/2004/02/skos/core#>

SELECT ?person ?name (COUNT(?bh) AS ?bh) 
FROM <http://biohackathon.org/>
WHERE {
  ?bh event:agent ?participant .
  ?participant rdfs:seeAlso ?person .
  ?person foaf:name ?name .
} ORDER BY DESC (?bh)


  • 参加者一覧 (with 国, 参加した年) exec
  • 特定の組織からの参加履歴 (例: SIB) exec
  • 特定の人の参加履歴 (例: Rutger) exec


その他のクエリ

  • ボトル一覧 exec


Stanza

個人用ツール