Category

Query examples

SPARQL query reasoning

EX1. All juvenile fish specimens PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/> SELECT ?s dwc_terms:scientificName ?scientificName FROM <http://data.ascdc.tw/uc/bio/> WHERE { ?s dwc_terms:lifeStage <http://data.ascdc.tw/terms/bio/Juvenile>; <http://purl.org/dc/terms/type> <http://dbpedia.org/resource/Specimen>. ?s dwc_terms:scientificName ?scientificName. } EX2. Fish specimens with body length over 1000 mm PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/> PREFIX ascdc-props_bio: <http://data.ascdc.tw/property/bio/> SELECT ?s dwc_terms:scientificName ?scientificName FROM <http://data.ascdc.tw/uc/bio/> WHERE { ?s ascdc-props_bio:SL|ascdc-props_bio:minSL ?minSL; <http://purl.org/dc/terms/type> <http://dbpedia.org/resource/Specimen>. ?s dwc_terms:scientificName ?scientificName. FILTER ( ?minSL > 1000 ). } EX3. "Stromateidae" as family name PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/> PREFIX txn: <http://lod.taxonconcept.org/ontology/txn.owl#> SELECT ?s dwc_terms:scientificName ?scientificName FROM <http://data.ascdc.tw/uc/bio/> FROM <http://data.ascdc.tw/taicol/> WHERE { ?s dwc_terms:scientificName ?concept. ?concept txn:inFamily <http://data.ascdc.tw/taicol/family/Animalia_Stromateidae>. ?s dwc_terms:scientificName ?scientificName. } EX4. "Formosana" as Specific Epithet PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/> PREFIX txn: <http://lod.taxonconcept.org/ontology/txn.owl#> SELECT ?s dwc_terms:scientificName ?scientificName FROM <http://data.ascdc.tw/uc/bio/> FROM <http://data.ascdc.tw/taicol/> WHERE { ?s dwc_terms:scientificName ?concept. ?concept (txn:synonymName|txn:acceptedName)/txn:specificEpithet 'formosana'. ?s dwc_terms:scientificName ?scientificName. } EX5. Objects with "海馬 seahorse" as Chinese vernacular name? PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/> SELECT ?s dwc_terms:vernacularName ?vernacularName FROM <http://data.ascdc.tw/uc/bio/> WHERE { ?s dwc_terms:vernacularName ?vernacularName. FILTER langMatches(LANG(?vernacularName), 'zh'). FILTER contains(STR(?vernacularName), '海馬'). } EX6. Fish sampled by the bottom trawling method PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/> SELECT ?s dwc_terms:scientificName ?scientificName FROM <http://data.ascdc.tw/uc/bio/> WHERE { ?s dwc_terms:samplingProtocol '底拖網'@zh. ?s dwc_terms:scientificName ?scientificName. }
EX1. Clothing items in red color from the Atayal and Bunun tribes PREFIX schema: <http://schema.org/> PREFIX ascdc-props_anth: <http://data.ascdc.tw/property/anth/> PREFIX AAT: <http://vocab.getty.edu/ontology#> SELECT ?s rdfs:label ?title FROM <http://data.ascdc.tw/uc/anth/ntm/> WHERE { ?s ascdc-props_anth:hasRelatedTribe ?o. ?s schema:color ?o2. ?s AAT:aat2218_used-function_as ?o3. ?s rdfs:label ?title. FILTER (Contains(STR(?o), 'Bunun') || Contains(STR(?o), '布農') || Contains(STR(?o), 'Atayal') || Contains(STR(?o), '泰雅') ) . FILTER (Contains(STR(?o2), '紅色') || Contains(STR(?o2), '300126225')) . FILTER (Contains(STR(?o3), '300266639')) . FILTER (langMatches(Lang(?title), 'zh')) .} EX2. Objects made of wood and decorated with a stripe pattern PREFIX schema: <http://schema.org/> PREFIX ascdc: <http://data.ascdc.tw/property/> SELECT ?s rdfs:label ?title FROM <http://data.ascdc.tw/uc/anth/ntm/> WHERE { ?s ascdc:hasAddedDecoration ?o. ?s schema:material ?o2. ?s rdfs:label ?title. FILTER (Contains(STR(?o), '條紋')) . FILTER (Contains(STR(?o2), '木頭') || Contains(STR(?o2), '300011914')) . FILTER (langMatches(Lang(?title), 'zh')) .} EX3. Objects made of glass and having length over 800 mm. PREFIX schema: <http://schema.org/> PREFIX ascdc: <http://data.ascdc.tw/property/> SELECT ?s rdfs:label ?title FROM <http://data.ascdc.tw/uc/anth/ntm/> WHERE { ?s schema:material ?o. ?s ascdc:length ?length. ?s rdfs:label ?title. FILTER (Contains(STR(?o), '玻璃') || Contains(STR(?o), '300010797')) . FILTER (?length >= 800). FILTER (langMatches(Lang(?title), 'zh')) .} EX4. Finding the subjects of all digitized items PREFIX dcterms: <http://purl.org/dc/terms/> select ?title (COUNT(?title) AS ?count) FROM <http://data.ascdc.tw/uc/anth/ntm/> FROM <http://vocab.getty.edu/aat/> WHERE { { ?s dcterms:subject ?title FILTER langMatches(Lang(?title), 'zh')}} EX5. Objects collected in Taitung PREFIX sam: <http://def.seegrid.csiro.au/isotc211/iso19156/2011/sampling#> SELECT ?s rdfs:label ?title FROM <http://data.ascdc.tw/uc/anth/ntm/> FROM <http://vocab.getty.edu/aat/> WHERE { ?s sam:sampling_location ?o. ?s rdfs:label ?title. FILTER (Contains(STR(?o), '台東') || Contains(STR(?o), '臺東')) . FILTER (langMatches(Lang(?title), 'zh')) .}
EX1. What are the names and number of items contained in each series in the archive of "Chen Cheng-po’s paintings and documents"? prefix locah:<http://data.archiveshub.ac.uk/def/> select * from <http://data.ascdc.tw/archive/ith/ccp/> where{ ?series locah:level <http://data.archiveshub.ac.uk/id/level/series>; rdfs:label ?label; locah:item ?item. } EX2. What are the watercolor paintings of Chen Cheng-po? Please list the title, alternative title and the date of creation of these paintings. prefix locah:<http://data.archiveshub.ac.uk/def/> prefix dcterms:<http://purl.org/dc/terms/> select * from <http://data.ascdc.tw/archive/ith/ccp/> where{ ?item locah:level <http://data.archiveshub.ac.uk/id/level/item>; dcterms:isPartOf <http://data.ascdc.tw/archive/ith/ccp/CCP_02_02>; rdfs:label ?label; dcterms:alternative ?alternative; dc:date ?date. } EX3. Which of Chen’s paintings were created on canvas? What are their titles? prefix locah:<http://data.archiveshub.ac.uk/def/> prefix dcterms:<http://purl.org/dc/terms/> select ?item ?label <http://vocab.getty.edu/aat/300014078> as ?medium from <http://data.ascdc.tw/archive/ith/ccp/> where{ ?item locah:level <http://data.archiveshub.ac.uk/id/level/item>; dcterms:medium <http://vocab.getty.edu/aat/300014078>; rdfs:label ?label. } EX4. Which of Chen’s paintings contain naked women? What are the titles and files of these paintings? prefix locah:<http://data.archiveshub.ac.uk/def/> prefix dcterms:<http://purl.org/dc/terms/> select * from <http://data.ascdc.tw/archive/ith/ccp/> where{ ?item locah:level <http://data.archiveshub.ac.uk/id/level/item>; rdfs:label ?ItemLabel. filter contains(str(?ItemLabel), '裸女'). OPTIONAL{?item dcterms:isPartOf/rdfs:label ?fileLabel} } EX5. Which paintings made during Chen’s studentship at the Tokyo School of Fine Arts depict the landscape of Chiayi? What are their date(s) of creation? prefix locah:<http://data.archiveshub.ac.uk/def/> prefix dcterms:<http://purl.org/dc/terms/> select ?item, ?file, <http://vocab.getty.edu/tgn/7468019> as ?place, ?date from <http://data.ascdc.tw/archive/ith/ccp/> where{ ?item locah:level <http://data.archiveshub.ac.uk/id/level/item>; dcterms:spatial <http://vocab.getty.edu/tgn/7468019>; dc:date ?date. ?item dcterms:isPartOf <http://data.ascdc.tw/archive/ith/ccp/CCP_01_01>. <http://data.ascdc.tw/archive/ith/ccp/CCP_01_01> rdfs:label ?file. filter contains(str(?file), '東京美術學校求學時期油畫作品'). } EX6. What (actual) places does Chen paint? How often do they appear? prefix locah:<http://data.archiveshub.ac.uk/def/> prefix dcterms:<http://purl.org/dc/terms/> select * from <http://data.ascdc.tw/archive/ith/ccp/> where{ ?item locah:level <http://data.archiveshub.ac.uk/id/level/item>; rdfs:label ?label; dcterms:spatial ?place. } EX7. In Chen’s postcard collections, which annual edition(s) of the Taiwan Art Exhibition (Taiten) postcards can be found? Please locate the data about the relevant editions of Taiten in Linked Taiwan Artists. prefix locah:<http://data.archiveshub.ac.uk/def/> prefix dcterms:<http://purl.org/dc/terms/> select * from <http://data.ascdc.tw/archive/ith/ccp/> where{ ?item locah:level <http://data.archiveshub.ac.uk/id/level/item>; rdfs:label ?label; rdfs:seeAlso ?related. filter contains(str(?label), '臺灣美術展覽會'). } EX8. Which Western artists appear in Chen’s scrapbook? Please locate the names of these artists and their data in ULAN. prefix locah:<http://data.archiveshub.ac.uk/def/> prefix dcterms:<http://purl.org/dc/terms/> select ?item, ?person, ?ulan from <http://data.ascdc.tw/archive/ith/ccp/> where{ ?item locah:level <http://data.archiveshub.ac.uk/id/level/item>; dcterms:isPartOf <http://data.ascdc.tw/archive/ith/ccp/CCP_09_01>; dc:subject ?subject. ?subject rdfs:label ?person; owl:sameAs ?ulan. } EX9. In continuation of the question above, what are the nationality of these Western artists appearing in Chen’s scrapbook? PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX dc: <http://purl.org/dc/elements/1.1/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX gvp: <http://vocab.getty.edu/ontology#> SELECT ?item, ?ulan, ?person, ?nationality FROM <http://data.ascdc.tw/archive/ith/ccp/> FROM <http://vocab.getty.edu/ulan/> FROM <http://vocab.getty.edu/aat/> WHERE{ ?item dcterms:isPartOf <http://data.ascdc.tw/archive/ith/ccp/CCP_09_01>; dc:subject/owl:sameAs ?ulan. ?ulan rdfs:label ?person. ?ulan foaf:focus/gvp:nationalityPreferred/skos:prefLabel ?nationality. FILTER langMatches( lang(?person), "en" ). FILTER langMatches( lang(?nationality), "en" ). } EX10. In continuation of the question above, what are the artistic styles of these Western artists appearing in Chen’s scrapbook? PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX dc: <http://purl.org/dc/elements/1.1/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX dbo: <http://dbpedia.org/ontology/> SELECT * FROM <http://data.ascdc.tw/archive/ith/ccp/> FROM <http://dbpedia.org/> WHERE{ ?item dcterms:isPartOf <http://data.ascdc.tw/archive/ith/ccp/CCP_09_01>; dc:subject/rdfs:label ?person; dc:subject/owl:sameAs ?dbpedia. ?dbpedia (dbo:movement|dbo:subject)/rdfs:label ?style. FILTER langMatches( lang(?style), "en" ). } EX11. Which art books appear in Chen’s book collections? Please locate the names of these book titles, their contributors, place of publication, and language in the WorldCat. PREFIX locah:<http://data.archiveshub.ac.uk/def/> PREFIX dcterms:<http://purl.org/dc/terms/> PREFIX library:<http://purl.org/library/> PREFIX schema:<http://schema.org/> SELECT ?item, ?worldcat, ?langauge, ?contributor, ?place FROM <http://data.ascdc.tw/archive/ith/ccp/> FROM <http://www.worldcat.org/> WHERE{ ?item dcterms:isPartOf ?level. FILTER (?level = <http://data.ascdc.tw/archive/ith/ccp/CCP_09_07> || ?level = <http://data.ascdc.tw/archive/ith/ccp/CCP_09_08>). ?item rdfs:seeAlso ?worldcat. ?worldcat schema:inLanguage ?langauge. ?worldcat schema:contributor ?contributor. ?worldcat library:placeOfPublication ?place }
EX1. List the number of works which depict the image of “Vimalakirti and Manjushri” in every region and their structural coordinates on the wall. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> Prefix schema: <http://schema.org/> SELECT ?ProvinceStructure (count(?ProvinceStructure) as ?count) from <http://data.ascdc.tw/buddhist/> where { ?work3 schema:about/rdfs:label ?topic. Filter regex(?topic, "文殊維摩問答"). ?work3 crm:P46i_forms_part_of ?work2. ?work2 rdfs:label ?title2. ?work2 crm:P59_has_section/crm:P87_is_identified_by/rdfs:label ?section. ?work2 crm:P46i_forms_part_of ?work. ?work crm:P12i_was_present_at ?discovery. ?discovery crm:P7_took_place_at ?place. ?place rdfs:label ?placeLabel. Filter regex(?placeLabel, "省"). BIND(CONCAT(?placeLabel, " ", ?section) AS ?ProvinceStructure) }order by ?placeLabel DESC(?count) EX2. List the names of works which depict the image of “Vimalakirti and Manjushri”, with their structural coordinates on the wall, names of the related parent structure, and the locations of those works. PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> Prefix schema: <http://schema.org/> SELECT ?Work ?Section ?Parent ?Place from <http://data.ascdc.tw/buddhist/> WHERE { ?work3 rdfs:label ?Work. ?work3 schema:about/rdfs:label ?topic. Filter regex(?topic, "文殊維摩問答"). ?work3 crm:P46i_forms_part_of ?work2. ?work2 rdfs:label ?Parent. ?work2 crm:P59_has_section/crm:P87_is_identified_by/rdfs:label ?Section. ?work2 crm:P46i_forms_part_of ?work1. ?work1 rdfs:label ?title1. ?work1 crm:P12i_was_present_at ?discovery. ?discovery crm:P7_took_place_at ?pa. ?pa rdfs:label ?Place. Filter regex(?Place, "省"). }
EX1. Which people in the Qing dynasty came from Fujian Province? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?s ascdc:Place ?placeCtvc FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?s ascdc:Place ?placeCtvc . ?s ascdc:dynastyPersonBirth <http://data.ascdc.tw/time/chi/dynasty/031> . ?placeCtvc rdfs:label ?placeZh . FILTER (Contains(STR(?placeZh ), '福建省')) } EX2. Which works did Wang Shi-jen (王世貞), a Ming author who had a good command of both poetry and prose, compose? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> SELECT <http://data.ascdc.tw/dnb/Agent/NO000018406> as ?s dbpedia-owl:created ?works FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { <http://data.ascdc.tw/dnb/Agent/NO000018406> dbpedia-owl:created ?works } ORDER BY ?works EX3. Who took the office of provincial governor (巡撫/ Shunfu) in Anhui Province? How long did they serve? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX leo: <http://linkedevents.org/ontology/> PREFIX time: <http://www.w3.org/2006/time#> SELECT ?Agent ?officialCtvc ?Duration FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?Agent ascdc:officialEvent ?officialSerial . ?officialSerial leo:involved ?officialCtvc . ?officialCtvc rdfs:label ?officialZh . FILTER (Contains(STR(?officialZh ), '安徽巡撫')) ?officialSerial ascdc:atTime ?Duration } EX4. In the history of Chinese painting, there are Four Wangs famous for landscape painting in the early Qing dynasty: Wang Shi-min (王時, 1592-1680), Wang Jian (王鑑, 1598-1677) , Wang Hui (王翬, 1632-1717), and Wang Yuan-qi (王原祁, 1642-1715). Who were their respective students? PREFIX agrelon: <http://d-nb.info/standards/elementset/agrelon#> SELECT ?agent ?student FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?agent agrelon:hasStudent ?student . FILTER (Contains(STR(?agent), 'NO000009213') || Contains(STR(?agent), 'NO000009298') || Contains(STR(?agent), 'NO000009371') || Contains(STR(?agent), 'NO000009212')) } EX5. Which agents specialized in calligraphy? PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> SELECT ?agent FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?agent dbpedia-owl:speciality <http://vocab.getty.edu/aat/300053162> . } EX6. How many agents belong to the order of "Baqi" (八旗/ Eight Banners) of the Manchu, Han army, and Mongolia respectively? PREFIX ascdc: <http://data.ascdc.tw/property/> SELECT (COUNT(?agent) AS ?countAgent) ?eightBanners FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?agent ascdc:eightBannersTypeRefined ?eightBanners . FILTER (Contains(STR(?eightBanners), '滿洲') || Contains(STR(?eightBanners), '漢軍') || Contains(STR(?eightBanners), '蒙古')) } GROUP BY ?eightBanners ORDER BY ?eightBanners EX7. Which agents have a studio name and what are those studio names? PREFIX ascdc: <http://data.ascdc.tw/property/> SELECT ?agent ?altLabelCtvc ?label FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?agent skos:altLabel ?altLabelSerial . ?altLabelSerial ascdc:nameType ?altLabelCtvc . ?altLabelCtvc rdfs:label ?altLabelZh . FILTER (Contains(STR(?altLabelZh ), '室名')) . ?altLabelSerial rdfs:label ?label . } EX8. Which alternative names does Weng Fanggang (翁方綱), a renowned Qing epigraphist have? What are the types of these names and where do they come from? PREFIX ascdc: <http://data.ascdc.tw/property/> SELECT ?nameType ?label ?source FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { <http://data.ascdc.tw/dnb/Agent/NO000000105> skos:altLabel ?altLabelSerial . ?altLabelSerial ascdc:nameType ?nameType . ?altLabelSerial rdfs:label ?label . ?altLabelSerial dc:source ?source . } EX9. Which agents ranked as jinshi (進士) in the Qing dynasty come from Jangsu, Hubei, Hunan and Zhejiang? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX leo: <http://linkedevents.org/ontology/> SELECT distinct ?agent FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?agent ascdc:dynastyPersonBirth <http://data.ascdc.tw/time/chi/dynasty/031> . ?agent ascdc:imperialExamination ?imperialExamUrl . ?imperialExamUrl leo:involved ?imperialExamCtvc . ?imperialExamCtvc rdfs:label ?imperialExamZh . FILTER (Contains(STR(?imperialExamZh ), '進士')) . ?agent ascdc:Place ?placeCtvc . ?placeCtvc rdfs:label ?placeZh . FILTER ( Contains(STR(?placeZh), '江蘇省') || Contains(STR(?placeZh), '湖北省') || Contains(STR(?placeZh), '湖南省') || Contains(STR(?placeZh), '浙江省') ) } EX10. How old were the Qing agents when they first took up the post of governor-general (總督/ zongdu)? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX leo: <http://linkedevents.org/ontology/> PREFIX time: <http://www.w3.org/2006/time#> PREFIX schema: <http://schema.org/> SELECT ?s ?name ?eventLabel ?position ?birthYear ?yearAsGovernor ((?yearAsGovernor - xsd:decimal(?birthYear)) AS ?age) FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?s skos:prefLabel ?name . ?s ascdc:officialEvent ?eventSerial . ?s schema:birthDate ?yearo . BIND(REPLACE(?yearo , "\\[", "") AS ?yearo2) . BIND(REPLACE(?yearo2, "\\]", "") AS ?birthYear) . ?eventSerial time:inXSDgYear ?yearAsGovernor . ?eventSerial leo:involved ?eventCtvc . ?eventCtvc rdfs:label ?position . ?eventSerial rdfs:label ?eventLabel . ?eventSerial ascdc:atTime ?eventTime . FILTER (?yearAsGovernor >= 1644) . FILTER contains(STR(?position), '總督') . { SELECT ?s (MIN(?inXSDgO) AS ?yearAsGovernor) FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?s ascdc:officialEvent ?eventSerial . ?eventSerial time:inXSDgYear ?inXSDgO . ?eventSerial leo:involved ?eventCtvc . ?eventCtvc rdfs:label ?position . FILTER contains(STR(?position), '總督') . } } } ORDER BY ?s EX11. How old were the Qing agents when they first took up the post of provincial governor (巡撫/ shunfu)? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX leo: <http://linkedevents.org/ontology/> PREFIX time: <http://www.w3.org/2006/time#> PREFIX schema: <http://schema.org/> SELECT ?s ?name ?eventLabel ?position ?birthYear ?yearAsGovernor ((?yearAsGovernor - xsd:decimal(?birthYear)) AS ?age) FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?s skos:prefLabel ?name . ?s ascdc:officialEvent ?eventSerial . ?s schema:birthDate ?yearo . BIND(REPLACE(?yearo , "\\[", "") AS ?yearo2) . BIND(REPLACE(?yearo2, "\\]", "") AS ?birthYear) . ?eventSerial time:inXSDgYear ?yearAsGovernor . ?eventSerial leo:involved ?eventCtvc . ?eventCtvc rdfs:label ?position . ?eventSerial rdfs:label ?eventLabel . ?eventSerial ascdc:atTime ?eventTime . FILTER (?yearAsGovernor >= 1644) . FILTER contains(STR(?position), '巡撫') . { SELECT ?s (MIN(?inXSDgO) AS ?yearAsGovernor) FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?s ascdc:officialEvent ?eventSerial . ?eventSerial time:inXSDgYear ?inXSDgO . ?eventSerial leo:involved ?eventCtvc . ?eventCtvc rdfs:label ?position . FILTER contains(STR(?position), '巡撫') . } } } ORDER BY ?s EX12. Where did the Qing agents ranked as jinshi (進士) come from? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX leo: <http://linkedevents.org/ontology/> SELECT ?name ?placeCh ?TGAZ_URI FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?systemNumber skos:prefLabel ?name . ?systemNumber ascdc:dynastyPersonBirth <http://data.ascdc.tw/time/chi/dynasty/031> . ?systemNumber ascdc:imperialExamination ?imperialExamUri . ?imperialExamUri leo:involved ?imperialExamCtvc . ?imperialExamCtvc rdfs:label ?imperialExamZh . FILTER (Contains(STR(?imperialExamZh ), '進士')) . ?placeCtvc owl:sameAs ?TGAZ_URI . FILTER contains(STR(?TGAZ_URI), 'tgaz') . ?placeCtvc rdfs:label ?placeCh . ?systemNumber ascdc:Place ?placeCtvc . } EX13. In the families of those who are ranked as jinshi (進士), who else has attained the same rank? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX leo: <http://linkedevents.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX agrelon: <http://d-nb.info/standards/elementset/agrelon#> PREFIX pext: <http://www.ontotext.com/proton/protonext> PREFIX bio: <http://purl.org/vocab/bio/0.1/> PREFIX gvp: <http://vocab.getty.edu/ontology#> SELECT ?s ?o FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?s pext:hasSon|bio:father|agrelon:hasGrandchild|pext:hasBrother|agrelon:hasAncestor|agrelon:hasGrandparent|gvp:ulan1515_great-grandparent_of|gvp:ulan1516_great-grandchild_of|agrelon:hasNiceNephew|agrelon:hasChildInLaw|agrelon:hasCousin|agrelon:hasAuntUncle ?o . ?s ascdc:imperialExamination ?imperialExamUri . ?imperialExamUri leo:involved ?imperialExamCtvc . ?o ascdc:imperialExamination ?imperialExamUriO . ?imperialExamUriO leo:involved ?imperialExamCtvc . ?imperialExamCtvc rdfs:label ?imperialExamZh . FILTER (Contains(STR(?imperialExamZh ), '進士')) . } EX14. How many alternative names of the Qing epigraphist Weng Fanggang (翁方綱) are there in the Database of Names and Biographies (DNB) and the Virtual International Authority File (VIAF)? What are these alternative names and where do these names come from? PREFIX ascdc: <http://data.ascdc.tw/property/> SELECT ?nameType ?label ?source FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { { <http://data.ascdc.tw/dnb/Agent/NO000000105> skos:altLabel ?altLabelSerial . ?altLabelSerial ascdc:nameType ?nameType . ?altLabelSerial rdfs:label ?label . ?altLabelSerial dc:source ?source . } UNION { <http://data.ascdc.tw/dnb/Agent/NO000000105> owl:sameAs ?viafID . ?viafID ?nameType ?label . FILTER (contains(STR(?nameType), 'http://schema.org/name') || Contains(STR(?nameType), 'http://schema.org/alternateName') || Contains(STR(?nameType), 'http://schema.org/givenName') || Contains(STR(?nameType), 'http://www.w3.org/2004/02/skos/core#prefLabel')) } }
Data structure-based query
EX1. List the book types (such as Series, Monographs, Volumes) collected in the Chinese Rare Books, and calculate the number of occurrences of each book type. PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX gn: <http://www.geonames.org/ontology#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> SELECT count(?Series) as ?Series count(?Monographs) as ?Monographs count(?Volumes) as ?Volumes FROM <http://data.ascdc.tw/Book/crb/> WHERE { {?Series ?Property ?Object. FILTER contains(str(?Series), 'Collection_Work'). FILTER contains(str(?Property), 'identifier'). } UNION { ?Monographs ?Property ?Object. FILTER contains(str(?Monographs), 'Book_Work'). FILTER contains(str(?Property), 'identifier'). } UNION { ?Volumes ?Property ?Object. FILTER contains(str(?Volumes), 'Part_Work'). FILTER contains(str(?Property), 'identifier'). } } Group By ?Property
Data structure-based query
EX2. List the types of the Sibu-Classification (such as ""Jinbu""/ 經部) of those Chinese Rare Books, and calculate number of occurrences of each Sibu type. PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX gn: <http://www.geonames.org/ontology#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> SELECT ?Sibu_Classification count(?Sibu_Classification) as ?Count FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?Subject ascdc:FSNLibraryClassHeading1 ?Sibu_Classification. }
Data structure-based query
EX3. List the names of institutional repositories (such as Fu Ssu-nien Library/ 傅斯年圖書館) of those Chinese Rare Books, and calculate number of occurrences of each institute. PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX gn: <http://www.geonames.org/ontology#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> SELECT ?Institute count(?Institute) as ?Count FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?Subject bf:heldBy ?Institute. }
Data structure-based query
EX4. List the property types included in the ontological design of the Chinese Rare Books Database, and calculate number of occurrences of each property type. PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX gn: <http://www.geonames.org/ontology#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT ?Property count(?Property) as ?Count FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?Subject ?Property ?Object. }
Data structure-based query
EX5. List the introduction, publisher, release date, license terms and URL access for download of the dataset of the Chinese Rare Books. 敬待發布/ Released soon
Data research-based query
EX1. List the type of Chinese traditional Sibu-Classification (such as ""Jinbu""/ 經部) of each book collected in the Chinese Rare Books Database. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?BookWork ?Label ?Sibu_Classification1 ?Sibu_Classification2 FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?BookWork skos:prefLabel ?Label. ?BookWork ascdc:FSNLibraryClassHeading1 ?Sibu_Classification1. ?BookWork ascdc:FSNLibraryClassHeading2 ?Sibu_Classification2. }
Data research-based query
EX2. List the dynasty name (such as ""Ming""/ 明朝) of each book, in which the title is published, collected in the Chinese Rare Books Database. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?BookWork ?Label ?Dynasty FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?BookWork skos:prefLabel ?Label. ?BookWork bf:hasInstance ?BookInstance. ?BookInstance dbpedia-owl:dynasty ?Dynasty. }
Data research-based query
EX3. List the name of the Chinese emperor's reign (such as ""Wanli""/ 萬曆) of each book, under which the title is published, collected in the Chinese Rare Books Database. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?BookWork ?Label ?Era FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?BookWork skos:prefLabel ?Label. ?BookWork bf:hasInstance ?BookInstance. ?BookInstance dbpedia-owl:era ?Era. }
Data research-based query
EX4. List the version types (such as ""printing version""/ 刊本) of each book collected in the Chinese Rare Books Database. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?BookWork ?Label ?VersionType FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?BookWork skos:prefLabel ?Label. ?BookWork bf:hasInstance ?BookInstance. ?BookInstance owl:versionInfo ?VersionType. }
Data research-based query
EX5. Where are the places of publication of the monographs in the Chinese Rare Books Database of located today? How many monographs are related to those locations respectively? PREFIX ascdc:<http://data.ascdc.tw/property/> PREFIX bf:<http://id.loc.gov/ontologies/bibframe/> PREFIX skos:<http://www.w3.org/2004/02/skos/core#> PREFIX owl:<http://www.w3.org/2002/07/owl#> PREFIX dcterms:<http://purl.org/dc/terms/> PREFIX geo:<http://www.w3.org/2003/01/geo/wgs84_pos#> SELECT ?s ?label ?instance_s ?place ?version FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?s skos:prefLabel ?label . ?s bf:hasInstance ?instance_s . ?instance_s bf:originPlace / rdfs:label ?place . FILTER (Contains(STR(?instance_s), 'Instance')) . ?instance_s owl:versionInfo ?version. FILTER regex(?version, '刊本', 'i'). }
Data research-based query
EX6. In the Chines Rare Books Database, what are the titles of all collected books ( such as ""Zuo chuan chao ping, shi er juan""/ 左傳鈔評 十二卷)? What are the types of these variant titles? PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?Work ?Title ?Variant_Title ?Type_of_Variant_Title FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?Work skos:prefLabel ?Title . FILTER (Contains(STR(?Work), 'Work')) . ?Work bf:title ?VariantTitleUri . ?VariantTitleUri bf:variantType ?Type_of_Variant_Title . ?VariantTitleUri rdfs:label ?Variant_Title. }
Data research-based query
EX7. In the Chinese Rare Books Database, who are the contributors related to all book titles (such as ""Zuo chuan chao ping, shi er juan""/ 左傳鈔評 十二卷)? What are their role? PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> SELECT ?Work ?Title ?AgentUri ?AgentName ?RoleUri ?RoleType FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?Work skos:prefLabel ?Title . ?Work bf:hasInstance ?InstanceUri . ?InstanceUri bf:contribution ?ContributionUri . ?ContributionUri bf:agent ?AgentUri . ?AgentUri skos:prefLabel ?AgentName . ?ContributionUri bf:role ?RoleUri . ?RoleUri rdfs:label ?RoleType . }
Data research-based query
EX8. What are the books published during the Late Ming and Early Qing Dynasty (ca. 1620-1735)? List the title, publishing period and subject of these books. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> SELECT ?Work ?Title ?Era ?Year ?Sibu_Classification FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?Work bf:hasInstance ?Instance. ?Work skos:prefLabel ?Title. ?Work ascdc:FSNLibraryClassHeading1 ?Sibu_Classification. ?Instance dbpedia-owl:era ?Era. ?Instance bf:date ?YearUri . ?YearUri rdfs:label ?Year. FILTER regex(?Era, '天啟|崇禎|順治|康熙|雍正', 'i'). }
Data research-based query
EX9. List all the series, monographs and volumes contained in the Chinese Rare Books Database, which are also collected in the Dataset of Names and Biographies. PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX gndo: <http://d-nb.info/standards/elementset/gnd#> SELECT DISTINCT ?Work ?MainTitle ?DnbUri ?Person FROM <http://data.ascdc.tw/Book/crb/> FROM <http://data.ascdc.tw/dnb/Agent/> WHERE { ?Work skos:prefLabel ?MainTitle . FILTER (Contains(STR(?Work), 'Work')) . ?DnbUri gndo:publication ?MainTitle . ?DnbUri skos:prefLabel ?Person . }
Data research-based query
EX10. List the version types of each book title collected in the Chinese Rare Books Database. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX gndo: <http://d-nb.info/standards/elementset/gnd#> SELECT ?Work ?Title ?Edition_Statement FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?Work skos:prefLabel ?Title . FILTER (Contains(STR(?Work), 'Work')) . ?Work bf:hasInstance ?Instance . ?Instance bf:editionStatement ?Edition_Statement . }
Data research-based query
EX11. List the format types of vertical lines per page and characters per line (such as ""10 vertical lines per page and 20 characters in each line""/ 10行20字) of each book collected in the Chinese Rare Books Database. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?BookWork ?Label ?LinesPerPage FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?PartInstance ascdc:linesPerPage ?LinesPerPage. ?PartInstance bf:partOf ?BookInstance. ?BookWork skos:prefLabel ?Label. ?BookWork bf:hasInstance ?BookInstance. } Group By ?BookWork ?Label ?LinesPerPage
Data research-based query
EX12. List the decorative types of framing line (such as ""double framing line""/ 雙欄) of each book collected in the Chinese Rare Books Database. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?BookWork ?Label ?FramingLineType FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?PartInstance ascdc:frameLineType ?FramingLineType. ?PartInstance bf:partOf ?BookInstance. ?BookWork bf:hasInstance ?BookInstance. ?BookWork skos:prefLabel ?Label. } Group By ?BookWork ?Label ?FramingLineType
Data research-based query
EX13. List the decorative type of ""YuWei pattern"" (such as ""double YuWei pattern""/ 雙魚尾) of each book collected in the Chinese Rare Books Database. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?BookWork ?Label ?YuWei FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?PartInstance ascdc:yuWei ?YuWei. ?PartInstance bf:partOf ?BookInstance. ?BookWork bf:hasInstance ?BookInstance. ?BookWork skos:prefLabel ?Label. } Group By ?BookWork ?Label ?YuWei
Data research-based query
EX14. Which local history chronicles are collected in the Chinse Rare Books Database and how are they classified by subject? How are they classified in the dataset of the Library of Congress? PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX owl: <http://www.w3.org/2002/07/owl#> SELECT ?CRB_Work, ?Label, ?CRB_Subject, ?LC_Work, ?LC_Subject FROM <http://data.ascdc.tw/Book/crb/> FROM <http://id.loc.gov/> WHERE { ?CRB_Work skos:prefLabel ?Label. ?CRB_Work bf:subject ?subject; ascdc:FSNLibraryClassHeading ?CRB_Subject; owl:sameAs ?LC_Work. ?LC_Work bf:subject/rdfs:label ?LC_Subject. FILTER (str(?subject) = '方志'). FILTER langMatches( lang(?LC_Subject), 'zh' ). } Group By ?CRB_Work ?Label ?CRB_Subject ?LC_Work ?LC_Subject
Data research-based query
EX15. Which version of the chronicle ""Jiaxingfuzhi"" (嘉興府志) is collected in the Chinese Rare Books Database and what other related versions of the ""Jiaxingfuzhi"" can be found in the dataset of the Library of Congress? PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX owl: <http://www.w3.org/2002/07/owl#> SELECT * FROM <http://data.ascdc.tw/Book/crb/> FROM <http://id.loc.gov/> WHERE { ?crbWork skos:prefLabel ?crbLabel; bf:hasInstance/bf:editionStatement ?crbEdition; owl:sameAs|rdfs:seeAlso ?locWork. FILTER contains(str(?crbLabel), '嘉興府志'). ?locWork bf:hasInstance/bf:editionStatement ?locEdition. FILTER langMatches( lang(?locEdition), 'zh-hani' ). }
Data research-based query
EX16. In the Chinese Rare Books Database, if we were to examine the Ming and Qing dynasty works falling under the category of ""Chunqiu Zuochuan"" (春秋左傳), which book titles would we find? In addition, under which emperor’s reign were these titles printed? PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?BookWork ?Label ?Sibu ?Dynasty ?Era ?Version FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?BookWork ascdc:FSNLibraryClassHeading2 ?Sibu. ?BookWork skos:prefLabel ?Label. ?BookWork bf:hasInstance ?BookInstance. ?BookInstance owl:versionInfo ?Version. ?BookInstance dbpedia-owl:dynasty ?Dynasty. ?BookInstance dbpedia-owl:era ?Era. FILTER regex(?Sibu, '春秋', 'i'). }
Data research-based query
EX17. To which emperor’s reign does the year of publication of each monograph in the Chinese Rare Books Database correspond? List the number of monographs published during respective reigns. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?eraURI ?era count(?s) as ?countEra FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?s bf:date ?eraURI . ?eraURI rdfs:label ?era . FILTER (Contains(STR(?s), 'Instance')) . FILTER (Contains(STR(?eraURI), 'era')) . } ORDER BY ?eraURI
Data research-based query
EX18. In the Chinese Rare Books Database, which contributors are associated with each single volume? And among those who have been involved in the same single volume, how are they related to one and another in terms of the times they were involved together as the volume's contributors (authoring the book, the preface, the postscript, or other devotional articles, etc.)? PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX dcterms: <http://purl.org/dc/terms/> SELECT ?Book ?Label ?Contributor FROM <http://data.ascdc.tw/Book/crb/> WHERE{ ?Book bf:contribution/bf:agent/skos:prefLabel ?Contributor; dcterms:identifier ?Id. FILTER (contains(str(?Book), 'Book_Work')||contains(str(?Book), 'Book_Instance')) . OPTIONAL {?Book skos:prefLabel ?Label} } ORDER BY ?Label
Data research-based query
EX19. In the Chinese Rare Books Database, which books have a format of 10 vertical lines per page, with 20 characters in each line? What are the subjects and the dynasties of publication of these works? PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?BookWork ?LinesPerPage ?Label ?Version ?Dynasty ?Era ?Subject1 ?Subject2 FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?PartInstance ascdc:linesPerPage ?LinesPerPage. ?PartInstance bf:partOf ?BookInstance. ?BookInstance owl:versionInfo ?Version. ?BookInstance dbpedia-owl:dynasty ?Dynasty. ?BookInstance dbpedia-owl:era ?Era. ?BookWork bf:hasInstance ?BookInstance. ?BookWork ascdc:FSNLibraryClassHeading1 ?Subject1. ?BookWork ascdc:FSNLibraryClassHeading2 ?Subject2. ?BookWork skos:prefLabel ?Label. FILTER regex(?LinesPerPage, '10行20字|十行二十字', 'i'). FILTER regex(?Version, '刊本', 'i'). } Group By ?BookWork ?LinesPerPage ?Label ?Version ?Dynasty ?Era ?Subject1 ?Subject2
Data research-based query
EX20. In the Chines Rare Books Database, which books have both the decorative elements of a double YuWei pattern (雙魚尾) and a double framing line (雙欄)? What are the subjects and dynasties of publication of these works? PREFIX bf: <http://id.loc.gov/ontologies/bibframe/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?BookWork ?Label ?Subject ?FrameLineType ?YuWei ?DyanstyLabel FROM <http://data.ascdc.tw/Book/crb/> WHERE { ?PartInstance ascdc:frameLineType ?FrameLineType. ?PartInstance ascdc:yuWei ?YuWei. ?PartInstance bf:partOf ?BookInstance. ?BookInstance dbpedia-owl:dyansty ?Dyansty. ?Dyansty rdfs:label ?DyanstyLabel. ?BookWork bf:hasInstance ?BookInstance. ?BookWork ascdc:FSNLibraryClassHeading2 ?Subject. ?BookWork skos:prefLabel ?Label. FILTER regex(?FrameLineType, '雙欄', 'i'). FILTER regex(?YuWei, '雙魚尾', 'i'). } Group By ?BookWork ?Label ?Subject ?FrameLineType ?YuWei ?DyanstyLabel
EX1. What was the first position of those who had been a "governor-general (zongdu)" in the Qing Dynasty? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX schema: <http://schema.org/> SELECT ?name GROUP_CONCAT(distinct ?label ; separator=";") as ?Position GROUP_CONCAT(distinct ?label2 ; separator=";") as ?FirstPositionDNB GROUP_CONCAT(distinct ?label3 ; separator=";") as ?FirstPositionDQOT ?s as ?name_uri FROM <http://data.ascdc.tw/dnb/Agent/> FROM <http://data.ascdc.tw/OfficialPosition/DQOT/> WHERE { ?s skos:prefLabel ?name; ascdc:officialEvent/schema:about/rdfs:label ?label. FILTER (Contains(STR(?label), '總督')). ?s ascdc:officialEvent ?officialService. ?officialService rdfs:label ?label2. FILTER (xsd:integer(SUBSTR(STR(?officialService), 54)) = 1). OPTIONAL {?officialService schema:about/rdfs:label ?label3.} } EX2. Was the sequence "provincial judicial commissioner(anchashi)"→"provincial administration commissioner (buzhengshi)"→"governor(xunfu)" a common career path in the Qing Dynasty? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX schema: <http://schema.org/> SELECT ?Name GROUP_CONCAT(distinct ?label ; separator=";") as ?Position1 GROUP_CONCAT(distinct ?label2 ; separator=";") as ?Position2 GROUP_CONCAT(distinct ?label3 ; separator=";") as ?Position3 ?s as ?Name_uri FROM <http://data.ascdc.tw/dnb/Agent/> FROM <http://data.ascdc.tw/OfficialPosition/DQOT/> WHERE { ?s skos:prefLabel ?Name; ascdc:officialEvent ?officialService, ?officialService2, ?officialService3. ?officialService schema:about/rdfs:label ?label. ?officialService2 schema:about/rdfs:label ?label2. ?officialService3 rdfs:label ?label3. FILTER (Contains(STR(?label), '按察使') && Contains(STR(?label2), '布政使') && Contains(STR(?label3), '巡撫')). FILTER (SUBSTR(STR(?officialService3), 54) > SUBSTR(STR(?officialService2), 54) && SUBSTR(STR(?officialService2), 54) > SUBSTR(STR(?officialService), 54)). } EX3. How many bannermen (qiren) and civilians (minren) are there respectively, who had been a "governor (xunfu)" in the Qing Dynasty? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX schema: <http://schema.org/> SELECT ?name GROUP_CONCAT(distinct ?label ; separator=";") as ?Position ?EightBanners ?s as ?name_uri FROM <http://data.ascdc.tw/dnb/Agent/> FROM <http://data.ascdc.tw/OfficialPosition/DQOT/> WHERE { ?s skos:prefLabel ?name; ascdc:officialEvent/schema:about/rdfs:label ?label. FILTER (Contains(STR(?label), '巡撫')). OPTIONAL {?s ascdc:eightBannersTypeRefined ?EightBanners} } EX3-1. How many bannermen (qiren) belonged to "Hanjun," who had been a "governor(xunfu)" in the Qing dynasty? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX schema: <http://schema.org/> SELECT ?name GROUP_CONCAT(distinct ?label ; separator=";") as ?Position ?EightBanners ?s as ?name_uri FROM <http://data.ascdc.tw/dnb/Agent/> FROM <http://data.ascdc.tw/OfficialPosition/DQOT/> WHERE { ?s skos:prefLabel ?name; ascdc:eightBannersTypeRefined ?EightBanners; ascdc:officialEvent/schema:about/rdfs:label ?label. FILTER (Contains(STR(?label), '巡撫')). FILTER (Contains(STR(?EightBanners), '漢軍')). } EX4. What are the imperial examination results of those who had been a "governor (xunfu)" in the Qing Dynasty? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX schema: <http://schema.org/> SELECT ?name GROUP_CONCAT(distinct ?label ; separator=";") as ?Position ?ImperialExamination ?s as ?name_uri FROM <http://data.ascdc.tw/dnb/Agent/> FROM <http://data.ascdc.tw/OfficialPosition/DQOT/> WHERE { ?s skos:prefLabel ?name; ascdc:imperialExamination/rdfs:label ?ImperialExamination; ascdc:officialEvent/schema:about/rdfs:label ?label. FILTER (Contains(STR(?label), '巡撫')). } EX4-1. What were the specialties of those who had been a "governor (xunfu)" in the Qing dynasty? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX schema: <http://schema.org/> PREFIX dbpedia-owl: <http://dbpedia.org/ontology/> SELECT ?name GROUP_CONCAT(distinct ?label ; separator=";") as ?Position ?speciality ?s as ?name_uri FROM <http://data.ascdc.tw/dnb/Agent/> FROM <http://data.ascdc.tw/OfficialPosition/DQOT/> WHERE { ?s skos:prefLabel ?name; dbpedia-owl:speciality ?speciality; ascdc:officialEvent/schema:about/rdfs:label ?label. FILTER (Contains(STR(?label), '巡撫')). } EX4-2. Where were the native places of those who had been a "governor (xunfu)" in the Qing dynasty? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX schema: <http://schema.org/> PREFIX owl: <http://www.w3.org/2002/07/owl#> SELECT ?name GROUP_CONCAT(distinct ?label ; separator=";") as ?Position ?nativePlace ?TGAZ ?s as ?name_uri FROM <http://data.ascdc.tw/dnb/Agent/> FROM <http://data.ascdc.tw/OfficialPosition/DQOT/> WHERE { ?s skos:prefLabel ?name; ascdc:Place ?nativePlace; ascdc:officialEvent/schema:about/rdfs:label ?label. FILTER (Contains(STR(?label), '巡撫')). OPTIONAL {?nativePlace owl:sameAs ?TGAZ} } EX4-3. In the Qing dynasty, who were the fathers, ancestors, and friends of those who had been a "governor (xunfu)" ? PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX schema: <http://schema.org/> PREFIX bio: <http://purl.org/vocab/bio/0.1/> PREFIX agrelon: <http://d-nb.info/standards/elementset/agrelon#> SELECT ?name GROUP_CONCAT(distinct ?label ; separator=";") as ?Position ?father GROUP_CONCAT(distinct ?ancestor ; separator=";") as ?ancestors GROUP_CONCAT(distinct ?friend ; separator=";") as ?friends ?s as ?name_uri ?fatherURI as ?father_uri FROM <http://data.ascdc.tw/dnb/Agent/> FROM <http://data.ascdc.tw/OfficialPosition/DQOT/> WHERE { ?s skos:prefLabel ?name; ascdc:officialEvent/schema:about/rdfs:label ?label. FILTER (Contains(STR(?label), '巡撫')). OPTIONAL{?s bio:father ?fatherURI. ?fatherURI skos:prefLabel ?father} OPTIONAL{?s agrelon:hasAncestor/skos:prefLabel ?ancestor} OPTIONAL{?s agrelon:hasFriend/skos:prefLabel ?friend} }
EX1. What is the list of Han wooden slips with a format of "two rows," and what is each slip's excavation site, dynasty of origin, length, and width? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> SELECT ?Item ?ID ?FormatType ?Place ?Period ?Length ?Width ?Thickness ?Weight FROM <http://data.ascdc.tw/WoodenSlips/WCD/IHP/> WHERE{ ?Item crm:P2_has_type/rdfs:label ?FormatType. FILTER (str(?FormatType) = '兩行'). ?Item schema:identifier ?ID. ?Item crm:P24i_changed_ownership_through/crm:P134i_was_continued_by/crm:P7_took_place_at/rdfs:label ?Place. ?Item crm:P108i_was_produced_by/crm:P4_has_time-Span/crm:P10_falls_within/rdfs:label ?Period. FILTER langMatches(LANG(?Period), 'zh'). ?Item crm:P43_has_dimension ?Dimension1, ?Dimension2, ?Dimension3, ?Dimension4 . ?Dimension1 crm:P90_has_value ?Thickness. ?Dimension2 crm:P90_has_value ?Width. ?Dimension3 crm:P90_has_value ?Weight. ?Dimension4 crm:P90_has_value ?Length. FILTER regex(?Dimension1, "Thickness"). FILTER regex(?Dimension2, "Width"). FILTER regex(?Dimension3, "Weight"). FILTER regex(?Dimension4, "Length"). } EX2. What is the list of Han wooden slips decorated with perforations, and what are their excavation sites? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> SELECT ?Item ?ID ?Decoration ?FormatType ?Place FROM <http://data.ascdc.tw/WoodenSlips/WCD/IHP/> WHERE{ ?Item crm:P111i_was_added_by/rdfs:label ?Decoration. FILTER (str(?Decoration) = '穿孔'). ?Item crm:P2_has_type/rdfs:label ?FormatType. ?Item schema:identifier ?ID. ?Item crm:P24i_changed_ownership_through/crm:P134i_was_continued_by/crm:P7_took_place_at/rdfs:label ?Place. } EX3. What is the list of Han wooden slips inscribed with "zhuan" (傳), and what are their excavation sites, calligraphic styles, and time periods? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> SELECT ?Item ?Word ?Script ?Place ?Time WHERE { ?Item crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / rdfs:label ?Word. FILTER (str(?Word) = '傳'). ?Item crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / dcterms:type/ rdfs:label ?Script. ?Item crm:P24i_changed_ownership_through / crm:P134i_was_continued_by / crm:P7_took_place_at / rdfs:label ?Place. ?Item crm:P108i_was_produced_by / crm:P4_has_time-Span / rdfs:label ?Time. } Group By ?Item EX4. What is the list of Han wooden slips with burn marks, and what are their excavation sites? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX schema: <http://schema.org/> SELECT ?Item ?ID ?Decoration ?Place WHERE { ?Item crm:P111i_was_added_by / rdfs:label ?Decoration. FILTER (str(?Decoration) = '燒痕'). ?Item crm:P24i_changed_ownership_through / crm:P134i_was_continued_by / crm:P7_took_place_at / rdfs:label ?Place. ?Item schema:identifier ?ID. } EX5. What is the list of Han wooden slips with pictures, and what are their formats? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX schema: <http://schema.org/> SELECT ?Item ?ID ?Decoration ?FormatType WHERE { ?Item crm:P111i_was_added_by / rdfs:label ?Decoration. FILTER (Contains(STR(?Decoration), '人面形') || Contains(STR(?Decoration), '圖形')) ?Item crm:P2_has_type / rdfs:label ?FormatType. ?Item schema:identifier ?ID. } EX6. What is the list of characters used as "practice characters" (習字) on Han wooden slips, and what are the formats of those slips? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX schema: <http://schema.org/> SELECT ?Item ?ID ?Word ?Style ?FormatType WHERE { ?Item crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / rdfs:label ?Word. ?Item crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / dcterms:description ?Style. FILTER (str(?Style) = '習字'). ?Item crm:P2_has_type / rdfs:label ?FormatType. ?Item schema:identifier ?ID } Group By ?Item EX7. What is the list of Han wooden slips with the human-face talisman format, that include color photographs? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX schema: <http://schema.org/> SELECT ?Item ?ID ?FormatType ?Image ?WCD_URL WHERE { ?Item crm:P2_has_type / rdfs:label ?FormatType. FILTER (str(?FormatType) = '人面符'). ?Item crm:P65_shows_visual_item / crm:P2_has_type / rdfs:label ?Image. FILTER (str(?Image) = '彩色照片'). ?Item schema:identifier ?ID. ?Item owl:sameAs ?WCD_URL. } EX8. What is the list of Han wooden slips with a calligraphic style of "clerical script" (隸書) and a format of "two rows"? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX schema: <http://schema.org/> SELECT ?Item ?ID ?Script ?FormatType WHERE { ?Item crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / dcterms:type / rdfs:label ?Script. FILTER (str(?Script) = '隸書'). ?Item crm:P2_has_type / rdfs:label ?FormatType. FILTER (str(?FormatType) = '兩行'). ?Item schema:identifier ?ID } Group By ?Item EX9. What is the list of Han wooden slips inscribed with "yue" (月), "shi" (石), "dou" (斗), or "sheng" (升), and excavated from the "A8 City Ruins" (A8破城子)? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX schema: <http://schema.org/> SELECT ?Item ?ID ?Word ?Place ?WCD_URL WHERE { ?Item crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / rdfs:label ?Word. FILTER (Contains(STR(?Word), '月') || Contains(STR(?Word), '石')|| Contains(STR(?Word), '斗') || Contains(STR(?Word), '升')). ?Item crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / schema:url ?WCD_URL. ?Item crm:P24i_changed_ownership_through / crm:P134i_was_continued_by / crm:P7_took_place_at / rdfs:label ?Place. FILTER (str(?Place) = 'A8 破城子'). ?Item schema:identifier ?ID. } Group By ?Item EX10. What is the list of Han wooden slips inscribed with the place of origin "lingshichong" (令史充), and the proximate time periods of wooden slips in the same numbered bundle? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> SELECT ?Item ?ID ?Inscription ?Place ?Time WHERE { ?Item crm:P128_carries / dcterms:description ?Inscription. FILTER (Contains(STR(?Inscription), '令史充') || Contains(STR(?Inscription), '╱令史充')). ?Item crm:P24i_changed_ownership_through / crm:P134i_was_continued_by / crm:P7_took_place_at / rdfs:label ?Place. ?Item schema:identifier ?ID. ?Item crm:P108i_was_produced_by / crm:P4_has_time-Span / rdfs:label ?Time. } EX11. What is the list of Han wooden slips inscribed with “zhuan” (專), with a calligraphic style of “Chinese clerical script” (隸書)? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc:<http://data.ascdc.tw/property/> PREFIX schema: <https://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> SELECT ?Item ?Component ?Script WHERE { ?Item crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / ascdc:characterComponent ?Component. FILTER (str(?Component) = '專'). ?Item crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / dcterms:type / rdfs:label ?Script. FILTER (str(?Script) = '隸書'). } Group By ?Item EX12. What is the list of Han wooden slips that are notched (刻齒), and what are their excavation sites? PREFIX crm: <http://www.cidoc-crm.org/cidoc-crm/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX schema: <http://schema.org/> SELECT ?Item ?ID ?FormatType ?Decoration ?Place WHERE { ?Item crm:P111i_was_added_by / rdfs:label ?Decoration. FILTER (str(?Decoration) = '刻齒'). ?Item crm:P24i_changed_ownership_through / crm:P134i_was_continued_by / crm:P7_took_place_at / rdfs:label ?Place. ?Item crm:P2_has_type / rdfs:label ?FormatType. ?Item schema:identifier ?ID. }
Data research-based query
EX1. List all information about Chishang Township, including: field information, references, government materials, field investigation events, collection of multimedia and field investigation reports, etc. PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX gn: <http://www.geonames.org/ontology#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT ?Data ?Name ?Type FROM <http://data.ascdc.tw/scsrt/> WHERE { { ?Data gn:parentADM3 ?Place. FILTER contains(str(?Place), '池上鄉'). ?Data schema:name ?Name. ?Data rdf:type ?Type. FILTER contains(str(?Data), 'Place'). } UNION { ?Data schema:name ?Name. FILTER contains(str(?Name), '池上'). ?Data rdf:type ?Type. FILTER contains(str(?Data), 'Reference'). } UNION { ?Data schema:name ?Name. FILTER contains(str(?Name), '池上'). ?Data rdf:type ?Type. FILTER contains(str(?Data), 'Dataset'). } UNION { ?Data schema:name ?Name. ?Data rdf:type ?Type. FILTER contains(str(?Data), 'Event'). } UNION { ?Data schema:name ?Name. ?Data rdf:type ?Type. FILTER contains(str(?Data), 'DigitalDocument'). } UNION { ?Data schema:name ?Name. FILTER contains(str(?Name), '臺東縣池上鄉'). ?Data rdf:type ?Type. FILTER contains(str(?Data), 'Report'). } }
Data research-based query
EX2. List all places that produce rice and their demographic information (including population, male, female, and elderly population in the last year). PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX gn: <http://www.geonames.org/ontology#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT ?Place ?Name ?Product ?Statistic_Name ?Population ?Men ?Women ?Over65 FROM <http://data.ascdc.tw/scsrt/> WHERE { { ?Place schema:name ?Name. ?Place dbo:produces / skos:prefLabel ?Product. FILTER contains(str(?Product), '稻米'). ?Place dbo:population ?Statistics. ?Statistics skos:prefLabel ?Statistic_Name. ?Statistics gn:population ?Population. } UNION { ?Place schema:name ?Name. ?Place dbo:produces / skos:prefLabel ?Product. FILTER contains(str(?Product), '稻米'). ?Place dbo:population ?Statistics. ?Statistics skos:prefLabel ?Statistic_Name. ?Statistics gn:population ?Population. ?Statistics ascdc:populationMen ?Men. ?Statistics ascdc:populationWomen?Women. ?Statistics ascdc:populationOver65y ?Over65. } }
Data research-based query
EX3. List the procession route of the god-inviting ceremony for the Zhongyuan festival of 2020 in Chishang Township, and count the number of gods or their representatives related to the ceremony. PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX gn: <http://www.geonames.org/ontology#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT ?Data ?Name ?Type ?About ?StartDate ?Place ?Latitude ?Longitude ?RelatedGod FROM <http://data.ascdc.tw/scsrt/> WHERE { ?Data schema:name ?Name. ?Data rdf:type ?Type. FILTER contains(str(?Data), 'ReportEvent'). ?Data schema:about ?About. FILTER contains(str(?About), '001'). ?Data schema:startDate ?StartDate. ?Data schema:location/skos:prefLabel ?Place. ?Data schema:location/schema:latitude ?Latitude. ?Data schema:location/schema:longitude ?Longitude. ?Data dcterms:relation/skos:prefLabel ?RelatedGod. }
Data structure-based query
EX1. List the class types included in the ontological design for the dataset of the Social and Cultural Survey of Rural Taiwan, and calculate number of instances under each class type. PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX gn: <http://www.geonames.org/ontology#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT ?Object count(?Object) as ?Count FROM <http://data.ascdc.tw/scsrt/> WHERE { ?Subject rdf:type ?Object. }
Data structure-based query
EX2. List the property types included in the ontological design for the dataset of the Social and Cultural Survey of Rural Taiwan, and calculate number of occurrences of each property type. PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX gn: <http://www.geonames.org/ontology#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT ?Property count(?Property) as ?Count FROM <http://data.ascdc.tw/scsrt/> WHERE { ?Subject ?Property ?Object. }
Data structure-based query
EX3. List the introduction, publisher, release date, license terms and URL access for download of the dataset of the Social and Cultural Survey of Rural Taiwan. PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX schema: <http://schema.org/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX gn: <http://www.geonames.org/ontology#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX ascdc: <http://data.ascdc.tw/property/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT ?Dataset ?Title ?Description ?Publisher ?Date ?License ?AccessURL ?Size ?Format FROM <http://data.ascdc.tw/scsrt/> WHERE { ?Dataset dcterms:title ?Title. ?Dataset dcterms:description ?Description. ?Dataset dcterms:publisher / skos:prefLabel ?Publisher. ?Dataset dcterms:issued ?Date. ?Dataset dcat:distribution ?Distribution. ?Distribution dcterms:license ?License. ?Distribution dcat:accessURL ?AccessURL. ?Distribution dcat:byteSize ?Size. ?Distribution dcat:compressFormat ?Format. }



