Analyzing the Spatial Distribution and Language Abilities of Physicians in Alberta, Canada ========================================================================================== * Christopher Belanger * Lise M. Bjerre ## Abstract This study combined public data and geospatial analysis to examine physicians’ language abilities and locations in Alberta, Canada, and produced an interactive map to allow patients and policymakers to view the data. We identified n=11,370 active physicians in the province of Alberta, of whom we further identified n=194 (1.7%) as University of Ottawa (uOttawa) graduates, n=955 (8.4%) as French-speaking, and n=4,965 (43.7%) as community-based family physicians. French-speaking physicians were concentrated in Census Division 6 (n=464, 48.6%) surrounding Calgary and Census Division 11 (n=356, 37.3%) surrounding Edmonton. Overall reported French-language ability was low, with just 955 (8.4%) of all active physicians reporting competency in French. uOttawa graduates (n=70, 36.1%) were much more likely to report French ability than graduates of other schools (n=885, 7.9%), women (n=457, 9.6%) were slightly more likely than men (n=497, 7.6%), and specialists (n=666, 10.4%) were more likely than family physicians (n=289, 5.8%). ## Introduction The University of Ottawa’s Faculty of Medicine is interested in better understanding the distribution of French-speaking physician care in the province of Alberta, especially among uOttawa graduates. This study combined public data with geospatial analysis to learn how and where French-speaking uOttawa graduates practice in Alberta, and to produce an interactive online map to allow patients and policymakers to explore the data. To better understand the supply and distribution of French-speaking physicians in Alberta, Canada, and especially of community-based family physicians, this study has four goals: * Collecting data from the College of Physicians and Surgeons of Alberta; * Analyzing the supply and distribution of family physicians; * Analyzing the supply and distribution of French-speaking physicians; and, * Producing an interactive map of Alberta family physicians searchable by language, analogous to prior work—see [www.docmapper.ca](http://www.docmapper.ca) / [www.trouvezunmedecin.ca](http://www.trouvezunmedecin.ca). ## Methods ### Data Collection Data was collected from the official “Physician Search” website of the Alberta College of Physicians and Surgeons (CPSA) during the week of January 31, 2023 [3]. A search was run with fully default parameters, which returned 35,188 basic results with general information (name, location, practice discipline, gender, languages spoken, and web link for more details). For each basic result, we then followed the web link and collected more detailed information (phone number, fax number, specialties, membership status, conditions on practice, registration number, qualifications, and whether they reported accepting new patients). Finally, we collected latitude and longitude coordinates for each physicians’ location using Google’s geocoding API [4]. Initial geocoding failed for n=195 physicians whose addresses included PO boxes, so we removed PO boxes from their locations and geocoded the remaining address. The final result was a tabular data set with 35,1888 rows and the following 15 columns: name, location, phone\_number, fax\_number, practice\_disciplines, specialties, gender, languages, membership\_status, conditions\_on\_practice\_permit, registration\_number, accepting\_new\_patients, qualifications, lat, lon. Provincial boundaries were collected from Statistics Canada’s digital boundary files [5]. ### Data Cleaning and Processing We cleaned the data in several steps outlined in Figure 1. First, we removed all physicians whose membership status was not “Active.” There were ten other possible membership statuses in addition to “Active,” including “Inactive,” “Inactive - Deceased,” “Suspended,” and “Active - Not in current practice.” Removing n=19,933 physicians with these other membership statuses resulted in a set of 15,255 physicians with active registrations. ![Figure 1:](http://medrxiv.org/https://www.medrxiv.org/content/medrxiv/early/2023/09/15/2023.09.14.23295573/F1.medium.gif) [Figure 1:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/F1) Figure 1: Population creation diagram for Alberta physicians dataset Next, we excluded n=3,363 physicians with missing or invalid addresses. This included n=3,333 physicians whose contact information had been intentionally withheld, listed only as “Contact information for this physician has not been made public.” This yielded a set of 11,892 active physicians with valid addresses. Next we excluded n=521 physicians practicing outside the province of Alberta, using physicians’ geocoded latitudes and longitudes and keeping only those inside Statistics Canada’s digital boundary for the province of Alberta. We verified visually that the physicians excluded were all outside the province’s borders, and the physicians included were all inside. This yielded a final set of 11,370 active physicians with valid addresses in Alberta. ### Identifying Family Physicians Beginning with the full set of n=11,370 active physicians, we further refined this set to identify active community-based family physicians. First, we excluded n=5,919 physicians whose listed specialties or practice disciplines did not include the terms “Family Medicine” or “General Practice”, leaving n=5,451 potential family physicians. We then excluded n=454 family physicians whose work location included the terms “hospital” or “emergency,” leaving 4,997 non-hospital-or-emergency-department-based potential family physicians. Before exclusion, we verified that there were no false positives, and that one ambiguous location, the Northern Lights Health Centre at 7 Hospital St. in Fort McMurray, does not list primary care services to the public on its website [6]. Our final set of n=4,997 family physicians indicates that 47.9% of Alberta’s registered physicians are providing community-based primary care services. ### Identifying University of Ottawa Graduates Physicians who obtained their medical degree (MD) from the University of Ottawa were identified by excluding n=11,176 physicians without the word “Ottawa” in their degree information, leaving n=194 University of Ottawa Graduates as shown in Figure 3. ![Figure 2:](http://medrxiv.org/https://www.medrxiv.org/content/medrxiv/early/2023/09/15/2023.09.14.23295573/F2.medium.gif) [Figure 2:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/F2) Figure 2: Population creation diagram for Alberta family physicians dataset. ![Figure 3:](http://medrxiv.org/https://www.medrxiv.org/content/medrxiv/early/2023/09/15/2023.09.14.23295573/F3.medium.gif) [Figure 3:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/F3) Figure 3: Population creation diagram for University of Ottawa graduates data set. Note that this only includes physicians who received their medical degree from the University of Ottawa, and so excludes, for example, those who completed their residency requirements at the University of Ottawa. Residency and other qualification information is not provided by the CPSA. Identifying Alberta-based physicians who completed residencies or other qualifications at the uOttawa would require internal uOttawa data, for example physician names and specialties, and additional analysis to link the CPSA data with the uOttawa data. ### Software Used All analysis described in this report was done using the R Language for Statistical Computing [1] and RStudio [2]. These are open-source software packages that enable code-based and reproducible research: since all steps in the analysis are executed through computer code, anyone with access to the code and input data is able to inspect all analytical steps and to reproduce them for themselves. The code used in this analysis can be made available upon request. ## Results In this section, we present summary tables and visualizations describing our main results. We begin with population characteristics for the overall physician cohort, followed by more detailed tables for several subcategories of interest (family physicians, French-speaking physicians, and uOttawa graduates). We also provide more focused tables exploring French-speaking ability and physician locations. ### Population Characteristics #### All Physicians Abbreviated population characteristics for the full set of active physicians are shown in Table 1. Categories with more than five values have been truncated to the top five. View this table: [Table 1:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/T1) Table 1: Population characteristics for all n=11,370 physicians. #### Family Physicians Population characteristics for the set of family physicians are presented in Table 2. Categories with more than five values have been truncated to the top five. View this table: [Table 2:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/T2) Table 2: Population characteristics for n=4,965 community-based family physicians. #### French-Speaking Physicians Abbreviated population characteristics for n=955 French-speaking physicians are shown below in Table 3. Categories with more than five values have been truncated to the top five. View this table: [Table 3:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/T3) Table 3: Population characteristics for n=955 Frenchspeaking physicians. #### uOttawa Graduates Abbreviated population characteristics for n=194 uOttawa graduates are shown in Table 4. Categories with more than five values have been truncated to the top five. View this table: [Table 4:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/T4) Table 4: Population characteristics for n=194 uOttawa graduates. ### French-Language Ability Table 5 below shows French-language ability for different physician categories. Overall, only 955 (8.4%) of all active physicians reported competency in French. However, there was substantial variation between groups, with family physicians less likely to report French ability (5.8%) and uOttawa graduates more likely (36.1%). View this table: [Table 5:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/T5) Table 5: French-speaking ability among physician subcategories. ### Location As can be seen in Figures 4-7, the majority of physicians in all categories were located in Census Division 6 surrounding Calgary and Census Division 11 surrounding Edmonton. Further details are shown below in Table 6. View this table: [Table 6:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/T6) Table 6: Census division locations for physician subcategories. ![Figure 4:](http://medrxiv.org/https://www.medrxiv.org/content/medrxiv/early/2023/09/15/2023.09.14.23295573/F4.medium.gif) [Figure 4:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/F4) Figure 4: Distribution of all active physicians in Alberta, density by census division (left) and point distribution (right). ![Figure 5:](http://medrxiv.org/https://www.medrxiv.org/content/medrxiv/early/2023/09/15/2023.09.14.23295573/F5.medium.gif) [Figure 5:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/F5) Figure 5: Distribution of active communitybased family physicians in Alberta, density by census division (left) and point distribution (right). ![Figure 6:](http://medrxiv.org/https://www.medrxiv.org/content/medrxiv/early/2023/09/15/2023.09.14.23295573/F6.medium.gif) [Figure 6:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/F6) Figure 6: Distribution of active French-speaking physicians in Alberta, density by census division (left) and point distribution (right). ![Figure 7:](http://medrxiv.org/https://www.medrxiv.org/content/medrxiv/early/2023/09/15/2023.09.14.23295573/F7.medium.gif) [Figure 7:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/F7) Figure 7: Distribution of active University of Ottawa medical school graduates in Alberta, density by census division (left) and point distribution (right). French-speaking physicians were concentrated in Census Divisions 6 (n=464, 48.6%) and 11 (n=356, 37.3%), with only 135 (14.1%) serving the remainder of the province. Six Census Divisions (numbers 4, 5, 7, 9, 13, and 18) had only one French-speaking physician. This distribution was similar to the general distribution of all physicians. ### Interactive Map We also created an interactive map of Alberta-based physicians filterable by language. A draft English version is available at [https://docmapper-english-test-site.netlify.app/](https://docmapper-english-test-site.netlify.app/), and bilingual maps will be published at [www.docmapper.ca](http://www.docmapper.ca) and [www.trouvezunmedecin.ca](http://www.trouvezunmedecin.ca). ## Discussion We identified n=11,370 active physicians in the province of Alberta, of whom we further identified n=194 (1.7%) as uOttawa graduates, n=955 (8.4%) as French-speaking, and n=4,965 (43.7%) as community-based family physicians. French-speaking physicians were concentrated in Census Division 6 (n=464, 48.6%) surrounding Calgary and Census Division 11 (n=356, 37.3%) surrounding Edmonton, with only 135 (14.1%) French-speaking physicians serving the remainder of the province. Six Census Divisions (numbers 4, 5, 7, 9, 13, and 18) had only one French-speaking physician. This distribution was similar to the general distribution of all physicians. Overall reported French-language ability was low, with just 955 (8.4%) of all active physicians reporting competency in French. uOttawa graduates (n=70, 36.1%) were much more likely to report French ability than graduates of other schools (n=885, 7.9%), women (n=457, 9.6%) were slightly more likely than men (n=497, 7.6%), and specialists (n=666, 10.4%) were more likely than family physicians (n=289, 5.8%). These results are raw percentages reported without error bars or significance tests, because they describe an entire population or sub-population, as defined in the methods, and therefore do not constitute samples. See Appendix A for details. ### Limitations This study has several limitations. First, it is based on a secondary analysis of data from the CPSA which is only updated annually. It is possible that our data cleaning processes categorized physicians incorrectly, either due to geocoding errors or misclassification. We were also not able to locate analyze n=3,333 physicians with no listed address and excluded them from the analysis. Finally, our uOttawa graduate analysis only includes uOttawa medical school graduates, not those who completed residency requirements or other training at uOttawa, because residency information is not available through the CPSA website. This analysis could be refined with additional data from uOttawa. ### Conclusion In this study we have successfully collected and analyzed data about active registered physicians in the province of Alberta, Canada. We analyzed French-speaking ability and found that uOttawa graduates were much more likely the report French ability than the general population of physicians. We also produced an interactive map, filterable by language, to help patients and policymakers to find local language-concordant physicians. This study could be extended in several directions. For example, a travel analysis could explore inequities in travel burden for French-speaking linguistic minority communities, or with additional data the analysis could expand to include uOttawa residency graduates. ## Data Availability Physician information is available online at https://search.cpsa.ca/ . The authors' processed data is not presently available. View this table: [Appendix A:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/T7) Appendix A: Detailed Data Tables, All Physicians View this table: [Appendix B:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/T8) Appendix B: Detailed Data Tables, Family Physicians View this table: [Appendix C:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/T9) Appendix C: Detailed Data Tables, French-Speaking Physicians View this table: [Appendix D:](http://medrxiv.org/content/early/2023/09/15/2023.09.14.23295573/T10) Appendix D: Detailed Data Tables, uOttawa Graduates ## Footnotes * christopher{at}belangeranalytics.com, lbjerre{at}uottawa.ca * Received September 14, 2023. * Revision received September 14, 2023. * Accepted September 15, 2023. * © 2023, Posted by Cold Spring Harbor Laboratory This pre-print is available under a Creative Commons License (Attribution 4.0 International), CC BY 4.0, as described at [http://creativecommons.org/licenses/by/4.0/](http://creativecommons.org/licenses/by/4.0/) ## References 1. [1].R Core Team. R: A Language and Environment for Statistical Computing. Vienna, Austria: R Foundation for Statistical Computing; 2021. 2. [2].RStudio Team. RStudio: Integrated Development Environment for R. Boston, MA: RStudio, PBC.; 2020. 3. [3].College of Physicians and Surgeons of Alberta. Physician Search 2023. 4. [4].Google. Overview Geocoding API Google Developers 2023. 5. [5].Statistics Canada. 2021 Census Boundary files 2021. 6. [6].Alberta Health Services. Northern Lights Regional Health Centre. Alberta Health Services 2023.