City Council data now available in Edmonton’s open data catalogue

Yesterday Edmonton became the first city in Canada to release “a fully robust set” of City Council datasets to its open data catalogue. A total of five datasets were released, including meeting details, agenda items, motions, attendance, and voting records. There are now more than 100 datasets available in the catalogue, with more on the way.

Here’s the video recording of the news conference:

The City also produced a video about the new datasets:

The Office of the City Clerk is responsible for managing Council & Committee meetings, boards, elections, and more. The release of this data (referred to as “Clerk’s data” by some City employees) is another example of the way that office has embraced technology over the years. Kudos to Alayne Sinclair and her team, as well as Chris Moore, Ashley Casovan, and the rest of the IT team for making this data available!

I’m really excited about the potential for this data. The information has long been available on the City’s website, it was just locked away in meeting minutes as “unstructured” data – possible for humans to read relatively easily, but not for software. Now that it is available as “structured” data in the open data catalogue, applications can be written that take advantage of the data. You can find the data under the City Administration tab of the catalogue. Unfortunately the datasets only go back to June 1, 2011 instead of the start of Council’s term in October 2010. Currently, the datasets are updated daily.

I’ve now had a chance to look through the data, and while it looks good, it is unfortunately incomplete at the moment. There’s quite a bit of data missing. I would love to do some statistical analysis on the data, but with so many missing records there’s a good chance that my conclusions would be incorrect. I have already summarized my findings and passed them along to the team, so hopefully they can resolve the issues quickly!

I have already added functionality to ShareEdmonton for this data, and as soon as the datasets are fixed, I’ll release it. I hate to say “stay tuned” but there’s not much choice right now!

2010-2013 Edmonton City Council Swearing-in Ceremony & Inaugural Meeting

Edmonton’s new City Council was officially sworn into office this afternoon at City Hall. Following the ceremony, they held what will undoubtedly be the quickest meeting of the term, to approve council chamber seating arrangements, standing committee membership, and the meeting schedule for the next year. Nearly 400 people attended, including many of the Mayor’s and Councillors’ friends, family, and supporters.

Edmonton City Council Swearing in Ceremony 
Organized by Communications & the City Clerk, the event had a very nice printed program!

Edmonton City Council Swearing in Ceremony
Staff Sergeant Langford Bawn piped council members into the City Room, accompanied by members of the Edmonton Police Service, Fire Rescue, and Alberta Paramedics Guards of Honour.

Edmonton City Council Swearing in Ceremony
Council members smiled and waved as they entered. Lynda Steele served as the Master of Ceremonies. Matt Day played the piano, and Amanda Clark led the singing of O Canada.

Edmonton City Council Swearing in Ceremony
The Honourable Don Manderscheid, Justice of the Court of Queen’s Bench, administered the oath to the Mayor and Councillors.

Edmonton City Council Swearing in Ceremony
After Mayor Mandel was sworn in, he received the Chain of Office from City Manager Simon Farbrother. After all the Councillors were sworn in, Mayor Mandel spoke about the work ahead.

Edmonton City Council Swearing in Ceremony
Students from the City Hall School lined the second floor of the City Room, while friends and family filled the seats below.

Edmonton City Council Swearing in Ceremony
Council Chambers was packed for the inaugural meeting! By the time everyone had piled in, the meeting was finished! A reception was held following the meeting.

Edmonton City Council Swearing in Ceremony
2010-2013 Edmonton Mayor & City Council

You can see the rest of my photos from the event here.

UPDATE: Courtesy of Dave, here are some photos from the 2007 swearing-in ceremony.

Tony Caterina on the issues in 2009

It’s not surprising that City Councillors are often in the news, offering comment, explanations, and other thoughts on the latest decisions and issues. Some are generally in the news for positive reasons, others, not so much. Ward 3 councillor Tony Caterina is one of the members of council who seems to be mentioned for negative reasons more than positive ones (thanks to Dave for the photo). I mean, he’s even got his own hashtag on Twitter to track all of the bizarre things he says and does! I thought it would be interesting to take a look back at Caterina’s quotes throughout 2009. Ideally I could just point you to his voting record online, but we’re not there yet, so quotes will have to do!

