We developed a freely available web mapping platform that allows users to visualize the spatial patterns of built environment indicators, vulnerable populations and environmental inequity within Canadian cities. In developing this application, we further aimed: (i) to create a flexible data system for easy updating of datasets, and (ii) to engage users and obtain continuous feedback during the development process.
We identified target user groups for HealthyPlan.City as professional urban planners, environmental health practitioners, and community and advocacy groups. An Advisory Committee was recruited at the beginning of the design phase via a call for volunteers through the Canadian Urban Environmental Health Research Consortium (CANUE), the National Collaborating Centre for Environmental Health and the Canadian Institute of Planners. We selected 16 individuals representing local governments, not-for-profit organizations, academia and private industry from across Canada, as well as two internationally recognized experts on healthy cities. These individuals provided guidance on priority indicators and useful tool functions via meetings and surveys.
We collaborated with the University of Toronto’s Masters of Information (MI) program to test and improve the HealthyPlan.City tool user interface. Student teams worked on early versions as part of their course requirements for the MI User Experience Design concentration and subsequently were hired to develop and implement a comprehensive user experience evaluation program. Overall, 38 individuals representing urban planners (n = 15), public health professionals (n = 8), researchers (n = 7), community advocates (n = 5), policy makers (n = 2) and other (n = 1) took part in a comprehensive real-time testing interview of HealthyPlan.City prior to the last phase of development. Ease of use and clarity of content were the key foci of this effort.
We worked with a web development company to produce a custom web application that leverages a collection of geographic boundaries and a database of demographic and environmental data. During the development phase, we identified administrative functions to be built by the application developers that allow: (i) easily updating the database without any coding necessary; (ii) editing all the text and images in the application interface, and (ii) gathering data for evaluation of uptake and usage.
Geographic Boundary Files
The current implementation of HealthyPlan.City includes 129 municipalities (also called Census Subdivisions by Statistics Canada and commonly recognized as cities). We selected all Census Subdivisions (CSDs) with a population over 30,000 that intersected Statistics Canada’s medium and large Population Centres (PCs), defined as areas with a population of at least 30,000 and a population density of 400 persons or more per square kilometer (See Supplemental Figure S1). Since some CSD boundaries cover a large geographic area with a dispersed population, we excluded CSDs where less than 75% of the population lives within the overlapping PC. These population level and density thresholds help ensure that there is enough range in data to support the calculations required by the tool and that the tool includes data for the majority of individuals living in a given municipality. To facilitate the comparison of equity indicators among similar sized cities, we grouped the cities into five categories based on population: 30,000 to 50,000; 50,000 to 100,000; 100,000 to 200,000; 200,000 to 500,000; and over 500,000 residents. Within each CSD (city), we used Census dissemination blocks (DBs), the smallest possible geographic zones available with total population counts reported, as the base geography and assigned all demographic and environmental data to these DBs. For some cities, we included boundaries such as planning areas, electoral districts and locally defined neighbourhoods to allow comparisons between subzones of a given city. We acquired the neighbourhood boundaries from municipal open data portals.
Demographic and built environment data
The demographic indicators included in the current version of HealthyPlan.City were obtained from the 2021 Canadian Census as the percentage of a given vulnerable population in a Dissemination Area (DA) (Supplemental Table S1). We downscaled the DA-level data to the smaller Dissemination Block (DB) level by assigning the same proportion of vulnerable populations within a DA to all DBs within it, and for some summary reporting, we used the total population of a DB and the DA percentage to calculate the total number of people in a selected demographic group at the DB level.
Built environment indicators were developed by the project data specialists for four themes identified as priorities by the Advisory Committee and Research Team - urban climate, community amenities, parks and recreation, and air and noise pollution. To the extent possible the data selected for the indicators needed to have complete coverage across Canada. Within each theme, the project data specialists explored available data sources for suggested indicators, and developed methods to produce and then assign the indicator values to DBs (i.e., extracting the value from a 30 m raster at the DB centroid, or averaging all values of the 30 m raster within the DB). We used a pragmatic approach during this phase that focused on defining indicators based on available data within a theme, rather than defining a specific indicator and then trying to find supporting data. The environmental data included in the current version of HealthyPlan.City are listed in Supplemental Table S1. For further details, and as both demographic and environmental indicators might change over time, please refer to the Methods section of the HealthyPlan.City website for the most up-to-date information (https://healthyplan.city/en/methods).
Equity priority areas
By combining the demographic data with the environmental data we identified Equity Priority areas as dissemination blocks where proportionally more vulnerable people experience proportionally less beneficial environments. We first ranked the percentages of vulnerable populations and the values of built environment indicators for all dissemination blocks into city-specific deciles (i.e. from 1 to 10). A ranking of 1 represents the lowest 10% of values in a given city (i.e., low percentage of vulnerable population group or the lowest levels of beneficial environment), while a ranking of 10 represents the highest 10% of values (i.e., highest percentage of vulnerable population group or the highest levels of beneficial environment). Based on this ranking strategy, equity priority areas are identified by the intersection of city-level ranks of vulnerable populations > 5 (higher percentages of vulnerable populations) and built environment < 6 (lower levels of beneficial environments), as illustrated in the Equity Priority matrix in Fig. 1, and displayed accordingly in the map view. Darker shades of show areas with higher inequity (values that are further from the city median for both indicators), whereas lighter shades of yellow show areas with lower inequity (closer to the city median).
The final data product is a comma separated value (csv) file with geographic, census, environmental, and equity priority values for every dissemination block within each city included in HealthyPlan.City. Geographic data columns include the dissemination block unique identifier, the unique municipality name to which each dissemination block belongs, a city group variable identifying similar-sized cities across Canada, and the unique neighbourhood zone names within select cities. Census data columns include the population counts and the percent values of each vulnerable population for each dissemination block. The environmental data columns include values for built environment indicators (e.g. # of parks within a 1 km radius from the DB, average percent coverage of tree canopy cover within a DB). Finally, two columns indicating the city-specific decile ranks of demographic and environmental variables are included to allow identifying equity priority areas.
Administrative and Research Data Functions
The platform was defined to enable indicators to change whenever new, better, or simply different data are identified or become available. Doing so requires changes to the associated database, therefore the application developers created a stand-alone script that allows the project team to replace the active PostgreSQL database on the application server with a new version as needed. In addition to the database and geographic files, a substantial amount of content (text, images, links, tutorials, etc.) was required to help users navigate and understand the maps and summary data views presented in HealthyPlan.City. A comprehensive content management system (CMS) using Prismic.io was established to allow easy editing of this type of information. Currently, Google Analytics is enabled and will allow for tracking site use to support research on how HealthyPlan.City is being used. Importantly, these flexible attributes enable us to adapt the application for targeted uses. For example, we can copy the application and database to a new unique domain/url and include only the geographic zone(s) and data of interest. This could be useful for a city with specific local data or key issues on which they want to focus, or for a broader application on a specific topic.