<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><font face="Helvetica, Arial, sans-serif">Task complete. The
multi-postal codes are tagged on buildings which may have more
than 1 address. Local mappers who are familiar with the areas
should review it. It looks like in many places imports were
used which incorrectly parsed the addresses. Many issues where
the value started with 2 letters representing the province and
then an incomplete postal code (aka "AA A#A").<br>
</font></p>
<pre><tt> 248803 "A#A #A#"
1455 "A#A"
14 "A#A #A#;A#A #A#"
1 "A#A #A#;A#A #A#;A#A #A#"</tt><tt>
</tt></pre>
<pre>(my initial query was incomplete, that's why the numbers are much bigger now... I was querying the postal codes where also there is a contact record)
</pre>
<tt><br>
</tt>
<div class="moz-cite-prefix">On 2018-02-07 08:01 PM, Matthew Darwin
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:b933b156-9a96-8b81-2939-76c77898dfbc@mdarwin.ca">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<p><font face="Helvetica, Arial, sans-serif">Hi all,</font></p>
<p><font face="Helvetica, Arial, sans-serif">Below are the 10 top
postal code formats in Canada as seen in <b>addr:postcode</b>.
When I get bored of tidying up phone numbers, I'll tackle some
postal codes. <br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">I hope we can all
agree that "A#A #A#", which is the most popular, is the
correct format that should be used. The ones that just have </font><font
face="Helvetica, Arial, sans-serif"><font face="Helvetica,
Arial, sans-serif">'A#A' (the "Forward Sortation Area") I
will leave as well. There are more than 60 unique formats
in use today.... and funny enough I see phone numbers in the
postal code field.... arrh!</font><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">I am open to
comments/suggestion on this, as always.<br>
</font></p>
<p><tt> 20271 'A#A #A#'</tt><tt><br>
</tt><tt> 1454 'A#A#A#'</tt><tt><br>
</tt><tt> 96 'a#a#a#'</tt><tt><br>
</tt><tt> 37 'A#A #A# '</tt><tt><br>
</tt><tt> 29 'a#a #a#'</tt><tt><br>
</tt><tt> 28 'A#A'</tt><tt><br>
</tt><tt> 24 'A#A #a#'</tt><tt><br>
</tt><tt> 23 'AA A#A #A#'</tt><tt><br>
</tt><tt> 17 'A#A-#A#'</tt><tt><br>
</tt><tt> 12 'A#A #A#'</tt><font face="Helvetica, Arial,
sans-serif"><br>
</font></p>
<br>
</blockquote>
<br>
</body>
</html>