Edmonton Public Schools & Open Data

Today I’m very excited to announce that Edmonton Public Schools has taken a big step into the world of open data by releasing a data set containing information on all of their schools, including the six opening later this year. I understand the data will be made available in the City of Edmonton’s Open Data Catalogue early next week, but you can download the CSV file today if you like.

Download the Edmonton Public Schools Data in CSV

Back in early February I met Jeremy and Paul for lunch to chat about open data and the community here in Edmonton. One of the things we talked about was how Edmonton Public Schools could get involved. In addition to attending events like the Open City Workshop, Jeremy and his team also started working behind-the-scenes to pull together data that might be useful to share. I helped define the fields that should be included and did the geocoding work, but they did all the rest. The result is a great data set of public schools in Edmonton, containing the name, address, lat/long, grade levels, programming information, and contact details for each.

Edmonton Public Schools follows in the footsteps of the Edmonton Public Library in embracing open data. Both organizations should be applauded for being “early adopters” and for their enthusiastic participation in the open data movement here in Edmonton. They have set an example that others can follow. Specifically:

  • Start small! EPL released branch locations, EPSB released school locations.
  • Work with the community! In both cases, I was able to help with some of the work. There are many others in the community who are eager to help as well.
  • Engage the City! In addition to getting the data in the catalogue, which is really important to have a central repository, the City has also offered some suggestions for improvements.

Thank you to Jeremy and the rest of the team at Edmonton Public Schools for making this happen!

No post about a new data set would be complete without mentioning that the data is now available at ShareEdmonton! You can now see a list of all public schools and on the details page for each one, you can see the relevant school ward, grade level, and programming information on the right side (for example, McNally, the high school I attended). More improvements coming soon!

Edmonton Neighbourhood Census Data

For a long time I’ve wanted to get the City of Edmonton’s neighbourhood census data in CSV format (or really any usable format other than PDF). Recently, with the help of Laura (and Sandra) at the City’s Election & Census Services department, who I met at the Open City Workshop, I finally got it. And now you can have it too!

Download the Edmonton Neighbourhood Census Data in CSV

I’ve also emailed this to the City’s open data team, so hopefully they can get it in the data catalogue soon.

Visualizing the Data

Why is having the census data in a format like CSV useful? Well for one thing, it enables creatives to do stuff with that data through code or other tools. For instance, I was able to generate a heat map for the City of Edmonton:

The darker sections are more heavily populated, the lighter yellow regions are less populated.

Not all neighbourhoods are reflected, as the City does not release details for neighbourhoods with a population between 1 and 49. Here are some other things we can learn from the data set:

  • Total population in the data set is 777,811, which means there are 4628 individuals unaccounted for (total for 2009 was 782,439).
  • The average neighbourhood population is 2424, or 3039 if you exclude neighbourhoods with a reported population of 0.
  • The median neighbourhood population is 2216.
  • Oliver and Downtown are the only two neighbourhoods with a population greater than 10,000.
  • More dwellings are owned (192,171) than rented (121,953).

ShareEdmonton

Another reason having this data in CSV is useful is because app developers can more easily integrate it into the things they are building. For example, all the census data is now available at ShareEdmonton! So when you view a neighbourhood, you’ll see the census data on the right side (see Alberta Avenue for example). You can also browse neighbourhoods by population. I’ve also fixed the neighbourhood search, so it works better now.

This is just the first of a few neighbourhood-related updates this month, so stay tuned for more!

Apps4Edmonton

Yesterday the City released more information on the Apps4Edmonton competition. The first phase, from now until May, is “accepting community ideas”. Basically they want you to tell them what data you want. Aside from the obvious “we don’t know what we don’t know” problem, I think the community has done a pretty good job of defining desired data sets already.

They City had a great start in January with the launch of the data catalogue, but we need more data. Especially data like the census data, which myself and many others have been asking for since the day the PDFs were released. There are clearly some internal issues that need to be worked out if I was able to acquire this before the open data team was. I hope they get everything resolved for the competition, because it’ll be a pretty boring one if we still only have twelve data sets (New York and other cities had dozens, maybe even hundreds, before their competitions).

That said, I know there are passionate, smart people working on it. Email opendata@edmonton.ca if you have data set requests or want to get involved in Apps4Edmonton.

Notes for 4/5/2010

Here are my weekly notes, long weekend edition!

Edmonton Notes for 4/3/2010

Here are my weekly Edmonton notes:

An under construction shot of the new Epcor Tower:

Epcor Tower

Divertido’s Network @ The Aquatic Lounge

Tonight I finally made it out to a Divertido event! Hosted at the Eye Care Group on 104th Street and Jasper Avenue, Network @ The Aquatic Lounge was Divertido’s twelfth event since they launched in September 2008. I’ve wanted to attend one of their events for a long time now, but always had something else going on. Here’s the Divertido elevator pitch:

