The Postal Code Conversion File (PCCF) is a digital file which provides a correspondence between the Canada Post Corporation (CPC) six-character postal code and Statistics Canada's standard geographic areas for which census data and other statistics are produced. Through the link between postal codes and standard geographic areas, the PCCF permits the integration of data from various sources. The Single Link Indicator provides one best link for every postal code, as there are multiple records for many postal codes. To obtain the postal code conversion file or for questions, consult the DLI contact at your educational institution. New to the June 2022 version, a separate data file is available for retired postal codes. The retired file uses the same record layout as the PCCF file. The same syntax file can be used for both the PCCF data file and the retired data file. The geographic coordinates attached to each postal code on the PCCF are commonly used to map the distribution of data for spatial analysis (e.g., clients, activities). The location information is a powerful tool for planning, or research purposes. In April 1983, the Statistical Registers and Geography Division released the first version of the PCCF, which linked postal codesOM to 1981 Census geographic areas and included geographic coordinates. Since then, the file has been updated on a regular basis to reflect changes. For this release of the PCCF, the postal codes are directly geocoded to 2021 Census geographic areas. A quality indicator for the confidence of this linkage is available in the PCCF.

This data set supersedes PCCF+ 8A

Postal codes are part of nearly every administrative and research data set, and postal code conversion using PCCF or PCCF+ and related tools is now the usual way of exploiting their rather impressive potential. The resulting small area geography and/or latitude-longitude coordinates have a wide variety of possible uses, even where individual measures of SES are also available on a data set. Familiarity with the methods (tools and techniques), as well as the strengths and limitations of dealing with postal coded data, will allow data service providers to help users to more meaningfully exploit their potential.

A presentation on the Postal Code Conversion file (PCCF) and the Postal Code Conversation file plus (PCCF+), including referene material, licence conditions, access and use.

The presentation provided an introduction to the PCCF and PCCF+, the uses of small-area data, components of a postal code, SLI geocoding versus population-weighting, pitfalls of automated geocoding, and why one would want to use PCCF+ file.

Usage note: please be aware … Statistics Canada confirmed on May 10th, 2018, that a number of particular postal codesOM are missing in the June 2017 (published in December 2017) release of the PCCF, but was not able provide specifics about why these are missing. However, Statistics Canada checked each missing postal code against the newest internal release of the product, and they did exist in that file. The postal codesOM in question should be available in the August 2018 file. The Postal Code Conversion File (PCCF) is a digital file which provides a correspondence between the Canada Post Corporation (CPC) six-character postal code and Statistics Canada's standard geographic areas for which census data and other statistics are produced. Through the link between postal codes and standard geographic areas, the PCCF permits the integration of data from various sources. The Single Link Indicator provides one best link for every postal code, as there are multiple records for many postal codes. To obtain the postal code conversion file or for questions, consult the DLI contact at your educational institution. The geographic coordinates attached to each postal code on the PCCF are commonly used to map the distribution of data for spatial analysis (e.g., clients, activities). The location information is a powerful tool for planning, or research purposes. The geographic coordinates, which represent the standard geostatistical areas linked to each postal codeOM on the PCCF, are commonly used to map the distribution of data for spatial analysis (e.g., clients, activities). The location information is a powerful tool for marketing, planning, or research purposes. In April 1983, the Statistical Registers and Geography Division released the first version of the PCCF, which linked postal codesOM to 1981 Census geographic areas and included geographic coordinates. Since then, the file has been updated on a regular basis to reflect changes. For this release of the PCCF, the vast majority of the postal codesOM are directly geocoded to 2016 Census geography while others are linked via various conversion processes. A quality indicator for the confidence of this linkage is available in the PCCF.

This hands-on workshop has two parts. The first part covers working with SAS and the Postal Code Conversion File Plus. You'll start with Postal Codes, and leave with Census geography that can be linked to Census demographics. The second part introduces OpenRefine, an open source software platform for cleaning up messy data files. Initially developed by Google, OpenRefine will open your eyes to the beauty of clean data! No previous experience required.

A workshop on using the PCCF+ in SAS. Visit https://dataone.org/datasets/sha256%3A69f7de400d50c8fd87a3ec60fc143b125902e79be93e4ff735b0e3e0b7261ea6 for complete metadata about this dataset.