1)Query the data field of life stage (txn:individualStatus) and filter out the records, which have value as http://data.ascdc.tw/terms/bio/Juvenile.
2)Filter out again the records, which has value of data type as http://dbpedia.org/resource/Specimen.
3)List the scientificName of the resources, which match the query conditions mentioned as steps 1 and 2.
1)Query the data field of fish’s standard length (ascdc-props_bio:SL) or minimal standard length (ascdc-props_bio:minSL) and filter out the records, which have record type as http://dbpedia.org/resource/Specimen.
2)Filter out again the records, whose value of minimal standard length is greater than 100 (minSL > 100).
3)List the scientificName of the resources, which match the query conditions mentioned as steps 1 and 2.
1)Query the data field of scientific name (txn:scientificName) and filter out the records, which have value as http://data.ascdc.tw/taicol/family/Animalia_Stromateidae.
2)List the scientificName of the resources, which match the query conditions mentioned as the step 1.
1)Query the data field of scientific name (txn:scientificName) and filter out the records, which have value of specific epithet as "formosana".
2)List the scientificName of the resources, which match the query conditions mentioned as the step 1.
1)Query the data field of vernacular name (dwc_terms:vernacularName) and filter out the records, which have value as "海馬" with language type as "zh".
2)List the label/ vernacularName of the resources, which match the query conditions mentioned as the step 1.
1)Query the data field of sampling method (txn:samplingProtocol) and filter out the records, which have value as "底拖網’@zh".
2)List the scientificName of the resources, which match the query conditions mentioned as the step 1.
1)Search for the data field of tribe (ascdc-props_anth:hasRelatedTribe), to which a item is belonging, and filter out the records, which have value as "Bunun", "布農", "Atayal" or "泰雅".
2)Filter out the data field of item’s color (schema:color) from these records selected after step 1 and find out the items, which has value as "紅色" or "http://vocab.getty.edu/aat/300126225"(AAT).
3)Filter out again the data field of item’s usage function (gvp:aat2218_used-function_as) from these records selected after step 2 and find out the items, which has value as "http://vocab.getty.edu/aat/300266639"(AAT).
4)List the label/title of the resources, which match the query conditions as abovementioned.
1)Search for the data field of decoration (ascdc:hasAddedDecoration) and filter out the records, which have value as "條紋".
2)Filter out again the data field of item’s material (schema:color) from these records selected after step 1 and find out the items, which has value as "木頭" or "http://vocab.getty.edu/aat/300011914"(AAT)
3)List the label/title of the resources, which match the query conditions as abovementioned.
1)Search for the data field of material (schema:material) and filter out the records, which have value as "玻璃" or "http://vocab.getty.edu/aat/300010797"(AAT).
2)Filter out again the data field of object’s length from these records queried after step 1, whose value of length (mm) is greater than 800 (length > 800).
3)List the label/title of the resources, which match the query conditions as abovementioned.
1)Search for the data field of subject (dcterms:subject) within all data and filter out the records that the titles arte marked with "zh" as value of language type.
2)List the title of all queried resources that match the query conditions mentioned as above.
1)Search for the data field of sampling location (sam:sampling_location) and filter out the records, which have data value as "台東" or "臺東" .
2)List the label/title of resources, which match the query conditions mentioned as above.
1)Query the data field of denomination (dbpedia-owl:denomination) within all resources and filter out the records, which have value as "Gelug" (dbpedia:Gelug).
2)List the title of resources, which match the query conditions mentioned as the step 1.
1)Query the data field of author (schema:author) within all resources and filter out the records, which have value as "Dzong-ka-ba" or "Gendun Drub" (viaf:65296968 or viaf:10645178).
2)List the title of resources, which match the query conditions mentioned as the step 1.
1)Query the data field of location (schema:locationCreated),where the items were created, within all resources.
2)Make statistics of each queried location instance selected after the step 1.
3)List all location instances and total count of each location, which match the query conditions as abovementioned.
1)Locate every URI available in the level (locah:level) of Series (http://data.archiveshub.ac.uk/id/level/series)
2)Locate the data in fields including Label (rdfs:label) and Item (locah:item).
3)Search results will appear in the fields of Series, Label, and Item.
1)Search the “isPartOf” field (dcterms:isPartOf) in Item and locate every URI of the data fields titled as Watercolor (http://data.ascdc.tw/archive/ith/ccp/CCP_02_02).
2)Locate Label (rdfs:label), Alternative (dcterms:alternative), and Date (dc:date) among these URIs.
3)Search results will appear in the fields of Item, Label, Alternative, and Year.
1)Locate every data value of "canvas" (http://vocab.getty.edu/aat/300014078) in the data field of Material (dcterms:medium) in the Item level of the archive.
2)Locate the data value in the field of Title (rdfs:label) in the URIs obtained in step 1.
3)Search results will appear in the fields of Item, Title, and Material.
1)Locate every URI in the Item level, which contains 裸女 ("naked woman") in data field of rdfs:label.
2)Look for the URI in the field of dcterms:isPartOf in the URIs obtianed in step 1.
3)Look for the content of rdfs:label in the URIs obtained in step 2.
4)Search results will appear in the fields of Item, Label/Item, and Label/File.
1)Locate the URIs with value of http://data.ascdc.tw/archive/ith/ccp/CCP_01_01 in the field of dcterms:isPartOf in Item level and find out the fields of rdfs:label whose content is "oil painting created during the studentship at the Tokyo School of Fine Arts."
2) Look for the data fields (dcterms:spatial) containing "Chiayi" in the URIs obtained in step 1.
3)Locate the data fields of dc:date in the URIs obtained in step 2.
4)Search results will appear in the fields of Item, File, Place, and Year.
1)Locate all data fields in dcterms:spatial in Item level.
2)Apply statistics to the searched results.
3)Search results will appear in the fields of Item and Place.
1)Look for every URI containing value as 臺灣美術展覽會 (Taiwan Art Exhibition) in rdfs:label in Item level.
2)Locate the URI of rdfs:seeAlso in the URIs obtained in step 1.
3)Search results will appear in the fields of Item, Label/Item, and Related.
1)Locate every URI containing value as http://data.ascdc.tw/archive/ith/ccp/CCP_09_01 in the field of dcterms:isPartOf in Item level.
2)Look for the URIs (beginning with http://data.ascdc.tw/Agent/archive/ith/ccp/) in the field of dc:subject in the URIs obtained in step 1.
3)Look for person’s name in the field of rdfs:label and ULAN-URI in the field of owl:sameAs in the URIs obtained in step 2.
4)Search results will appear in the fields of Item, Person, and ULAN.
1)Locate every URI containing value as http://data.ascdc.tw/archive/ith/ccp/CCP_09_01 in the field of dcterms:isPartOf in Item level.
2)Look for the URIs (beginning with http://data.ascdc.tw/Agent/archive/ith/ccp/) in the field of dc:subject in the URIs obtained in step 1.
3)Look for person’s name in the field of rdfs:label and ULAN-URI in the field of owl:sameAs in the URIs obtained in step 2.
4)Look for ID-Agent URI in the field of foaf:focus of the matched ULAN-URI queried in the step 3.
5)Look for the data in the field of gvp:nationalityPrefferred of the ID-Agent URI and their preferred label (xl:prefLabel) obtained in the Step 4.
6)Search results will appear in the fields of Item, Person, ULAN and Nationality.
1)Locate every URI containing value as http://data.ascdc.tw/archive/ith/ccp/CCP_09_01 in the field of dcterms:isPartOf in Item level.
2)Look for the URIs (beginning with http://data.ascdc.tw/Agent/archive/ith/ccp/) in the field of dc:subject in the URIs obtained in step 1.
3)Look for person’s name in the field of rdfs:label and DBpedia-URI in the field of owl:sameAs in the URIs obtained in step 2.
4)Look for data in the field of dbo:movement and the label of those queried DBpedia URI obtained in the step 3.
5)Search results will appear in the fields of Item, Person, DBpedia and Style.
1)Locate every URI containing value as http://data.ascdc.tw/archive/ith/ccp/CCP_09_07 and http://data.ascdc.tw/archive/ith/ccp/CCP_09_08 in the field of dcterms:isPartOf in Item level.
2)Look for the URIs (beginning with http://www.worldcat.org/oclc/) in the field of dc:subject in the URIs obtained in step 1.
3)Look for the data values in the fields of schema:inLanguage, schema:contributor and library:placeOfPublication within those queried WorldCat URI obtained in the step 2.
4)Search results will appear in the fields of Item, WorldCat, Language, Contributor and Place.
1)Set ?work3 as the URIs of third level images. Set P as schema:about and rdfs:label. Set ?topic as the Chinese names of topics for images in work3.
2)Limit the query to images with the topic (?topic) of “Vimalakirti and Manjushri”.
3)The URIs of third level images (?work3) form part of (crm:P46i_forms_part_of) the URIs of higher second level structures (?work2).
4)Set the Chinese name (rdfs:label) of URIs of second level structures (?work2) as (?title2).
5)To query the structural coordinates of second level images, the URIs of second level structures (?work2) is identified (has_section/crm:P87_is_identified_by/rdfs:label) by section coordinates (?section).
6)The URIs of second level structures (?work2) form part of (crm:P46i_forms_part_of) the full URIs of higher first level works (?work).
7)Query the discovery of the works (?work). Set P as crm:P12i_was_present_at. Set ?discovery as the URIs of the discoveries.
8)Set the discovery’s (?discovery) location (crm:P7_took_place_at) as (?place).
9)Limit location results (?place) to contain “province.”
10)Displaying location (?place) and structure (?section) together facilitates the creation of statistical charts.
11)Order results by location name and structure number in descending order.
12)(count(?structure) as ?count) counts the number of each location and structure.
1)List the Chinese names of third level images (?work3). P is rdfs:label. ?Work is the works’ Chinese names.
2)Set ?work3 as the URIs of third level images. Set P as schema:about and rdfs:label. Set ?topic as the Chinese names of topics for images in work3.
3)Limit the query to images with the topic (?topic) of “Vimalakirti and Manjushri”.
4)The URIs of third level images (?work3) form part of (crm:P46i_forms_part_of) the URIs of higher second level structures (?work2).
5)Set the Chinese name (rdfs:label) of URIs of second level structures (?work2) as (?Parent).
6)To query the structural coordinates of second level images, the URIs of second level structures (?work2) is identified by (has_section/crm:P87_is_identified_by/rdfs:label) section coordinates (?Section).
7)The URIs of second level structures (?work2) form part of (crm:P46i_forms_part_of) the full URIs of higher first level works (?work).
8)Set ?work1 as the full URIs of first level works. Set P as schema:about and rdfs:label. Set ?topic as the Chinese names of work1.
9)Query the discovery of the works (?work1). Set P as crm:P12i_was_present_at. Set ?discovery as the URIs of the discoveries.
10)Set the discovery’s (?discovery) location (crm:P7_took_place_at) as (?Place).
11)Limit location results (?Place) to contain “province”.
1)Search for all items whose (O) value for Native Place (ascdc:Place) is Fujian (http://data.ascdc.tw/dnb/Place/0000007) in the dataset.
2)Select from the agents (S) of this group defined by step 1 those whose (O) value in Dynasty (ascdc:dynasty) is "Qing".
3)Search result will come in the order of Agent and Native Place.
1)Search for all items of Works (dbpedia-owl:created) within the dataset for Wang Shi-jen (王世貞): S as http://data.ascdc.tw/dnb/Agent/018406.
2)Search result will come in the order of Agent and Works.
1)Search for all items of Offices/ Postings (leo:involved) in the dataset, select (S) for the posting records (ascdc:OfficialService) from data whose (O) value literally contains “provincial governor of Anhui” (http://data.ascdc.tw/dnb/Position/0000066).
2)Search for agents (class,ascdc:Agent) involved in Posting Record (ascdc:officialEvent) from ascdc:OfficialService.
3)Search for the duration of office (class,time:temporalEntity) among items of “leo:atTime” defined by the search in step 1 (ascdc:OfficialService).
4)Search result will come in the order of Agent, Position, and Duration.
1)Search for (O) values (O/ class,ascdc:Name) labeled as Four Wangs (四王) within the category of Alternative Name (skos:altLabel) of the dataset.
2)Select form the agent group (S/ class,ascdc:Agent) defined by step 1 for the relationship of “agrelon:hasStudent” to locate agents (O) who have been their students.
3)Search result will come in the order of Agent and Student.
1)Search within the category of Specialty (dbpedia-owl:speciality) for (O) values literally containing "shufa" (calligraphy).
2)Search result will come in the order of Agent and Specialty.
1)Search within the dataset for Eight Banners (ascdc:eightBannersType) and select those whose (O) value literally contains "Manchu" (滿州), "Hanjun" (漢軍), and "Menggu" (蒙古).
2)Search result will come in the order of "Manchu", "Hanjun", and "Menggu".
1)Search for all items (O, class,ascdc:Name) in the category of Alternative Name (異名, skos:altLabel).
2)Select (O) values labeled as studio name (http://data.ascdc.tw/dnb/NameType/studioName) from the type of alternative name (ascdc:nameType).
3)At the same time, select the content from the (O) values above in Alternative Name (rdfs:label).
4)Search result will come in the order of Agent, Types of Alternative Names, and Label.
1)Search for all the (O) values (class,ascdc:Name) available in Alternative Name (skos:altLabel) from the Agent dataset of "Weng Fanggang" (S/ http://data.ascdc.tw/dnb/Agent/000105).
2)Select Alternative Name (rdfs: label), Name Type ((ascdc:type), and Source (dc:source) from the (O) values above.
3)Search result will come in the order of Agent, Alternative Name, Name Type, and Source.
1)Search within the dataset for native place (ascdc:nativePplace) and select the agents whose (O) value contains "Jiangsu" (http://data.ascdc.tw/dnb/Place/0000002), "Hubei" (http://data.ascdc.tw/dnb/Place/0000008), "Hunan" (http://data.ascdc.tw/dnb/Place/0000001) and "Zhejiang" (http://data.ascdc.tw/dnb/Place/0000024).
2)To locate agents in Qing dynasty, filter within Dynasty (ascdc:dynasty) and select those whose (O) value literally contains "Qing".
3)Search within the group of Qing agents for the (O) value of Imperial Examination (class,ascdc:ImperialExamination) in Examination Event (ascdc:imperialExaminationEvent) and the (O) value of jinshi (http://data.ascdc.tw/dnb/ResultType/003) in Event Type (leo:involved).
4)Search result will come in the order of Agent, Place, and Result Type.
1)Set S as the URI of agents, P as those whose (O) value corresponds to the URI of Qing (ascdc:dynastyPersonBirth).
2)Set S as the agent satisfying the quality of the URI in step 1 and O as the URI of Posting Event.
3)Set S as the (O) value of step 2, P as “leo:involved” and O as the URI corresponding to the post of zongdu in the control vocabulary of governmental posts.

