You are here

Home » Catalog » Series Countries / Regions

Canadá

Há item de 17113489 no banco de dados de código postal de Canadá e você pode fazer o download de todos os dados depois de o pagamento.

Descrição do Produto

  • Nome de Produto : Canadá dados de banco de código postal
  • SKU : zipcode-can
  • Método de Entrega : Baixar
  • Disponibilidade de item : Apenas Online
  • Prazo de Entrega : Instante
  • Forma de Pagamento : PayPal
  • País / Região : Canadá
  • Abreviatura : CAN
  • Abreviatura 2 : CA

  • Língua de Dados : Predefinido (English (EN))
  • Formato de Arquivo : csv, txt
  • Tamanho do Arquivo : 738.37 M (ZIP File)
  • Catalog : Series Countries / Regions
  • Exemplo de Site : Canadá
  • Preço de Venda :USD $ 1,029.99
  • Última Atualização :November-2025


    • Canadá
Lista de Campos

  • civic_no: The civic number of the address.
  • civic_no_suffix: The alphabetical suffix for the civic number.
  • street_name: The official name of the street as registered by the local government.
  • street_type: The official type of the thoroughfare.
  • street_dir: The directional suffix of the street.
  • csd_place: The name of the Census Subdivision (CSD), which is a key administrative division in Canada, typically corresponding to a municipality.
  • mail_street_name: The official street name as recognized and formatted by Canada Post for mail delivery.
  • mail_street_type: The street type as required for mail delivery.
  • mail_street_dir: The street direction as required for mail delivery.
  • mail_muni: The official postal municipality name required by Canada Post.
  • province: The province or territory in Canada.
  • province_abbr: The standard 2-letter abbreviation for the province or territory.
  • postal_code: The 6-character alphanumeric postal code.
Product Image
The following is Canadá dados de banco de código postal 's product sample image.

Canada Postcode Database
Product Sample
The following is Canada Postcode Database's product sample data, you can download the free sample sheet to get an overview of Canada Postcode.
Sample File: Canada Postal Code Database Sample.xlsx
Mais Informações

Q: Why does the dataset contain over 17 million records?

Unlike datasets that provide house number ranges (e.g., "1-100"), the Canada Postal Code Database is a point-address level dataset. It enumerates every single valid civic number (house number) in Canada.
Impact: You will see separate rows for house number 1, 2, 3, etc., even if they share the same postal code. This allows for precise address validation down to the individual doorstep.

Q: What is the difference between 'csd_place' and 'mail_muni'?

Canada often has distinct names for the administrative boundary versus the postal delivery area:
· csd_place (Census Subdivision): The legal/administrative municipality name (e.g., "Miscouche"). Use this for government reporting or tax purposes.
· mail_muni (Postal Municipality): The city name required by Canada Post for mail delivery (e.g., "MISCOUCHE"). Use this field when generating shipping labels.

Q: Why are there two versions of street names ('street_name' vs 'mail_street_name')?

The dataset provides both the official legal spelling and the postal-optimized version:
· street_name: Mixed case, official spelling (e.g., "Horncastle").
· mail_street_name: Uppercase, often abbreviated or simplified to meet postal machine sorting standards (e.g., "HORNCASTLE").
For shipping labels, it is safer to use the mail_ columns.

Q: How are the postal codes formatted?

Canada uses a 6-character Alphanumeric system (ANA NAN), e.g., A1L 1J7.
· The first 3 characters represent the FSA (Forward Sortation Area).
· The last 3 characters represent the LDU (Local Delivery Unit), which denotes a specific block, building, or large volume receiver.

Q: Why do neighboring house numbers have different postal codes?

Because the Canadian LDU (the last 3 characters) is extremely precise. A single street can be split into multiple LDUs. For example, house #23 might be A1L 2B1, while house #24 next door is A1L 1J7. You must rely on the exact civic_no to retrieve the correct code.

Q: How should I handle French characters?

The files are encoded in UTF-8-SIG. This is essential for correctly displaying French characters used in Quebec and other regions (e.g., "Montréal", "Québec", "Rue d'Église"). Ensure your import process explicitly supports UTF-8 to avoid character corruption.

Q: What file formats are included?

The package typically includes CSV, Excel (.xlsx), and TXT formats. Given the file size (17M+ records), we strongly recommend importing the CSV or TXT into a SQL database (like MySQL, PostgreSQL) rather than trying to open it directly in Excel.

Q: What is the refund policy?

Due to the digital nature of the product, all sales are final and non-refundable. We recommend downloading the Free Sample before purchasing.

For any further inquiries, please reach out to us via our contact form.

Exemplo de envelope
Canadá Exemplo de envelope
Para obter mais explicações, leia o documento oficial de can.pdf, por favor. (Inglês)
  • 115977 reads