Usted está aquí

Inicio » Catálogo » Series Countries / Regions

Canadá

Hay 17113489 ítems en la base de datos de códigos postales Canadá, podría descargar todos los datos después del pago.

Descripción de Producto

  • Nombre de Producto : Canadá Base de Datos de Códigos Postales
  • Código SKU : zipcode-can
  • Método de Entrega : Descargar
  • Disponibilidad de Ítem : Sólo en línea
  • Tiempo de Entrega : Instantáneo
  • Forma de Pago : PayPal
  • País / Región : Canadá
  • Abreviatura : CAN
  • Abreviatura 2 : CA

  • Idioma de Datos : Por defecto (English (EN))
  • Formato de Archivo : csv, txt
  • Tamaño de Archivo : 738.37 M (ZIP File)
  • Catálogo : Series Countries / Regions
  • Sitio Web de Ejemplo : Canadá
  • Precio de Ventas :USD $ 1,029.99
  • Última Actualización :Noviembre-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á Base de Datos de Códigos Postales '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
Más Información

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.

Ejemplo de sobre
Canadá Ejemplo de sobre
Para más explicación, lea el documento oficial: can.pdf . (Inglés)
  • 115933 lecturas