Température minimale journalière
Affichez les 100 premières températures minimales journalières de l'année 2019
SELECT ?jour ?mois (MIN(?value) AS ?T_min)
WHERE { GRAPH inrae_graph:2019
{
?obs a sosa:Observation.
?obs sosa:observedProperty inrae_property:air_temperature.
?obs sosa:resultTime ?timeStamp.
?obs sosa:hasResult ?res.
?res qudt:numericValue ?value.
BIND (DAY(?timeStamp+"PT6H"^^xsd:duration) AS ?jour).
BIND (MONTH(?timeStamp+"PT6H"^^xsd:duration) AS ?mois).
FILTER ( YEAR(?timeStamp)=2019 )
}}
GROUP BY ?mois ?jour
ORDER BY ?mois ?jour
LIMIT 100
WHERE { GRAPH inrae_graph:2019
{
?obs a sosa:Observation.
?obs sosa:observedProperty inrae_property:air_temperature.
?obs sosa:resultTime ?timeStamp.
?obs sosa:hasResult ?res.
?res qudt:numericValue ?value.
BIND (DAY(?timeStamp+"PT6H"^^xsd:duration) AS ?jour).
BIND (MONTH(?timeStamp+"PT6H"^^xsd:duration) AS ?mois).
FILTER ( YEAR(?timeStamp)=2019 )
}}
GROUP BY ?mois ?jour
ORDER BY ?mois ?jour
LIMIT 100