Query #1: 台灣國寶級植物——台灣一葉蘭的地理分布為何？

What are the geographical distributions of the Taiwan national treasure, the Pleione Formosana?

 
#check geo distribution of the Pleione Formosana at ODW (http://data.odw.tw/sparql)
#PlaceR = Place in Refined Version; PlaceD = Place in DC 15 Version
#The current EOL mapping is only for data in 3 projects (project:q21095859, project:q21095858, and project:q21095857)

SELECT ?PlaceLabel ?PlaceR ?PlaceD
WHERE { ?s txn:hasEOLPage eol:1134120; dct:requires ?event. 
              OPTIONAL { ?event gn:parentFeature ?PlaceR. ?PlaceR rdfs:label ?PlaceLabel. }
              OPTIONAL { ?s dc:coverage ?PlaceD. } }
ORDER by DESC(?PlaceR)
 

Query #2: 台灣國寶級植物——台灣一葉蘭的人時空資訊為何？

What  are Time, Place, and People information for the Pleione Formosana?

 
#check Time, Place, and People information for the Pleione Formosana at ODW (http://data.odw.tw/sparql)

SELECT ?s ?TimeR ?TimeD ?PlaceR ?PlaceLabel ?PeopleD1 ?PeopleD2
WHERE { ?s txn:hasEOLPage eol:1134120; dct:requires ?event. 
              OPTIONAL { ?event gn:parentFeature ?PlaceR. ?PlaceR rdfs:label ?PlaceLabel}
              OPTIONAL { ?event dwc:eventDate ?TimeR }
              OPTIONAL { ?s dc:date ?TimeD }
              OPTIONAL { ?s dc:creator ?PeopleD1; dc:contributor ?PeopleD2.} }
ORDER by ?s
 

Query #3: 表1所列的12項「開放資料連結」知識庫的個體量與三元組量為何?

How many entities and triples are for the LOD knowledge bases listed in the Table 1?

    表1: 五項全球「開放資料連結」跨領域知識庫與七項專業「開放資料連結」知識庫基本資訊 (2016/11/06)

LOD 知識庫

起始

組織

資料性質

主要來源

個體量 (Entity)

三元組量 (Triples)

更新頻率 (Update)

 

專家建構

OpenCyc

2008

商業

跨領域

自建

41,029

2,412,520

超過一年未更新

Getty AAT

2014

商業

文化藝術

自建

45,327

13,259,890

LOD後一年3-5次

Getty TGN

2014

商業

地名

自建

2,495,100

204,614,290

Ordnance Survey

2010

政府

地理資訊

自建 (二者視為同一專業知識庫)

2,938,707

58,377,209

視需求

Open Names

2015

政府

地名

925,157

21,360,688

一年兩次

混合

EOL (TraitBank)

2014

學會

生物

整合專業資料庫/資料協作為輔

10,753,384

359,292,712

統計更新約一週

 

協同合作

Freebase

2008

商業

跨領域

Wikipedia

49,947,799

3,124,791,156

2015關閉

YAGO

2007

大學

跨領域

Wikipedia

5,130,031

1,001,461,786

超過一年

DBpedia 

2007

大學

跨領域

Wikipedia

5,109,890

402,086,316

約一年/ 部分即時

DBpediaPlace

2007

大學

地名

Wikipedia

816,252

53,895,946

Wikidata

2012

NGO

跨領域

Wikipedia

19,367,201

1,371,170,022

即時

LinkedGeoData

2010

大學

地理資訊

OpenStreetMap

> 3 billion

1,384,887,500

約一年 / 即時對應Sparqlify 建置中

GeoNames

2010

NGO

地名

資料協作為主/ 整合地名資料庫為輔

>6.2 million

93,896,732

即時

#check all entities & triples at Getty http://vocab.getty.edu/sparql 

select ?s ?EntityNo ?TripleNo
where { ?s void:entities ?EntityNo . 
Optional {?s void:triples ?TripleNo . } }
 
#count all entities at Ordnance Survey (http://data.ordnancesurvey.co.uk/datasets/os-linked-data/explorer/sparql)
#count all entities at Open Names (http://data.ordnancesurvey.co.uk/datasets/opennames/explorer/sparql)

select (count(distinct ?s) as ?EntityNo) 
where { ?s a [] }
 
#count all entities at YAGO (https://linkeddata1.calcul.u-psud.fr/sparql) 
#count all entities at at DBpedia (https://dbpedia.org/sparql) 

select (count(distinct ?s) as ?EntityNo) 
where { ?s a owl:Thing }
 
#count all entities for DBpediaPlace (https://dbpedia.org/sparql) 

select (count(distinct ?s) as ?PlaceNo)
where {?s a dbo:Place }
 
#count all entities at Wikidata (https://query.wikidata.org/)

select count(distinct ?s) as ?EntityNo)  
where { ?s wdt:P31 ?o }
 
#count all triples at most KGs

select (count(*) as ?TripleNo) 
where { ?s ?p ?o }
 
#count all triples for DBpediaPlace (https://dbpedia.org/sparql) 

select (count(*) as ?TripleNo) 
where { ?s ?p ?o . 
?s a dbo:Place . }
 

Query #4: 採集於大同鄉的台灣一葉蘭標本物件有那些，採集時間為何?

What are the Pleione Formosana specimen collected in Datong Xiang (gns:1667637)?

 
#check the Pleione Formosana specimens collected in Datong Xiang (gns:1667637), and list them by time orders.

SELECT ?s ?time ?timeNote
WHERE {?s txn:hasEOLPage eol:1134120; dct:requires ?event. 
       OPTIONAL { ?event gn:parentFeature gns:1667637} 
       OPTIONAL { ?event dwc:eventDate ?time; skos:editorialNote ?timeNote} }

ORDER by DESC(?time)
 

Query #5: 西元2000年之前的台灣一葉蘭標本藏品有哪些?

Find all the Pleione Formosana that have been curated before the year 2000 ?

#check the Pleione Formosana that have been curated before the year 2000

SELECT ?s ?time 
WHERE { ?s txn:hasEOLPage eol:1134120 ; dct:requires ?event.
OPTIONAL { ?event dwc:eventDate ?time. }
FILTER ( ?time <= xsd:dateTime('2000-01-01T00:00:00Z') )
}
ORDER by ?time
 

Query #6: "清末民初"藏品有哪些? 他們如何藉由 wikidata 再現時間語意?

#check collections which belong to the end of Qing dynasty and the start of Minguo calendar through wikidata IDs

SELECT ?s ?TimeR1 ?TimeR2
WHERE { ?s dc:date ?o; dct:requires ?event. 
   OPTIONAL { ?event voc:lastIntervalOf ?TimeR1 }
   OPTIONAL { ?event voc:initialIntervalOf ?TimeR2 }
   FILTER regex(STR(?o), "清末民初" ) }
 

Query #7: "初期"或"初年"的時間描述有哪些?

#check terms used which are belong to the initial interval Of sometimes

SELECT distinct ?time ?timeLabel
WHERE { ?s voc:initialIntervalOf ?time. 
   OPTIONAL {?time rdfs:label ?timeLabel } }