A foreach loop then averages out the temperatures during the day and finally the result is returned to the caller.Īt this point I created an application to wrap the library in for testing. This variable is then loaded by using Load to retrieve data from the http address. The first step in the function code creates a new XmlDocument to store the retrieved XML. There are multiple temperature readings per day that the code averages out. The tempXPath stores the path to extract the temperature from the XML.
We’ll substitute the key and date into the string as parameters. city by substituting its state code and name into the URL. It’s simple to get weather data for any major U.S. The weatherUndergroundAddress variable stores the http address to fetch the weather for Minneapolis. Let’s walk through a few parts of this code. I used Visual Studio 2010 as the development environment.
We’ll need to create a C# Class Library to store the code for the SQL Server CLR library. You use a http request to call the API and it returns either a JSON or XML object with the requested weather data included. This should be plenty to get started and it’s easy to upgrade later if your business case justifies it. The free Developer account gives you 500 API calls per day for free. This will give you a personal key that you can use to authenticate against the API. The first step is to sign up for a developers account on Weather Underground. Net client, I decided to document how I accessed it and inserted the data into SQL Server using a CLR assembly. Since there isn’t much documentation out there about how to connect to the Weather Underground API using a. It also has an API that you can program against. Another resource on the web, Weather Underground, publishes current daily weather data. Recently I was working with a client that needed a daily average temperature inserted into a table in their SQL Server database. The Microsoft Research project was conceived of and led by Drew Purves.įetch Climate doesn’t include current weather data, though. The data has been combined from many sources and patched together into a consistent whole. If you need historical weather data then Fetch Climate is a great resource. There are several excellent sources of weather data. One of the most common and easily available types of external data is weather data. Many companies are beginning to bring external data into their data infrastructure.
0 kommentar(er)