[The following reasoning steps are for finding the 1st beginning year as governor-general/provincial governor of the a person]

4)Set the (O) value in step 3 as S, P as “leo:involved” and O as the URI of Posting Record. Reset the previously retrieved (O) value as S, P as “leo:atTime” and O as the URI of Office Duration.
5)Set the (O) value previously retrieved in step 4 as S, P as “time:hasBeginning” and O as the URI of Office Duration.
6)Set the (O) value previously retrieved in step 5 as S, P as “time:inXSDgYear” and O as the Office Duration in terms of the Common Era.
7)If the Governmental Post URI of agents satisfying the qualities defined by steps 1 – 3 precedes the range (http://data.ascdc.tw/dnb/Position/0000041) defined by steps 4 - 6 and have more than one set of Office Duration in terms of the Common Era, keep the chronologically earlier datum. Likewise, if the Governmental Post URI of an agent comes chronologically later than the range (http://data.ascdc.tw/dnb/Position/0000041) and has more than one set of Office Duration in terms of the Common Era, keep the datum that is chronologically the earliest.

[The following reasoning steps are for showing the result after the 1st beginning year as governor-general/provincial governor of the a person minus his birth year]

8)Set the URI of agents defined by steps 1 – 3 as S, P as “schema:birthDate”, and O as the year of birth in terms of the Common Era.
9)Deduct the result of step 8 from the result of step 7 and the sum amounts to the age of Qing agents when they first took up the post of zongdu.
1)Set S as the URI of agents, P as those whose (O) value corresponds to the URI of Qing (ascdc:dynastyPersonBirth).
2)Set S as the agent satisfying the quality of the URI in step 1 and O as the URI of Posting Event.
3)Set S as the (O) value of step 2, P as “leo:involved” and O as the URI corresponding to the post of zongdu in the control vocabulary of governmental posts.