A note on the data: I decided to make it simple and to only look at quotes from the Edmonton Journal. I searched the Canadian Newsstand database (anyone with an Edmonton Public Library card can access it for free) for “tony caterina” in the Edmonton Journal for any date in 2009. A total of 71 articles were found, up to December 3rd. For each one, I looked for direct quotes. I also added some quotes from articles written after December 3rd.

First off, here’s a Wordle of all the quotes:

And here, by subject, is a selection of Tony Caterina quotes on the issues in 2009. You can download all of the quotes I found here in PDF.

On the City Centre Airport:

"We’re talking about closing aviation down, and businesses, and putting people on the unemployment line. Really, that doesn’t make sense."

"In regards to economic development, it’s critical … here we are contemplating getting rid of something that’s already here. That just doesn’t make sense to me."

"If we’re not going to talk about the possibility of improved aviation service, what are the possibilities? From our perspective on council, we will want to push for that to be part of the debate."

On the Edmonton Indy:

"It’s not a cost, it’s an investment into promoting Edmonton as a world-class city. We made a decision as council to support this event because it is world-renowned … Given the exposure we have had, it’s money well spent."

"The publicity, you can’t even put a price tag on it. The Indy is being seen by countries around the world."

On EXPO 2017:

"The prudent thing would be to get a…firm commitment from the province and the federal governments (that) if this bid is successful, they are prepared to support the $2.3 billion."

On Budget 2010:

"We have gone all year asking administration to work on this budget, three per cent (plus) two per cent for (neighbourhood) renewal. They have certainly done that. It’s a very fair budget to everyone. If we don’t accept this recommendation on this after a full year’s work, then going forward from this, any time we ask them to do something, where’s the credibility?"

On Jasper Avenue:

"The pedway system is there. Certainly, we’re not going to get rid of that, but there probably needs to be better planning for the buildings that are going up. The main floor has to be commercial, more so. They should be concentrating on getting merchants back on the street so people have a reason to be outside, and not just in the pedway system. To bring people back on the street, you need something for people to attract them -clothiers and shoe shops."

On the York Hotel:

"They make everybody else look bad. The majority in the…industry are good operators, but you have the few who, they can’t comply or won’t comply."

On cats:

"I don’t know what it is about me, I’ve always denied that I like cats but I’m always the first one they come to."

"When it’s a cat involved, there are more people saying ‘just keep Fluffy, I’m not paying 250 bucks for it. It seems dogs have more value."

On infrastructure:

"We’ve been so far behind in infrastructure repairs. The more we can get done, the better. There are a little sharper pencils putting the prices out. This will help go a long way to making sure we come in with a very very reasonable tax rate for next year."

On the U-Pass:

"There’s enough residual benefits, from (lower) carbon dioxide emissions and fewer vehicles…We subsidize (student) tuition, we subsidize transit, we subsidize all kinds of things, but they’re an important group."

On the new ward system:

"Even with the system that we have now, you’re running against each other. There’s always a chance that one incumbent, as happened in the last election, or both, could be defeated. I don’t think that’s an issue for consideration."

On bike trails:

"There’s a limited amount of money and we have to look after higher priorities. Edmonton already has a lot of paths for a winter city — about 1,000 kilometres of bike trails and roads — so I think we’ve done a good job."

On the Citizen Panel:

"How many members, how many panels, do we need? We might as well just ask the public where to put the money. That’s a big part of the councillor’s responsibility. It sounds good to have public involvement, but at the end of the day that’s what council is here for."

On the idling bylaw:

"All it’s going to do is pit neighbour against neighbour. I would have to agree with my constituents that have phoned in to say this sounds like the silliest thing we have done here in a number of years. I think this is a little excessive. People in general are good. They understand the environment and will do what they can in order to mitigate their contribution to … pollution."

On bloggers (thanks Dave for saving it):

"A number of bloggers — who knows where they come from — are treated as gospel."

As you can see, not all of the quotes are negative. As an aside, I think Scott McKeen wrote more about Caterina than anyone else this year. He must love him ;) In quite a few articles, Caterina is mentioned as the only councillor to vote for or against something. He likes to be different, I guess! I couldn’t find a quote, but earlier this year Caterina said he worked longer hours and spent fewer nights at home when he worked in the private sector. That’s no surprise though, as Caterina apparently likes to get out of his duties as a city councillor.

