2016 Waterloo Region CMA Population Density by Census Tract map now live


2016 Waterloo Region Population Density

A Wednesday morning FYI for you:  I’ve now posted a map detailing Waterloo Region CMA’s population density in 2016 by census tract.  I went back to my old ways and developed the map with QGIS and then exported it into leaflet.js, which basically means that it’s super fast.  Tableau’s maps are very easy to develop, but their usability isn’t ideal.

Take a gander at the map here…

Ontario Population Change, 2011 to 2016

OntPopChange2016-bannerStatistics Canada has released its Population and Dwelling Counts from the 2016 Census.  This is the first of several releases scheduled for StatCan – it plans to release data products for all modules (e.g., income, labour, ethnocultural diversity) before the end of 2017.  Hats off to them!

This is a map I quickly rendered in Tableau. I’ve played with Tableau in the past but usually stuck to hacking out code and data myself.  After a December meeting and tutorial with Lucia Costanzo at the University of Guelpgh Library, though, I’ve become a bit of a convert.  The proprietary nature of the software is sometimes problematic, but it certainly speeds up the development of your maps and visualizations. Perhaps more on that later.

This map shows the population change in Ontario’s Census Divisions (CD’s) from 2011 to 2016.  The percentage change is based on one census cycle to the next, but the color gradation ends up comparing this percentage change from one region to another. Note well that this can cause issues in interpretation of your numbers.

Some interesting things to note or remember:

  • This is considering population change only.  It doesn’t take into account the value itself.  So, while Kenora, in the northwest, shows the most significant population change, it might still be unfair to draw a comparison against any of the regions in the golden horseshoe or GTA

The Shortsighted Closure of 54 Public Library Locations in Newfoundland

Here are some quick thoughts on today’s announcement that the Province of Newfoundland will close 54 public libraries, leaving the system with only 41 locations. It’s a travesty for a province’s educational, literacy, and information access goals, regardless of its fiscal crisis. You can follow the public fallout of this poorly conceived plan by following the #nlpublib hashtag.


One thing that really bothered me in this announcement is the consolation that the Newfoundland Library Chair, Calvin Taylor, tried to make. What follows is a statement that tries to focus on the positive in a very bad situation, but what it does is pinpoint how awful and shortsighted this action is.  The CBC reports that:

[Taylor] said 85 per cent of residents in the province should be within a 30-minute drive of a remaining branch — which will be open a minimum of 30 hours a week — and available to people in a service area where they go for groceries or to do their banking.

This argument is incredibly shortsighted. It presumes that all library users have vehicles or are able to drive, or even have access meaningful public transit. But that doesn’t begin to describe the makeup of our contemporary towns, cities, and communities. Even in rural and remote communities, the poor, the young, and the elderly often don’t have access to a car, and these three groups often represent a very, very large percentage of a library’s users.

If a library is open for only a paltry 30 hours a week (and likely mostly during afternoon weekday hours) but only a few can make their way to its doors, will anyone care?

The CBC article also mentioned that Newfoundland has some of the lowest literacy scores in Canada.  I can’t speak to that since literacy is not my field, but certainly closing so many access points to free learning, educational, and cultural resources cannot improve such a rate.

If you live in Newfoundland and Labrador, then you should contact your MHA and your local councillors immediately to make a protest because time is of the issue in situations like this. If you live outside of Newfoundland, like I do, then you can still lend a hand by raising a flag and making the situation known.  The closure of so many library locations is an unacceptable policy decision and unacceptable cost-cutting measure than can kneecap a generation.

October 2014 Unemployment Rates

This week’s map visualizes Canada’s unemployment rates for October 2014, which were announced last week:

I coded this map with trepidation since comparing unemployment rates across provinces isn’t always as important as considering one province’s current rate against its own historic numbers. For example, this map shows us that Ontario’s unemployment rate still lags behind Alberta’s. No surprise there. What the map cannot do, though, is show that Ontario’s unemployment rate for this month – 6.5% – has finally recovered since the Sept 2008 crash.  The last time Ontario’s unemployment rate was this low was in October 2008. To best visualize the province’s unemployment trend back to pre-recession numbers, one should simply chart the data, or even just give the real numbers in tabular format. The best way to do this on the web is with charts.js, which seems to be some of the easiest coding I’ve ever seen.  That will be my project for later this week.