[The following reasoning steps are for finding the 1st beginning year as governor-general/provincial governor of the a person]

4)Set the (O) value in step 3 as S, P as “leo:involved” and O as the URI of Posting Record. Reset the previously retrieved (O) value as S, P as “leo:atTime” and O as the URI of Office Duration.
5)Set the (O) value previously retrieved in step 4 as S, P as “time:hasBeginning” and O as the URI of Office Duration.
6)Set the (O) value previously retrieved in step 5 as S, P as “time:inXSDgYear” and O as the Office Duration in terms of the Common Era.
7)If the Governmental Post URI of agents satisfying the qualities defined by steps 1 – 3 precedes the range (http://data.ascdc.tw/dnb/Position/0000041) defined by steps 4 - 6 and have more than one set of Office Duration in terms of the Common Era, keep the chronologically earlier datum. Likewise, if the Governmental Post URI of an agent comes chronologically later than the range (http://data.ascdc.tw/dnb/Position/0000041) and has more than one set of Office Duration in terms of the Common Era, keep the datum that is chronologically the earliest.

[The following reasoning steps are for showing the result after the 1st beginning year as governor-general/provincial governor of the a person minus his birth year]

8)Set the URI of agents defined by steps 1 – 3 as S, P as “schema:birthDate”, and O as the year of birth in terms of the Common Era.
9)Deduct the result of step 8 from the result of step 7 and the sum amounts to the age of Qing agents when they first took up the post of zongdu.
1)Set S as the URI of agents, P as “ascdc:dynastyPersonBirth”, and O as the URI corresponding to the Qing dynasty.
2)Set S as the URI of agents satisfying the quality defined by step 1, P as “ascdc:imperialExamination”, and O as the URI of Posting Event.
3)Set S as the (O) value defined by step 2, P as “leo:involved” and select those whose (O) URI is "jinshi".
4)Set S as the URI of agents satisfying the quality defined by steps 1 – 3 and (O) as the value which is identical to ASCDC’s controlled vocabulary of Places and connected to the URI of TGAZ.
1)Set S as the URI of agents in the name authority files, P as “ascdc:imperialExamination”, and O as the URI of the event of imperial examination.
2)Set S as (O) value defined in step 1 and P as “leo:involved” and select those whose (O) value contains the URI of "jinshi".
3)Set the URI of agents satisfying the quality defined by steps 1 and 2 as S, P as related properties for personal relationship association and (O) stands for the agent’s URI or given name.
4)Set the (O) value defined by step 3 as S, P as “ascdc:imperialExamination”, and (O) as the URI of Posting Record.
5)Set S as the (O) value defined by step 4, P as “leo:involved” and select those whose (O) value contains "jinshi".
6)To conclude, the final S designates the URI of agents ranked as "jinshi", P as their kinship association and O designates family members conferred with the same rank.
1)In the in the LOD Database of Names (DNB), set the value S as http://data.ascdc.tw/dnb/Agent/NO000000105 and P as the value O of skos:altLabel, ascdc:nameType, rdfs:label, and dc:source.
2)In the in the LOD Database of Names (DNB), set the value S as http://data.ascdc.tw/dnb/Agent/NO000000105, the value P as owl:sameAs, and the value O as the triple of http://viaf.org/viaf/30871320.
3)In the Virtual International Authority File (VIAF), set S as http://viaf.org/viaf/30871320 and P as the value O of http://schema.org/name, http://schema.org/alternateName, http://schema.org/givenName, and http://www.w3.org/2004/02/skos/core#prefLabel.