Some other related reading you might be interested in:

Anyone else looking forward to more fun with #toncat next year? Election day is October 18, 2010.

Edmonton’s improved online City Council meeting agendas & minutes

A little over a week ago a new online system for Edmonton City Council’s meeting agendas and minutes went live. The long overdue update brings a number of improvements for public access, notably an integrated view of all information on the same screen. As someone who frequently accesses the agendas and minutes, I’m really happy the old system is gone, and at least so far, I think the new one is great!

The previous system for managing agendas and minutes, built in-house about 15 years ago, was called OCCTOPUS (Official Council and Committee Tracking Output Publishing and Updating Services). If you’ve never used it, consider yourself lucky! Based on Microsoft Word documents, OCCTOPUS was clunky and awkward to use. To get at the details for an agenda item, you often had to click through four connected Word documents. It always reminded me of the ETS Trip Planner, which loves to spawn dozens of new windows.

If you want to see the old system, check out the minutes for the November 10th Council meeting. Then compare that to the new system, by looking at the minutes for the November 24th Council meeting. I think you’ll agree that the new one is much better!

Some of the improvements & features of the new system include:

  • No more Word documents! Agendas and minutes now appear in HTML.
  • You can access the agenda, minutes, supporting materials, and archived video for a meeting from within the same screen.
  • Archived video and supporting materials (often PDF reports) appear in column on the right side and open with a single click.
  • If you really want to, you can get a print view of the agenda or minutes with a single click.

Aileen Giesbrecht, Director of Governance and Legislative Services in the Office of the City Clerk, told me that the project to replace OCCTOPUS started in the summer of 2007, and in the fall of 2008 SIRE Technologies was awarded the contract. SIRE provides “legislative management technology” for county and local governments, and offers a number of off-the-shelf solutions or modules. According to Sarah Ellington of SIRE Technologies, the City of Edmonton is using three such modules: Agenda Plus, Minutes Plus, and Workflow. Each of the modules have been configured to meet the City’s requirements for formatting, business processes, etc. The City of Edmonton’s implementation is the first major SIRE project in Canada.

The biggest challenge in getting the new system in place, according to Aileen, was simply “finding the time to make it happen.” The work isn’t finished yet, either! The project currently improves access primarily for the public, and Aileen and her team are now working on improving access internally too. She said the related internal systems being implemented will help with ease of use and will support the City’s paperless strategy.

The proposed 2010 budget for Corporate Services (PDF), which mentions $164,000 for operational maintenance and support of SIRE, offers some additional insight into what’s next:

Operational funding of SIRE will allow for: Maintenance of SIRE software, including ‘Agenda and Minutes Plus’ and web integration between SIRE and our current ‘Thunderstone’ web-based search function; licences associated with SIRE software, including access for Councillors (‘Agenda To Go’), as well as access for City Clerks and other Administrators, Bi-annual updates to the SIRE software suite; and one staff position to coordinate and maintain the entire SIRE system.

The new system isn’t perfect – it still uses Windows Media for video, and it would be nice to be able to click directly from an item on the agenda to the corresponding item in the minutes – but it’s much better than what we had previously. I think it’s great that the City is working to improve access to information for citizens, and I hope this is just the beginning (think: open data).

Edmonton City Centre Airport Decision: Phased Closure

City Council voted today to implement a phased closure of the City Centre Airport. The motion put forward by Councillor Gibbons described two phases and passed by a vote of 10-3. I’m happy with the decision that was made today, and I commend Council for taking a courageous step toward ensuring the City’s Vision and Strategic Plan are realized.

Here is the vote breakdown for adopting the motion (which you can download here):

Councillor Karen Leibovici (Ward 1) Yes
Councillor Linda Sloan (Ward 1) No
Councillor Ron Hayter (Ward 2) No
Councillor Kim Krushell (Ward 2) Yes
Councillor Ed Gibbons (Ward 3) Yes
Councillor Tony Caterina (Ward 3) No
Councillor Jane Batty (Ward 4) Yes
Councillor Ben Henderson (Ward 4) Yes
Councillor Bryan Anderson (Ward 5) Yes
Councillor Don Iveson (Ward 5) Yes
Councillor Amarjeet Sohi (Ward 6) Yes
Councillor Dave Thiele (Ward 6) Yes
Mayor Stephen Mandel Yes

