Do you feel like a certain rooms in your home are always much warmer/cooler than the rest of the house?
Want to know how effective your HVAC system is at maintaining a specific temperature in the summer or winter?
Home CC Monitor is a real-time IoT monitoring application for home climates that addresses these questions. It retrieves data from sensor nodes throughout a house over a RESTful API and stores the data in a database. The front-end allows one to easily analyze the temperature variations per room via historical data visualization, as well as monitor live temperature and humidity status of each sensor node. The project will ultimately provide a low-cost solution to evaluating the efficiency of one's HVAC system.
- Maintain a database of organized temperature data from an API feed which is displayed on the front-end.
- Visualization of current temperature data per room.
- Visualization of historical temperature data.
The project consists of minimal hardware and full stack deployment of Python/Javascript/jQuery/PostgreSQL.
- Compare overall data to local weather conditions using a local weather API.
- Create customizable alerts for rooms that exceed or fall below set values.
- Integrate alerts with IFTTT Service
- Make the application scalable using unique ID’s and passwords for multiple users.
- Create a mobile friendly front-end.
- Create more complex Javascript functions to analyze historical temperatures logs and predict home climate or further quantify temperature deviations.
The project uses Pipenv to manage following Python libraries in a virtualenv:
$ pipenv install requests tornado queries jinja2 arrow
We chose to use ThingSpeak's REST API service to publish and retrieve data. An API Key is needed to make GET and POST requests to a private channel. Documentation can be found here.
An SQL database needs to be setup with columns for datetime and each additional field of sensor data. For example:
CREATE TABLE home_monitor (
id SERIAL NOT NULL PRIMARY KEY,
created TIMESTAMP WITH TIME ZONE,
bedroom_temp NUMERIC,
bedroom_humidity NUMERIC,
livingroom_temp NUMERIC,
livingroom_humidity NUMERIC
);
The Python script at cron_jobs/get_latest.py is run every 30 minutes by adding the following job to crontab:
*/30 * * * * cd /home/username/climate-control-system-monitor && /path/to/pipenv run python3 cron_jobs/get_latest.py
where get_latest.py and pipenv are full paths. The script retrieves updated data from ThingSpeak's API, inserts it into the database, and generates a JSON file in the monitor/static/json/ directory
2018-07-29
Updated Tornado server file, page js file and related html file to make them compatible with json file instead of database value
Bootstrap | 
CSS3 | 
NGINX | 
ThingSpeak
HTML5 | 
JavaScript | 
Jinja2 | 
jQuery
Highcharts | 
PostgreSQL | 
Python 3 | 
Tornado