The Postal Code Conversion File (PCCF) is a digital file, which provides a correspondence between the six character postal code and Statistics Canada's standard geographical areas for which census data and other statistics are produced. Through the link between postal codes and standard geographic areas, the PCCF permits the integration of data from various sources. The Single Link Indicator provides one best link for every postal code, as there are multiple records for many postal codes. To obtain the postal code conversion file or for questions, consult the DLI contact at your educational institution. The geographic co-ordinates attached to each postal code on the PCCF are commonly used to map the distribution of data for spatial analysis (e.g., clients, activities). The location information is a powerful tool for marketing, planning, or research purposes. In April 1983, the Geography Division released the first version of the Postal Code Conversion File, which linked postal codes to census geographic areas and included geographic coordinates. Since then, the file has been updated on a regular basis to reflect postal code changes provided by Canada Post Corporation. Every five years, the postal code linkages on the PCCF are “converted” to the latest census geographic areas. The original PCCF was linked to the 1981 Census geographic areas. Since then, the PCCF has undergone three “conversions”, following the 1986, 1991 and 1996 censuses. An automated system was developed for the 1991-1996 conversion. Also, for the first time, the 1996 Census reported postal codes were used to validate the PCCF links.

PCCF+ programs and reference files (except for the User Guide) are all plain text files, which can be browsed and edited with any text editor such as Notepad, etc. The outputs of PCCF+ programs are also plain text files which can be browsed and edited with any text editor such as Notepad, etc.

Introduction to the PCCF. What is the PCCF? Overview of the content of the August 2015 release, limitations, PCCF vs PCCF+, changes to the licensing, etc.

An R script to extract and parse the Postal Code Conversion File (PCCF) from Statistics Canada/Canada Post.

The Postal Code Conversion File (PCCF) is a digital file which provides a correspondence between the Canada Post Corporation (CPC) six-character postal code and Statistics Canada's standard geographic areas for which census data and other statistics are produced. Through the link between postal codes and standard geographic areas, the PCCF permits the integration of data from various sources. The Single Link Indicator provides one best link for every postal code, as there are multiple records for many postal codes. To obtain the postal code conversion file or for questions, consult the DLI contact at your educational institution. The geographic coordinates attached to each postal code on the PCCF are commonly used to map the distribution of data for spatial analysis (e.g., clients, activities). The location information is a powerful tool for planning, or research purposes. The geographic coordinates, which represent the standard geostatistical areas linked to each postal codeOM on the PCCF, are commonly used to map the distribution of data for spatial analysis (e.g., clients, activities). The location information is a powerful tool for marketing, planning, or research purposes. In April 1983, the Statistical Registers and Geography Division released the first version of the PCCF, which linked postal codesOM to 1981 Census geographic areas and included geographic coordinates. Since then, the file has been updated on a regular basis to reflect changes. For this release of the PCCF, the vast majority of the postal codesOM are directly geocoded to 2016 Census geography while others are linked via various conversion processes. A quality indicator for the confidence of this linkage is available in the PCCF.

This hands-on workshop has two parts. The first part covers working with SAS and the Postal Code Conversion File Plus. You'll start with Postal Codes, and leave with Census geography that can be linked to Census demographics. The second part introduces OpenRefine, an open source software platform for cleaning up messy data files. Initially developed by Google, OpenRefine will open your eyes to the beauty of clean data! No previous experience required.

The Postal Code Project is responsible for linking the approximately 900,000 single postal codes in Canada to Statistics Canada’s Census dissemination geography, (presently 2021 Census geography). This process is performed by using data provided by Canada Post Corporation and linking to Census Dissemination geography via the process of geocoding. The result is the creation of the Postal Code Conversion File (PCCF) which provides a correspondence between the six character postal code and Statistics Canada’s standard geographical areas, and also the Postal Codes by Federal Ridings File (PCFRF) which provides a link between the six character postal code and Canada’s federal electoral districts.

