Naesstrom

Sensors created in HASS
- sensor.luftdaten_pm10
- sensor.luftdaten_pm25

##HASS template:
## Calculate AirQUality:
##        average percentage of values below thesholds defined by WHO
##        <=40% -> EXCELLENT
##        <=60% -> GOOD
##        <=80% -> FAIR

Naesstrom

### PM10
SELECT mean("SDS_P1") FROM "feinstaub" WHERE ("node" = 'esp8266-3402380') AND $timeFilter GROUP BY time(1h)

### PM2.5
SELECT mean("SDS_P2") FROM "feinstaub" WHERE ("node" = 'esp8266-3402380') AND $timeFilter GROUP BY time(1h)

Naesstrom

[
    {
        "id": "36e44ecd.4941f2",
        "type": "tab",
        "label": "Flow 4",
        "disabled": true,
        "info": ""
    },
    {
        "id": "bd43a711.db4298",

Naesstrom

- alias: Earth hour starts
  trigger:
    platform: time
    after: "20:30:00"
  condition:
    condition: time
    weekday:
      - sat
  action:
    service: light.turn_off

Naesstrom

2018-05-07 21:29:56 ERROR (MainThread) [homeassistant.components.sensor.statistics] mean requires at least one data point
2018-05-07 21:29:56 ERROR (MainThread) [homeassistant.components.sensor.statistics] variance requires at least two data points
2018-05-07 21:29:56 ERROR (MainThread) [homeassistant.components.sensor.statistics] mean requires at least one data point
2018-05-07 21:29:56 ERROR (MainThread) [homeassistant.components.sensor.statistics] variance requires at least two data points
2018-05-07 21:29:56 ERROR (Thread-8) [homeassistant.components.sensor.command_line] Command failed: curl http://192.168.1.236/data.json
2018-05-07 21:29:56 ERROR (MainThread) [homeassistant.components.sensor.statistics] mean requires at least one data point
2018-05-07 21:29:56 ERROR (MainThread) [homeassistant.components.sensor.statistics] variance requires at least two data points
2018-05-07 21:29:57 ERROR (Thread-6) [homeassistant.components.sensor.command_line] Command failed: curl http://192.168.1.236/data.json
2018-

Naesstrom

 INFO [05-09 13:50:54] - MM, Starting NxFilter v4.2.6
 INFO [05-09 13:50:54] - MM, It's running stand alone.
 INFO [05-09 13:51:08] - CLlN, Loading vxlogon.
 INFO [05-09 13:51:08] - CLlC, Loading config.
 INFO [05-09 13:51:08] - CLcLC, Copying config into local DB.
 INFO [05-09 13:51:10] - CLlDS, Loading dns_setup.
 INFO [05-09 13:51:11] - RCcNC, Negative cache cleared.
 INFO [05-09 13:51:11] - ZDlDD, Loading dynamic domains.
 INFO [05-09 13:51:11] - CLlZF, Loading zone_file.
 INFO [05-09 13:51:11] - CLlA, Loading alert.

Naesstrom

[
    {
        "id": "9807b581.2c0318",
        "type": "tab",
        "label": "Temperatur.nu",
        "disabled": false,
        "info": ""
    },
    {
        "id": "972bb80a.6aca08",

Naesstrom

Contents of ~/.node-red/settings.js

functionGlobalContext: {
        // os:require('os'),
        // octalbonescript:require('octalbonescript'),
        // jfive:require("johnny-five"),
        // j5board:require("johnny-five").Board({repl:false}),
           TelldusAPI:require("telldus-live"),
           mqttModule:require("mqtt")
 },

Naesstrom

#include <Stepper_28BYJ_48.h>
#include <ESP8266WiFi.h>
#include <ESP8266mDNS.h>
#include <PubSubClient.h>
#include <WiFiUdp.h>
#include <WiFiManager.h>
#include <ArduinoJson.h>
#include "FS.h"
#include <WiFiClient.h>
#include <ESP8266WebServer.h>

Naesstrom

sensor:
  - platform: template
    sensors:
      erik_location:
        friendly_name: "Erik's Location"
        value_template: "{{ states.device_tracker.google_maps_110812454925350234140.attributes.address }}"

      sussa_location:
        friendly_name: "Sussas's Location"
        value_template: "{{ states.device_tracker.google_maps_114557479077035215629.attributes.address }}"