Query NDC Bad Postal Code: Difference between revisions

Line 1:

~~==What is it?==~~

We cross-check the postal codes we collect as part of [[Postal Code collection]] against a list of known-good postal codes.

~~Is an mdb that has~~ a list of ~~all~~ postal codes ~~in the province of Manitoba~~

==~~Where was it obtain~~==

== Steps ==

~~From Randy Martens to~~ [[~~Julie Mojica~~]]

=== 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}}

==~~Current Location~~==

=== updating the codes ===

~~X:\CCMDB\PostalCode\Postal_Code_Checker_Master~~.~~mdb~~

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.

==~~What are we doing with it?~~==

== File Locations ==

*Made a query for the bad PostalCode today with Tina.

old master imports can be found at

**Find out that we have 621 problem records includes blanks and incorrect PostalCode.

X:\CCMDB\z_archive\PostalCode

***No decision made yet how to fix the problem.

~~[[User:PTorres|PTorres]] 13:16, 2014 September 29 (CDT)~~

*Plan include in the [[CFE]] for the main office and have and NDC for the weekly vetting process

**Tina to hook into [[CFE]] so Pagasa can run weekly AND also update Master Postal code checker.mdb.

*Outlook Appointment set up for Monday Sept 29 with Pagasa.[[~~User:TOstryzniuk|Trish Ostryzniuk~~]] 17:~~38, 2014 September 24 (CDT)~~

==Where was it obtained==

From Randy Martens to [[Julie Mojica]]

* other potential sources

** http://geocoder.ca/?freedata=1

==Start Date==

2014-09-29

~~{{Potential Change}}~~

[[Category: Data Processing]]

@@ Line 1: / Line 1: @@
-==What is it?==
+We cross-check the postal codes we collect as part of [[Postal Code collection]] against a list of known-good postal codes.
-Is an mdb that has a list of all postal codes in the province of Manitoba
-==Where was it obtain==
+== Steps ==
-From Randy Martens to [[Julie Mojica]]
+=== 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}}
-==Current Location==
+=== updating the codes ===
-X:\CCMDB\PostalCode\Postal_Code_Checker_Master.mdb
+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.
-==What are we doing with it?==
+== File Locations ==
-*Made a query for the bad PostalCode today with Tina.
+old master imports can be found at
-**Find out that we have 621 problem records includes blanks and incorrect PostalCode.
+X:\CCMDB\z_archive\PostalCode
-***No decision made yet how to fix the problem.
-[[User:PTorres|PTorres]] 13:16, 2014 September 29 (CDT)
-*Plan include in the [[CFE]] for the main office and have and NDC for the weekly vetting process
-**Tina to hook into [[CFE]] so Pagasa can run weekly AND also update Master Postal code checker.mdb.
-*Outlook Appointment set up for Monday Sept 29 with Pagasa.[[User:TOstryzniuk|Trish Ostryzniuk]] 17:38, 2014 September 24 (CDT)
+==Where was it obtained==
+From Randy Martens to [[Julie Mojica]]
+* other potential sources
+** http://geocoder.ca/?freedata=1
 ==Start Date==
+-09-29
-{{Potential Change}}
 [[Category: Data Processing]]