Available query types
Query examples
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 tribes PREFIX 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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
SPARQL query reasoning
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)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)
2)
3)
1)
2)
3)
1)
2)
3)
1)
2)
1)
2)
1)
2)
1)
2)
1)
2)
1)
2)
1)
2)
2)
2)



SPARQL query results (Select the wished presentation modus)