Methodology

Learn more about the methodology that were used to create the Canadian Cancer Resource Planning tool.

Disclaimer: Due to data availability, years of data were pooled for some calculations below.  Please refer to ‘Data sources’ for the year(s) of data that were used in the calculation.

Incidence rate (crude) per 100,000 population All cancers and lung cancer:
(average new cancer cases per year)/(2016 population (both sexes))  x 100,000
Gynecological cancers:
(average new cancer cases per year)/(2016 female population )  x 100,000
New cancer cases per care provider (average new cancer cases per year)/
(# of corresponding care providers)
Mortality rate (crude) per 100,000 population All cancers:
(# of cancer deaths)/(2016 population (both sexes))  x 100,000
Lung cancer:
(average cancer deaths per year)/(2016 population (both sexes))  x 100,000
Gynecological cancers:
(average cancer deaths per year)/(2016 female population )  x 100,000
Cancer deaths per care provider (average cancer deaths per year)/(# of corresponding care providers)
Prevalence per 100,000 population (5-year) All cancers and lung cancer:
(# of people alive with cancer)/(2016 population (both sexes))  x 100,000
Gynecological cancers:
(# of people alive with cancer)/(2016 female population )  x 100,000
Population per care provider Gynecological Oncologist:
(2016 female population)/(# of corresponding care providers)
Rest of care providers:
(2016 population (both sexes))/(# of corresponding care providers)
Health authority/zone – Health Authority boundary layers for all jurisdictions were obtained from the Statistics Canada Portal
– Data for each jurisdiction was calculated at the FSA (Forward Sortation Area) level and then aggregated to the Health Authority level for reporting purposes.
– The aggregation was done through the ArcGIS software by adding up the data in FSA’s that fall within a Health Authority boundary. The process used was ‘Summarize Within’.
– For more information regarding this process, please refer to the ArcGIS documentation here. The inputs to the ArcGIS tool were the following:
– – – Health Authority Boundary layer will act as the polygon layer.
– – – FSA data layer will be the layer to summarize.
– – – Data fields like Population count/Female Population/cancer cases/mortality count will be selected to apply statistics as Sum on these fields.
– The tool will generate a new layer that will have counts at the Health Authority level for population/care providers/care centers/cancer cases/mortality cases.
– The shapefile is exported for this layer and then loaded to ArcGIS Pro for calculating other metrics such as “incidence cases per 100,000 population” for Health Authorities.
– This processed layer is then uploaded to the ArcGIS Online interface and used to render the Health Authority maps by jurisdiction.