The NALENND™ NPA NXX to Canadian Postal Code Database provides the coverage required to identify which telephone area codes and exchanges are used in a particular Postal Code as well as what Postal Codes are in use within a particular telephone area code and exchange.
This mapping is based on the geography of the NPA NXX Rate Center and the Postal Code boundaries which yields a true representation of the coverage areas.
Produced: on or before 5th calendar day monthly
Current Release: September 2, 2020
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
|Field||Data Type||Field Description|
|NPA||CHAR (3)||The 3-digit area code.|
|NXX||CHAR (3)||The 3-digit exchange prefix.|
|ZIP||CHAR (7)||7-character alpha numeric Canada Postal Code. Format is A1A 1A1, where A is a letter and 1 is a digit, with a space separating the third and fourth characters.|
For those exchanges and/or services that are not geographically associated with a postal code area (e.g. 211, 411, 811, 911 etc.) or when a postal code cannot be identified, this field will be populated with the value Q0Q 0Q0.
|STATE||CHAR (2)||Two character province or territory abbreviation.|
|CITY||VARCHAR (128)||Name of city or locale identified by the current postal code.|
|RC||CHAR (10)||10-character Rate Center abbreviated name identifying local service area where the NPA NXX is assigned.|
CREATE DATABASE if not exists `nalennd`; USE `nalennd`; DROP TABLE IF EXISTS `npanxx2postal`; CREATE TABLE `npanxx2postal` ( `NPA` CHAR(3) NOT NULL, `NXX` CHAR(3) NOT NULL, `ZIP` CHAR(7) NOT NULL, `STATE` CHAR(2) NOT NULL, `CITY` VARCHAR(128) NOT NULL, `RC` VARCHAR(128) NOT NULL, PRIMARY KEY (`NPA`,`NXX`,`ZIP`) ) ENGINE=MYISAM DEFAULT CHARSET=utf8;