DISCLAIMER: The software and scripts below are freely available for download, this is my way of giving back to this community. Here’s the deal, please feel free to download the available solutions, but do so at your own risk. Anything listed on this site comes as-is, with no warranties either expressed or implied. I will not, and can not, be held responsible for any damages or loss of any kind that occurs as a result of downloading and using anything that is available here. Only continue if you understand this and accept these risks.
This script comes as-is, with no warranties either expressed or implied. I am not, and can not, be held responsible for any damages or loss of data that occurs as a result of downloading and using this script. Only continue if you completely understand this, accept these risks, have read and understand the known issues detailed in the documentation, and have the knowledge and skills necessary to implement this process.
Designed specifically with WeatherLink in mind, this script enables you to automate the process of backing up your weather station data. By automating the execution
of this PowerShell script, your entire backup process can become something that just happens.
New in 1.0.3 (06/08/2016):
Integrates with 7zip which allows you to compress your data backups. Testing has revealed an 80%+ savings in storage requirements over non-compressed.
Staged backups. This allows you to initally backup to faster (SSD) storage, then move the backup to slower storage for archiving. This enables us
to spend less time working with the 'live' data thus further avoiding 'file in-use' complications.
Base Features:
Specify a drive/folder location of your WeatherLink data that you will be backing up.
Specify a drive/folder that you send this backup data.
To organize your backups, this script will automatically create the following folder layout: <Drive Letter>:\YYYY\MM\DD\wlb_hhmm
Configure this script to keep backups for any length of time, the only limitation is the amount of available drive space.
Backups that are older than the configured archive interval are automatically purged.
Email notifications. If enabled, the script will send an email each time it is ran, indicating a successful or failed backup. Backup and drive
space statistics are also included.
Designed with the intention of being ran as an automated task, backups can be taken at any frequency.
Supports Windows 7 and Server 2008, PowerShell version 2 and higher. For alert notifications, an upgrade PowerShell to Version 3 is necessary. This
should work on any version of Windows with at least PowerShell version 2, but it has only been tested on these two platforms.
Software
wx2sqlVersion: 0.1.4Last Updated on: 01/28/2018Documentation | Download wx2sql
This script comes as-is, with no warranties either expressed or implied. I am not, and can not, be held responsible for any damages or loss of data that occurs as a result of downloading and using this script. Only continue if you completely understand this, accept these risks, have read and understand the known issues detailed in the documentation, and have the knowledge and skills necessary to implement this process.
WeatherLink does a great job of managing the Davis Vantage Pro2 weather stations, however, storage of weather observations is done thru the use
of flat files. This is not the best solution if you intend to display your observation data on the web. For this, you really need to have the
data stored in a database.
wx2sql is a java-based, multi-platform solution that runs on Windows, Linux, and macOS. Current features include:
Observations are stored in a MySQL database
Weather Station data can be accessed via Amazon Alexa with an Alexa app that is specifically designed for wx2sql.
Browse data contained in .wlk files
Perform Health Checks of .wlk files
Export Observational data from .wlk files to csv files
Import existing WeatherLink data by reading and importing .wlk files.
After initially importing data from .wlk files, the database will be kept up to date by reading in other files produced by WeatherLink
Validate database entries against the original files to ensure accuracy
Analyze WLK data files to identify potential issues. A summary report is generated in PDF format.
Import Sunrise/Sunset data, along with Moonrise/Moonset data, from the United States Naval Observatory into the wx2sql database.
WeatherCourierVersion: 0.1.0Last Updated on: 09/10/2017Documentation | Download SQL Script
This script comes as-is, with no warranties either expressed or implied. I am not, and can not, be held responsible for any damages or loss of data that occurs as a result of downloading and using this script. Only continue if you completely understand this, accept these risks, have read and understand the known issues detailed in the documentation, and have the knowledge and skills necessary to implement this process.
Download WeatherCourier
This script comes as-is, with no warranties either expressed or implied. I am not, and can not, be held responsible for any damages or loss of data that occurs as a result of downloading and using this script. Only continue if you completely understand this, accept these risks, have read and understand the known issues detailed in the documentation, and have the knowledge and skills necessary to implement this process.
The National Weather Service provides forecast information for free. Many websites use scripts to pull this information directly from the NWS for display purposes. Wouldn't it be nice to archive this information for later analysis, or perhaps use past forecast information to correlate with observational data? That is where WeatherCourier comes in. WeatherCourier is a java-based, multi-platform solution that will download Tabular State and Zone Forecasts from the National Weather Service and inputs them into a MYSQL database. Current features include:
Observations are stored in a MySQL database
Highly configurable forecast selection. Select data from single or multiple Weather Forecast Offices and any number of forecast locations.
Download different forecast products, including Tabular State and Zone Forecasts
Future releases will add the ability to download and process a variety of watch and warning products.