Category

Query examples

SPARQL query reasoning

EX1. All juvenile fish specimens PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/>\nSELECT ?s dwc_terms:scientificName ?scientificName\nFROM <http://data.ascdc.tw/uc/bio/>\nWHERE {\n?s dwc_terms:lifeStage <http://data.ascdc.tw/terms/bio/Juvenile>;\n<http://purl.org/dc/terms/type> <http://dbpedia.org/resource/Specimen>.\n?s dwc_terms:scientificName ?scientificName.\n} EX2. Body lenth of fish specimen over 1000 mm PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/>\nPREFIX ascdc-props_bio: <http://data.ascdc.tw/property/bio/>\nSELECT ?s dwc_terms:scientificName ?scientificName\nFROM <http://data.ascdc.tw/uc/bio/>\nWHERE {\n?s ascdc-props_bio:SL|ascdc-props_bio:minSL ?minSL;\n<http://purl.org/dc/terms/type> <http://dbpedia.org/resource/Specimen>.\n?s dwc_terms:scientificName ?scientificName.\nFILTER ( ?minSL > 1000 ).\n} EX3. "Stromateidae" as family name PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/>\nPREFIX txn: <http://lod.taxonconcept.org/ontology/txn.owl#>\nSELECT ?s dwc_terms:scientificName ?scientificName\nFROM <http://data.ascdc.tw/uc/bio/>\nFROM <http://data.ascdc.tw/taicol/>\nWHERE {\n?s dwc_terms:scientificName ?concept.\n?concept txn:inFamily <http://data.ascdc.tw/taicol/family/Animalia_Stromateidae>.\n?s dwc_terms:scientificName ?scientificName.\n} EX4. "Formosana" as Specific Epithet PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/>\nPREFIX txn: <http://lod.taxonconcept.org/ontology/txn.owl#>\nSELECT ?s dwc_terms:scientificName ?scientificName\nFROM <http://data.ascdc.tw/uc/bio/>\nFROM <http://data.ascdc.tw/taicol/>\nWHERE {\n?s dwc_terms:scientificName ?concept.\n?concept (txn:synonymName|txn:acceptedName)/txn:specificEpithet 'formosana'.\n?s dwc_terms:scientificName ?scientificName.\n} EX5. Objects have "海馬(Hhppocampus)" as Chhnese vernacular name? PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/>\nSELECT ?s dwc_terms:vernacularName ?vernacularName\nFROM <http://data.ascdc.tw/uc/bio/>\nWHERE {\n?s dwc_terms:vernacularName ?vernacularName.\nFILTER langMatches(LANG(?vernacularName), 'zh').\nFILTER contains(STR(?vernacularName), '海馬').\n} EX6. Bottom trawling as method by fish sampling PREFIX dwc_terms: <http://rs.tdwg.org/dwc/terms/>\nSELECT ?s dwc_terms:scientificName ?scientificName\nFROM <http://data.ascdc.tw/uc/bio/>\nWHERE {\n?s dwc_terms:samplingProtocol '底拖網'@zh.\n?s dwc_terms:scientificName ?scientificName.\n}
EX1. Clothing items in red color from the Atayal and Bunun tribesPREFIX schema: <http://schema.org/>\nPREFIX ascdc-props_anth: <http://data.ascdc.tw/property/anth/>\nPREFIX AAT: <http://vocab.getty.edu/ontology#>\nSELECT ?s rdfs:label ?title\nFROM <http://data.ascdc.tw/uc/anth/ntm/>\nWHERE {\n ?s ascdc-props_anth:hasRelatedTribe ?o.\n?s schema:color ?o2.\n?s AAT:aat2218_used-function_as ?o3.\n?s rdfs:label ?title.\nFILTER (Contains(STR(?o), 'Bunun') || Contains(STR(?o), '布農') || Contains(STR(?o), 'Atayal') || Contains(STR(?o), '泰雅') ) .\n FILTER (Contains(STR(?o2), '紅色') || Contains(STR(?o2), '300126225')) .\nFILTER (Contains(STR(?o3), '300266639')) .\nFILTER (langMatches(Lang(?title), 'zh')) .} EX2. Objects made of wood and decorated with strippe pattern PREFIX schema: <http://schema.org/>\nPREFIX ascdc: <http://data.ascdc.tw/property/>\nSELECT ?s rdfs:label ?title\nFROM <http://data.ascdc.tw/uc/anth/ntm/>\nWHERE {\n?s ascdc:hasAddedDecoration ?o.\n?s schema:material ?o2.\n?s rdfs:label ?title.\nFILTER (Contains(STR(?o), '條紋')) .\nFILTER (Contains(STR(?o2), '木頭') || Contains(STR(?o2), '300011914')) .\nFILTER (langMatches(Lang(?title), 'zh')) .} EX3. Objects made of glass and having length over 800 mm. PREFIX schema: <http://schema.org/>\nPREFIX ascdc: <http://data.ascdc.tw/property/>\nSELECT ?s rdfs:label ?title\nFROM <http://data.ascdc.tw/uc/anth/ntm/>\nWHERE {\n?s schema:material ?o.\n?s ascdc:length ?length.\n?s rdfs:label ?title.\nFILTER (Contains(STR(?o), '玻璃') || Contains(STR(?o), '300010797')) .\nFILTER (?length >= 800).\nFILTER (langMatches(Lang(?title), 'zh')) .} EX4. Finding the subjects of all digitized items PREFIX dcterms: <http://purl.org/dc/terms/>\nselect ?title (COUNT(?title) AS ?count)\nFROM <http://data.ascdc.tw/uc/anth/ntm/>\nFROM <http://vocab.getty.edu/aat/>\nWHERE {\n{ ?s dcterms:subject ?title\nFILTER langMatches(Lang(?title), 'zh')}} EX5. Objects collected in Taitung PREFIX sam: <http://def.seegrid.csiro.au/isotc211/iso19156/2011/sampling#>\nSELECT ?s rdfs:label ?title\nFROM <http://data.ascdc.tw/uc/anth/ntm/>\nFROM <http://vocab.getty.edu/aat/>\nWHERE {\n?s sam:sampling_location ?o.\n?s rdfs:label ?title.\nFILTER (Contains(STR(?o), '台東') || Contains(STR(?o), '臺東')) .\nFILTER (langMatches(Lang(?title), 'zh')) .}
EX1. What are the series and number of items contained in each series in the archive of the "Chen Cheng-po's paintings and documents"? prefix locah:<http://data.archiveshub.ac.uk/def/>\nselect *\nfrom <http://data.ascdc.tw/archive/ith/ccp/>\nwhere{\n?series locah:level <http://data.archiveshub.ac.uk/id/level/series>;\nrdfs:label ?label;\nlocah:item ?item.\n} 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/>\nprefix dcterms:<http://purl.org/dc/terms/>\nselect *\nfrom <http://data.ascdc.tw/archive/ith/ccp/>\nwhere{\n?item locah:level <http://data.archiveshub.ac.uk/id/level/item>;\ndcterms:isPartOf <http://data.ascdc.tw/archive/ith/ccp/CCP_02_02>;\nrdfs:label ?label;\ndcterms:alternative ?alternative;\ndc:date ?date.\n} EX3. Which of Chen's paintings are created on canvas? What are the titles of his paintings on canvas? prefix locah:<http://data.archiveshub.ac.uk/def/>\nprefix dcterms:<http://purl.org/dc/terms/> \nselect ?item ?label <http://vocab.getty.edu/aat/300014078> as ?medium\nfrom <http://data.ascdc.tw/archive/ith/ccp/>\nwhere{\n?item locah:level <http://data.archiveshub.ac.uk/id/level/item>;\ndcterms:medium <http://vocab.getty.edu/aat/300014078>;\nrdfs:label ?label.\n} EX4. Which of Chen's paintings contain naked women? What are the title of these paintings and their files? prefix locah:<http://data.archiveshub.ac.uk/def/>\nprefix dcterms:<http://purl.org/dc/terms/> \nselect *\nfrom <http://data.ascdc.tw/archive/ith/ccp/>\nwhere{\n?item locah:level <http://data.archiveshub.ac.uk/id/level/item>;\nrdfs:label ?ItemLabel.\nfilter contains(str(?ItemLabel), '裸女').\nOPTIONAL{?item dcterms:isPartOf/rdfs:label ?fileLabel}\n} EX5. During Chen's studentship at the Tokyo School of Fine Arts, which paintings depict the landscape of Chiayi? What are their date(s) of creation? prefix locah:<http://data.archiveshub.ac.uk/def/>\nprefix dcterms:<http://purl.org/dc/terms/> \nselect ?item, ?file, <http://vocab.getty.edu/tgn/7468019> as ?place, ?date\nfrom <http://data.ascdc.tw/archive/ith/ccp/>\nwhere{\n?item locah:level <http://data.archiveshub.ac.uk/id/level/item>;\ndcterms:spatial <http://vocab.getty.edu/tgn/7468019>;\ndc:date ?date.\n?item dcterms:isPartOf <http://data.ascdc.tw/archive/ith/ccp/CCP_01_01>.\n<http://data.ascdc.tw/archive/ith/ccp/CCP_01_01> rdfs:label ?file.\nfilter contains(str(?file), '東京美術學校求學時期油畫作品').\n} EX6. What (actual) places does Chen paint? How often do they occur? prefix locah:<http://data.archiveshub.ac.uk/def/>\nprefix dcterms:<http://purl.org/dc/terms/> \nselect *\nfrom <http://data.ascdc.tw/archive/ith/ccp/>\nwhere{\n?item locah:level <http://data.archiveshub.ac.uk/id/level/item>;\nrdfs:label ?label;\ndcterms:spatial ?place.\n} 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/>\nprefix dcterms:<http://purl.org/dc/terms/> \nselect *\nfrom <http://data.ascdc.tw/archive/ith/ccp/>\nwhere{\n?item locah:level <http://data.archiveshub.ac.uk/id/level/item>;\nrdfs:label ?label;\nrdfs:seeAlso ?related.\nfilter contains(str(?label), '臺灣美術展覽會').\n} EX8. Which western artists appear in Chen's collage? Please locate the name of these artists and their data in ULAN. prefix locah:<http://data.archiveshub.ac.uk/def/>\nprefix dcterms:<http://purl.org/dc/terms/> \nselect ?item, ?person, ?ulan\nfrom <http://data.ascdc.tw/archive/ith/ccp/>\nwhere{\n?item locah:level <http://data.archiveshub.ac.uk/id/level/item>;\ndcterms:isPartOf <http://data.ascdc.tw/archive/ith/ccp/CCP_09_01>;\ndc:subject ?subject.\n?subject rdfs:label ?person;\nowl:sameAs ?ulan.\n} EX9. In continuation of the question above, what are the nationality of these western artists appear in Chen's collage? 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 appear in Chen's collage? 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 collection? Please locate the names of these book titles, their contributors, place of publication and languague in the data of 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/>\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nSELECT ?s ascdc:Place ?placeCtvc\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n ?s ascdc:Place ?placeCtvc .\n ?s ascdc:dynastyPersonBirth <http://data.ascdc.tw/time/chi/dynasty/031> .\n ?placeCtvc rdfs:label ?placeZh .\n FILTER (Contains(STR(?placeZh ), '福建省'))\n} EX2. Which works did Wang Shi-jen (王世貞), a Ming author who had a good command in both poetry and prose, compose? PREFIX ascdc: <http://data.ascdc.tw/property/>\nPREFIX dbpedia-owl: <http://dbpedia.org/ontology/>\nSELECT <http://data.ascdc.tw/dnb/Agent/NO000018406> as ?s dbpedia-owl:created ?works\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n <http://data.ascdc.tw/dnb/Agent/NO000018406> dbpedia-owl:created ?works\n}\nORDER 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/>\nPREFIX leo: <http://linkedevents.org/ontology/>\nPREFIX time: <http://www.w3.org/2006/time#>\nSELECT ?Agent ?officialCtvc ?Duration\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n ?Agent ascdc:officialEvent ?officialSerial .\n ?officialSerial leo:involved ?officialCtvc .\n ?officialCtvc rdfs:label ?officialZh .\n FILTER (Contains(STR(?officialZh ), '安徽巡撫'))\n ?officialSerial ascdc:atTime ?Duration\n} EX4. In the history of Chinese painting, there are Four Wangs famous for landscape painting in early Qing dynasty: Want Shi-min (王時, 1592-1680), Wang Jian (王鑑, 1598-1677) , Wang Hui (王翬, 1632-1717), and Wang Yuan-qi (王原祁, 1642-1715). Who were their students respectively? PREFIX agrelon: <http://d-nb.info/standards/elementset/agrelon#>\nSELECT ?agent ?student \nFROM <http://data.ascdc.tw/dnb/Agent/> \nWHERE {\n ?agent agrelon:hasStudent ?student .\n FILTER (Contains(STR(?agent), 'NO000009213') || Contains(STR(?agent), 'NO000009298') || Contains(STR(?agent), 'NO000009371') || Contains(STR(?agent), 'NO000009212'))\n} EX5. Which agents specialized in calligraphy? PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>\nSELECT ?agent\nFROM <http://data.ascdc.tw/dnb/Agent/> \nWHERE {\n ?agent dbpedia-owl:speciality <http://vocab.getty.edu/aat/300053162> .\n} EX6. How many agents belong to the order of "Baqi" (八旗/ Eight Banners) of Manchu, Han army, and Mongolia respectively? PREFIX ascdc: <http://data.ascdc.tw/property/>\nSELECT (COUNT(?agent) AS ?countAgent) ?eightBanners\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n ?agent ascdc:eightBannersTypeRefined ?eightBanners .\n FILTER (Contains(STR(?eightBanners), '滿洲') || Contains(STR(?eightBanners), '漢軍') || Contains(STR(?eightBanners), '蒙古'))\n}\nGROUP BY ?eightBanners\nORDER BY ?eightBanners EX7. Which agent(s) has a studio name and what are those studio names? PREFIX ascdc: <http://data.ascdc.tw/property/>\nSELECT ?agent ?altLabelCtvc ?label\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n ?agent skos:altLabel ?altLabelSerial .\n ?altLabelSerial ascdc:nameType ?altLabelCtvc .\n ?altLabelCtvc rdfs:label ?altLabelZh .\n FILTER (Contains(STR(?altLabelZh ), '室名')) .\n ?altLabelSerial rdfs:label ?label .\n} 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/>\nSELECT ?nameType ?label ?source\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n <http://data.ascdc.tw/dnb/Agent/NO000000105> skos:altLabel ?altLabelSerial .\n ?altLabelSerial ascdc:nameType ?nameType .\n ?altLabelSerial rdfs:label ?label .\n ?altLabelSerial dc:source ?source .\n} EX9. Which agents ranked as jinshi (進士) in Qing dynasty come from Jangsu, Hubei, Hunan and Zhejiang? PREFIX ascdc: <http://data.ascdc.tw/property/>\nPREFIX leo: <http://linkedevents.org/ontology/>\nSELECT distinct ?agent\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n ?agent ascdc:dynastyPersonBirth <http://data.ascdc.tw/time/chi/dynasty/031> .\n ?agent ascdc:imperialExamination ?imperialExamUrl .\n ?imperialExamUrl leo:involved ?imperialExamCtvc .\n ?imperialExamCtvc rdfs:label ?imperialExamZh .\n FILTER (Contains(STR(?imperialExamZh ), '進士')) . \n ?agent ascdc:Place ?placeCtvc .\n ?placeCtvc rdfs:label ?placeZh . \n FILTER (\n Contains(STR(?placeZh), '江蘇省') ||\n Contains(STR(?placeZh), '湖北省') ||\n Contains(STR(?placeZh), '湖南省') ||\n Contains(STR(?placeZh), '浙江省')\n )\n} 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/>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\nPREFIX leo: <http://linkedevents.org/ontology/>\nPREFIX time: <http://www.w3.org/2006/time#>\nPREFIX schema: <http://schema.org/>\n\nSELECT ?s ?name ?eventLabel ?position ?birthYear ?yearAsGovernor ((?yearAsGovernor - xsd:decimal(?birthYear)) AS ?age)\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n?s skos:prefLabel ?name .\n?s ascdc:officialEvent ?eventSerial .\n?s schema:birthDate ?yearo .\nBIND(REPLACE(?yearo , "\\[", "") AS ?yearo2) .\nBIND(REPLACE(?yearo2, "\\]", "") AS ?birthYear) .\n?eventSerial time:inXSDgYear ?yearAsGovernor .\n?eventSerial leo:involved ?eventCtvc .\n?eventCtvc rdfs:label ?position .\n?eventSerial rdfs:label ?eventLabel .\n?eventSerial ascdc:atTime ?eventTime .\nFILTER (?yearAsGovernor >= 1644) .\nFILTER contains(STR(?position), '總督') .\n {\n SELECT ?s (MIN(?inXSDgO) AS ?yearAsGovernor)\n FROM <http://data.ascdc.tw/dnb/Agent/>\n WHERE\n {\n ?s ascdc:officialEvent ?eventSerial .\n ?eventSerial time:inXSDgYear ?inXSDgO . \n ?eventSerial leo:involved ?eventCtvc .\n ?eventCtvc rdfs:label ?position .\n FILTER contains(STR(?position), '總督') .\n }\n }\n}\nORDER 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/>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\nPREFIX leo: <http://linkedevents.org/ontology/>\nPREFIX time: <http://www.w3.org/2006/time#>\nPREFIX schema: <http://schema.org/>\n\nSELECT ?s ?name ?eventLabel ?position ?birthYear ?yearAsGovernor ((?yearAsGovernor - xsd:decimal(?birthYear)) AS ?age)\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n?s skos:prefLabel ?name .\n?s ascdc:officialEvent ?eventSerial .\n?s schema:birthDate ?yearo .\nBIND(REPLACE(?yearo , "\\[", "") AS ?yearo2) .\nBIND(REPLACE(?yearo2, "\\]", "") AS ?birthYear) .\n?eventSerial time:inXSDgYear ?yearAsGovernor .\n?eventSerial leo:involved ?eventCtvc .\n?eventCtvc rdfs:label ?position .\n?eventSerial rdfs:label ?eventLabel .\n?eventSerial ascdc:atTime ?eventTime .\nFILTER (?yearAsGovernor >= 1644) .\nFILTER contains(STR(?position), '巡撫') .\n {\n SELECT ?s (MIN(?inXSDgO) AS ?yearAsGovernor)\n FROM <http://data.ascdc.tw/dnb/Agent/>\n WHERE\n {\n ?s ascdc:officialEvent ?eventSerial .\n ?eventSerial time:inXSDgYear ?inXSDgO . \n ?eventSerial leo:involved ?eventCtvc .\n ?eventCtvc rdfs:label ?position .\n FILTER contains(STR(?position), '巡撫') .\n }\n }\n}\nORDER BY ?s EX12. Where did the Qing agents ranked as jinshi come? PREFIX ascdc: <http://data.ascdc.tw/property/>\nPREFIX owl: <http://www.w3.org/2002/07/owl#>\nPREFIX leo: <http://linkedevents.org/ontology/>\nSELECT ?name ?placeCh ?TGAZ_URI\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n ?systemNumber skos:prefLabel ?name .\n ?systemNumber ascdc:dynastyPersonBirth <http://data.ascdc.tw/time/chi/dynasty/031> .\n ?systemNumber ascdc:imperialExamination ?imperialExamUri .\n ?imperialExamUri leo:involved ?imperialExamCtvc .\n ?imperialExamCtvc rdfs:label ?imperialExamZh .\n FILTER (Contains(STR(?imperialExamZh ), '進士')) . \n ?placeCtvc owl:sameAs ?TGAZ_URI .\n FILTER contains(STR(?TGAZ_URI), 'tgaz') .\n ?placeCtvc rdfs:label ?placeCh .\n ?systemNumber ascdc:Place ?placeCtvc .\n} EX13. In the family of those who are ranked as jinshi (進士), who else has attained the same rank? PREFIX ascdc: <http://data.ascdc.tw/property/>\nPREFIX leo: <http://linkedevents.org/ontology/>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX agrelon: <http://d-nb.info/standards/elementset/agrelon#>\nPREFIX pext: <http://www.ontotext.com/proton/protonext>\nPREFIX bio: <http://purl.org/vocab/bio/0.1/>\nPREFIX gvp: <http://vocab.getty.edu/ontology#>\nSELECT ?s ?o \nFROM <http://data.ascdc.tw/dnb/Agent/> \nWHERE {\n ?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 . \n ?s ascdc:imperialExamination ?imperialExamUri . \n ?imperialExamUri leo:involved ?imperialExamCtvc . \n ?o ascdc:imperialExamination ?imperialExamUriO . \n ?imperialExamUriO leo:involved ?imperialExamCtvc . \n ?imperialExamCtvc rdfs:label ?imperialExamZh .\n FILTER (Contains(STR(?imperialExamZh ), '進士')) . \n} EX14. How many alternative names of the Qing epigraphist Weng Fanggang (翁方綱) are there in the Database of Names (DNB) and Biographies 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/>\nSELECT ?nameType ?label ?source\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n {\n <http://data.ascdc.tw/dnb/Agent/NO000000105> skos:altLabel ?altLabelSerial .\n ?altLabelSerial ascdc:nameType ?nameType .\n ?altLabelSerial rdfs:label ?label .\n ?altLabelSerial dc:source ?source .\n }\n UNION\n {\n <http://data.ascdc.tw/dnb/Agent/NO000000105> owl:sameAs ?viafID .\n ?viafID ?nameType ?label .\n 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'))\n }\n}
EX1. To which emperor’s reign does the year of publication of each monograph in the LOD Dataset of the Chinese Rare Books correspond? List the amount of monographs published during respective reigns. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/>\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nSELECT ?o ?oCh count(?s) as ?countEra\nFROM <http://data.ascdc.tw/Book/crb/>\nWHERE {\n ?s bf:date ?o .\n ?o rdfs:label ?oCh .\n FILTER (Contains(STR(?s), 'Instance')) .\n FILTER (Contains(STR(?o), 'era')) .\n}\nORDER BY ?o EX2. Where are the places of the publication of the monographs in the LOD Dataset of the Chinese Rare Books located today? For each contemporary location, how many monographs are related to those locations respectively? PREFIX ascdc: <http://data.ascdc.tw/property/>\nPREFIX schema: <http://schema.org/>\nSELECT ?o count(?s) as ?countO ?oTgn\nFROM <http://data.ascdc.tw/Book/crb/>\nWHERE {\n ?s ascdc:Place ?o .\n FILTER (Contains(STR(?s), 'Instance')) .\n OPTIONAL {?s schema:locationCreated ?oTgn} .\n} EX3. What other titles does "Zuo chuan chao ping, shi er juan" (左傳鈔評 十二卷) have? What are the types of these variant titles? PREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX bf: <http://id.loc.gov/ontologies/bibframe/>\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nSELECT ?s ?variantType ?label\nFROM <http://data.ascdc.tw/Book/crb/>\nWHERE {\n ?s skos:prefLabel ?o .\n FILTER (Contains(STR(?s), 'Work')) .\n FILTER (Contains(STR(?o), '左傳鈔評')) .\n ?s bf:title ?variantTitleUri .\n ?variantTitleUri bf:variantType ?variantType .\n ?variantTitleUri rdfs:label ?label\n} EX4. In continuation of the question above, what are the contributors related to "Zuo chuan chao ping, shi er juan" (左傳鈔評 十二卷)? What are their role? PREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX bf: <http://id.loc.gov/ontologies/bibframe/>\nSELECT ?agentUri ?agentCh ?roleUri ?roleCh\nFROM <http://data.ascdc.tw/Book/crb/>\nWHERE {\n ?s skos:prefLabel ?o .\n FILTER (Contains(STR(?o), '左傳鈔評')) .\n ?s bf:hasInstance ?instanceUri .\n ?instanceUri bf:contribution ?contributionUri .\n ?contributionUri bf:agent ?agentUri .\n ?agentUri skos:prefLabel ?agentCh .\n ?contributionUri bf:role ?roleUri .\n ?roleUri rdfs:label ?roleCh\n} EX5. What are the books published during the reign of the Daoguang emperor? List the preferred title and caption title for these books. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/>\nPREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nSELECT ?instanceUri ?mainTitle ?variantTitle\nFROM <http://data.ascdc.tw/Book/crb/>\nWHERE {\n ?instanceUri bf:date ?eraUri .\n ?eraUri rdfs:label '道光'@zh .\n FILTER (Contains(STR(?instanceUri), 'Instance')) .\n ?workUri bf:hasInstance ?instanceUri .\n ?workUri skos:prefLabel ?mainTitle .\n OPTIONAL {\n ?instanceUri bf:title ?variantTitleUri .\n ?variantTitleUri bf:variantType ?variantType .\n FILTER (Contains(STR(?variantType), '卷端題名')) .\n ?variantTitleUri rdfs:label ?variantTitle .\n } \n} EX6. List all the series, monographs and volumes contained in the LOD Dataset of the Chinese Rare Books, which are also collected LOD Dataset of Names and Biographies. PREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX dbpedia-owl: <http://dbpedia.org/ontology/>\nPREFIX gndo: <http://d-nb.info/standards/elementset/gnd#>\nSELECT DISTINCT ?workUri ?mainTitle\nFROM <http://data.ascdc.tw/Book/crb/>\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n ?workUri skos:prefLabel ?mainTitle .\n FILTER (Contains(STR(?workUri), 'Work')) .\n ?dnbUri gndo:publication ?mainTitle .\n} EX7. Who are the authors of the publications displayed in the results of the query above? PREFIX bf: <http://id.loc.gov/ontologies/bibframe/>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX gndo: <http://d-nb.info/standards/elementset/gnd#>\nSELECT DISTINCT ?workUri ?agentCh ?agentUri\nFROM <http://data.ascdc.tw/Book/crb/>\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n ?workUri skos:prefLabel ?mainTitle .\n FILTER (Contains(STR(?workUri), 'Work')) .\n ?dnbUri gndo:publication ?mainTitle .\n ?workUri bf:contribution ?contributionUri .\n ?contributionUri bf:agent ?agentUri .\n ?contributionUri bf:role ?roleUri .\n ?agentUri skos:prefLabel ?agentCh .\n} EX8. What are the editions of the aforementioned publications contained in the LOD Dataset of the Chinese Rare Books? PREFIX bf: <http://id.loc.gov/ontologies/bibframe/>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX gndo: <http://d-nb.info/standards/elementset/gnd#>\nSELECT DISTINCT ?mainTitle ?editionStatement\nFROM <http://data.ascdc.tw/Book/crb/>\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n ?workUri skos:prefLabel ?mainTitle .\n FILTER (Contains(STR(?workUri), 'Work')) .\n ?dnbUri gndo:publication ?mainTitle .\n ?workUri bf:hasInstance ?instanceUri .\n ?instanceUri bf:editionStatement ?editionStatement .\n} EX9. Who are the other contributors related to the publication of the aforementioned books? What is their contribution? List the URI of these figures from the LOD Dataset of Names and Biographies and from the LOD Dataset of the Chinese Rare Books. PREFIX bf: <http://id.loc.gov/ontologies/bibframe/>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX gndo: <http://d-nb.info/standards/elementset/gnd#>\nSELECT DISTINCT ?mainTitle ?agentUri ?agentCh ?roleCh\nFROM <http://data.ascdc.tw/Book/crb/>\nFROM <http://data.ascdc.tw/dnb/Agent/>\nWHERE {\n ?workUri skos:prefLabel ?mainTitle .\n FILTER (Contains(STR(?workUri), 'Work')) .\n ?dnbUri gndo:publication ?mainTitle .\n ?workUri bf:hasInstance ?instanceUri .\n ?instanceUri bf:contribution ?contributionUri .\n ?contributionUri bf:agent ?agentUri .\n ?agentUri skos:prefLabel ?agentCh .\n ?contributionUri bf:role ?roleUri .\n ?roleUri rdfs:label ?roleCh\n} EX10. In the LOD dataset of the Chinese Rare Books, 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 are involved together as the volume's contributors (authoring the book, the preface, the postscript, or other devotional articles etc.)? See the network of associations PREFIX bf: <http://id.loc.gov/ontologies/bibframe/>\nPREFIX skos: <http://www.w3.org/2004/02/skos/core#>\nPREFIX dcterms: <http://purl.org/dc/terms/>\nSELECT ?uri ?contributor ?label\nFROM <http://data.ascdc.tw/Book/crb/>\nWHERE{\n?uri bf:contribution/bf:agent/skos:prefLabel ?contributor;\ndcterms:identifier ?id.\nFILTER (contains(str(?uri), 'Book_Work')||contains(str(?uri), 'Book_Instance')) .\nOPTIONAL {?uri skos:prefLabel ?label} \n}\nORDER BY ?label\n EX11. Which local history chronicles are collected in the Chinese Rare Book dataset and how do those classified by content's subject? And how do those classified in the BIBFRAME 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 ?crbWork, ?crbSubject, ?locWork, ?locSubject FROM <http://data.ascdc.tw/Book/crb/> FROM <http://id.loc.gov/> WHERE { ?crbWork bf:subject ?subject; ascdc:FSNLibraryClassHeading ?crbSubject; owl:sameAs ?locWork. ?locWork bf:subject/rdfs:label ?locSubject. FILTER (str(?subject) = '方志'). FILTER langMatches( lang(?locSubject), "zh" ). } EX12. Which version of the chronicle "Jiaxingfuzhi" (嘉興府志) is collected in the Chinese Rare Book dataset and what other related versions of the "Jiaxingfuzhi" can be found in the BIBFRAME 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" ). }



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.
5)
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)Set the value S as the Instance URI of monographs in question, the value P as bf:date, and the value O as the URI of regnal year.
2)Display values S and O.
3)Look for the sum of every O value in the column for numbers.
1)Find the triples with value S as the Instance URI of monographs, P as schema:locationCreated, and their values as O.
2)Display the values of S and O, and the number of volumes contained in O.
3)Make a table to display the numbers corresponding to each O value.
1)Set the value S as work URI, the value P as skos:prefLabel, and the value O as for 左傳鈔評 十二卷 (Zuo chuan chao ping, shi er juan).
2)Retain the value S. Set the value P as bf:title, the value 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 string of those variant titles.
3)Display the queried results of the step 2.
1)Set the value P as skos:prefLabel, the value O as the Instance URI for 左傳鈔評 十二卷 (Zuo chuan chao ping, shi er juan), and the value O as the URI of Contribution. Then set the value S as Contribution URI, the value P as bf:agent, and the value O as bf:role.
2)Display the relevant contributors' URI, their Chinese name, the URI for their role, and the Chinese term for the role.
1)Set the value S as Instance URI, the value P as bf:date, and the value O as the URI for Daoguang. Select the S (Instance URI) values satisfying the conditions above and set the value P as bf:title, and the value O as VariantTitle URI. (a) Reset the value S as the VariantTitle URI obtained through O, the value P as bf:variantType, and the value O for “caption title.” Select the values S (VariantTitle URI) satisfying the conditions above, set the value P as rdfs:label and obtain the content of O values i.e. the caption titles. (b) Set the value S satisfying the O value in step1 as work URI, the P value as skos:prefLabel, and obtain the O value for preferred titles.
2)Display the Instance URI, preferred titles and caption titles.
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)Display the preferred title of publications and work URI listed in both the LOD Dataset of the Chinese Rare Books and the LOD Database of Names and Biographies.
1)Continue with the result obtained through question 6. Set the S value as the work URI of the filtered books, the P value as bf: contribution, and the O value as Contribution URI. Then, find out the O values, which have the previous Contribution URI as the S value and P value as bf:agent.
2)Display the title of publications, URI of persons, and their names.
1)Continue with the results obtained through question 6. Find out the O values, which has Instance URI of the aforementioned publications as S value and the P value as bf: editionStatement.
2)Display the title of publications and their edition statement.
1)Continue with the result obtained through question 6. Select the Instance URI of the aforementioned publications and set the P value as bf: contribution and the O value as the Contribution URI. Then, set the aforementioned Contribution URI as the S value, P value as bf: agent and bf: role and find out the O values, which satisfy this reasoning condition.
2)Display the title of publications, URI of persons, their names and label of role in the publications.
1)Set every value S as "work" (referring to the single volume) 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 single volumes' URI, the volume's title, and names associated with the volume.
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)Search results will appear in the fields of 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)Search results will appear in the fields of CRB Work, CRB Label, CRB Edition, LC Work, LC Edition.