Rants and Revelations

I went kayaking for the first time in 3 weeks today. The weather wasn’t looking great, but I figured it had been too long. I was right about the weather - it started raining when I was about 2/3rds of the way to the weir, but it wasn’t a cold rain so I kept going. I was alone, so I was paddling as fast as I could. Probably too fast. Mostly I wanted to see how far I could go without pausing, and then after I had to pause, how few pauses I could take and still keep up a decent pace. That’s sort of how I built up my fitness when I first started cross country skiing and again when I started mountain biking - go fast, and work on increasing the range, instead of doing the more conventional starting with long slow distance and building up the speed, which is how I started running.
(more…)

I had a phone call from a very nice person at PygmyBoats. She was calling me because I’d ordered the wrong size spray skirt for the kayak kit I’d ordered, and she wanted to know if I was ordering them for the kit, or for another boat. It turns out that the Arctic Tern 14 is a “medium” size boat, but the Arctic Tern Hi Volume is a “large” size boat. Also, when I saw the “1 hand toggle” on the order form, I’d actually ordered 1 pair. Oh, and I got the UPS tracking number - they said that I should get it Friday or Monday. I’m hoping it’s Friday for obvious reasons.

I’m reading the latest Analog (or at least the one on top of my to-be-read pile, which grows faster than I can read it down, but which usually acts as a stack rather than a queue), and came across a story “Sand and Iron” by Michael Flynn. I noticed the name “Slugger O’Toole”, and immediately started thinking of the song “The Irish Rover”. And as I read further, I realized that all of the names in the story seemed to correspond to names in the song. Here is the mapping, in roughly the order they appear in the story:

As you can see, I can’t figure out “Amos January”, and the only unused name in the song is “Malone”. And the Maggie B to Barnie McGee mapping isn’t exactly a slam dunk either. But everything else works so well, to the point where Mgurk hides from work as well.

Another day of interesting discoveries:

• Our drill SUCKs. It’s a not incredibly old Skil 4.1 Amp corded drill, and it doesn’t have enough power consistently to drill 3 inches into the end of a 2×4. It also has a standard old chuck instead of one of those new quick ones - I must have spend 80% of my time switching between drill bit and nut driver bit.
• In spite of having a degree in structural engineering, I forgot that a parallelepiped with non-rigid joints needs cross bracing or it will collapse. I guess I’ll go get some strapping or something tomorrow.
• This is probably going to end up being a fair weather project. After finishing the two parallelepiped, I put the particle board sheet on one (and attempted to put on the second one, but that one collapsed), and there is almost no room to move around the garage. I might rip a foot off the edge of the sheets to give me some room.

Anyway, the work surface is nearly done, and I can probably safely go ahead and order the kit.

In spite of the existence of my cedar strip canoe, which still looks pretty good 25 years after I built it, I’m not good with my hands. But for some reason, I got it into my head that I really want to build a Pygmy Boats kayak kit.
(more…)

I went out to the dealer today to put a deposit on a Prius. Since nobody is negotiating prices, I figured there was no reason not to just go to the closest dealership.
(more…)

I let both my instrument currency and my club annual ride expire in the last little while, so I had to do that. I contacted my favourite CFI, Jim Hood, and he agreed that we could get both requirements satisfied with one IPC.
(more…)

Wow, never thought I’d utter that sentence.

Every two years, I have to re-take the Health Safety and Environment Orientation for contract employees. In the past, that’s always required me to show up at the HSE office at 7am, sit with a bunch of the type of contractors who do actual work (you know, with tools and stuff instead of computers), and be lectured on the proper way to dispose of dirt or what to do if your backhoe (or computer, in my case) accidentally ruptures a line carrying something nasty. Usually the lecturer is some grumpy old guy who reminds me of Jasper in that Simpson’s episode where he ends up teaching a class in the school. “Using a camera? That’s a paddling. Smoking on the property? Immediate firing, then a paddling. Improperly disposing of construction garbage? First we fine your employer, then fire you, then a paddling.” And of course, I can’t tell you how useful it is to know that I’m not allowed to use Kodak ladders or oxygen lines in my line of work.

This year, however, they’ve got on-line training. And not only that, but they have different training for outside workers and office workers. So I clicked the link, and got a stupid animated guy pointing at a button on the side menu saying “Start by clicking this button”. “Fuck that”, I thought, and clicked on the button marked “Final Assessment”. I took the test, got 10 out of 10, and got the certificate, all in way less time than I’m wasting on writing this blog post. So hooray for on-line training where you skip the boring bits (ie. all of it) and go straight to the incredibly obvious test questions.

BTW, the test questions were all on the order of “Where do you dispose of waste? A) toss it over the fence onto non-Kodak property, B) make a big pile and set fire to it C) put it in designated containers or D) Your contract will have instructions on proper waste disposal” And I’m not kidding, that is pretty much verbatim. (BTW: The correct answer is D - sometimes the contract will require you to remove the waste yourself.)

Your cow orkers are evidently neither gamers nor Penny Arcade readers, so when somebody sends an email to the group saying that it’s so-and-so’s birthday, and to come to the breakroom for cake, it’s not a good idea to do a group reply to say “THE CAKE IS A LIE”.

…only without medkits, saved games, and restores.

