You can query the database directly using the following query (GET request):
The server will offer a file for download containing the Meet je Stad data.
attribute selects how to pack the data.
- Use csv if you want to have a tab separated file for easy import in a spreadsheet or statistics tool.
- sql can be used if you want to help develop the website and need a local dataset to query.
attribute defines which kind of data to download:
- sensors selects measurements done by the Meet je Stad sensor stations
- flora selects flora observations put in through the website
- stories selects the stories database. Please note that CSV export is not possible for stories.
attribute defines the number of rows to return. Setting it to ALL will return all data. Be careful though not to download more data than needed to prevent excessive server load.
Data can be narrowed down to a number of nodes and a specific time window by adding begin
attributes to the query, denoted as yyyy-mm-dd,hh:mm. E.g. begin=2017-11-16,12:00 will return data beginning 16th of November 2017 at noon. Times are specified in the UTC timezone.
When sensordata is queried the ids
attribute can be used to get data of a single node or a set of nodes. A comma separates the node numbers. A minus symbol can be used to get a range. E.g. ids=1,3-5,8 will return data for the nodes 1, 3, 4, 5 and 8.
Get latest measurement for a single node as a json record
Download a two day time series for a single node as a csv table
Download a data to create a heat map for a certain set of sensors