The Postal Code Conversion File (PCCF) is a digital file which provides a correspondence between the Canada Post Corporation (CPC) six-character postal code and Statistics Canada's standard geographic areas for which census data and other statistics are produced. Through the link between postal codes and standard geographic areas, the PCCF permits the integration of data from various sources. The Single Link Indicator provides one best link for every postal code, as there are multiple records for many postal codes. To obtain the postal code conversion file or for questions, consult the DLI contact at your educational institution. The geographic coordinates attached to each postal code on the PCCF are commonly used to map the distribution of data for spatial analysis (e.g., clients, activities). The location information is a powerful tool for planning, or research purposes. The geographic coordinates, which represent the standard geostatistical areas linked to each postal codeOM on the PCCF, are commonly used to map the distribution of data for spatial analysis (e.g., clients, activities). The location information is a powerful tool for marketing, planning, or research purposes. In April 1983, the Statistical Registers and Geography Division released the first version of the PCCF, which linked postal codesOM to 1981 Census geographic areas and included geographic coordinates. Since then, the file has been updated on a regular basis to reflect changes. For this release of the PCCF, the vast majority of the postal codesOM are directly geocoded to 2011 Census geography while others are linked via various conversion processes. A quality indicator for the confidence of this linkage is available in the PCCF.

The Postal Code Conversion File (PCCF) is a digital file which provides a correspondence between the Canada Post Corporation (CPC) six-character postal code and Statistics Canada's standard geographic areas for which census data and other statistics are produced. Through the link between postal codes and standard geographic areas, the PCCF permits the integration of data from various sources. The Single Link Indicator provides one best link for every postal code, as there are multiple records for many postal codes. The geographic coordinates attached to each postal code on the PCCF are commonly used to map the distribution of data for spatial analysis (e.g., clients, activities). The location information is a powerful tool for planning, or research purposes. In April 1983, the Geography Division released the first version of the Postal Code Conversion File, which linked postal codes to census geographic areas and included geographic coordinates. Since then, the file has been updated on a regular basis to reflect postal code changes provided by Canada Post Corporation. Every five years, the postal code linkages on the Postal Code Conversion File are “converted” to the latest census geographic areas. The original Postal Code Conversion File was linked to the 1981 Census geographic areas. Since then, the Postal Code Conversion File has undergone four “conversions”, following the 1986, 1991, 1996 and 2001 censuses. A revised automated system was used for the 1996-2001 conversion. The 2001 Census postal codes reported by respondents were used to validate the Postal Code Conversion File links. To obtain the postal code conversion file or for questions, consult the DLI contact at your educational institution.

The Postal Code Conversion File (PCCF) provides a link between the six character postal code and the standard geographical areas for which Statistics Canada produces data. To obtain the postal code conversion file or for questions, consult the DLI contact at your educational institution. This version of the PCCF represents postal codes as of January 1991 and the Standard Geographical Classification and other geographic areas of the 1986 Census as of January 1, 1986. Postal codes have also been linked to the 1987 Representation Order of the federal electoral districts. In April 1983, the Geography Division released the first version of the Postal Code Conversion File, which linked postal codes to census geographic areas and included geographic coordinates. Since then, the file has been updated on a regular basis to reflect postal code changes provided by Canada Post Corporation. Every five years, the postal code linkages on the PCCF are “converted” to the latest census geographic areas. The original PCCF was linked to the 1981 Census geographic areas. Since then, the PCCF has undergone one “conversion”, following the 1986 census.

