Microclimate Sensor Readings
This dataset contains environmental readings from microclimate sensors located across the city. The data is updated every hour in fifteen minute increments and can be used to determine variations in microclimate changes throughout the day. Microclimate data includes:
Ambient air temperature
Relative humidity
Barometric pressure
Particulate matter 2.5
Particulate matter 10
Average wind speed
The Microclimate Sensor Readings helps us to understand temperature, relative humidity, pressure, particulate matter 2.5, particulate matter 10, and average wind speed at different locations and different times of day to better inform decision-making and plan for the future.
Additional values are included in this dataset to provide an easier way to correlate the data with the official EPA Victoria data. These can be identified with the value 'epa' included in the type column. EPA Victoria report air quality readings in 1 hour and 24 hour averages. This includes; ambient air temperature readings in 1 hour average, relative humidity readings in 1 hour average, particulate matter 2.5 readings in 1 hour and 24 hour averages, and particulate matter 10 readings in 1 hour and 24 hour averages.
The site_id column can be used to merge the data with the <a href='https://data.melbourne.vic.gov.au/Environment/Mircoclimate-Sensor-Locations/irqv-hjr4' target='_blank'>Sensor Locations dataset</a> which contains the sensor location. Any changes to sensor locations are important to consider when analysing and interpreting historical microclimate data.
Note this dataset may not contain a reading for every sensor for every 15 minutes as the sensor devices might not have a reading for each value. There may be situations where no readings are reported for all sensors or only some readings are reported at a particular site.
For the description of each sensor please see the <a href='https://data.melbourne.vic.gov.au/api/views/u4vh-84j8/files/a2a9a6e3-2d46-4469-8d04-3335306034d5?download=true&filename=MicroClimateSensors_Metadata_Attachment_DataDictionary.pdf'>sensor type document</a>.
Related datasets:
<a href='https://data.melbourne.vic.gov.au/Environment/Mircoclimate-Sensor-Locations/irqv-hjr4' target='_blank'>Microclimate Sensors - Sensor Locations</a>
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"melbourne-vic-gov-au/microclimate-sensor-readings-u4vh-84j8\".\"microclimate_sensor_readings\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.