Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Historical weather data

Storegga_Effect
6 - Meteoroid

Hi fellow Alteryx-addicted friends!

Just wanted to know if you had any relevant data source to recommend to download historical data on climate? (ie temperature, humidity) on a specific location?

There's a few websites out there but wanted to know your best off!

Thanks,

13 REPLIES 13
jdunkerley79
ACE Emeritus
ACE Emeritus

Did a post on my blog a few months ago on parsing the UK Met office historic station data:

http://jdunkerley.co.uk/2015/09/04/downloading-and-parsing-met-office-historic-station-data-with-alt...

 

Been meaning to look at the NOAA data but havent got around to it yet (http://www.ncdc.noaa.gov/data-access/land-based-station-data/land-based-datasets/quality-controlled-...

TaraM
Alteryx Alumni (Retired)

We have a sample that downloads and parses data from https://www.wunderground.com/

 

From Help > Sample Workflows > Data Artistry > Download Data and Parse Report

2016-03-22 09_09_43-.png

Tara McCoy
ategg
5 - Atom

Hey Storegga_Effect,

 

https://developer.forecast.io/ - 1000 free calls every day

 

http://nomads.ncdc.noaa.gov/dods/ - is great for raw historical data - (check out http://stackoverflow.com/questions/3200984/where-can-i-find-historical-raw-weather-data for an example of how you can use the data).

 

Storegga_Effect
6 - Meteoroid

Muchas gracias fellows for these insightful answers!

cbridges
11 - Bolide

How do you work with the NCDC data if you don't know/have Python? I couldn't get Alteryx to read .dds or .das.

@thizviz
Storegga_Effect
6 - Meteoroid

Hi, Did not have a chance to try it - but looks like ALT does not read these files as you pointed out. Did you find what you're looking for?

damyon_claar_pressley
6 - Meteoroid

@TaraM - It seems that the sample workflow you referenced is no longer included.  How can I get a copy of if? 

 

Thanks!

TaraM
Alteryx Alumni (Retired)

I am attaching it here - you may need to change the base map in the Report map tool.

Tara McCoy
damyon_claar_pressley
6 - Meteoroid

Thanks a million.

Labels