Collect and analyze


ThingSpeak is an open data platform for the internet of things I've chosen to collect and analyze Squirrel Feeder data. Sensor data is send to the cloud which then can be visualized easily.

 

For the first time I'm using a service offered by The MathWorks Inc. who are well known for their MATLAB and Simulink software packages. So I'm curious to learn what tools are available to understand relationships in data.

The first graph shown is a plot of the environmental temperature measured at the Squirrel Cafe. The temperature is pushed at a frequency of 5 minutes to ThingSpeak cloud. The second plot shows how many nuts have been chowed down. Whenever the lid is closed for a period of 90 secs the nut counter resets to 0. The third diagram gives you an idea of the eating speed which is calculated in "Nuts per minute [npm]".

 

If the data of the following diagrams isn't displayed correctly, reload the webpage please.

Outside temperature

Nut consumption

Nut consumption speed

 

 

 

 



If you are interested in the data collected by The Squirrel Cafe, feel free to download it. The data covers the timeframe from July 28th 2016 to Aug. 8th 2018.

 

Download
The Squirrel Cafe Data
TheSquirrelCafe_data_csv.zip
Compressed Archive in ZIP Format 1.3 MB

Since April 16th 2017 I've taken temperature measurements with a different device called @airrohr. Therefore you'll find two CSV files in the data archive, the original tsc_data.csv file and a airrohr_data.csv file containing temperature measurements after April 16th 2017. Temperature measurements have been dropped in the tsc_data.csv file after April 16th 2017.

 

More information about the @airrohr project which also measures particle matter PM10 and PM2.5  can be found on http://luftdaten.info.  It's a citizien science project to measure air quality. Please, have a look at the map of luftdaten.info to see realtime air quality measurements taken by over 1000 sensors.

 

If you have any questions don't hesitate to contact me. Also, if you have done something tantalizing with the data, please let me know.