Hello,
Greetings from the Philippines.
I'm a newbie to this forum so please bear with me.
I joined in this forum because I want some advises from weather experts on how to automatically store the weather data into a database. I'm curious about it since our company is currently running 18 Davis Automatic Weather Stations using 6555 WeatherLink Data Logger. Through WeatherLink Software, we used TCP/IP connection so that we can remotely monitor the weather in our farms located in the different areas in the Philippines. We can't figure out how to create a system that can automatically get the data from the weather station without human intervention, and store these data to our database, and keeping it always running, still without human intervention. . . . shortened . . .
Thank you.
I can not help you with the product you mentioned, BUT you are already using 18 WLIP 6555 dataloggers. So you can upload that data without any money involved to Weatherlink.com and let them automatically and free of charge upload the data to WeatherUnderground.com (WU).
Off course you have to define your 18 WU weatherstations first, if you not already have done so.
After doing these simple tasks, the WLIP will automatically upload to Weatherlink.com which will then upload the data to WU where WU will store all your data in the cloud.
You can than view your
current and
historical data on the 18 weatherstations pages on WU. Your data is visible in tables and in graphs. You can also use free PHP scripts on your webserver to retrieve the data and make all kind of graphs or colored tables.
So as long as you want to see current and historical weatherconditions for one farm at a time:
No database needed. WU will store your data in the cloud and makes it accesible where and when you want.
If you want to compare the weatherconditions between stations you have to define and build a database.
No standard product has that, as far as I know. But you can use the WU data for that.
You can download the historical and current data as a CSV file and insert the data into your own database. That will not be to much developement work.
If you do not want your data on the accesible to others as will be tha case when using the WU servers, you could buy 18 Metebridge devices (1 per farm) and let the Meteobridge devices upload the data to a SQL database you have to build either way.
Succes, Wim