475,243
edits
(→Food Composition Tables in WikiFCD: add query for food items with FoodOn id and NALT id) |
(→Food Composition Tables in WikiFCD: update heading) |
||
(13 intermediate revisions by the same user not shown) | |||
Line 12: | Line 12: | ||
} | } | ||
</SPARQL> | </SPARQL> | ||
== | ==Food Items with SMILING Thailand Food Code and Reference== | ||
<SPARQL> | <SPARQL> | ||
PREFIX wd: <http://www.wikidata.org/entity/> | PREFIX wd: <http://www.wikidata.org/entity/> | ||
Line 19: | Line 19: | ||
PREFIX p: <https://wikifcd.wikibase.cloud/prop/> | PREFIX p: <https://wikifcd.wikibase.cloud/prop/> | ||
PREFIX pr: <https://wikifcd.wikibase.cloud/prop/reference/> | PREFIX pr: <https://wikifcd.wikibase.cloud/prop/reference/> | ||
PREFIX prov: <http://www.w3.org/ns/prov#> | |||
SELECT ?food ?foodLabel ?code WHERE { | |||
?food wbt:P315 ?code; | |||
p:P315 [ prov:wasDerivedFrom [pr:P62 wb:Q568274]]. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
</SPARQL> | |||
==Timeline View of FCTs with Publication Dates== | |||
<SPARQL> | |||
#defaultView:Timeline | |||
#Food Composition Tables in WikiFCD with publication dates | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/> | |||
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/> | |||
PREFIX p: <https://wikifcd.wikibase.cloud/prop/> | |||
PREFIX prov: <http://www.w3.org/ns/prov#> | |||
SELECT DISTINCT ?item ?itemLabel ?date WHERE { | |||
?item wbt:P1 wb:Q12. | |||
?item wbt:P58 ?date. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
</SPARQL> | |||
==WikiFCD federated query for food items with foodOn id and NALT id== | |||
<SPARQL> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/> | |||
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/> | |||
PREFIX p: <https://wikifcd.wikibase.cloud/prop/> | |||
PREFIX pr: <https://wikifcd.wikibase.cloud/prop/reference/> | |||
PREFIX dct: <http://purl.org/dc/terms/> | |||
SELECT DISTINCT ?item ?itemLabel ?foodon ?nalt WHERE { | SELECT DISTINCT ?item ?itemLabel ?foodon ?nalt WHERE { | ||
Line 28: | Line 62: | ||
?item rdfs:label ?itemLabel | ?item rdfs:label ?itemLabel | ||
SERVICE <https://query.wikidata.org/sparql> { | SERVICE <https://query.wikidata.org/sparql> { | ||
?wikidata wdt:P2004 ?nalt | ?wikidata wdt:P2004 ?nalt | ||
}} | |||
</SPARQL> | |||
==WikiFCD food items with FoodOn identifier== | |||
<SPARQL> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/> | |||
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/> | |||
SELECT DISTINCT ?food ?foodLabel ?foodon WHERE { | |||
?food wbt:P309 ?foodon; | |||
rdfs:label ?foodLabel. | |||
} | |||
</SPARQL> | |||
==WikiFCD Count of Properties by Property Type== | |||
<SPARQL> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/> | |||
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/> | |||
SELECT (COUNT(?property) as ?pcount ) ?wbtype WHERE { | |||
?property rdf:type wikibase:Property. | |||
?property wikibase:propertyType ?wbtype. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
GROUP BY ?wbtype | |||
ORDER BY DESC(?pcount) | |||
</SPARQL> | |||
==Graph Visualization of Food Items with Stated Taxon Source Referenced to a FCT== | |||
<SPARQL> | |||
#defaultView:Graph | |||
PREFIX wdt: <http://www.wikidata.org/prop/direct/> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/> | |||
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/> | |||
PREFIX p: <https://wikifcd.wikibase.cloud/prop/> | |||
PREFIX pr: <https://wikifcd.wikibase.cloud/prop/reference/> | |||
SELECT ?item ?itemLabel ?taxon ("00FFFF" AS ?rgb) ?taxonLabel WHERE { | |||
?item wbt:P73 ?taxon; | |||
p:P73 [prov:wasDerivedFrom [pr:P62 ?source ]]. | |||
?source wbt:P1 wb:Q12. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
</SPARQL> | |||
==Federated Query WikiFCD Taxon Name is Main Subject of a Scientific Article== | |||
<SPARQL> | |||
PREFIX wdt: <http://www.wikidata.org/prop/direct/> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/> | |||
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/> | |||
SELECT DISTINCT ?item ?itemLabel ?wikidata ?article ?articleLabel WHERE { | |||
?item wbt:P1 wb:Q20. | |||
?item wbt:P61 ?wikidata. | |||
?item rdfs:label ?itemLabel . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?article wdt:P921 ?wikidata. | |||
?article rdfs:label ?articleLabel. | |||
}} | |||
Limit 100 | |||
</SPARQL> | |||
==Federated Query WikiFCD PFaF with Optional Image== | |||
<SPARQL> | |||
PREFIX wdt: <http://www.wikidata.org/prop/direct/> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/> | |||
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/> | |||
SELECT DISTINCT ?food ?foodLabel ?taxon ?value (SAMPLE (?img) AS ?image) | |||
WHERE { | |||
?food wbt:P73 ?taxon. | |||
?taxon wbt:P61 ?wikidata. | |||
?food rdfs:label ?foodLabel . | |||
SERVICE <https://query.wikidata.org/sparql> { | |||
?wikidata wdt:P4301 ?value. | |||
OPTIONAL {?wikidata wdt:P18 ?img.} | |||
}} | |||
GROUP BY ?food ?foodLabel ?taxon ?value | |||
</SPARQL> | |||
==Food Items with SMILING Cambodia Food Code and Reference== | |||
<SPARQL> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/> | |||
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/> | |||
PREFIX p: <https://wikifcd.wikibase.cloud/prop/> | |||
PREFIX pr: <https://wikifcd.wikibase.cloud/prop/reference/> | |||
PREFIX prov: <http://www.w3.org/ns/prov#> | |||
SELECT ?food ?foodLabel ?code WHERE { | |||
?food wbt:P313 ?code; | |||
p:P313 [ prov:wasDerivedFrom [pr:P62 wb:Q128052]]. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
</SPARQL> | |||
==Ranked List of Food Items Containing Most to Least DHA (Docosahexaenoic acid)== | |||
<SPARQL> | |||
PREFIX wd: <http://www.wikidata.org/entity/> | |||
PREFIX wbt: <https://wikifcd.wikibase.cloud/prop/direct/> | |||
PREFIX wb: <https://wikifcd.wikibase.cloud/entity/> | |||
PREFIX p: <https://wikifcd.wikibase.cloud/prop/> | |||
PREFIX psv: <https://wikifcd.wikibase.cloud/prop/statement/value/> | |||
SELECT ?itemLabel ?_DHA ?unitLabel WHERE { | |||
?item p:P135/psv:P135 ?DHA. | |||
?DHA wikibase:quantityAmount ?_DHA. | |||
?DHA wikibase:quantityUnit ?unit. | |||
{ SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"} }} | |||
ORDER BY DESC(?_DHA) | |||
</SPARQL> | </SPARQL> |