Postal Code Master table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (9 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
Postal_Code_Master | 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]]. | 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 == | |||
{| class="wikitable sortable" | |||
|- | |||
!| field | |||
!| type | |||
!| description | |||
|- | |||
|| '''PCODE''' || text(6) || the postal code | |||
|- | |||
|| rhaname || text(17) || name of regional health authority that the postal code is in | |||
|- | |||
|| CA_name || text(22) || | |||
|- | |||
|| NC_Name|| text(27) || | |||
|- | |||
|| latitude || number(single) || | |||
|- | |||
|| longitude || number(single) || | |||
|- | |||
|| province || text(4) || | |||
|- | |||
|| town || text(40) || | |||
|} | |||
== 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... there is no free and regularly updated source of this that we know of. | |||
== Log == | |||
* 2022-08-?? - made field sizes smaller / more appropriate recently, removed duplicating/unused fields | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:Data structure]] | [[Category:Data structure]] | ||
[[Category:Postal Codes]] | [[Category:Postal Codes]] | ||
Latest revision as of 19:36, 2022 August 31
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(6) | the postal code |
| rhaname | text(17) | name of regional health authority that the postal code is in |
| CA_name | text(22) | |
| NC_Name | text(27) | |
| latitude | number(single) | |
| longitude | number(single) | |
| province | text(4) | |
| town | text(40) |
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... there is no free and regularly updated source of this that we know of.
Log
- 2022-08-?? - made field sizes smaller / more appropriate recently, removed duplicating/unused fields
Related articles
| Related articles: |