Bologna acciona sensors latest measurements 2020

URL: https://opendata.rockproject.eu/api/3/action/datastore_search_sql?sql=with c as ( select * from "84891031-8735-4776-9784-c50a00594b62" d join "556ae20a-599e-4d88-a534-303a3b16fa1b" s on d."SensorId" = s."ID_Sensor" where d."AmbTemp" is not null ), p as ( select * from "b7f0d0d9-1c91-4756-be50-7d919d5736dd" d join "556ae20a-599e-4d88-a534-303a3b16fa1b" s on d."SensorId" = s."ID_Sensor" ), n as ( select * from "6e628bae-777f-421b-92ee-79af74805f3b" d join "556ae20a-599e-4d88-a534-303a3b16fa1b" s on d."SensorId" = s."ID_Sensor" ) select CAST('Bologna' as VARCHAR) city,c."Sensor_Location", c."time", cast(c."AmbTemp" as FLOAT) "AmbTemp", cast(c."AmbHum" as FLOAT) "AmbHum" , cast(c."Pressure" as FLOAT) "Pressure",cast(c."WindSpeed" as FLOAT) "WindSpeed", cast(c."WindDirection" as FLOAT) "WindDirection", cast(c."RainLast24H" as FLOAT) "RainLast24H", cast(p."PM1" as FLOAT) "PM1", cast(p."PM2_5" as FLOAT) "PM2_5", cast(p."PM10" as FLOAT) "PM10", n."NOISE" from c left join p on c."time" = p."time" and c."Sensor_Location" = p."Sensor_Location" left join n on c."time" = n."time" and c."Sensor_Location" = n."Sensor_Location" order by c."time" desc, c."Sensor_Location" limit 25

From the dataset abstract

This dataset contains only test data

Source: Test Dataset

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

Download resource

Additional Information

Field Value
Data last updated July 22, 2019
Metadata last updated July 22, 2019
Created July 22, 2019
Format JSON
License Creative Commons Attribution
createdover 1 year ago
formatJSON
has viewsTrue
id90c2ccaf-deac-43df-b754-26f6dec127bb
on same domainTrue
package idd5ec2707-9b0e-4526-8062-f23f13a6e1ed
position13
revision id5a325d2a-4dc1-46ba-98f4-4762c8ffbec7
stateactive