Postal Code Master table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
(One intermediate revision by the same user not shown)
Line 32: Line 32:
|| town || text(255) ||  
|| town || text(255) ||  
|}
|}
== Contents ==
The contents are a mix of what we have received from various sources, and of what Pagasa adds when she finds a code that hasn't been listed before.
This data is not available form the Government of Canada, but a regularly updated file is available from here:
* https://www.serviceobjects.com/blog/free-zip-code-and-postal-code-database-with-geocoordinates/
** This data has some errors...


== Related articles ==  
== Related articles ==  

Revision as of 13:53, 2022 August 11

Postal_Code_Master table in Centralized_data.mdb is used by query NDC_Bad_Postal_Code to detect by exclusion Postal Code entries that are likely invalid.

The table on its own would be about 71MB, (30MB with all extra info stripped out) which is why the check was not included in CCMDB.accdb.

Data Structure

field type description
PCODE text(255) the postal code
rhacode text(255) code of regional health authority that the postal code is in
rhaname text(255) name of regional health authority that the postal code is in
CA text(255)
CA_name text(255)
NC text(255)
NC_Name text(255)
latitude number(double)
longitude number(double)
province text(255)
town text(255)

Contents

The contents are a mix of what we have received from various sources, and of what Pagasa adds when she finds a code that hasn't been listed before.

This data is not available form the Government of Canada, but a regularly updated file is available from here:

Related articles

Related articles: