{"id":158,"date":"2024-11-21T12:12:08","date_gmt":"2024-11-21T11:12:08","guid":{"rendered":"https:\/\/www.liita.it\/?page_id=158"},"modified":"2025-09-17T12:54:45","modified_gmt":"2025-09-17T10:54:45","slug":"sparql","status":"publish","type":"page","link":"https:\/\/www.liita.it\/?page_id=158","title":{"rendered":"SPARQL"},"content":{"rendered":"\n

<\/p>\n\n\n\n

The LiITA Knowledge Base is accessible through our SPARQL endpoint<\/a>, where you can perform advanced queries on the data.<\/p>\n\n\n\n

Example Queries:<\/h4>\n\n\n\n
Quantitative distribution of PoS in LiITA<\/summary>\n
PREFIX lila: <http:\/\/lila-erc.eu\/ontologies\/lila\/>\n\nSELECT ?pos (COUNT(*) as ?count)\nWHERE {\n  GRAPH <http:\/\/liita.it\/data> {\n    ?lemma a lila:Lemma .\n    ?lemma lila:hasPOS ?pos .\n  }\n}\nGROUP BY ?pos\nORDER BY DESC (?count )<\/code><\/pre>\n\n\n\n
Check the results<\/a><\/p>\n<\/details>\n\n\n\n
Count how many nouns end in -ione<\/summary>\n
PREFIX lila: <http:\/\/lila-erc.eu\/ontologies\/lila\/>\nPREFIX ontolex: <http:\/\/www.w3.org\/ns\/lemon\/ontolex#>\n\nSELECT COUNT(*) as ?count\nWHERE {\n  GRAPH <http:\/\/liita.it\/data> {\n    ?lemma a lila:Lemma .\n    ?lemma lila:hasPOS lila:noun .\n    ?lemma ontolex:writtenRep ?wr .\n    FILTER regex(str(?wr), \"ione$\") .\n  }\n}<\/code><\/pre>\n\n\n\n
Check the results<\/a>.<\/p>\n<\/details>\n\n\n\n
Lemmas starting in infra-
<\/summary>\n
PREFIX lila: <http:\/\/lila-erc.eu\/ontologies\/lila\/>\nPREFIX ontolex: <http:\/\/www.w3.org\/ns\/lemon\/ontolex#>\n\nSELECT ?lemma ?wr\nWHERE {\n  GRAPH <http:\/\/liita.it\/data> {\n    ?lemma a lila:Lemma .\n    ?lemma ontolex:writtenRep ?wr .\n    FILTER regex(str(?wr), \"^infra\") .\n  }\n}<\/code><\/pre>\n\n\n\n
Check the results<\/a>.<\/p>\n<\/details>\n\n\n\n
Find all Italian entries linked to CompL-IT where the definition starts with the word “uccello”, and show its translation in the Parmigian Glossary<\/summary>\n
PREFIX lime: <http:\/\/www.w3.org\/ns\/lemon\/lime#>\nPREFIX vartrans: <http:\/\/www.w3.org\/ns\/lemon\/vartrans#>\nPREFIX rdfs: <http:\/\/www.w3.org\/2000\/01\/rdf-schema#>\nPREFIX skos: <http:\/\/www.w3.org\/2004\/02\/skos\/core#>\nPREFIX dct: <http:\/\/purl.org\/dc\/terms\/>\nPREFIX onto: <http:\/\/www.ontotext.com\/>\nPREFIX lexinfo: <http:\/\/www.lexinfo.net\/ontology\/3.0\/lexinfo#>\nPREFIX ontolex: <http:\/\/www.w3.org\/ns\/lemon\/ontolex#>\nPREFIX rdf: <http:\/\/www.w3.org\/1999\/02\/22-rdf-syntax-ns#>\nSELECT ?liitaLemma ?lemma ?parmigianoLemma ?wr ?definition WHERE\n{\n  SERVICE <https:\/\/klab.ilc.cnr.it\/graphdb-compl-it\/> {\n    ?word a ontolex:Word ;\n  lexinfo:partOfSpeech [ rdfs:label ?pos ] ;\n                         ontolex:sense ?sense ;\n                         ontolex:canonicalForm ?form .\n    ?form ontolex:writtenRep ?lemma .\n    OPTIONAL {\n      ?sense skos:definition ?definition \n    } .\n    OPTIONAL {\n      ?sense lexinfo:senseExample ?example \n    } .\n    FILTER(str(?pos) = \"noun\") .\n    FILTER (strstarts(str(?definition), \"uccello\")).\n  }\n  ?word ontolex:canonicalForm ?liitaLemma.\n  ?leItaLexiconPar ontolex:canonicalForm ?liitaLemma;\n                   ^lime:entry <http:\/\/liita.it\/data\/id\/LexicalReources\/DialettoParmigiano\/Lexicon>.\n  ?leItaLexiconPar vartrans:translatableAs ?leParLexiconPar.\n  ?leParLexiconPar ontolex:canonicalForm ?parmigianoLemma.\n  ?parmigianoLemma ontolex:writtenRep ?wr\n}  group by ?wr<\/code><\/pre>\n\n\n\n
Check the results<\/a>.<\/p>\n<\/details>\n\n\n\n
Retrieves the Italian entries in the Parmigian Glossary linked to CompL-it whose definition begins with ‘colore’<\/summary>\n
PREFIX lime: <http:\/\/www.w3.org\/ns\/lemon\/lime#>\nPREFIX vartrans: <http:\/\/www.w3.org\/ns\/lemon\/vartrans#>\nPREFIX rdfs: <http:\/\/www.w3.org\/2000\/01\/rdf-schema#>\nPREFIX skos: <http:\/\/www.w3.org\/2004\/02\/skos\/core#>\nPREFIX dct: <http:\/\/purl.org\/dc\/terms\/>\nPREFIX onto: <http:\/\/www.ontotext.com\/>\nPREFIX lexinfo: <http:\/\/www.lexinfo.net\/ontology\/3.0\/lexinfo#>\nPREFIX ontolex: <http:\/\/www.w3.org\/ns\/lemon\/ontolex#>\nPREFIX rdf: <http:\/\/www.w3.org\/1999\/02\/22-rdf-syntax-ns#>\nSELECT * WHERE\n{\n SERVICE <https:\/\/klab.ilc.cnr.it\/graphdb-compl-it\/> {\n   ?word a ontolex:Word ;\n lexinfo:partOfSpeech [ rdfs:label ?pos ] ;\n                        ontolex:sense ?sense ;\n                        ontolex:canonicalForm ?form .\n   ?form ontolex:writtenRep ?lemma .\n   OPTIONAL {\n     ?sense skos:definition ?definition\n   } .\n   OPTIONAL {\n     ?sense lexinfo:senseExample ?example\n   } .\n   FILTER(str(?pos) = \"noun\") .\n   FILTER (strstarts(str(?definition), \"colore\")).\n }\n}<\/code><\/pre>\n\n\n\n
Check the results<\/a>.<\/p>\n<\/details>\n\n\n\n
Retrieves the Parmigiano and LiITA lemmas of the hyponyms of the lemma ‘colore’ in CompL-it
<\/summary>\n
PREFIX lime: <http:\/\/www.w3.org\/ns\/lemon\/lime#>\nPREFIX vartrans: <http:\/\/www.w3.org\/ns\/lemon\/vartrans#>\nPREFIX rdfs: <http:\/\/www.w3.org\/2000\/01\/rdf-schema#>\nPREFIX skos: <http:\/\/www.w3.org\/2004\/02\/skos\/core#>\nPREFIX dct: <http:\/\/purl.org\/dc\/terms\/>\nPREFIX onto: <http:\/\/www.ontotext.com\/>\nPREFIX lexinfo: <http:\/\/www.lexinfo.net\/ontology\/3.0\/lexinfo#>\nPREFIX ontolex: <http:\/\/www.w3.org\/ns\/lemon\/ontolex#>\nPREFIX rdf: <http:\/\/www.w3.org\/1999\/02\/22-rdf-syntax-ns#>\n\nSELECT ?senseHyponym \nGROUP_CONCAT(str(?_definition);SEPARATOR=\"; esempio: \") AS ?definition \n?liitaLemma ?parmigianoLemma ?wr\nWHERE\n   {\n     SERVICE <https:\/\/klab.ilc.cnr.it\/graphdb-compl-it\/> {\n       ?word a ontolex:Word ;\n             lexinfo:partOfSpeech [ rdfs:label ?pos ] ;\n             ontolex:sense ?sense ;\n             ontolex:canonicalForm [ ontolex:writtenRep ?lemma ] .\n       ?sense lexinfo:hypernym ?senseHyponym .\n       OPTIONAL {\n         ?senseHyponym skos:definition ?_definition \n       } .\n       FILTER(str(?pos) = \"noun\") .\n       FILTER(str(?lemma) = \"colore\") .\n       ?wordHyponym ontolex:sense ?senseHyponym .\n     } \n     ?wordHyponym ontolex:canonicalForm ?liitaLemma.\n     ?leItaLexiconPar ontolex:canonicalForm ?liitaLemma;\n                   ^lime:entry <http:\/\/liita.it\/data\/id\/LexicalReources\/DialettoParmigiano\/Lexicon>.\n     ?leItaLexiconPar vartrans:translatableAs ?leParLexiconPar.\n     ?leParLexiconPar ontolex:canonicalForm ?parmigianoLemma.\n     ?parmigianoLemma ontolex:writtenRep ?wr\n   }  \nGROUP BY ?senseHyponym ?liitaLemma ?parmigianoLemma ?wr\nORDER BY ASC(?wr)<\/code><\/pre>\n\n\n\n
Check the results<\/a>.<\/p>\n<\/details>\n\n\n\n
Retrieves the Parmigiano and LiITA lemmas corresponding to the meronyms of the lemma ‘giorno’ in CompL-it<\/summary>\n
PREFIX lime: <http:\/\/www.w3.org\/ns\/lemon\/lime#>\nPREFIX vartrans: <http:\/\/www.w3.org\/ns\/lemon\/vartrans#>\nPREFIX rdfs: <http:\/\/www.w3.org\/2000\/01\/rdf-schema#>\nPREFIX skos: <http:\/\/www.w3.org\/2004\/02\/skos\/core#>\nPREFIX dct: <http:\/\/purl.org\/dc\/terms\/>\nPREFIX onto: <http:\/\/www.ontotext.com\/>\nPREFIX lexinfo: <http:\/\/www.lexinfo.net\/ontology\/3.0\/lexinfo#>\nPREFIX ontolex: <http:\/\/www.w3.org\/ns\/lemon\/ontolex#>\nPREFIX rdf: <http:\/\/www.w3.org\/1999\/02\/22-rdf-syntax-ns#>\n\nSELECT ?senseMeronym \nGROUP_CONCAT(str(?_definition);SEPARATOR=\"; esempio: \") AS ?definition \n?liitaLemma ?parmigianoLemma ?wr\nWHERE\n   {\n     SERVICE <https:\/\/klab.ilc.cnr.it\/graphdb-compl-it\/> {\n       ?word a ontolex:Word ;\n             lexinfo:partOfSpeech [ rdfs:label ?pos ] ;\n             ontolex:sense ?sense ;\n             ontolex:canonicalForm [ ontolex:writtenRep ?lemma ] .\n      ?senseMeronym lexinfo:partMeronym ?sense .\n       OPTIONAL {\n         ?senseMeronym skos:definition ?_definition \n       } .\n       FILTER(str(?pos) = \"noun\") .\n       FILTER(str(?lemma) = \"giorno\") .\n       ?wordMeronym ontolex:sense ?senseMeronym .\n     } \n     ?wordMeronym ontolex:canonicalForm ?liitaLemma.\n     ?leItaLexiconPar ontolex:canonicalForm ?liitaLemma;\n                   ^lime:entry <http:\/\/liita.it\/data\/id\/LexicalReources\/DialettoParmigiano\/Lexicon>.\n     ?leItaLexiconPar vartrans:translatableAs ?leParLexiconPar.\n     ?leParLexiconPar ontolex:canonicalForm ?parmigianoLemma.\n     ?parmigianoLemma ontolex:writtenRep ?wr\n   }  \nGROUP BY ?senseMeronym ?liitaLemma ?parmigianoLemma ?wr\nORDER BY ASC(?wr)<\/code><\/pre>\n\n\n\n
Check the results<\/a>.<\/p>\n<\/details>\n\n\n\n
<\/p>\n\n\n\n
Retrieves all Sicilian lemmas having written representations containing the alternation “ed”-“ied”<\/summary>\n
PREFIX lila: <http:\/\/lila-erc.eu\/ontologies\/lila\/>\nPREFIX ontolex: <http:\/\/www.w3.org\/ns\/lemon\/ontolex#>\n\nSELECT ?lemmaSiciliano ?lemmaSicilianoLabel ?wr1 ?wr2\nWHERE {\n?lemmaSiciliano dcterms:isPartOf <http:\/\/liita.it\/data\/id\/DialettoSiciliano\/lemma\/LemmaBank>.\n?lemmaSiciliano rdfs:label ?lemmaSicilianoLabel.\n?lemmaSiciliano ontolex:writtenRep ?wr1, ?wr2 .\nfilter( ?wr1 != ?wr2 ).\nFILTER regex(str(?wr1), \"ied\") .\nFILTER regex(str(?wr2), \"ed\") .\n} group by ?lemmaSiciliano<\/code><\/pre>\n\n\n\n
Check the results.<\/a><\/p>\n<\/details>\n\n\n\n
<\/p>\n\n\n\n
Retrieves Sicilian common nouns ending with the abstract suffix “\u00eca” and show the correspoding Italian translations<\/summary>\n
PREFIX lila: <http:\/\/lila-erc.eu\/ontologies\/lila\/>\nPREFIX ontolex: <http:\/\/www.w3.org\/ns\/lemon\/ontolex#>\nPREFIX dcterms: <http:\/\/purl.org\/dc\/terms\/>\nPREFIX vartrans: <http:\/\/www.w3.org\/ns\/lemon\/vartrans#>\n\nSELECT ?lemma (GROUP_CONCAT(DISTINCT ?wr ;separator=\", \") as ?wrs) ?liitaLemma (GROUP_CONCAT(DISTINCT ?wrIT ;separator=\", \") as ?wrsIT)\nWHERE {\n?lemma dcterms:isPartOf <http:\/\/liita.it\/data\/id\/DialettoSiciliano\/lemma\/LemmaBank>.\n?lemma ontolex:writtenRep ?wr .\n?lemma lila:hasPOS lila:noun .\n?le ontolex:canonicalForm ?lemma.\n?leITA vartrans:translatableAs ?le;\nontolex:canonicalForm ?liitaLemma.\n?liitaLemma ontolex:writtenRep ?wrIT.\nFILTER regex(str(?wr), \"\u00eca$\") .\n} group by ?lemma ?liitaLemma<\/code><\/pre>\n\n\n\n
Check the results.<\/a><\/p>\n<\/details>\n","protected":false},"excerpt":{"rendered":"
The LiITA Knowledge Base is accessible through our SPARQL endpoint, where you can perform advanced queries on the data. Example Queries:<\/p>\n","protected":false},"author":4,"featured_media":0,"parent":69,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-158","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.liita.it\/index.php?rest_route=\/wp\/v2\/pages\/158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.liita.it\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.liita.it\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.liita.it\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.liita.it\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=158"}],"version-history":[{"count":32,"href":"https:\/\/www.liita.it\/index.php?rest_route=\/wp\/v2\/pages\/158\/revisions"}],"predecessor-version":[{"id":277,"href":"https:\/\/www.liita.it\/index.php?rest_route=\/wp\/v2\/pages\/158\/revisions\/277"}],"up":[{"embeddable":true,"href":"https:\/\/www.liita.it\/index.php?rest_route=\/wp\/v2\/pages\/69"}],"wp:attachment":[{"href":"https:\/\/www.liita.it\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}