At the Lovell Litho & Publications plant in Montreal, home of the Musée de l’imprimerie du Québec.

In a laudable effort toward transparency and open data, the Office of the Third Party (the name bestowed on the Green Party in the Legislative Assembly) has released its expenses in comma-delimited ASCII format. In a blog post about the release, leader Peter Bevan-Baker requested feedback about the release and it seems only appropriate to provide the feedback in the open as well.

Format

The CSV file of the expenses appears to be simple a CSV export of the same spreadsheet used to generate the PDF file of the expenses, and as such it’s intended for human consumption not machine consumption.

Given that one of the benefits offered by open data is new opportunities for data visualization and analysis, machine readability generally trumps human readability (the PDF is fine for humans).

For example, if I wanted to track the expenses over the long term myself, to support longer-term analysis, the first thing I would do is to store them in a database. And to store them in a database in the current form would mean stripping out all of titles and subtitles, subtotals and grand totals intended for humans.

I would also need to convert the “amount” column to be simple decimal numbers, removing the “C$” from each figure so that these figures could be represented as numbers.

The result would look like this (visualized in a spreadsheet):

In this more machine-friendly format, I could simply import the CSV file directly into a database with no additional effort required.

Abbreviations, First Names and Context

What’s the CRRF-NAF 2015 Conference?  Who is Pat? Who is Peter? What is the WI (I know the answer, but does everyone? Will people know in 50 years?)

Using acronyms that aren’t generally understood, or only first names, means some of the meaning is lost. Spelling things out ensures everyone can understand, now and in the future.

Why did Pat go go the Cumberland Energy Symposium? And to the CRRF/NAF Conference and the Atlantic Summer Institute?

I don’t doubt that there are good reasons for all three, but it would be nice to know the context for expenses like this, even if it’s just a simple sentence like “Supporting the leader’s work on local energy independence.”

Why are the cell phone bills sometimes more than $200 a month when all-you-can-use cell phone plans are available for less than $60 a month. Maybe there’s a good reason for this; I don’t know (maybe there’s more than one phone? maybe they need to shop around for a better plan?). Explaining expenses that might appear unusual to the lay reader can head off misunderstandings. And, again, it adds helpful context.

Many of these issues can be solved simply by elaboration of the data already there — spelling out abbreviations, adding last names and titles — and in other cases it might be useful to accompany the data with a set of  explanatory notes that would add context (explaining conferences, cell phone plans, bank charges, etc.)

Hosting and Preservation

The release of the expenses was done through Peter Bevan-Baker’s own website. I would prefer to find the information under the Office of the Third Party website; I would expect the information there would have a better chance of being archived as part of the records of the Assembly than it would on Peter’s own website. It would also benefit being exposes to the Legislative Assembly’s search feature.

In any case, ensuring there’s a plan for long term preservation of the data is important.

Kudos

This is a great step forward, and my commentary above is offered in the spirit of “yes, and…” only. I hope the other parties quickly follow suit, and that this results in a sort of “openness arms race” where each tries to best the others in the degree of clarity, context and transparency offered to the public as spending of public funds is reported on.

This is the 2016 levee schedule for New Years Day, January 1, 2016 for Charlottetown, Prince Edward Island and area.

This is the 11th year I’ve been collating and confirming this information. If you’re new to all of this and want to give it a try, read How to Levee.

If you have additional levees to add, or changes to the information below, please drop me a line.

Changes from 2015

• Table now includes accessibility information.
• New levee at Andrews of Stratford.
• New levee at Upstreet Craft Brewing (well-timed for an uptown swing to UPEI and the Women’s Institute).
• New levee from Discover Charlottetown and The Guild.
• There is no levee at HMCS Queen Charlotte this year.
• Added the levee for The Kitchen Witch. Not technically in the “Charlottetown Area,” but included nonetheless.
• The Premier’s Levee returns to the Confederation Centre of the Arts.
• In a stunning blow to the “Charlottetown area” in the title of this post, I’ve added the City of Summerside levee for this first time. Welcome, western neighbours.
• Now that Summerside’s on the list, seems only right to add Borden-Carleton. And Kensington.

The code that generates all of the above is available on Github.

License

Like the rest of this website, the levee schedule covered under a Creative Commons Attribution, NonCommercial, ShareAlike License. That means that you’re free to copy the data, publish the data, mash up the data, share the data, but that you must provide a credit to the source, like:

Schedule data from ruk.ca/levee-2016  under a Creative Commons Attribution, NonCommercial, ShareAlike License.

You’re encouraged to spread the information here as far and as wide as possible.

Today was the day to overprint TERMS OF UNION in black over the red Prince Edward Island. See also Five Islands.

