Go to resource

Eindhoven acciona sensors latest measurements 2020

URL: https://opendata.rockproject.eu/api/3/action/datastore_search_sql?sql=with c as ( select * from "e21b3e2d-57e4-4067-8155-77de422b92ec" d join "9b4fa48e-a2bb-4400-b64a-d2f70e588aba" s on d."SensorId" = s."ID_Sensor" where d."Temp" is not null ), p as ( select * from "741cecad-b43d-4eae-bc29-7ccec390f319" d join "9b4fa48e-a2bb-4400-b64a-d2f70e588aba" s on d."SensorId" = s."ID_Sensor" ) select CAST('Eindhoven' as VARCHAR) city,c."Sensor_Title", c."time", cast(c."Temp" as FLOAT) "Temp", cast(c."RelHum" as FLOAT) "RelHum" , cast(p."PM1" as FLOAT) "PM1", cast(p."PM_25" as FLOAT) "PM2_5", cast(p."PM10" as FLOAT) "PM10", cast(p."Ozon" as FLOAT) "Ozon", cast(p."NO2" as FLOAT) "NO2" from c left join p on c."time" = p."time" and c."ID_Sensor"%2B100 = p."ID_Sensor" order by c."time" desc, c."Sensor_Title" limit 50

From the dataset abstract

This dataset contains only test data

Source: Test Dataset

Text

Fullscreen Embed

This resource view is not available at the moment. Click here for more information.

Download resource

Additional Information

Field	Value
Data last updated	January 21, 2020
Metadata last updated	January 21, 2020
Created	January 21, 2020
Format	JSON
License	Creative Commons Attribution
created	over 1 year ago
format	JSON
has views	True
id	186c18d3-2542-4e3a-8ba8-9b54ed3b0f45
on same domain	True
package id	d5ec2707-9b0e-4526-8062-f23f13a6e1ed
position	14
revision id	53e05e1d-8025-4117-bde9-d612f84293e1
state	active