This map is created with:

2011 Population Density, Brantford, Ontario

This week, I’ve taken the same population density variable I used last week and plotted it for Brantford, Ontario. I’ll be speaking about open StatCan data to our journalism students in Brantford in a few days’ time, so it was only fair to plot the same variable for our students in this city, too.


(Click here to open the map in its own window.)

This map is created with:

Mapping for the masses: Population Density in Kitchener-Waterloo

One of my sidebar projects this fall has been to get back into mapping socio-economic data. This is something I used to do quite a bit four years ago (these maps have sadly succumbed to linkrot and plugin abandonment). Projecting numeric data onto maps is easier than most people think, and ever since I moved to a new city in 2013, I planned to pick up this skill again to learn a few things about my new town. And as a data librarian, I know where to find and work with census data, so it was easy to kickstart things into gear once more.

Below is a map showing population density in Waterloo Region’s census tracts at the 2011 census. Click through to get the entire map:

The interesting thing about this map isn’t so much its colorful polygons, (based on statistics anyone can download here) but the tools I used to build it.  When I was creating maps in 2010, the average person who wanted to hack something out was limited largely to using Arc on his or her campus, or using the open source (and still maturing) variant, QGIS, or working with Google Maps. These days, QGIS is very mature and has a strong developer community, GMaps is still going strong, and users can use services such as Mapbox’s TileMill. The options to choose from are stronger, and there is an option that can meet your background, whatever it may be.

As an example, I’m linking over to Mita Williams’s recent work mapping population change in Windsor, Ontario, as well as making the case for electoral change in her hometown.  Mita is a UX librarian and far more of a coder than I’ll ever be, so her recent work with maps shows a freer hand at hacking out java to make things go, while I use plugins within QGIS to automate some of the coding for me, which frees up my time to spend on analysis.

At the end of the day, our maps are projected with the same code and with data from the same datasets, so our endpoint is the same, but the tools we’ve chosen to use may be better suited to our own particular abilities. That is something I didn’t see in 2010 as much as I see today. And that change is a good thing. Getting these datasets into the hands of the masses, and then making them usable and understandable for everyone, is crucial to the precepts of openness – open access, open government, open data – that we espouse as librarians. One can have completely open access to data, but its value is lessened when it cannot be used or understood by all of society. Yes, open data is a crucial part of today’s citizen-to-citizen and citizen-to-government relationships, but the more tools people have to work with that data, the better.

Share the CLA Statement on Cuts to Statistics Canada

CLA: Cuts to Statistics Canada are Harming Canadians (October 23, 2014)
CLA: Cuts to Statistics Canada are Harming Canadians (October 23, 2014)

This week, in the middle of Open Access Week, the Canadian Library Association issued a statement criticizing the government cuts that have been made to Statistics Canada in recent years. This critique is strongly worded and it packs a punch; I expect it to gain traction beyond our regular librarian circles.

But getting the word out cannot happen without your help. Read the statement and share it with your colleagues and friends, especially with people outside of your typical library and archives networks.  To make the case that StatCan is not just a numbers factory but a social barometer for the nation, we must extend our voice. We must be on point, and we must persuade.

I have copied the text of the statement from the original PDF in order to help circulate this statement. When you share, please link to the original document or to


Cuts to Statistics Canada are Harming Canadians
October 23, 2014

The Canadian Library Association / Association canadienne des bibliothèques (CLA/ACB) is the national voice for Canada’s library communities.

Canadians know that access to reliable and high quality information, from the widest variety of points of view, is critical to a prosperous, functioning and democratic society. The decisions that citizens, communities, and governments make are better informed and have the ability to be more innovative when there is a free exchange of ideas facilitated by open and equal access to information. It is with these values in mind that CLA responds to recent and ongoing changes at Statistics Canada.