I’m in the final stages (I hope) of a year-long project to produce sets of Prince Edward Island “Terms of Union Flash Cards.” Today was the day to start printing the envelopes. I started out with too much ink on the rollers for my own good, and so in an effort to keep things moving along, I did some experimenting. This may be the favourite accidental experiment I’ve ever produced.

Here’s what the envelopes looked like once I’d got things going (they’ll get overprinted with black text in the next step):

And here’s the letterpress cut – a loan from Ian Scott and Daphne Large – that made it all possible:

I really, really like Lumi, a company offering small runs of things like screen printing kits and vinyl decals from your own artwork. To try its services out, I prepared a vector version of the Reinvented logo and used Lumi’s remarkably simply web tool to upload it and select products to order (I ordered a vinyl decal and a screen print kit; total price $26.60 US).

Fifteen days after I ordered, the package arrived here in Charlottetown.

Lumi really needs to update its packaging game; my shipment was packed in a thin cardboard envelope that was twice as large as it needed to be and had been folded over double by the post office; the screen print ink in the package had started to leak a little. That all said, the decal and screen arrived intact and ready for use.

Here’s the vinyl decal before installation:

And here’s the vinyl decal installed on the door of the Reinventorium:

It was very easy to install, especially as a the kit included a squeegee. Lumi’s guide to decal installation was helpful, especially the caution to be careful when removing the transfer sheet (Reinvented almost lost an eyeball, but I used the aforementioned caution and avoided this).

About a year ago the Restore an Acre initiative of the Macphail Woods Ecological Forestry Project came to my attention. There was something about its simple, direct, well-executed approach to forest restoration that struck a chord with me, and so I became a supporter, making a $200 donation, in honour of former PEI premier Alex B. Campbell, who had been much on my mind last fall.

This weekend there was a walk through the forest that’s being restored – the Selkirk Road Public Forest – led by the project’s personable and enthusiastic leader Gary Schneider.

It was a damp, overcast afternoon, but a sizeable crowd of Restore an Acre supporters turned out and, over the course of three hours we headed from the Selkirk Road entrance deep into the woods, passing from the formerly-farmed front section into the sections at the rear that, among other things, sport large hemlock trees that, if you’re not used to them, seem completely out of place on Prince Edward Island.

Never missing an opportunity to map a new part of Prince Edward Island, I had GPS Logger running on my Android phone during the walk, and yesterday I turned the traces I’d gathered, along with data traced from the satellite view, into OpenStreetMap. There’s still some fine-tuning and enhancement to do, but here’s what the map looks like after my update:

The Selkirk Road is well-known to many Islanders as the fast run from Charlottetown to the Wood Island Ferry. Next time you’re heading to or from the ferry and you’re in need of a walk in the woods, I encourage you to take a hike through these woods.  And, of course, there are still acres waiting to be restored.

The Old Farmer’s Almanac long-range weather forecast for Charlottetown for November 2015 calls for “showers, cool”:

It is currently overcast and 7°C with light rain in Charlottetown – showers and cool, in other words:

And thus my Old Farmer’s Almanac umbrella, which is emblazoned with “The Old Farmer’s Almanac said it would RAIN TODAY” is, yet again, proved correct:

One the second floor of our house at 100 Prince Street we have a washroom with built-in shower that sports a light and exhaust fan in its ceiling.

Last week I went to take my morning shower and, as I do every morning, I flipped on the switch that turns these on.

Nothing.

I tried again.

Nothing.

“Oh no,” I thought to myself, “I’m going to have to call an electrician.”

Later in the morning I booked an appointment with Kingston Electrical.

A few days later the battery in my Braun shaver was getting low, so after my morning shave I plugged it in to the outlet next to the washroom sink.

The next morning I went to shave, only to find that the shaver was dead. 

Nothing.

For some reason it hadn’t charged up overnight.

I checked all the connections, and the plug, to make sure nothing was awry, but it appeared that the shaver was kaput.

“Oh no,” I thought to myself, “I’m going to have to buy another shaver.”

Later in the morning I went up to Home Hardware and purchased a Remington foil shaver that, helpfully, was on sale for $31.

This morning Kingston Electrical arrived first thing for their scheduled visit.

They went up to the washroom, noted that the ground fault circuit interrupter button on the washroom outlet was “tripped,” reset it, and then everything – the outlet, the shaver and the ceiling light and exhaust fan – started working.

Apparently, for some reason – they said it was unusual but not otherwise problematic – the shower stall’s electrical wiring was wired through the sink plug’s GFCI.

Live and learn.

While we’re on the topic of Ethan, my friend Heather Mullen, who is the best “snap a quick interesting photo on their phone” person I know, captured this shot of CBC’s Kerry Campbell about to do an interview with me about changes in education governance last week.

As it happens, Ethan was along with me that afternoon, and dutifully stood by as Kerry conducted his interview. Which is when Heather captured us.