Divertido Urban Jaunt is redefining what networking is all about by creating extraordinary events that go beyond the typical business mixer. The possibilities are endless! Come out, experience, enjoy and expand your network the Divertido way!

What is the Divertido way? First, each event has a theme, and features related decor, lights, and other surprises. Tonight, for the aquatic theme, there were blue lights and balloons, sushi, small fish bowls, and yes, a mermaid! Second, events are held at unique venues, unlike your typical networking event. Tonight’s was at the Eye Care Group, and previous events have been held at venues like the Coney Island Candy Shop, Spinelli’s, Ginger Clothing & Apparel, and EnPrivado. Third, the vibe is informal and hip. There’s a DJ, beer and wine, and business professional dress (though there is no official dress code).

Divertido

There’s no agenda, no speeches, and interestingly, no common thread among the attendees (other than the fact that they heard about Divertido). There was a really diverse group of people there tonight – I met a realtor, financial manager, a “chief uptime officer” (love it), and many others. It’s great if you love to meet new people!

DivertidoDivertido

Divertido was created by Roberto Moreno and Elisse Heine. You can see an interview with them here. You can see the rest of my photos from tonight here. Check out the website for more information and future events.

Notes for 3/28/2010

Here are my weekly notes:

Banff
The Banff Centre (the new Kinnear Centre for Creativity & Innovation, on the left, is coming along quite nicely)

Edmonton Notes for 3/27/2010

Here are my weekly Edmonton notes:

Recap: IABC Edmonton’s Connecting the Dots Workshop

The Edmonton chapter of the International Association of Business Communicators (IABC) held a mini social media conference called Connecting the Dots yesterday the Art Gallery of Alberta. Hosted by Justin Archer and Jay Averill, the event featured three speakers and a panel. George Siemens opened the conference with a “30,000 foot view” of the social media landscape – you can take a look at his slides here. Next up was myself, talking about social media’s impact on public policy. I used the City Centre Airport debate as a case study. After me, Mary Pat Barry presented Edmonton Stories as a case study, outlining how the site came to be what the next steps are. Finally, four panelists closed out the event: Karen Unland, Norman Mendoza, Dave Cournoyer, and Chris LaBossiere.

The common thread for the day seemed to be that “the medium alters the message.” George talked about it in his keynote, and it popped up again and again throughout the day. Everyone seemed to agree that social media is still young, and there is much change and maturation on the horizon.

