Events

As of 17:16 CDT, the massive Weather Now v3 to v5 import had 115,441,906 records left to transfer. At 14:28 CDT yesterday, it was at 157,409,431, giving us a rate of ( 41,967,525 / 96,480 seconds = ) 435 records per second. A little more math gives us another 265,392 seconds to go, or 3 days, 1 hour, 43 minutes left. So, OK then, what's the over-under on this thing finishing before 7pm Monday? It's just finished station KCKV (Outlaw Field, Clarksville, Tenn.), with another 2,770 stations left to...

Two stories this morning seemed oddly juxtaposed. In good news, the City of Chicago announced plans to spend $15 million on 77 km of new bike and pedestrian trails over the next couple of years: Several of the projects, including plans to convert an old railroad into a trail in Englewood, are still in the planning and design phases. Others, like Sterling Bay’s planned extension of the 606 Bloomingdale Trail into Lincoln Yards, are set to come to fruition through private partnerships.  The news release...

It takes a while to transfer 162.4 million rows of data from a local SQL database to a remote Azure Tables collection. So far, after 4 hours and 20 minutes, I've transferred just over 4 million rows. That works out to about 260 rows per second, or 932,000 per hour. So, yes, the entire transfer will take 174 hours. Good thing it can run in the background. Also, because it cycles through three distinct phases (disk-intensive data read, processor-intensive data transformation, and network-intensive data...

The data transfer from Weather Now v3 to v5 continues in the background. Before running it, I did a simple SQL query to find out how many readings each station reported between September 2009 and March 2013. The results surprised me a bit: The v3 database recorded 162.4 million readings from 4,071 stations. Fully 75 of them only have one report, and digging in I can see that a lot of those don't have any data. Another 185 have fewer than 100, and a total of 573 have fewer than 10,000. At the other end...

Sunday night I finished moving all the Weather Now v4 data to v5. The v4 archives went back to March 2013, but the UI made that difficult to discover. I've also started moving v3 data, which would bring the archives back to September 2009. I think once I get that done then moving the v2 data (back to early 2003) will be as simple as connecting the 2009 import to the 2003 database. Then, someday, I'll import data from other sources, like NCEI (formerly NCDC) and the Met*, to really flesh out the...

I won't belabor the point, or even inject my own opinion about Will Smith's Oscars meltdown Sunday night, except to say I'm amazed at how many articles, columns, and Tweets have appeared about it. I guess nothing else in the world matters right now?

I took Cassie for a 40-minute walk around Lexington's historic district on the way back from Berea: The light really wasn't great, so I didn't take a lot of photos. Plus Cassie has a way of adding motion blur to every photo I shoot. Two weeks ago I attended a conference by the Chicago River, which had dye left over from St Patrick's Day. Add a passing fire boat and it's Christmas in March:

Editing photos on my phone doesn't always produce the best results. Faster, cheaper, better, pick two, right? Fortunately I have Adobe Lightroom at home, and deploying software yesterday took a long time. Here are my re-edits. Better? Worse? At the very least, they're all correctly-proportioned (2x3) instead of whatever I guessed on my little phone screen. Thursday's sunrise at Nicura Ranch: Berea College: One of the ranch's permanent residents: Down the road from the ranch: Cinnamon, who rather...

I've just switched the DNS entries for wx-now.com over to the v5 App, and I've turned off the v4 App and worker role. It'll take some time to transfer over the 360 GB of archival data, and to upload the 9 million rows of Gazetteer data, however. I've set up a virtual machine in my Azure subscription specifically to do that. This has been quite a lift. Check out the About... page for the whole history of the application. And watch this space over the next few months for more information about how the app...

We're about to get back on the road for our 700 km drive back to Chicago. Before leaving, I just wanted to highlight Ravinia Festival's upcoming 2022 season. In particular, note who they're partnering with for these performances of La Clemenza di Tito and Don Giovanni. Oh, yes, I will be there.