Query Semantic Resources

To query semantic resources, access the Virtuoso SPARQL Endpoint Page made available by scheme. You will see a screen where you can enter a query to specify using the SPARQL language

Descriptive image of the screen that allows you to write a SPARQL query

Once the query is written, you can select in which format to return the results. Several options are possible including HTML, CSV, JSON, and several RDF serializations such as RDF/Turtle, RDF/XML, and N-Triples.
By clicking on the “Execute Query” button, you can run the query to get the results you are looking for.
To cancel everything you typed and chose as a result, you can use the Reset button.

Descriptive image of options regarding query result format, query execution and query cancellation

Note:

To facilitate the definition of the query, it is suggested to browse the various semantic resources currently published on the schema via the Web. The resources are navigable through software made available such as LODE and LodView. To do this, simply use the URI of the resources themselves in your browser.

Examples of SPARQL queries

Below are some examples of queries on schema semantic resources in natural language. Each query corresponds to a SPARQL query that can be executed by Virtuoso as described above.

Below are some examples of queries on schema semantic resources in natural language. Each query corresponds to a SPARQL query that can be executed by Virtuoso as described above.

  • Which Italian municipalities, with their belfiore code, of the historical archive are valid to date? 
    PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX clv: <https://w3id.org/italia/onto/CLV/> PREFIX ti: <https://w3id.org/italia/onto/TI/> PREFIX l0: <https://w3id.org/italia/onto/l0/> SELECT ?s ?ID ?idCadastral ?name ?starttime ?endTime WHERE {?s a skos:Concept ; skos:inScheme <https://w3id.org/italia/controlled-vocabulary/territorial-classifications/cities> ; skos:notation ?ID ; skos:prefLabel ?name ; clv:hasSOValidity/ti:endTime ?endTime ; clv:hasSOValidity/ti:startTime ?starttime ; ?identifier a clv:Identifier ; clv:identifierType ?idType ; l0:identifier ?idCadastral . FILTER (str(?endTime)="9999-12-31") FILTER (str(?idType) = "Catastal Code") FILTER (lang(?idType) = "it") }
  • In which semantic resource is the concept of ‘Public Service’ defined and what is its definition? 
    PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX dct: <http://purl.org/dc/terms/> SELECT ?URIResource ?titleResource ?URIConcept ?label ?definition where { ?URIConcept rdfs:isDefinedBy ?URIResource ; rdfs:label ?label ; rdfs:comment ?definition . ?URIResource dct:title ?titleResource . FILTER ((str(?label)="Public Service")) FILTER (lang(?label) = 'it') FILTER (lang(?definition) = 'it') FILTER (lang(?titleResource) = 'it') }
  • What are the licenses that fall under the open license type? 
    PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX clv: <https://w3id.org/italia/onto/CLV/> SELECT ?s ?ID ?name ?nameOpen WHERE {?s a skos:Concept ; skos:inScheme <https://w3id.org/italia/controlled-vocabulary/licences> ; clv:hasRankOrder "3" ; skos:notation ?ID ; skos:prefLabel ?name ; skos:broader*/skos:prefLabel ?nameOpen . FILTER (str(?nameOpen)="Open License") FILTER (lang(?nameOpen) = 'it') FILTER (lang(?name) = 'it') }
  • Which are the Italian provinces valid to date and to which region do they belong? 
    PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX clv: <https://w3id.org/italia/onto/CLV/> SELECT ?s ?province ?name ?IDISTATProv ?IDISTATReg ?nameRegion WHERE { ?s a skos:Concept ; skos:inScheme <https://w3id.org/italia/controlled-vocabulary/territorial-classifications/provinces> ; skos:notation ?IDISTATProv ; skos:prefLabel ?name ; clv:acronym ?province ; skos:broader ?region . ?region a skos:Concept ; skos:inScheme <https://w3id.org/italia/controlled-vocabulary/territorial-classifications/regions> ; skos:notation ?IDISTATReg ; skos:prefLabel ?nameRegion . }

    What are metropolitan cities?

    PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX clv: <https://w3id.org/italia/onto/CLV/> PREFIX l0: <https://w3id.org/italia/onto/l0/> SELECT ?s ?province ?name ?IDISTATProv ?IDISTATReg ?nameRegion ?identifier ?idMetropolitanCode WHERE { ?s a skos:Concept ; skos:inScheme <https://w3id.org/italia/controlled-vocabulary/territorial-classifications/provinces> ; skos:notation ?IDISTATProv ; skos:prefLabel ?name ; clv:acronym ?province ; clv:hasIdentifier ?identifier ; skos:broader ?region . ?identifier a clv:Identifier ; clv:identifierType ?idType ; l0:identifier ?idMetropolitanCode . ?region a skos:Concept ; skos:inScheme <https://w3id.org/italia/controlled-vocabulary/territorial-classifications/regions> ; skos:notation ?IDISTATReg ; skos:prefLabel ?nameRegion . FILTER (str(?idType) = "Metropolitan City Code") FILTER (lang(?idType) = 'it') }
  • In which semantic resource is the “Civic Number” defined? 
    PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX dct: <http://purl.org/dc/terms/> SELECT ?URIResource ?titleResource ?URIConcept ?label where { ?URIConcept rdfs:isDefinedBy ?URIResource ; rdfs:label ?label . ?URIResource dct:title ?titleResource . FILTER ((str(?label)="Civic Number")) FILTER (lang(?label) = 'it') FILTER (lang(?titleResource) = 'it') }