1) Search and filter the data of the Work URIs and their identifier-properties in the Series-level of the Chinese Rare Books Database.
2) Search and filter the data of the Work URIs and their identifier-properties in the Monograph-level of the Chinese Rare Books Database.
3) Search and filter the data of the Work URIs and their identifier-properties in the Volume-level of the Chinese Rare Books Database.
4) Count the numbers by the level types as the Series, Monographs and Volumes.

1) Search the data values of Sibu-Classification, by using the property as ascdc:FSNLibraryClassHeading1, of all books in the Chinese Rare Books Database.
2) Count the numbers by different types of Sibu-Classification.

1) Search the data values of institutional repositories, by using the property as bf:heldBy, of all books in the Chinese Rare Books Database.
2) Count the numbers by different types of institutional repositories.

1) Search and list all the properties applied in the dataset.
2) Count the numbers by different property types.

Released soon

1) In the Database of Chinese Rare Books, set S as Book_Work URIs, set P as skos:prefLabel to search all the book titles as value O.
2) Set S as the Book_Work URIs from step 1, query those monograph Book_Work URIs containing the data field P of ascdc:FSNLibraryClassHeading1 with their data values.
3) Set S as the Book_Work URIs from step 1, query those monograph Book_Work URIs containing the data field P of ascdc:FSNLibraryClassHeading2 with their data values.
4) Display the results by BookWork URI, Label, Sibu_Classification1, Sibu_Classification2.

