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”
What exactly is a weather record?
A weather record is the smallest unit of weather data that is used in the Visual Crossing Weather accounting process for our plans. Whether you have unlimited data access or are limited to 1000 records per day as a member of our Free plan, it is useful to understand the accounting behind weather records What …
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 …
Replacing the Weather Underground API
This article provides a step-by-step guide to replacing the Weather Underground API with the Visual Crossing Timeline Weather API. The Timeline Weather API offers a generous free daily API limit and a simple JSON response that is easily used in any existing application or script. This makes the Timeline API, the perfect replacement for the …
What will my weather data cost?
Trying to get an exact price on weather data can be a bit confusing but we have some tools and resources that can help you. In this document we will cover the usage of the Cost Calculator: https://www.visualcrossing.com/weather-data-cost-calculator Also we will cover the reasons why you would choose one plan over another. There are several …
Importing data from a JSON Weather API into Microsoft Excel using Power Query
This article shows how to import data into Microsoft Excel using Power Query from a RESTful Weather API. This API returns JSON-based data. We are also going to explain how to create a loop within our script so that we can call the API multiple times for multiple locations and create a combined result table …
Continue reading “Importing data from a JSON Weather API into Microsoft Excel using Power Query”
How to Load Weather Data into Microsoft Excel using a Web Query Data Connection
One of the powerful features of the Visual Crossing Weather Service is the ability to query data via a Web Service or URL. This benefits not only coders but rather can be utilized to import data into most Business Intelligence Systems including Excel. When you include your data into Excel, you can refresh the data …
Continue reading “How to Load Weather Data into Microsoft Excel using a Web Query Data Connection”
Building and Running your first weather API query
Using a weather API is an extremely powerful and flexible way to get weather data for any project. Whether you need historical data, forecasts, or current conditions, using an API allows you to automate fully automate the query process. There is no need to deal with web pages cluttered with ads or constantly updating an …
Continue reading “Building and Running your first weather API query”
How to obtain solar radiation data?
We offer solar radiation data in both our 15-day forecast and historical observations datasets as well as a solar component dataset in our Advanced Energy package. Both can be included in Weather API requests, viewed directly in the browser or downloaded as a CSV or Microsoft Excel format file. This document focuses on the general …
How Can I Load Historical Weather Data into Tableau Desktop?
Downloading historical weather data for multiple locations provides a fast and simple way to enrich your business data in Tableau Desktop with relevant weather parameters to analyze their impact. This article shows the necessary steps to quickly and easily generate the weather data for any location of the world and how to load it into …
Continue reading “How Can I Load Historical Weather Data into Tableau Desktop?”