Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3
Page Tree
rootTA-SPARQL
startDepth2

The Query Utility 

Example data:

Subject 

Predicate

Object

urn:ChampaignWeather["2009-9-10"^^xsd:date]

urn:hasMaxTemperature

"81"

urn:ChampaignWeather["2009-9-9"^^xsd:date]

urn:hasMaxTemperature

"76"

urn:ChampaignWeather["2009-9-8"^^xsd:date]

urn:hasMaxTemperature

"79"

urn:ChampaignWeather["2009-9-7"^^xsd:date]

urn:hasMaxTemperature

"78"

urn:ChampaignWeather["2009-9-6"^^xsd:date]

urn:hasMaxTemperature

"77"

urn:DaytonaWeather["2009-9-10"^^xsd:date]

urn:hasMaxTemperature

"88"

urn:DaytonaWeather["2009-9-9"^^xsd:date]

urn:hasMaxTemperature

"88"

urn:DaytonaWeather["2009-9-8"^^xsd:date]

urn:hasMaxTemperature

"87"

urn:DaytonaWeather["2009-9-7"^^xsd:date]

urn:hasMaxTemperature

"86"

Daily temperature in Champaign during September 2009

Code Block
BASE <urn:>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema>
SELECT ?x
WHERE {
 ChampaignWeather["2009-9-1"^^xsd:date ..
                  "2009-9-30"^^xsd:date] hasMaxTemperature ?x .
}

Temperature on Sep 9-10 for every city

Code Block
BASE <urn:>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema>
SELECT ?x ?x.t ?y
WHERE {
  ?x["2009-9-9"^^xsd:date .. "2009-9-10"^^xsd:date]
     hasMaxTemperature ?y .
}

Most recent known temperature for Champaign

Code Block
BASE <urn:>
SELECT *
WHERE {
  ChampaignWeather[LAST] hasMaxTemperature ?x .
}

Oldest known temperature for Champaign

Code Block
BASE <urn:>
SELECT *
WHERE {
  ChampaignWeather[FIRST] hasMaxTemperature ?x .
}

In which days was the temperature at Champaign 88 degrees

Code Block
BASE <urn:>
SELECT ?x ?x.t
WHERE {
 ChampaignWeather[*] -> ?x hasMaxTemperature "88" .
}

What was the maximum temperature in Champaign during the month of September

Code Block
BASE <urn:>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema>
SELECT MAX(?y)
WHERE {
  ChampaignWeather["2009-9-1"^^xsd:date ..
                   "2009-9-30"^^xsd:date]
       hasMaxTemperature ?y .
}