To be used in conjunction with the guides and tutorials at https://github.com/raspberrypilearning/weather_station_guide (published at www.raspberrypi.org/weather-station)

This repo is for code and technical stuff specifically for Texy's weather station shield.

---

Weather Station

Data logging code for the Raspberry Pi Weather Station Shield by Texy

Instructions to deploy

1. Start with a fresh install of Raspbian or Raspbian Lite.
2. Enable I²C. Enter the following command after logging into your Pi:

sudo raspi-config

Select Advanced Options and press Enter

Select I2C and press Enter

Note: If you do not see the I2C option listed it means you have an old image of Raspbian. Please visit the downloads page and update your SD card to the latest version.

Would you like the ARM I2C interface to be enabled? Yes > Enter

The ARM I2C interface is enabled Ok > Enter

1. Enable 1-Wire.
   Select Advanced Options and press Enter

Select 1-Wire and press Enter

Enable one-Wire interface? Enable > Enter

One-wire interface is enabled Ok > Enter

Select Finish from the main menu and press Enter

Would you like to reboot now? Yes > Enter

1. Log back in and configure the required device tree overlays. Enter the following command:

sudo nano /boot/config.txt

Add the following lines to the bottom of the file:

dtoverlay=i2c-rtc,ds3231

Confirm that the following lines are already present, if not add them :

dtparam=i2c_arm=on

dtoverlay=w1-gpio

Press Ctrl - O then Enter to save and Ctrl - X to quit nano.

Now set the required modules to load automatically on boot.

sudo nano /etc/modules

If not already present, add the following lines to the bottom of the file:

i2c-dev
w1-therm

Press Ctrl - O then Enter to save and Ctrl - X to quit nano.

1. Ensure that a CR/BR1225 3 volt coin cell battery has been inserted into the cage. Positive + side facing up.
2. Reboot for the changes to take effect.

sudo reboot

1. Check that the Real Time Clock appears in /dev

ls /dev/rtc*

Expected result: /dev/rtc0

1. Initialise the RTC with the correct time.

Use the date command to check the current system time is correct. If correct then you can set the RTC time from the system clock with the following command:

sudo hwclock -w

