How to import weather data into Microsoft SQL Server
When you want to drive data analysis of all types including data science and business intelligence applications, loading weather data into a relational databased is often the first step. As one of the most popular database platforms in the world, Microsoft SQL Server is the backend datastore for millions of applications from homebrew to enterprise. …
Continue reading “How to import weather data into Microsoft SQL Server”
How to find a Weather API for your hackathon
If you are running, or submitting an entry to, a hackathon, you may find yourself needing a weather API to retrieve weather data. The Visual Crossing Weather API is the perfect API for hackathons as it provides free access and rich features. The Weather API offers hourly historical weather data, 16-day weather forecasts and future …
Continue reading “How to find a Weather API for your hackathon”
7-Day Forecast
How Do I Get a 7-day Forecast? There are many types of forecasts and many lengths of forecasts. However, as we choose from our myriad of options the one thing that is clear is that the longer the forecast, the less accurate. However the one that stands out as the most-used on a daily basis …
Where can you find high quality Historical Weather Data at a low cost?
Finding weather data on the internet is easy. While finding historical weather data is a little more difficult, there are various places to find data including free consumer sites, government data feeds, and commercial services and APIs. However, the easiest data sources to find tend to be the hardest to use and the least complete. …
Continue reading “Where can you find high quality Historical Weather Data at a low cost?”
Where can I find historical heat index and wind chill data?
Historical heat index and wind chill data are very important “feels like” weather measures for use in measuring the comfort level of people and animals outdoors. Whether you are using these metrics to plan events, predict attendance levels, or plan heating and cooling for large groups or your personal outdoor activities, a weather data service …
Continue reading “Where can I find historical heat index and wind chill data?”
Where can I find historical humidity data?
Historical humidity data is an important weather measure that is needed in various business tasks as well as being key for human comfort. Whether you are looking for humidity data to analyze moisture’s effect on a product, understand human comfort levels, or plan tasks for a building project, a weather data service such as Visual …
Continue reading “Where can I find historical humidity data?”
Where can I find historical precipitation data?
Historical precipitation data is an important weather measure that is very useful for many types of personal analyses and business use cases. Whether you are looking for precipitation data to plan a trip, schedule a conference, or optimize agriculture, a weather data service such as Visual Crossing Weather can provide precipitation data easily using global …
Continue reading “Where can I find historical precipitation data?”
Where can I find historical temperature data?
Historical temperature data is one of the most requested weather measures. Whether you are looking for temperature trends for your neighborhood, seasonal temperature changes to manage an outdoor business, or the exact temperature at the time and date of a specific event, a weather data service such as Visual Crossing Weather can provide temperature data …
Continue reading “Where can I find historical temperature data?”
In what environments can I run weather API queries?
All types of development environments need access to weather data. From command-line tasks such as database ETL, to scripts that drive websites and priority alerts, to mobile apps and complex business applications, weather data drives insight, decisions, and revenue. A good weather API is flexible enough to span all of these use cases, bringing a …
Continue reading “In what environments can I run weather API queries?”
How to create a Raspberry PI frost alert using a weather api
In this tutorial we will create a simple frost alert using a Raspberry PI and the Visual Crossing Timeline Weather API. The aim of the simple circuit is to use colored LED lights to inform the user if frost or low temperatures are expected. A red light indicates below freezing temperatures are expected, yellow light …
Continue reading “How to create a Raspberry PI frost alert using a weather api”