1) In the Database of Chinese Rare Books, set S as Book_Work URIs, set P as skos:prefLabel to search all the book titles as value O.
2) Set S as the Book_Work URIs from step 1, query those monograph Book_Work URIs containing the data field P of bf:hasInstance with monograph Book_Instance URIs.
3) Set S as the Book_Instance URIs from step 2, query those Book_Instance URIs containing the data field P of dbpedia-owl:dynasty.
4) Display the results by BookWork URI, Label, Dynasty.

1) In the Database of Chinese Rare Books, set S as Book_Work URIs, set P as skos:prefLabel to search all the book titles as value O.
2) Set S as the Book_Work URIs from step 1, query those monograph Book_Work URIs containing the data field P of bf:hasInstance with monograph Book_Instance URIs.
3) Set S as the Book_Instance URIs from step 2, query those Book_Instance URIs containing the data field P of dbpedia-owl:era.
4) Display the results by BookWork URI, Label, Era.

1) In the Database of Chinese Rare Books, set S as Book_Work URIs, set P as skos:prefLabel to search all the book titles as value O.
2) Set S as the Book_Work URIs from step 1, query those monograph Book_Work URIs containing the data field P of bf:hasInstance with monograph Book_Instance URIs.
3) Set S as the Book_Instance URIs from step 2, query those Book_Instance URIs containing the data field P of owl:versionInfo.
4) Display the results by BookWork URI, Label, VersionType.

1) In the Database of Chinese Rare Books, set S as Book_Work URIs, set P as skos:prefLabel to search al the book titles as value O.
2) Set S as the Book_Work URIs from step 1, query those monograph Book_Work URIs containing the data field P of bf:hasInstance with monograph Book_Instance URIs.
3) Set S as the Book_Instance URIs from step 2, query those Book_Instance URIs containing the data field P of bf:originPlace and rdfs:label with value of Place.
4) Set S as the Book_Instance URIs from step 3, query those Book_Instance URIs containing the data field P of owl:versionInfo with value of “Printed Version” (刊本).
5) Display the results by Work URI, Label, Instance URI, Place, Version.

1) Set all the data with the value S as Work URI and P as skos:prefLabel.
2) Retain the value S and set the value P as bf:title and O as VariantTitle URI. Then set the value S as VariantTitle URI, the value P as bf:variantType and rdfs:label, and the value O for the type of variant titles and strings of those variant titles.
3) Display the results by Work URI, Title, Varinat Title, Type of Variant Title.