Rates of confirmed COVID-19 in Ottawa Wards, excluding LTC and RH cases, and number of cases in LTCH and RH in Ottawa Wards. Data are provided for all cases (i.e. cumulative), cases reported within 30 days of the data pull (i.e. last 30 days), and cases reported within 14 days of the data pull (i.e. last 14 days). Based on the most up to date information available at 2pm from the COVID-19 Ottawa Database (The COD) on the day prior to publication.Rates of confirmed COVID-19 in Ottawa Wards, excluding LTC and RH cases, and number of cases in LTCH and RH in Ottawa Wards. Data are provided for all cases (i.e. cumulative), cases reported within 30 days of the data pull (i.e. last 30 days), and cases reported within 14 days of the data pull (i.e. last 14 days). Based on the most up to date information available at 2pm from the COVID-19 Ottawa Database (The COD) on the day prior to publication. You can see the map on Ottawa Public Health's website.Accuracy: Points of consideration for interpretation of the data:Data extracted by Ottawa Public Health at 2pm from the COVID-19 Ottawa Database (The COD) on May 12th, 2020. The COD is a dynamic disease reporting system that allow for continuous updates of case information. These data are a snapshot in time, reflect the most accurate information that OPH has at the time of reporting, and the numbers may differ from other sources. Cases are assigned to Ward geography based on their postal code and Statistics’ Canada’s enhanced postal code conversion file (PCCF+) released in January 2020. Most postal codes have multiple geographic coordinates linked to them. Thus, when available, postal codes were attributed to a XY coordinates based on the Single Link Identifier provided by Statistics’ Canada’s PCCF+. Otherwise, postal codes that fall within the municipal boundaries but whose SLI doesn’t, were attributed to the first XY coordinates within Ottawa listed in the PCCF+. For this reason, results for rural areas should be interpreted with caution as attribution to XY coordinates is less likely to be based on an SLI and rural postal codes typically encompass a much greater surface area than urban postal codes (e.i. greater variability in geographic attribution, less precision in geographic attribution). Population estimates are based on the 2016 Census. Rates calculated from very low case numbers are unstable and should be interpreted with caution. Low case counts have very wide 95% confidence intervals, which are the lower and upper limit within which the true rate lies 95% of the time. A narrow confidence interval leads to a more precise estimate and a wider confidence interval leads to a less precise estimate. In other words, rates calculated from very low case numbers fluctuate so much that we cannot use them to compare different areas or make predictions over time.Update Frequency: Biweekly Attributes:Ward Number – numberWard Name – textCumulative rate (per 100 000 population), excluding cases linked to outbreaks in LTCH and RH – cumulative number of residents with confirmed COVID-19 in a Ward, excluding those linked to outbreaks in LTCH and RH, divided by the total population of that WardCumulative number of cases, excluding cases linked to outbreaks in LTCH and RH - cumulative number of residents with confirmed COVID-19 in a Ward, excluding cases linked to outbreaks in LTCH and RHCumulative number of cases linked to outbreaks in LTCH and RH - Number of residents with confirmed COVID-19 linked to an outbreak in a long-term care home or retirement home by WardRate (per 100 000 population) in the last 30 days, excluding cases linked to outbreaks in LTCH and RH –number of residents with confirmed COVID-19 in a Ward reported in the 30 days prior to the data pull, excluding those linked to outbreaks in LTCH and RH, divided by the total population of that WardNumber of cases in the last 30 days, excluding cases linked to outbreaks in LTCH and RH - cumulative number of residents with confirmed COVID-19 in a Ward reported in the 30 days prior to the data pull, excluding cases linked to outbreaks in LTCH and RHNumber of cases in the last 30 days linked to outbreaks in LTCH and RH - Number of residents with confirmed COVID-19, reported in the 30 days prior to the data pull, linked to an outbreak in a long-term care home or retirement home by WardRate (per 100 000 population) in the last 14 days, excluding cases linked to outbreaks in LTCH and RH –number of residents with confirmed COVID-19 in a Ward reported in the 30 days prior to the data pull, excluding those linked to outbreaks in LTCH and RH, divided by the total population of that WardNumber of cases in the last 14 days, excluding cases linked to outbreaks in LTCH and RH - cumulative number of residents with confirmed COVID-19 in a Ward reported in the 30 days prior to the data pull, excluding cases linked to outbreaks in LTCH and RHContact: OPH Epidemiology Team

The Postal Code Conversion File (PCCF) is a digital file which provides a correspondence between the Canada Post Corporation (CPC) six-character postal code and Statistics Canada's standard geographic areas for which census data and other statistics are produced. Through the link between postal codes and standard geographic areas, the PCCF permits the integration of data from various sources. The Single Link Indicator provides one best link for every postal code, as there are multiple records for many postal codes. Getting started guide To obtain the postal code conversion file or for questions, consult the DLI contact at your educational institution. The geographic coordinates attached to each postal code on the PCCF are commonly used to map the distribution of data for spatial analysis (e.g., clients, activities). The location information is a powerful tool for planning, or research purposes. In April 1983, the Geography Division released the first version of the Postal Code Conversion File, which linked postal codes to census geographic areas and included geographic coordinates. Since then, the file has been updated on a regular basis to reflect postal code changes provided by Canada Post Corporation. Every five years, the postal code linkages on the Postal Code Conversion File are “converted” to the latest census geographic areas. The original Postal Code Conversion File was linked to the 1981 Census geographic areas. Since then, the Postal Code Conversion File has undergone four “conversions”, following the 1986, 1991, 1996 and 2001 censuses. A revised automated system was used for the 1996-2001 conversion. The 2001 Census postal codes reported by respondents were used to validate the Postal Code Conversion File links.