If not then you can set the RTC time manually using the command below (you'll need to change the --date parameter, this example will set the date to the 1st of January 2014 at midnight):

sudo hwclock --set --date="2014-01-01 00:00:00" --utc

Then set the system clock from the RTC time.

sudo hwclock -s

You can passively display the time in the RTC using: sudo hwclock -r

1. Remove the fake hardware clock package.

sudo update-rc.d fake-hwclock remove
sudo apt-get remove fake-hwclock -y

1. Install the necessary software packages.

sudo apt-get update
sudo apt-get install i2c-tools python-smbus git-core telnet apache2 mysql-server python-mysqldb php5 libapache2-mod-php5 php5-mysql -y

This will take some time. You will be prompted to create and confirm a password for the root user of the MySQL database server.

1. Create the database within MySQL.

mysql -u root -p

Enter the password that you chose during installation.

You'll now be at the MySQL prompt mysql>, first create the database:

CREATE DATABASE weather;

Expected result: Query OK, 1 row affected (0.00 sec)

Switch to that database:

USE weather;

Expected result: Database changed

Create the table that will store all of the weather measurements:

CREATE TABLE WEATHER_MEASUREMENT(
  ID BIGINT NOT NULL AUTO_INCREMENT,
  REMOTE_ID BIGINT,
  AMBIENT_TEMPERATURE DECIMAL(6,2) NOT NULL,
  GROUND_TEMPERATURE DECIMAL(6,2) NOT NULL,
  AIR_QUALITY DECIMAL(6,2) NOT NULL,
  AIR_PRESSURE DECIMAL(6,2) NOT NULL,
  HUMIDITY DECIMAL(6,2) NOT NULL,
  WIND_DIRECTION DECIMAL(6,2) NULL,
  WIND_SPEED DECIMAL(6,2) NOT NULL,
  WIND_GUST_SPEED DECIMAL(6,2) NOT NULL,
  RAINFALL DECIMAL (6,2) NOT NULL,
  CREATED TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY ( ID )
);

Expected result: Query OK, 0 rows affected (0.05 sec)

Press Ctrl - D or type exit to quit MySQL.

1. Test that the I²C devices are online and working.

sudo i2cdetect -y 1

Expected output:

   0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f
00:          -- -- -- -- -- -- -- -- -- -- -- -- --
10: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
20: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
30: -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
40: 40 -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
50: -- -- -- -- -- -- -- 57 -- -- -- -- -- -- -- --
60: -- -- -- -- -- -- -- -- UU 69 -- -- -- -- -- --
70: -- -- -- -- -- -- 76 --
                     

• 40 = HTU21D. Humidity and temperature sensor module.
• 57 = EEPROM on the RTC module, this is not used.
• 68 = DS3231. Real Time Clock module, it will show as UU because it's reserved by the driver.
• 69 = MCP3428. Analogue to Digital Converter.
• 76 = BME280 presure, humdity and temperature sensor module

1. Download the data logging code.

cd ~
git clone https://github.com/Texy/weather-station.git

This will create a new folder in the home directory called weather-station.

1. IMPORTANT

• If you have the small HAT version of the weather board you must skip this step.
• If you have the massive prototype weather board (with the cloud graphic) you must do this step.

cd weather-station
git checkout prototype

1. Install additional Adaruit libraries in order to use the BME280 module.

sudo apt-get install python-pip python-dev
cd ~
git clone https://github.com/adafruit/Adafruit_Python_GPIO.git
cd ~\Adafruit_Python_GPIO
sudo python setup.py install

1. Start the Weather Station daemon and test it.

sudo ~/weather-station/interrupt_daemon.py start

Expected result: PID: 2345 (your number will be different)

A continually running process is required to monitor the rain gauge and the anemometer. These are reed switch sensors and the code uses interrupt detection. These interrupts can occur at any time as opposed to the timed measurements of the other sensors. You can use the telnet program to test or monitor it.

telnet localhost 49501

Expected result:

Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
OK

The following text commands can be used:

• RAIN: displays rainfall in ml
• WIND: displays average wind speed in kph
• GUST: displays wind gust speed in kph
• RESET: resets the rain gauge and anemometer interrupt counts to zero
• BYE: quits

Use the BYE command to quit.

1. UPDATE THE MYSQL CREDENTIALS FILE You'll need to use the password for the MySQL root user that you chose during installation. If you are not in the weather-station folder, type:

cd ~/weather-station
nano credentials.mysql

Change the password field to the password you chose during installation of MySQL. The double quotes " enclosing the values are important, so take care not to remove them by mistake.

Press Ctrl + O then Enter to save, and Ctrl + X to quit nano.

1. Set the Weather Station daemon to automatically start at boot time.

sudo nano /etc/rc.local

Insert the following lines before exit 0 at the bottom of the file:

echo "Starting Weather Station daemon..."
/home/pi/weather-station/interrupt_daemon.py start

1. The main entry point for the code are log_all_sensors.py. This will be called by the cron scheduler to automatically take measurements. The measurements will be saved in the local MySQL database.

The template crontab file crontab.save is provided as a default. If you wish to change the measurement or upload frequency then edit this file before going onto the next step:

cd ~/weather-station/
nano crontab.save

Press Ctrl - O then Enter to save and Ctrl - X to quit nano when you're done.

1. Heads up! At this point you may wish to stop and check out the Weather Station scheme of work (here).
2. Enable cron to automatically start taking measurements, also known as data logging mode.

cd ~/weather-station/
crontab < crontab.save

Your weather station is now live and recording data at timed intervals.

You can disable data logging mode at any time by removing the crontab with the command below:

crontab -r

To enable data logging mode again use the command below:

crontab < ~/weather-station/crontab.save

Note: Do not have data logging mode enabled while you're working through the data Collection lessons in the scheme of work.

1. You can manually cause a measurement to be taken at any time with the following command:

sudo ~/weather-station/log_all_sensors.py

Don't worry if you see Warning: Data truncated for column X at row 1, this is expected.

1. You can manually trigger an upload too with the following command:

sudo ~/weather-station/upload_to_oracle.py

1. You can also view the data in the database using the following commands:

mysql -u root -p

Enter the password. Then switch to the weather database:

USE weather;

Run a select query to return the contents of the WEATHER_MEASUREMENT table.

SELECT * FROM WEATHER_MEASUREMENT;

After a lot of measurements have been recorded it will be sensible to use the SQL where clause to only select records that were created after a specific date and time:

SELECT * FROM WEATHER_MEASUREMENT WHERE CREATED > '2014-01-01 12:00:00';

Press Ctrl - D or type exit to quit MySQL.

1. Go here to download and install the demo website.