Council started discussing the issue at 1:30pm, and didn’t wrap up until nearly 6pm. There were at least four rounds of questioning, driven largely by Councillors Caterina and Sloan who were vehemently opposed to the motion. After the questioning finally ended, Councillor Caterina put forward a motion to refer the issue to Administration which was soundly defeated.

Three amendments were made to the original motion. Councillor Iveson’s two amendments were “friendly”. Councillor Krushell’s amendment stated that after scheduled service licenses expire at ECCA in June of 2012, that they not be renewed. All three amendments were approved, and as soon as the final motion is online I’ll link to it which you can download here (PDF).

It became clear as Councillors gave their final remarks that the motion was going to pass. I thought Councillors Henderson, Iveson, and Krushell made excellent comments about why this decision needed to be made, speaking in particular about the future. Councillor Leibovici mentioned the role of social networking in this debate (more on that in a future post). Mayor Mandel used his time to make it clear that “this is a closure motion.” Councillor Gibbons used his time to get a dig in at Councillor Caterina, saying “if you can’t win, don’t bring it forward.”

After the vote passed, a motion from Councillor Sloan was brought forward that called into question the legality of Councillor Gibbons’ motion (the City’s legal counsel gave the OK hours earlier). It also requested that quarterly updates be provided to Council on legal issues related to the City Centre Airport. The motion was split – the first part was defeated, the second part (quarterly updates) passed.

What happens next?

The following will happen immediately:

  • Runway 16-34 will be closed. General aviation business activities will be adjusted to accommodate a one-runway airport. Medivac service will be maintained.
  • As a result, a GPS landing system will likely be added to runway 12-30.
  • The parcel of lands adjacent to runway 16-34 that can be surrendered to the City once the runway is closed will be identified.
  • Negotiations will begin with NAIT and the Province of Alberta to allow for NAIT expansion.
  • The City of Edmonton will create a development office and will work to set out long-term visioning plans for the ECCA lands in their entirety. The plan will be presented to Council by November 2009.
  • Plans for realignment of the NAIT LRT line based on the closure of 16-34 will be provided to Council no later than September 2009.
  • The downtown plan will be adjusted to take into consideration the immediate removal of the overlay height restrictions.
  • The City of Edmonton will develop a communications strategy to inform the public about the impact of this decision.
  • The City Manager will negotiate with Edmonton Regional Airport Authority (ERAA) to make mutually acceptable lease amendments.

The following will happen sometime in the future:

  • ERAA will work with Alberta Health Services on a long-term system design to facilitate Medivac operations at the Edmonton International Airport or other regional airports.
  • The final closure date will be determined by City Council with input from ERAA when the lands are required to support the long-term land development plan.
  • After the final closure date is set, environmental remediation will take place.

What does this mean?

Council decided today to close the City Centre Airport. They stopped short of attaching dates however, which makes the motion much weaker than it could have been (during my live-tweeting I called it “gutless”). Both Mayor Mandel and Councillor Henderson addressed this in their final remarks, stating that Council’s intentions should not be misinterpreted – the intention is to close the airport.

I fear the lack of a timeline will open the door for this to be discussed again in the future, however. At what point are the lands “required to support the long-term land development plan”? Who decides that and brings it forward, especially if the City is to be the developer of those lands? I do believe that the direction is clear, that the airport is to be closed, but the lack of a final closure date makes me uncomfortable.

It’s important to realize that we’re a long way from seeing the airport completely closed. New communities are not developed overnight, and especially not world-class, transit-oriented ones. The City needs to take the time to come up with a solid, exciting plan that Edmontonians readily support.

Final Thoughts

I think Council made a bold statement today. By voting to close the City Centre Airport, Council made it clear that they’re willing to do what it takes to ensure Edmonton’s future is bright. I think today’s decision was an important step in the push to create a more vibrant, sustainable, innovative, and livable Edmonton.

The City Centre Airport will be closed, and that’s good for Edmonton.

UPDATE (7/9/2009): You can download the final version of the motion here (PDF).