Weather with SOSA/SSN ontology
This RDF dataset contains the measurements generated by one of the meteorological stations that Irstea owns in its experimental farm at Montoldre. The dataset contains measurements collected from August 2018 up to day. This dataset is updated daily.
Dataset uses the new Semantic Sensor Network Ontology, called (and prefixed) sosa. We also reused some specific ontologies:
- The unit are described by the QUDT ontology.
- The sensor are described by the AWS ontology.
- The location of the weather station is described by the LOCN vocabulary and the geosparql ontology.
The weather station is the same used to generate another RDF dataset based on the old Semantic Sensor Network Ontology. The old dataset is deprecated. More information are available on here.
The data are available under the french open licence of etalab https://www.etalab.gouv.fr/licence-ouverte-open-licence. This licence it is compatible with the «Open Government Licence» (OGL) of the United Kingdom, the «Creative Commons Attribution 2.0» (CC-BY 2.0) licence of Creative Commons and the «Open Data Commons Attribution» (ODC-BY) licence of the Open Knowledge Foundation.
This dataset is aligned with
Access to SPARQL End Point
Access with a Web browser
- A SPARQL query interface using snorql is available at https://ontology.inrae.fr/weather/sparql/.
- A SPARQL query interface that display numeric results as a graph is available at http://ontology.inrae.fr/weather/snorql/test/
- Pubby frontend is available at http://ontology.irstea.fr/weather/.
Access for developer using their own SPARQL client
Access with other SPARQL client (such as sparql-query) is available on the URL https://ontology.inrae.fr/weather/sparql or http://ontology.inrae.fr/weather/sparql. Please limit the results of queries because the database contains more than 18,500,000 triples (one measure per 10 minutes).
Data Structure
Platform
Sensor
Observation
Time Interval
Tools and source files
The sources files to insert data into the SPARQL endpoint from CSV files or PostgreSQL table are availabe on irstea gitlab.
SPARQL Query Example
Minimal temperature per day in June 2019
WHERE
{
?o a sosa:Observation ;
sosa:observedProperty <http://ontology.irstea.fr/weather/resource/observableProperty/air_temperature> ;
sosa:resultTime ?timeStamp ;
sosa:hasResult [ qudt:numericValue ?t ] ;
BIND (DAY(?timeStamp+"PT6H"^^xsd:duration) AS ?DAY)
FILTER (YEAR(?timeStamp)=2019 && MONTH(?timeStamp)=06)
}
GROUP BY ?DAY ORDER BY ?DAY
Quantity of solar radiation per month
WHERE { {
[] a sosa:Observation ;
sosa:observedProperty <http://ontology.irstea.fr/weather/resource/observableProperty/solarFlux_density> ;
sosa:phenomenonTime [ time:hasDuration [ time:unitType time:unitMinute ;
time:numericDuration ?duration ] ;
time:hasEnd [ time:inDateTime [
time:YEAR ?YEAR; time:MONTH ?MONTH ]]];
sosa:hasResult [ qudt:numericValue ?value ] ;
} } GROUP BY ?YEAR ?MONTH ORDER BY ?YEAR ?MONTH
Last measurements of temperature
{ {
SELECT ?time ?temp WHERE
{
[] a sosa:Observation ;
sosa:observedProperty <http://ontology.irstea.fr/weather/resource/observableProperty/air_temperature> ;
sosa:hasResult [ qudt:numericValue ?temp ] ;
sosa:phenomenonTime [ time:inXSDDateTimeStamp ?time ];
}
ORDER BY DESC(?time) LIMIT 288}
}
ORDER BY ?time
Publication
C. ROUSSEY,S. BERNARD, G. ANDRÉ, D. BOFFETY. Weather Data Publication on the LOD using SOSA/SSN Ontology.Semantic Web Journal, 2019 http://www.semantic-web-journal.net/content/weather-data-publication-lod-using-sosassn-ontology-0
This dataset was published on Datahub.
A turtle dump file is available at Dump file. It contains data from August 2018 to July 2019. If the dump is no more available please contact catherine.roussey@inrae.fr or stephan.bernard@inrae.fr