As for my own presentation, I think it went quite well. I tried to present the story of how social media played a role in the ECCA debate, and also attempted to pull out some lessons. The main ones were:

  • Blogs are the starts of social media! Something I’ve become fond of saying. I really think the fact that the pro-closure side used blogs so effectively had a huge impact. Blogs allow longer form content, they have great longevity (easy to find old posts, not so with tweets), and they index well in search engines.
  • Don’t reinvent the wheel. From the hashtag (#ecca) to the Facebook group, I looked for existing communities when I got involved with the debate. Too often, organizations try to start something new, when it’s often a better idea to link up with whatever already exists.
  • Translate online interest into offline action. All of the tweeting and blogging and other social media activity that happened around the airport debate wouldn’t have meant anything if it didn’t translate into people calling and emailing their councillors.

The panel was really interesting. It wasn’t very balanced, with all four panelists being pro-social media, and I think that made the tone of the discussion with the audience a little combative. There were still some really great questions asked and answers given, however. Some of my favorite quotes/highlights:

  • Organizations can’t have conversations, only people can. (Chris)
  • People who live-tweet events probably listen better. (Karen)
  • Transparency is the new objectivity. (Karen, citing Jay Rosen)
  • Recognize that people make mistakes. How you handle them is more important than the actual mistake (usually). (me, on Twitter)
  • Links are the currency of the web. Social media helps us share them faster and wider. (me, on Twitter)

Twitter played an interesting role in the panel – there was a giant screen behind the panelists showing #iabcyeg tweets on TwitterFall. It became a point of contention, actually, with some arguing that expanding the conversation beyond the room was invaluable, while others thought perhaps it was disrespectful to be tweeting while others are talking. There were also questions about credibility, about employee use of social media, about how to monitor for mentions of you or your organization, etc. Really great discussion that probably could have gone on much longer!

Thanks to IABC for allowing me to take part – it was lots of fun! If you’re looking for a social media event to attend in the future, check out the conference that George and his team are organizing in April (on ShareEdmonton). And stay tuned to IABC Edmonton on Twitter.

Recap: GalaGuru 2010

Last night was the 2nd Annual GalaGuru, “an event that celebrates the co-mingling of the creative arts and technology.” Hosted by Guru Digital Arts College at the fantastic Latitude 53, the party was very well-attended and was lots of fun! The style was “Mad Men / Stray Cats rockabilly” and while there was some discussion as to what that meant, some people just looked amazing.

The festivities got underway at 6pm, with most people arriving closer to the start of the “program” at 7pm. Guru’s Owen Brierley shared some news on Guru Digital Arts College and congratulated the school’s most recent grads. In 2008, they had 14 students. Last year, they had 28. And this year, they are aiming for 56! It’s great to see them growing here in Edmonton.

GalaGuru 2010GalaGuru 2010

The Be Arthurs, Edmonton’s official ukulele cover band, rocked out for most of the evening. Hip hop artist Steb Sly was also on hand to keep the party lively. There were computers setup around the space (which many people used to check Twitter) and in the “viewing room” attendees were treated to ZoomJer’s creepy basement videos as well as screenings of some the Guru students’ most recent work. Of course, there was also good food and local drinks!

The Be Arthurs

I was really happy that Guru decided to support Twestival this year, meaning we could have one bigger event rather than two smaller ones. The money raised last night will go to Concern Worldwide, an organization that provides education for the world’s poorest children. In addition to whatever online donations were made, we managed to raise $293 last night. Thanks everyone!

GalaGuru 2010@bingofuel

In his opening remarks, Owen did a good job of highlighting Edmonton’s various creative communities and how they are increasingly getting connected. Last night was proof of that – lots of people told me they had never been to Latitude 53 before, and that they didn’t know too much about Guru. It’s always a good thing when local people meet one another!

GalaGuru 2010GalaGuru 2010

Thanks to Guru for hosting such a great event – can’t wait until the next one! You can see a few more photos here.

Social Media and the City

We’ve all heard the stat: more than half of the world’s population now lives in cities and towns. Wellington E. Webb, former mayor of Denver, is credited as saying “The 19th century was a century of empires, the 20th century was a century of nation states. The 21st century will be a century of cities.” Urban areas are extremely important, for the allocation of resources (such as education and health care) and the creation of social and economic opportunity, among other things. As the UNFPA says: “The challenge for the next few decades is learning how to exploit the possibilities urbanization offers. The future of humanity depends on it.”

I believe that technology is vital for this challenge. It was technology that made the city possible, after all, by enabling and encouraging increased population densities. Urban settlements expose incredible network efficiencies because of this density, whether for trade, communication, or service delivery. It is these network efficiencies that, as strategy consultant and fellow Canadian Jeb Brugmann said, “make cities the world’s strategic centres of social innovation.”

Technology will be used in an endless number of ways to exploit the possibilities and to address the challenges of urbanization, but I think creating a sense of place will be key. Resilient cities, those that are sustainable, eco-efficient, and place-based, are one of the four possible outcomes for cities in a world of significant challenges like climate change, according to Dr. Peter Newman (PDF). Telling the story of a place is necessary for a city to become resilient, because creating a stronger sense of place increases the viability of the local economy and facilitates innovation. Social media is driving transparency in cities and is enabling citizens to tell the story of their place like never before.

One definition for social media comes from JD Lasica and Chris Heuer, and it goes like this: “Any online technology or practice that lets us share (content, opinions, insights, experiences, media) and have a conversation about the ideas we care about.” Put another way, you could say that social media tools and technologies are strengthening democracy.

Social media is becoming the best amplifier of a city that we’ve ever seen. True, social media makes it easy to spread the word beyond a single city and there’s definitely value in that, but it’s at the local level where social media truly shines, by taking the network efficiencies created by cities to the next level. Social media is helping to facilitate a new relationship between government and citizens, is enabling creatives inside cities to better connect with one another, and is empowering citizens like never before. In short, it improves a city’s social capital.

Natural capital is made up of the natural environment, such as the river valley here in Edmonton. On top of that we build infrastructure capital – roads, houses, buildings, lights, etc. Human capital and organizational capital refer to the individuals and organizations that use the natural and infrastructure capital to start and grow families, to build companies, and to otherwise create economic value. Social capital represents trust, social engagement, civic participation, reciprocity, and networks.

Social capital is critical for enabling innovation, making it possible to tackle tough problems. Within a city, social capital is vitally important because as Cameron Sinclair pointed out in his TED Wish, “all problems are local and all solutions are local.” Or as you’ve probably heard in the past, “think global, act local.” I think that applies quite broadly; for instance, to climate change. It’s a global problem, but it’s one that we need to approach locally. If we don’t succeed at reducing our impact on the environment at the local level, there’s no hope for solving the problem globally.

For these reasons, I’m extremely passionate about social media and the city. I’ve written a lot in the past about the impact social media is having on Edmonton and other cities, and I’ll continue to do so. Cities are increasingly important, and social media is making them stronger. I think that’s very exciting!

Related links worth clicking:

Thanks to Ted Gartside for the Creative Commons-licensed globe photo of New York.