SPARQL (Basic).txt

/* SPARQL Questionnaire (Basic) Provide the SPARQL query and the result for the following queries expressed in natural language. */

/* 1. Get all the classes */
SELECT DISTINCT ?class
WHERE {
 ?class a rdfs:Class.
}

/* 2. Get all the subclasses of the class Establishment */
PREFIX url: <http://GP-onto.fi.upm.es/exercise2#> 
SELECT ?subclass
WHERE{
  ?subclass rdfs:subClassOf url:Establishment.
}

/* 3. Get all instances of the class City
PREFIX url: <http://GP-onto.fi.upm.es/exercise2#> 
SELECT ?city
WHERE{
  ?city a url:City.
}

/* 4. Get the number of inhabitants of Santiago de Compostela */
PREFIX url: <http://GP-onto.fi.upm.es/exercise2#> 
SELECT ?inhabitant
WHERE{
   url:Santiago_de_Compostela url:hasInhabitantNumber ?inhabitant.
}

/* 5. Get the number of inhabitants of Santiago de Compostela and Arzua */
PREFIX url: <http://GP-onto.fi.upm.es/exercise2#> 
SELECT ?inhabitantS ?inhabitantA
WHERE{
   url:Santiago_de_Compostela url:hasInhabitantNumber ?inhabitantS.
   url:Arzua url:hasInhabitantNumber ?inhabitantA.
}

/* 6. Get all places, together with the number of inhabitants, ordered by the place name (ascending) */
PREFIX url: <http://GP-onto.fi.upm.es/exercise2#> 
SELECT ?place ?inhabitant
WHERE{
   ?place url:hasInhabitantNumber ?inhabitant.
}
ORDER BY ASC(?place)

/* 7. Get all instances of Locality together with their number of inhabitants (if this information exists) */
PREFIX url: <http://GP-onto.fi.upm.es/exercise2#> 
SELECT ?locality ?inhabitant
WHERE{
   ?loc a ?subclass.
   ?subclass rdfs:subClassOf url:Locality.
   OPTIONAL {?locality url:hasInhabitantNumber ?inhabitant.}
}

/* 8. Get all places with more than 200.000 inhabitants */

/* 9. Get postal address data for Pazo_Breogan (street, number, locality, province) */

/* 10. Get all subclasses of class Location */

/* 11. Get all instances of class Locality */

/* 12. Describe the resource with rdfs:label "Madrid” */

/* 13. Construct a graph that relates directly all touristic places with their provinces, using a new property called ”isIn” */

/* 14. Check whether there is any instance of Town */


SPARQL Questionnaire (Advanced) Provide the SPARQL query and the result for the following queries expressed in natural language. The endpoint that you can use for this exercise is: http://es.dbpedia.org/sparql

/* A1. Dame todas las propiedades aplicables a las instancias de la clase Politician (http://dbpedia.org/ontology/Politician) */
SELECT DISTINCT ?p
WHERE {
  ?x a <http://dbpedia.org/ontology/Politician>.
  ?x ?p ?y
}

/* A2. Dame todas las propiedades, exceptuando rdf:type, aplicables a las instancias de la clase Politician (http://dbpedia.org/ontology/Politician) */
SELECT DISTINCT ?p
WHERE {
  ?x a <http://dbpedia.org/ontology/Politician>.
  ?x ?p ?y
  FILTER(?p!=rdf:type)
}

/* A3. ¿Cuántos valores distintos se pueden encontrar para las propiedades, exceptuando rdf:type, de las instancias de la clase Politician (http://dbpedia.org/ontology/Politician)? */
SELECT COUNT DISTINCT ?p
WHERE {
  ?x a <http://dbpedia.org/ontology/Politician>.
  ?x ?p ?y
  FILTER(?p!=rdf:type)
}

/* A4. Para cada una de las propiedades, exceptuando rdf:type, aplicables a las instancias de la clase Politician (http://dbpedia.org/ontology/Politician), dime cuántos valores distintos toman en dichas instancias */
SELECT COUNT DISTINCT ?p ?c
WHERE {
  ?x a <http://dbpedia.org/ontology/Politician> .
  ?x ?p ?y .
  ?y a ?c
  FILTER (?p!=rdf:type)
}

/* A5. Para cada una de las propiedades, exceptuando rdf:type, aplicables a las instancias de la clase Politician (http://dbpedia.org/ontology/Politician), dime la media de valores distintos que toman en dichas instancias. */


/* A6. Para cada una de las propiedades, exceptuando rdf:type, aplicables a las instancias de la clase Politician (http://dbpedia.org/ontology/Politician), dime el máximo número de valores distintos que toman entre todas sus instancias, ordenado de mayor a menor */
SELECT DISTINCT ?p (count(*) as ?count) 
WHERE { 
  ?x a <http://dbpedia.org/ontology/Politician> .
  ?x ?p ?y .
  ?y a ?c 
  FILTER (?p!=rdf:type)
}
ORDER BY DESC(?count)