Direct query
You can query the database directly using the following query (GET request):
https://meetjestad.net/data/?type=[sensors|flora|stories]&format=[csv|json]&limit=XXX
The server will offer a file for download containing the Meet je Stad data.
Attributes
The
format 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.
- Using json is convenient if you want to further process the data in a programming language, e.g. Python, PHP or Javascript.
- sql can be used if you want to help develop the website and need a local dataset to query.
The
type 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.
The
limit 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.
Time series
Data can be narrowed down to a number of nodes and a specific time window by adding
begin and
end 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.
Sensor sets
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.
Examples
Get latest measurement for a single node as a json record
https://meetjestad.net/data/?type=sensors&ids=24&format=json&limit=1
Download a two day time series for a single node as a csv table
https://meetjestad.net/data/?type=sensors&ids=24&begin=2017-11-16,00:00&end=2017-11-18,00:00&format=csv&limit=100
Download a data to create a heat map for a certain set of sensors
https://meetjestad.net/data/?type=sensors&ids=11,14,19,26,31,37,41,47&begin=2017-11-16,12:00&end=2017-11-16,12:15&format=json&limit=100