Saw this on Old Grover’s LiveJournal:

http://www.brightcove.tv/title.jsp?title=1438490562

I went kayaking after work today on Irondequoit Creek. The carp were mating, and there were lots of dead ones floating around, thus my little perl joke in the title.

It was a great day to blow off work a bit early, and Rob and I went upstream from Bay Creek Paddling Center up just past the Elison Park dog beach. I was pretty tired on the way back, and it didn’t help that the wind shifted around and got cold, so we ended up with headwinds in both directions. According to the thermometer in my car, the temperature dropped about 10 degrees in the course of the hour and a half paddle, although it felt like the temperature change happened all at once when the wind shifted.

The weir was a bit of a challenge, but nothing like it had been last time I took a look at it. I nearly dug a rail under, and was grateful for my spray skirt. Rob took about three tries, but mostly because he tried hitting it from one side or the other instead of coming right up the middle.

A couple of times we saw a bird that at first we thought was some sort of Loon because it was so low in the water, but it had no white markings, only black, with a bit of red or orange near the base of the beak. When it flew, we could see very long pointy wings. And when it swam it held its beak up at a 45 degree angle to the water, rather than parallel like a Loon does. I guessed it was a Cormorant, and after looking it up, I’m sure of it.

We also saw lots of geese. At one point, we heard a lot of honking up ahead, and as we rounded the corner this goose left the shore and paddled out in front of us, and did a bit of a fake take-off, presumably to try to lead us away from his nest. But this annoyed another goose, who then flew into the first one and attacked him until they both flew off.

Lots of people and dogs in the dog park, including two people who kept asking us all sorts of questions about paddling and seemed put out that we continued paddling instead of stopping to talk after we’d answered a couple. And one canoe coming upstream just as we’d flushed the Cormorant downstream for the last time. They asked us what the bird was, I said Cormorant, and the woman in the front of the canoe said “See, I told you” to the man in the back.

Lots of fun.

I don’t think the cut tags work right in RSS, so I won’t be saying any spoilers here. But I just finished the last three Torchwoods, and all I can say is

WHAT? WHY?

Good shows though. I did not see that coming at all.

Conversation at lunch today between R (been using emacs since 1981) and me (been using vi since 1987). It started off with him saying something about how he knew our latitude and longitude because he had to put it in his emacs config.

Me: When I’m looking for an editor, the ability to tell me sunrise and sunset times isn’t high on my list.
R: Emacs isn’t an editor, it’s an environment.
Me: Emacs isn’t an editor, it’s a lifestyle.
R: Yup. There’s straight, gay, and emacs.

At that point, I was literally laughing out loud (and I mean “literally” literally, not in the internet sense of “I smiled a bit”). I was lucky I didn’t have any food or drink in my mouth at the time.

The main loop query of my waypoint generator app is kind of hairy. And trying to do an “explain” on a typical query shows why it’s so slow.

explain SELECT a.id, c.pdb_id, internalid, a.type, name,
address, state, country, latitude, longitude,
declination, main_frequency, elevation,
b.category, chart_map, tpa, ispublic
FROM waypoint a, type_categories b,
id_mapping c
WHERE a.type = b.type AND
a.id = c.id AND
country in (’US’, ‘CA’) AND
(a.type in (’AIRPORT’, ‘VOR’, ‘NDB’) or
(category = 3 and (chart_map & 7) != 0)) AND
deletedon is null;
QUERY PLAN
——————————————————————————————————————————————————————–
Hash Join (cost=4442.82..19955.46 rows=34752 width=111)
Hash Cond: ((a.id)::text = (c.id)::text)
-> Hash Join (cost=4.83..12938.32 rows=34752 width=107)
Hash Cond: ((a.”type”)::text = (b.”type”)::text)
Join Filter: (((a.”type”)::text = ANY ((’{AIRPORT,VOR,NDB}’::character varying[])::text[])) OR ((b.category = 3) AND (((a.chart_map)::integer & 7) <> 0)))
-> Seq Scan on waypoint a (cost=0.00..10759.48 rows=72467 width=103)
Filter: ((country = ANY (’{US,CA}’::bpchar[])) AND (deletedon IS NULL))
-> Hash (cost=4.37..4.37 rows=37 width=15)
-> Seq Scan on type_categories b (cost=0.00..4.37 rows=37 width=15)
-> Hash (cost=2091.77..2091.77 rows=127777 width=12)
-> Seq Scan on id_mapping c (cost=0.00..2091.77 rows=127777 width=12)
(11 rows)

Adding indexes on country and type doesn’t help. There is still that nasty looking “Seq Scan on waypoint a” line. And also, another “Seq Scan on id_mapping c”, which I don’t understand at all because the joining column, c.id, is a primary key, so shouldn’t there be an index involved?

I’ve got a few ideas on how to use the spatial capability of PostGIS to improve that query, so I’m going to have to run a few tests. The first few ideas I’ve had aren’t showing major improvements in “explain”. It looks like the whole “type in … or ((chart_map & NN) != 0)” is going to force a sequential scan on waypoint no matter what I do. Hmmm.

Ok, I just added some indexes, and now the PostGIS version runs in 45 seconds. Phew! Man, I love “-d:DProf”.