Project:SPARQL/examples: Difference between revisions

From wikifcd
Jump to navigation Jump to search
(→‎WikiFCD food items with FoodOn identifier: ad properties by prop type query)
(remove whitespace)
Line 12: Line 12:
   }
   }
</SPARQL>
</SPARQL>
==WikiFCD federated query for food items with foodOn id and NALT id==
==WikiFCD federated query for food items with foodOn id and NALT id==
<SPARQL>
<SPARQL>
Line 32: Line 31:
   }}
   }}
</SPARQL>
</SPARQL>
==WikiFCD food items with FoodOn identifier==
==WikiFCD food items with FoodOn identifier==
<SPARQL>
<SPARQL>

Revision as of 21:25, 14 August 2022

Food Composition Tables in WikiFCD

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 ?item ?itemLabel WHERE {
  ?item wbt:P1 wb:Q12. 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  }

WikiFCD federated query for food items with foodOn id and NALT id

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 {
?food wbt:P73 ?item.
?item wbt:P1 wb:Q20.
?food wbt:P309 ?foodon.
?item wbt:P61 ?wikidata.
?item rdfs:label ?itemLabel 
  SERVICE <https://query.wikidata.org/sparql> {
     ?wikidata wdt:P2004 ?nalt 
  }}

WikiFCD food items with FoodOn identifier

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.
}

WikiFCD properties by property type

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)