Jesteś tutaj

Strona główna » Katalog » Series Countries / Regions

Kanada

Jest 17113489 pozycji w bazie danych kodów pocztowych Kanada , po dokonaniu płatności mogą Państwo zapisać wszystkie dane na dysku.

Opis Produktu

  • Nazwa Produktu : Kanada Baza Danych Kodów Pocztowych
  • SKU : zipcode-can
  • Sposób Dostawy : Pobierz
  • Dostępność : Tylko Online
  • Czas Dostawy : Natychmiastowy
  • Sposób Płatności : PayPal
  • Państwo/Region : Kanada
  • Skrót : CAN
  • Skrót 2 : CA

  • Język Danych : Domyślny (English (EN))
  • Format Pliku : csv, txt
  • Rozmiar Pliku : 738.37 M (ZIP File)
  • Katalog : Series Countries / Regions
  • Przykład Strony Internetowej : Kanada
  • Cena Sprzedaży :USD $ 1,029.99
  • Najnowsza Aktualizacja :Listopad-2025


    • Kanada
Lista Polowa

  • 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 Kanada Baza Danych Kodów Pocztowych '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
Więcej Informacji

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.

Przykład Koperty
Kanada Przykład Koperty
Więcej informacji zawiera dokument oficjalny: can.pdf . (Angielski)
  • 115957 odsłon