1) Set the values of property as skos:prefLabel and their Instance URIs. Then set the Instance URI as S and the value O as the URI of Contribution by using bf:contribution.
2) Set the value S as Contribution URI, the value P as bf:agent and bf:role, and the value O as label of bf:agent and bf:role.
3) Order the sesults by Work URI, Title, Agent URI, Agent Name, Role URI and Role Type of the contributors.

1) For records in the LOD Database of Chinese Rare Books, set S as the Book_Work URIs, set the data field P as bf:hasInsatnce and set O as the Book_Instance URIs.
2) Set S as the Book_Work URIs from step 1, then query the data field P for those with O values of skos:prefLabel.
3) Set S as the Book_Work URIs from step 2, then query the data field P for those with O values of ascdc:FSNLibraryClassHeading1.
4) Set S as the Book_Instance URIs from step 1, then query the data field P of dbpedia-owl:era for those with O values of “Era of Publication.”
5) Set S as the Book_Instance URIs from step 1, then query the data field P of bf:date for those with O values of “Year of Publication” URIs.
6) Set S as the Year of Publication URIs from step 5, then query the data field P for those with O values of rdfs:label. Use“FILTER”to limit query results to those with "Year Names" labeled as Tianqi (天啟), Chongzhen (崇禎), Shunzi (順治), Kangxi (康熙), or Yongzheng (雍正).
7) Order results by Work, Title, Era, Year and Sibu-Classification.

1) In the LOD Dataset of Names and Biographies, find values of O, which has P as gndo:publication. Suppose this queried information as series (a). In the LOD Dataset of the Chinese Rare Books, set every S value as work URI, the P value as the O value of skos:prefLabel i.e. the title of books. Suppose this set of information as series (b). Compare (a) and (b). The overlap between (a) and (b) contains the title of publications and work URI in the LOD Dataset of the Chinese Rare Books.
2) Search person's name in the Database of Names and Biographies, which meet the query condition as mentioned in the step 1, by using the property as skos:prefLabel.
3) Display the Work URI and main title of publications listed in both the Dataset of the Chinese Rare Books and Person's URI of the Database of Names and Biographies and person name.

1) For records in the LOD Database of Chinese Rare Books, search data values of the property as skos:prefeLabel of all Work URIs.
2) Set S as the Work URIs from step 1, then query the data field P of bf:hasInstance and set O as the Instance URIs.
3) Set S as the Instance URIs from step 2, then query the data field P of bf:editionStatement and set those values as O.
4) Order results by Work, Title and Edition_Statement.

1) For records in the LOD Database of Chinese Rare Books, set S as the Part Instance URIs that contain the property values in the data field of the "lines per page" (行款).
2) Set S as the Part_Instance URIs from step 1, then query the data field P of bf:partOf and set O as the Book_Instance URIs.
3) Set O as the Book_Instance URIs from step 2, then query the data field P of bf:hasInstance and set S as the monograph Book_Work URIs.
4) Set S as the Book_Instance URIs from step 3, then query the data field P for those O values of skos:prefLabel.
5) Order results by BookWork, Label, LinesPerPage.

1) For records in the LOD Database of Chinese Rare Books, set S as the Part_Instance URIs that contain the property values in the data field of the “type of framing line” (邊欄).
2) Set S as the Part_Instance URIs from step 1, then query the data field P of bf:partOf and set O as the Book_Instance URIs.
3) Set O as the Book_Instance URIs from step 3, then query the data field P of bf:hasInstance and set S as the Book_Work URIs.
4) Set S as the Book_Work URIs from step 5, then query the data field P of skos:prefLabel and set those values as O.
5) Order results by Instance BookWork, Label, FramengLineType.

1) For records in the LOD Database of Chinese Rare Books, set S as the Part_Instance URIs that contain the property values in the data field of “YuWei pattern” (魚尾).
2) Set S as the Part_Instance URIs from step 1, then query the data field P of bf:partOf and set O as the Book_Instance URIs.
3) Set O as the Book_Instance URIs from step 2, then query the data field P of bf:hasInstance and set S as the Book_Work URIs.
4) Set S as the Book_Work URIs from step 4, then query the data field P of skos:prefLabel and set those values as O.
5) Order results by BookWork, Label and YuWei.

1) Locate every Work URI in the level of monographies, which contains value as 方志 (local history chrpnicles) in data field of bf:subject.
2) Look for the content in the field of ascdc:FSNLibraryClassHeading in the Work URIs obtained in step 1.
3) Look for the Work URI of the Library of Congress (LC) in the field of owl:sameAs in the Work URIs obtained in step 1.
4) Look for the URI in the field of bf:subject of the LC Work URIs obtained in step 3.
5) Look for the value in the field of rdfs:label in the URI as obtained in step 4.
6) Order results by CRB Work, CRB Subject, LC Work, LC Subject.

1) Locate every Work URI in the level of monographies, which contains value as 嘉興府志 (Jiaxingfuzhi) in data field of skos:prefLabel.
2) Select the Works URI beginning with "http://data.ascdc.tw/Book/crb/Book_Work/" from the results queried in the step 1.
3) Look for the Instance URI in the field of bf:hasInstance from the Work URIs obtained in step 2.
4) Look for the value in the field of bf:editionStatement in the Instance URI obtained in step 3.
5) Look for the LC Work URI in the field of owl:sameAs and rdfs:seeAlso in the Work URI obtained in step 2.
6) Look for the LC Instance URIs in the field of bf:hasInstance from the LC Work URI obtained in step 5.
7) Look for the values marked with language type as @zh-hani in the field of bf:editionStatement in the LC Instance URIs obtained in step 6.
8) Order results by CRB Work, CRB Label, CRB Edition, LC Work, LC Edition.

1) For records in the LOD Database of Chinese Rare Books, set S as the Monograph Work URIs, set the Sibu-classification (四部分類) data field P as bf:subject, and set O as “春秋”(Chunqiu).
2) Set S as the Book_Work URIs from step 1, then query those monograph Book_Work URIs containing the data field P of skos:prefLabel with value of monograph's Label.
3) Set S as the Book_Work URIs from step 2, then query those monograph Book_Work URIs containing the data field P of bf:hasInstance with monograph Book_Instance URIs.
4) Set S as the Book_Instance URIs from step 3, then query those monograph Book_Instance URIs containing the data field P of dbpedia-owl:dynasty with value of Dynasty.
5) Set S as the Book_Instance URIs from step 4, then query those monograph Book_Instance URIs containing the data field P of dbpedia-owl:era with value of Era.
6) Set S as the Book_Instance URIs from step 5, then query those monograph Book_Instance URIs containing the data field P of owl:versionInfo with value of Version.
7) Order results by Instance BookWork, Label, Sibu, Dynasty, Era, Version.

1) Set the value S as the Instance URI of monographs in question, the value P as bf:date, and the value Era as the URI of regnal year.
2) Display values Era URIs as S and labels of those Era URIs.
3) Look for the sum of every Era value in the column for numbers.

1) Set every value S as "Work" (referring to the single monograph) and the Instance URI, the value P as the value O for bf:contribution and bf:agent to obtain the literal names of people to which the O values correspond.
2) Set the value S as "Work" and the Instance URI of the data fields obtained through step 1 and set the value P as the value O of dcterms:identifier.
3) Set the value S as the Work URI of the data fields obtained through step 1 and the value P as the value O of skos:prefLabel.
4) Display the monographs' URI, titles of label, and names of contributors associated with the volume.

1) For records in the LOD Database of Chinese Rare Books, set S as the Part Instance URIs, set the lines per page (行款) data field P as ascdc:linesPerPage, and set O as “10 lines 20 words” or “ten lines twenty words.”
2) Set S as the Part_Instance URIs from step 1, then query the data field P of bf:partOf and set O as the Book_Instance URIs.
3) Set S as the Book_Instance URIs from step 2, then query those monograph Book_Instance URIs containing the data field P of owl:versionInfo with the value of Edition (刊本).
4) Set S as the Book_Instance URIs from step 3, then query those monograph Book_Instance URIs containing the data field P of dbpedia-owl:era and dbpedia-owl:dynasty.
5) Set O as the Book_Instance URIs from step 4, then query the data field P of bf:hasInstance and set S as the monograph Book_Work URIs.
6) Set S as the Book_Instance URIs from step 5, then query the data field P for those with O values of ascdc:FSNLibraryClassHeading1 and ascdc:FSNLibraryClassHeading2.
7) Set S as the Book_Instance URIs from step 6, then query the data field P for those O values of skos:prefLabel.
8) Order results by BookWork, LinesPerPage, Label, Version, Dynasty, Era, Subject1 and Subject2.

1) For records in the LOD Database of Chinese Rare Books, set S as the Part_Instance URIs that contain both the “margin line” (邊欄) data field P set as ascdc:framelineType with the value of “double-framed margin line” (雙欄), and the “YuWei pattern” (魚尾) data field P set as ascdc:yuWei with the value of “double YuWei pattern” (雙魚尾).
2) Set S as the Part_Instance URIs from step 1, then query the data field P of bf:partOf and set O as the Book_Instance URIs.
3) Set S as the Book_Instance URIs from step 2, then query the “dynasty” data field P of dpedia-owl:dynasty and set those values as O.
4) Set O as the Book_Instance URIs from step 3, then query the data field P of bf:hasInstance and set S as the Book_Work URIs.
5) Set S as the Book_Work URIs from step 4, then query the data field P of ascdc:FSNLibraryClassHeading1 and set those values as O.
6) Set S as the Book_Work URIs from step 5, then query the data field P of skos:prefLabel and set those values as O.
7) Order results by Instance BookWork, Label, FrameLineType, Subject, YuWei, and DynastyLabel.

This is a template of "What was the first position of whom had been a "OOO" in the Qing dynasty?". (Default option of "OOO" is "總督".)
"OOO" can be filled with any other title of office from the following databse:" http://archive.ihp.sinica.edu.tw/officerc/officerkm2?"

How to use:
Freely enter the title of office you picked (full name or key words in Chinese) in the ’ ’ at line 9 of "Query examples" area, such as ’安徽巡撫’ and ’布政使’. Then click the submit buttom to get your own result.

Result (Triples):
1. "name": Names of officers correspand to the requirements in this question from the DNB LOD-based dataset.
"Position": Titles of office of whom are correspand to the requirements in this question.
"First Position(DNB)": The first title of office in career of whom are correspand to the requirements in this question.(Records from DNB LOD-based dataset)
"First Position(DQOT)": The first title of office in career of whom are correspand to the requirements in this question.(Records linked to DQOT LOD-based dataset)
2. There are 4 formats for downloading: JSON, XML, TTL, CSV. CSV files can be opened with Microsoft® Office Excel.
3. The formal names of some titles are identical to the others’ alias, so they are both shown in the result.

*DNB LOD-based dataset: Database of Names and Biographies LOD-based dataset
*DQOT LOD-based dataset: Database of Qing Official Titles LOD-based dataset

This is a template of "Was the order "OOO"→"OOO" →"OOO" a common career path in the Qing dynasty?". (Default options of "OOO" are "按察使", "布政使", and "巡撫".)
"OOO" can be filled with any other title of office from the following databse:" http://archive.ihp.sinica.edu.tw/officerc/officerkm2?"

How to use:
Freely enter the title of office you picked (full name or key words in Chinese) in the ’ ’ at line 12 of "Query examples" area, such as ’安徽巡撫’ and ’布政使’. Then click the submit buttom to get your own result.

Result (Triples):
1. "Name": Names of officers correspand to the requirements in this question from the DNB LOD-based dataset.
"Position 1": The first title of office of whom are correspand to the requirements in this question.
"Position 2": The second title of office of whom are correspand to the requirements in this question.
"Position 3": The third title of office in career of whom are correspand to the requirements in this question.
(The numbers 1,2,3 just represent the order of titles in the specific path.)
2. There are 4 formats for downloading: JSON, XML, TTL, CSV. CSV files can be opened with Microsoft® Office Excel.
3. The formal names of some titles are identical to the others’ alias, so they are both shown in the result.

*DNB LOD-based dataset: Database of Names and Biographies LOD-based dataset

This is a template of "How many bannermen (qiren) and civilians (minren) were there respectively of whom had been a "OOO" in the Qing dynasty?". (Default option of "OOO" is "巡撫".)
"OOO" can be filled with any other title of office from the following databse:" http://archive.ihp.sinica.edu.tw/officerc/officerkm2?"

How to use:
Freely enter the title of office you picked (full name or key words in Chinese) in the ’ ’ at line 9 of "Query examples" area, such as ’安徽巡撫’ and ’布政使’. Then click the submit buttom to get your own result.

Result (Triples):
1. "Name": Names of officers correspand to the requirements in this question from the DNB LOD-based dataset.
"Position": Titles of office of whom are correspand to the requirements in this question.
"EightBanners": The records of Eight Banners of whom are correspand to the requirements in this question. (Blank:civilians (minren) )
2. There are 4 formats for downloading: JSON, XML, TTL, CSV. CSV files can be opened with Microsoft® Office Excel.
3. The formal names of some titles are identical to the others’ alias, so they are both shown in the result.

*DNB LOD-based dataset: Database of Names and Biographies LOD-based dataset

This is a template of "How many bannermen (qiren) belonged to "XX" ,and also were a "OOO" in the Qing dynasty?". (Default option of "XX" is "漢軍", and "OOO" is "巡撫".)
"OOO" can be filled with any other title of office from the following databse:" http://archive.ihp.sinica.edu.tw/officerc/officerkm2?"

How to use:
Freely enter the value you want (full name or key words in Chinese) in the ’ ’ at line 10 and line 11 of "Query examples" area, such as ’安徽巡撫’ , ’布政使’, ’滿洲’ , and ’正紅旗’. Then click the submit buttom to get your own result.

