Articles for "database"

How to load historical weather data into any database

Many business intelligence, data science, and academic research projects need high quality historical weather data to be available in a database. Weather data is typically quite large in volume, and its analysis often requires processing thousands or even millions of detailed records in order to find valuable patterns and apply them to the task at …

How to Import Weather Forecast Data and Historical Weather Data into a MySQL Database

In this article, we are going to import weather data into a MySQL database. In addition to setting up the database tables, we will demonstrate techniques to import both historical weather data and weather forecast data. We will include the ways to retrieve the weather data and how to set up a script so the …

Announcing Real-Time Historical Weather Data Using the MADIS Observational Weather Database

Announcing Real-Time Historical Weather Data Using the MADIS Observational Weather Database

We are pleased to announce that the Visual Crossing Weather History Database now includes real-time weather observations. You can now get up-to-the-minute weather history data including temperature, rainfall, wind, humidity and heat index if you are using the Weather API, downloading historical weather data or using reports and dashboards. MADIS observation weather database The MADIS data feed is the primary source …

How We Process the NOAA Integrated Surface Database Historical Weather Data

How We Process the NOAA Integrated Surface Database Historical Weather Data

We use a lot of sources for our weather data. One of the richest sources of historical weather data is the Integrated Surface Database (ISD) from NOAA. The amount of data available is impressive. Hourly or sub-hourly weather records for 1000s of weather stations that are, in some cases, over 100 years old. However obtaining and manipulating …

Calculating chill hours for fruit plants and trees

Many fruit plants and trees do not produce an optimal crop unless they experience a dormant period with lower temperatures. These dormant periods help the plant rest during the winter period. They also may regulate the plant’s development including the budding time. Unlike a plant hardiness zone, which indicate the coldest temperatures that a plant …

How to download weather data for multiple locations

Downloading weather data for multiple locations in CSV, Excel, or JSON format is easy using our Query Builder page. In this guide, we will walk through the process of uploading a file of location or pasting in CSV data from the clipboard, composing a weather query, previewing weather data for these locations, and then downloading …