COOP-Therm : a module to analyse data from temp & humidity data loggers

[SebastiendOrnano]

I’m still working on my app: CO-OP, designed to monitor building self-renovation projects. In residential building renovation, the first goal is to improve thermal and humidity comfort. To achieve this goal you have to perform a lot of complex calculations to identify the best materials, but, at the end, you have to check whether your choices were the right ones. To do this, measurements must be taken by placing data logger sinside and outside over several days (several hundred data points, since logging occurs every 15 minutes !).

Once the data has been retrieved as a CSV file, it must be analyzed. To do this, you have the choice between :

• using the software provided with the sensor, but it doesn’t allow for comparisons, online collaboration...
• building a galaxy brain solution, spahetti style , with Excel spreadsheets
• creating a simple app that exactly meets your needs (and is accessible online) with SQLPage.

I chose the third option and I committed a THERM module in COOP !

For data retrieval, I use a bulk import (see example 14 in the documentation); to retrieve the sensor locations, a GeoJSON file f(to do that you have to create a PostGIS extension!).

Analysis can be performed by cross-referencing data from two sensors over the same period (outdoor-indoor comparison). Using various PostgreSQL functions and CTEs, you can calculate the phase shift and the amplitude attenuation factor when comparing outdoor and indoor data. Below a proof of the efficiency of the use of a bio-based material : straw clay to stabilyze temperature and humidity in a buiding.,

Analysis can be performed by comparing data from a single sensor at different times (for example, between periods with the heating on or off). Temperature stability can be calculated by determining the standard deviation.

The analysis can also be focused by filtering for a specific time period. Results can be viewed as graphs, and data can be exported as CSV files and graphs as SVG files.

And you can open your app to users with CRUD rights

and users with only CRU rights :

I am convinced that SQLPage is at his best for that kind of application where you have to deal with a load of data to analyse. SQLPage allows a no-pro developper to commit a tailor made, efficient solution. Thanks to Ophir and all the contributors !