Query NDC Bad Postal Code: Difference between revisions
Ttenbergen (talk | contribs) cleaned up article, pls see I got all right |
|||
| Line 1: | Line 1: | ||
We cross-check the postal codes we collect as part of [[Postal Code collection]] against a list of known-good postal codes. | |||
== | == Steps == | ||
=== Comparison === | |||
Comparisons are done as part of [[vetting]] via NDC query ''NDC_Bad_Postal_Code'' in [[CFE]]. | |||
Steps will be: | |||
<we need to fill these in when we have completed the first-time updates, we deferred decision on the steps today to when we have done partial cleaning and know how much is left. booked to do with Pagasa on Monday. Ttenbergen 16:50, 2014 October 2 (CDT)> {{discussion}} | |||
== | === updating the codes === | ||
Codes are stored in table ''Postal_Code_Master''. Codes can be manually added to or imported into this table when a new master set becomes available. | |||
== | == File Locations == | ||
old master imports can be found at | |||
X:\CCMDB\z_archive\PostalCode | |||
==Where was it obtained== | |||
From Randy Martens to [[Julie Mojica]] | |||
* other potential sources | |||
** http://geocoder.ca/?freedata=1 | |||
==Start Date== | ==Start Date== | ||
2014-09-29 | |||
[[Category: Data Processing]] | [[Category: Data Processing]] | ||
Revision as of 15:50, 2 October 2014
We cross-check the postal codes we collect as part of Postal Code collection against a list of known-good postal codes.
Steps
Comparison
Comparisons are done as part of vetting via NDC query NDC_Bad_Postal_Code in CFE. Steps will be: <we need to fill these in when we have completed the first-time updates, we deferred decision on the steps today to when we have done partial cleaning and know how much is left. booked to do with Pagasa on Monday. Ttenbergen 16:50, 2014 October 2 (CDT)> Template:Discussion
updating the codes
Codes are stored in table Postal_Code_Master. Codes can be manually added to or imported into this table when a new master set becomes available.
File Locations
old master imports can be found at X:\CCMDB\z_archive\PostalCode
Where was it obtained
From Randy Martens to Julie Mojica
- other potential sources
Start Date
2014-09-29