Monday, January 23, 2017

Great Lakes Ice Cover

I had a discussion the other day about ice cover on the Great Lakes, which led me to searching out some data. Turns out the GLERL here in Ann Arbor has it, a lot of it. After I got it all downloaded and converted the shapefiles to CSV I loaded it up. Wow...there is a lot of it. about 150,000 rows per day, after removing land values, and I had from the 02-03 to 15-16 winters. Turned out to be about 180M rows, way more than the Tableau Public limit of 15M. I picked about 60 random days (8.2M rows) and included just them.
I tend to over complicate things and have to work hard to simplify, simplify, simplify!