Result (Triples):
1. "Name": Names of officers correspand to the requirements in this question from the DNB LOD-based dataset.
"Position": Titles of office of whom are correspand to the requirements in this question.
"EightBanners": The records of Eight Banners of whom are correspand to the requirements in this question.
2. There are 4 formats for downloading: JSON, XML, TTL, CSV. CSV files can be opened with Microsoft® Office Excel.
3. The formal names of some titles are identical to the others’ alias, so they are both shown in the result.

*DNB LOD-based dataset: Database of Names and Biographies LOD-based dataset

This is a template of "What were the imperal examination results of whom had been a "OOO" in the Qing dynasty?". (Default option of "OOO" is "巡撫".)
"OOO" can be filled with any other title of office from the following databse:" http://archive.ihp.sinica.edu.tw/officerc/officerkm2?"

How to use:
Freely enter the title of office you picked (full name or key words in Chinese) in the ’ ’ at line 10 of "Query examples" area, such as ’安徽巡撫’ and ’布政使’. Then click the submit buttom to get your own result.

Result (Triples):
1. "Name": Names of officers correspand to the requirements in this question from the DNB LOD-based dataset.
"Position": Titles of office of whom are correspand to the requirements in this question.
"ImperialExamination": The resords of imperial examination of whom are correspand to the requirements in this question.
2. There are 4 formats for downloading: JSON, XML, TTL, CSV. CSV files can be opened with Microsoft® Office Excel.
3. The formal names of some titles are identical to the others’ alias, so they are both shown in the result.

*DNB LOD-based dataset: Database of Names and Biographies LOD-based dataset

This is a template of "What were the specialties of whom had been a "OOO" in the Qing dynasty?". (Default option of "OOO" is "巡撫".)
"OOO" can be filled with any other title of office from the following databse:" http://archive.ihp.sinica.edu.tw/officerc/officerkm2?"

How to use:
Freely enter the title of office you picked (full name or key words in Chinese) in the ’ ’ at line 11 of "Query examples" area, such as ’安徽巡撫’ and ’布政使’. Then click the submit buttom to get your own result.

Result (Triples):
1. "Name": Names of officers correspand to the requirements in this question from the DNB LOD-based dataset.
"Position": Titles of office of whom are correspand to the requirements in this question.
"Specialty": The resords of specialty of whom are correspand to the requirements in this question. (Some records are linked to Art & Architecture Thesaurus Online, AAT )
2. There are 4 formats for downloading: JSON, XML, TTL, CSV. CSV files can be opened with Microsoft® Office Excel.
3. The formal names of some titles are identical to the others’ alias, so they are both shown in the result.

*DNB LOD-based dataset: Database of Names and Biographies LOD-based dataset

This is a template of "Where were the nativeplaces of whom had been a "OOO" in the Qing dynasty?". (Default option of "OOO" is "巡撫".)
"OOO" can be filled with any other title of office from the following databse:" http://archive.ihp.sinica.edu.tw/officerc/officerkm2?"

How to use:
Freely enter the title of office you picked (full name or key words in Chinese) in the ’ ’ at line 11 of "Query examples" area, such as ’安徽巡撫’ and ’布政使’. Then click the submit buttom to get your own result.

Result (Triples):
1. "Name": Names of officers correspand to the requirements in this question from the DNB LOD-based dataset.
"Position": Titles of office of whom are correspand to the requirements in this question.
"NativePlace": The resords of native place of whom are correspand to the requirements in this question.
"TGAZ API": Records of native placename linked to "Temporal Gazetteer API, The China Historical Geographic Information System".
2. There are 4 formats for downloading: JSON, XML, TTL, CSV. CSV files can be opened with Microsoft® Office Excel.
3. The formal names of some titles are identical to the others’ alias, so they are both shown in the result.

*DNB LOD-based dataset: Database of Names and Biographies LOD-based dataset

This is a template of "In the Qing dynasty, who were the fathers, ancestors, and friends of whom had been a "OOO" ?". (Default option of "OOO" is "巡撫".)
"OOO" can be filled with any other title of office from the following databse:" http://archive.ihp.sinica.edu.tw/officerc/officerkm2?"

How to use:
Freely enter the title of office you picked (full name or key words in Chinese) in the ’ ’ at line 11 of "Query examples" area, such as ’安徽巡撫’ and ’布政使’. Then click the submit buttom to get your own result.

Result (Triples):
1. "Name": Names of officers correspand to the requirements in this question from the DNB LOD-based dataset.
"Father": Names of officers’ fathers correspand to the requirements in this question from the DNB LOD-based dataset.
"Ancestors": Names of officers’ ancestors correspand to the requirements in this question from the DNB LOD-based dataset.
"Friends": Names of officers’ friends correspand to the requirements in this question from the DNB LOD-based dataset.
2. There are 4 formats for downloading: JSON, XML, TTL, CSV. CSV files can be opened with Microsoft® Office Excel.
3. The formal names of some titles are identical to the others’ alias, so they are both shown in the result.

*DNB LOD-based dataset: Database of Names and Biographies LOD-based dataset

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field value (O) of "two rows," and set the "format type" (形制類型) data field (P) as crm:P2_has_type/rdfs:label.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of schema:identifier and set O as the ID numbers.

3. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P24i_changed_ownership_through/crm:P134i_was_continued_by/crm:P7_took_place_at/rdfs:label and set O as the excavation sites.

4. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P108i_was_produced_by/crm:P4_has_time-Span/crm:P10_falls_within/rdfs:label and set O as the dynasty of origin.

5. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P43_has_dimension/crm:P90_has_value and set O as the measurements of length, width, thickness, etc.

6. Order results by wooden slip URI (Item), wooden slip number (ID), format (FormatType), excavation site (Place), dynasty of origin (Period), Length, Width, Thickness, and Weight.

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field (O) of "perforation" (穿孔) and set the "decoration" (紋飾特徵) data field (P) as crm:P111i_was_added_by / rdfs:label.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of P2_has_type/rdfs:label and set O as the formats.

3. Set S as the wooden slip URIs from step 1, then query the data field (P) of schema:identifier and set O as the ID numbers.

4. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P24i_changed_ownership_through/crm:P134i_was_continued_by/crm:P7_took_place_at/rdfs:label and set O as the excavation sites.

5. Order results by wooden slip URI (Item), wooden slip number (ID), Decoration, format (FormatType), and excavation site (Place).

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field value (O) of "zhuan" (傳) and set the "inscription word" (釋文單字) data field (P) as crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / rdfs:label.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / dcterms:type/ rdfs:label and set O as the script style.

3. Set S as the wooden slip URIs from step 2, then query the data field (P) of crm:P24i_changed_ownership_through / crm:P134i_was_continued_by / crm:P7_took_place_at / rdfs:label and set O as the excavation site.

4. Set S as the wooden slip URIs from step 3, then query the data field (P) of crm:P108i_was_produced_by / crm:P4_has_time-Span / rdfs:label and set O as the time of creation.

5. Order results by wooden slip URI (Item), Word, Script, Place, and Time.

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field (O) of "burn marks" (燒痕) and set the "decoration" (紋飾特徵) data field (P) as crm:P111i_was_added_by / rdfs:label.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P24i_changed_ownership_through / crm:P134i_was_continued_by / crm:P7_took_place_at / rdfs:label and set O as the excavation sites.

3. Set S as the wooden slip URIs from step 1, then query the data field (P) of schema:identifier and set O as the ID numbers.

4. Order results by wooden slip URI (Item), wooden slip number (ID), Decoration, and excavation site (Place).

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field (O) of "human face format" (人面形) and "image format" (圖形), and set the "decoration" (紋飾特徵) data field (P) as crm:P111i_was_added_by / rdfs:label.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P2_has_type / rdfs:label ?FormatType and set O as the formats.

3. Set S as the wooden slip URIs from step 1, then query the data field (P) of schema:identifier and set O as the ID numbers.

4. Order results by wooden slip URI (Item), wooden slip number (ID), Decoration, and format (FormatType).

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field value (O) of "practice characters" (習字) and set the "Style" (書寫特徵) data field (P) as crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / dcterms:description.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / rdfs:label and set O as the words on the slip.

3. Set S as the wooden slip URIs from step 2, then query the data field (P) of crm:P2_has_type / rdfs:label and set O as the formats.

4. Set S as the wooden slip URIs from step 3, then query the data field (P) of schema:identifier and set O as the ID numbers.

5. Order results by wooden slip URI (Item), ID, Script, Style, and format (FormatType).

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field (O) of "human face talisman" (人面符) and set the "format" (形制) data field (P) as crm:P2_has_type / rdfs:label.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P65_shows_visual_item / crm:P2_has_type / rdfs:label and set O as the wooden slip URIs with “color photographs” (彩色照片).

3. Set S as the wooden slip URIs from step 2, then query the data field (P) of schema:identifier and set O as the ID numbers.

4. Set S as the wooden slip URIs from step 3, then query the data field (P) of owl:sameAs and set O as the Wooden Slip Character Dictionary URLs.

5. Order results by wooden slip URI (Item), wooden slip number (ID), format (FormatType), and Wooden Slip Character Dictionary URLs (WCD_URL).

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field value (O) of "clerical script" (隸書) and set the "calligraphic style" (文字書體) data field (P) as crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / dcterms:type / rdfs:label.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P2_has_type / rdfs:label and set O as the formats.

3. Set S as the wooden slip URIs from step 2, then query the data field (P) of schema:identifier and set O as the ID numbers.

4. Order results by wooden slip URI (Item), ID, Script, and format (FormatType).

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field value (O) of "yue" (月), "shi" (石), "dou" (斗), or "sheng" (升) and set the "inscription word" (釋文單字) data field (P) as crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / rdfs:label.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / schema:url and set O as the Wooden Slips Character Dictionary URLs.

3. Set S as the wooden slip URIs from step 2, then query the data field (P) of schema:identifier and set O as the ID numbers.

4. Set S as the wooden slips URIs from step 3, then query the data field (P) of crm:P24i_changed_ownership_through / crm:P134i_was_continued_by / crm:P7_took_place_at / rdfs:label and set O as "A8 City Ruins" (A8 破城子) excavation sites.

5. Set as the wooden slips URIs from step 4, then query the data field (P) of schema:identifier and set O as the ID numbers.

6. Order results by wooden slip URI (Item), ID, Word, Place, and Wooden Slips Character Dictionary URL (WCD-URL).

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field value (O) of "lingshichong" (令史充) or "/lingshichong" (╱令史充) and set the "recognized word content" (釋文內容) data field (P) as crm:P128_carries / dcterms:description.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P24i_changed_ownership_through / crm:P134i_was_continued_by / crm:P7_took_place_at / rdfs:label and set O as the excavation sites.

3. Set S as the wooden slip URIs from step 2, then query the data field (P) of schema:identifier and set O as the ID numbers.

4. Set S as the wooden slips URIs from step 3, then query the data field (P) of crm:P108i_was_produced_by / crm:P4_has_time-Span / rdfs:label and set O as the time of creation.

5. Order results by wooden slip URI (Item), ID, Inscription, Place, and Time.

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field value (O) of "zhuan" (專) and set the "character component" (單字部件) data field (P) as crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / ascdc:characterComponent.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P128_carries / crm:P3_has_note / crm:P67_refers_to / dcterms:type / rdfs:label and set O as the words written in "clerical script" (隸書).

3. Order results by wooden slip URI (Item), Word, Component, and Script.

1. For records in the Wooden Slips Database, set S as the wooden slip URIs with a data field (O) of notched" (刻齒) and set the "decoration" (紋飾特徵) data field (P) as crm:P111i_was_added_by / rdfs:label.

2. Set S as the wooden slip URIs from step 1, then query the data field (P) of crm:P24i_changed_ownership_through / crm:P134i_was_continued_by / crm:P7_took_place_at / rdfs:label and set O as the excavation sites.

3. Set S as the wooden slip URIs from step 2, then query the data field (P) of crm:P2_has_type / rdfs:label and set O as the formats.

4. Set S as the wooden slip URIs from step 3, then query the data field (P) of schema:identifier and set O as the ID numbers.

5. Order results by wooden slip URI (Item), wooden slip number (ID), Decoration, and format (FormatType).

1) Search the place name containing value with ""Chishang Township"" (池上鄉) by using property as ""gn:parentADM3.""\n2) Search reference titles containing value with ""Chishang"" (池上) by using property as ""schema:name.""\n3) Search titles of government materials containing value with ""Chishang"" (池上) by using property as ""schema:name.""\n4) Search events and multimedia that happen or are collected in Chishang.\n5) Search titles of field investigation reports containing value with ""Chishang"" (池上) by using property as ""schema:name.""\n6) Combine the data obtained from the above steps and display the results after data URI, titles and types of dataset.

1) Search the field location where the local natural crops (dbo:produces) are ""rice"".\n2) Seach the demographic information, such as population (gn:population), male population (ascdc:populationMen), female population (ascdc:populationFemale),elderly population (ascdc:populationOver65), of the field location, which is retrieved by the aforesaid step.

1) Search all the events (valued as ""ReportEventType=001"") related to the ""god-inviting ceremony"" during the Zhongyuan festival in Chishang Township.\n2) Search the time of event (schema:startDate), place of event (schema:location), longitude (schema:latitude) and latitude (schema:longitude) of the place (schema:longitude), and the statues of god or their representatives (dcterms:relation) obtained after each ceremony.

1) Search and list all the types of class instances (rdf:type) contained in the dataset.\n2) Count the number of instances by different class types (rdf:type).

1) Search and list all the properties applied in the dataset.\n2) Count the numbers by different property types.

1) Search and list the title (dcterms:title), description (dcterms:description), publisher (dcterms:publisher) and released date (dcterms:issued) of the SCSRT-dataset, which is structured after the DCAT model. \n2) Search and list the license condition (dcterms:license), URL allocation (dcat:accessURL), capacity (dcat:byteSize) and compressed format (dcat:compressedFormat) of the SCSRT-dataset, which is structured in the class of ""Distribution"" as designed in the DCAT model.