Jours chauds
Quel est le nombre de jours chauds pour l'année 2019
Calcul avec la temperature maximale journalière :
SELECT COUNT(?T_max)
WHERE {
SELECT ?jour ?mois (MAX(?value) AS ?T_max)
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
HAVING (?T_max > 35)
ORDER BY ?mois ?jour
}
WHERE {
SELECT ?jour ?mois (MAX(?value) AS ?T_max)
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
HAVING (?T_max > 35)
ORDER BY ?mois ?jour
}