Recent programme cuts and policy changes at Statistics Canada have made it more difficult than ever for Canadians to track changes to critical issues that affect their communities, such as unemployment rates or the education of our children. The replacement of the mandatory long-form census with the National Household Survey, at a significantly greater cost, and the cancellation of many social surveys has made it increasingly challenging, if not impossible, for municipalities, hospitals, schools, and government agencies to administer social programmes and to track their success. In some cases, municipalities are financing their own surveys to gather the critical data they once had access to through StatCan. StatCan cuts and changes are continuing to impede effective planning for all agencies, making future programming a costly gamble. Additionally, with all levels of government focused on social and economic innovation, it is imperative that municipalities have the ability to look back on trends in order to plan for the future with reliable data.

Statistics Canada withering on the vine
Budget cuts have affected Statistics Canada enormously, which in turn affects all Canadians and all levels of government. While StatCan extended a lifeline to surveys and tools that tracked the nation’s economy through these cuts, it did so at the great expense of its social surveys, where significant budget reductions to the agency and ill-advised policy changes to its census program created major gaps that cannot be filled.
Canadians have forever lost valuable research that affects their communities as a result of cancellations of and cuts to surveys such as:

  • The National Longitudinal Survey of Children and Youth, which followed the development and well-being of Canadian children from birth to early childhood
  • The Survey of Labour and Income Dynamics, which provided valuable insight into the financial situation of Canadian families
  • The Workplace and Employment Survey, which examined employer and employee issues affecting the Canadian work place, such as competitiveness, technology, training, and job stability.

Canadians and their communities are now suffering the consequences of budget cuts and policy changes at Statistics Canada. Major, long-standing surveys that paint a dynamic picture of Canadian society have been eliminated, making it nearly impossible to do year-over-year comparisons and to track the changes in social data and programs over time. It is hard to imagine less responsible measures in the age of open data, open government, and evidence-based policy-making than limiting the supply of data or replacing it with inferior products.

In the context of fiscal responsibility, CLA believes that the government can be much more effective at planning and supporting sound planning. The current government is determined to balance the books and bring Canada into an environment of economic prosperity and growth. In order to plan for these outcomes, careful public spending is dependent on correct information to inform decisions. Statistics Canada has long been the core agency for Canada’s ability to plan and spend carefully at all levels of government, and within the business and not-for-profit sectors. CLA believes that without consistent and reliable data, this ability will be lost.

The CLA urges the government to return Statistics Canada to its status as one of the world’s most respected National Statistical agencies by restoring its funding and the long-form census. The CLA urges the government to provide Statistics Canada with the support it needs to collect, analyze, and publish data that has proven, longstanding value for decision-makers, communities, and Canadians alike.

The Canadian Library Association/Association canadienne des bibliothèques (CLA/ACB) is the national voice for Canada’s library communities, representing the interests of libraries, library workers, and all those concerned about enhancing the quality of life of Canadians through information and literacy. CLA/ACB represents 1410 library workers, libraries and library supporters; and Canadian libraries serve in excess of 34 million Canadians through the nation’s public, school, academic, government and special libraries.

For more information, please visit
Valoree McKay, CAE
Executive Director
613-232-9625 x 306

New Article on RDM and Collaboration (and Canada)

Image CC @ Wikipedia
Image CC @ Wikipedia

This week, my article on research data management and collaboration inside and outside the academic library was published in Partnership.  And here’s my shameless plug: you should go read it now.  The article examines the different facets of research data management – collection, access, use, and preservation – and it locates them within the different part of the academic library. It is also advocates for real collaboration with our peers and stakeholders across the entire university, such as our colleagues in Research Offices and Research Ethics Boards (IRBs for our American friends).

The article also examines the current policy gap regarding RDM in Canada, as well as ongoing efforts by different groups to develop RDM provisions in our granting formulas, and to provide resources and share expertise in order to ensure that we don’t create a paper tiger. What’s needed is not just policy but action, and both must be considered in the same breath.

Here’s the article’s abstract:

Research data management (RDM) has become a professional imperative for Canada’s academic librarians. Recent policy considerations by our national research funding agencies that address the ability of Canadian universities to effectively manage the massive amounts of research data they now create has helped library and university administrators recognize this gap in the research enterprise and identify RDM as a solution. RDM is not new to libraries, though. Rather, it draws on existing and evolving organizational functions in order to improve data collection, access, use, and preservation. A successful research data management service requires the skills and knowledge found in a library’s research liaisons, collections experts, policy analysts, IT experts, archivists and preservationists. Like the library, research data management is not singular but multi-faceted. It requires collaboration, technology and policy analysis skills, and project management acumen.

This paper examines research data management as a vital information, technical, and policy service in academic libraries today. It situates RDM not only as actions and services but also as a suite of responsibilities that require a high level of planning, collaboration, and judgment, thereby binding people to practice. It shows how RDM aligns with the skill sets and competencies of librarianship and illustrates how RDM spans the library’s organizational structure and intersects with campus stakeholders allied in the research enterprise.


For what it’s worth, collaboration has been a real buzzword at IASSIST40 and I’ve already been to a few presentations that share similar arguments as mine, and which definitely have the same spirit. I hope we’re all on to something with this, and I hope that we in Canada can get up to speed with our counterparts in other countries.

Finally, this paper began in part from an Introduction to RDM session that I co-presented with Jeff Moon of Queen’s University at OLA in January 2014 (details here).  Jeff has also written a great article on research data management, and it appears in the same issue of PartnershipHe is on the forefront of RDM in Canada and knows how to get things done, so be sure to read his work, too.


2014 OLA presentation on RDM

(n.b.:  This post about my RDM co-presentation at the 2014 OLA SuperConference is very, very late. I had decided to let it go in February and not publish it. However, now that the term is winding down and I’m finding time to look back on the past three months, I’ve noticed that the event still sticks out in my mind, so I’ve decided to present the slides to everyone.   -m.)

What's a blog post without a wordle?In January 2014, I co-presented a session, Research Data Management: an Introduction, at the OLA SuperConference in Toronto.  Working with Jeff Moon of the Queen’s University Library, we led a thorough session on RDM basics to the crowd. Jeff, always the great teacher that he is, spoke first by introducing RDM – what it means in terms of stewardship and infrastructure, its place within Canadian librarianship, how it is implemented, etc.  The Queen’s Library has developed a great model for RDM through the work of Jeff and Alex Cooper: it is scalable, it is built on local and consortial resources, and it develops in-house knowledge. It is one of several RDM units that Canadian librarians should investigate when considering RDM, in my opinion.

I followed Jeff by discussing RDM within the organizational context of the library and the university. In many ways, RDM touches upon all the “traditional” library functions: acquisitions and collections, access, reference and research, preservation, IT, etc., and I firmly believe that an RDM programme can’t fully succeed without engendering collaboration with colleagues from all these areas. Not all of our libraries have a wealth of resources to develop our RDM programmes, but we certainly aren’t going to get good mileage if we can’t bring together all library functions to develop our data collection infrastructure and use our information management expertise to serve this pressing need within the Canadian research enterprise.

There were two other major points I touched on in the presentation, which I want to reiterate in text. First, a strong RDM programme is going to require buy-in from your entire team of librarians, including liaison librarians.  As others have noted (e.g.: Witt, Hswe and Holt;, Gabridge,) liaisons are our colleagues with subject expertise and with developed networks within their departments. Furthermore, when RDM eventually becomes a Tri-Council obligation (as I expect it to become), we are going to require help from liaisons to make sure that we don’t drown in a deluge of work. Secondly, make sure you reach out to your campus Office of Research Services, your IT Services, and to your Research Ethics Boards.  These groups are allies, they are valued stakeholders on campus, and they have a wealth of expertise in the research enterprise.  Research Data Management is not the domain only of librarians, and we can’t forget that. RDM requires our colleagues across campus, both in the faculties and in administrative units. I hope to write more on this during the spring since I’m working on this particular area at the moment myself.

You can find slides from our presentation at this link, under Session 413, and I’ve embedded mine below.  (And yes, it was a damn fine cup of coffee.)