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 …
Continue reading “How to load historical weather data into any database”
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
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
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 …
Continue reading “How We Process the NOAA Integrated Surface Database Historical Weather Data”
How your data is used within Visual Crossing
We are aware how important your secure, confidential data is, and Visual Crossing takes great care to ensure that any confidential data entrusted to us stays completely confidential. Fortunately, you will find that Visual Crossing rarely handles and never stores confidential data except in very special and completely optional situations entirely under your control. (These …
Continue reading “How your data is used within Visual Crossing”
What is a Weather API?
A weather API is an Application Programming Interface that allows weather data to be queried from scripts and code. Good weather APIs provide both historical weather data and forecast data via an easy-to-use, well-defined programming interface. The best APIs have dozens of weather measures, near-real-time current conditions reporting, and decades of worldwide historical weather reports. …
Weather Data Documentation
The Visual Crossing Weather Data platform provides the ability to easily access weather data sets including weather forecast data, weather history data and historical weather summary data. The data is available for download through the Weather Data Query Page and the Timeline Weather API. Core weather columns These columns are common to most weather data sets unless disabled. …
Replacing the Yahoo Weather API
Visual Crossing is the perfect replacement for the Yahoo Weather API offering up to 1000 free results a day and full access to forecast and historical data.
How to find historical weather for maritime, sea and ocean locations
Maritime weather data covering many of the world’s oceans and seas is available in Visual Crossing Weather Data Services for viewing, downloading and accessing via the Weather API. This article discusses the available data and the variables that are unique to maritime data. Available maritime weather data Maritime weather data in Visual Crossing Weather is …
Continue reading “How to find historical weather for maritime, sea and ocean locations”
How to schedule weather data queries
In many cases, it is very useful to be able to schedule a weather query to run for you periodically and then deliver the latest data directly into your analysis. Imagine having the forecast for all of your business locations updated fresh each morning in your Excel sheet right before your planning meeting? Consider a …