BioHackathon-RDF
提供:TogoWiki
(版間での差分)
(→SPARQL queries) |
(→SPARQL queries) |
||
40行: | 40行: | ||
?geo vcard:longitude ?lon . | ?geo vcard:longitude ?lon . | ||
} | } | ||
+ | |||
* 参加者一覧(参加回数順)[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] |
2017年9月3日 (日) 13:06時点における版
BioHackathon LOD
SPARQL queries
- 2011年開催のBioHackathonの情報
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 . }
- 参加者一覧(参加回数順)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)