--000000000000802b0d06166017e1 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello Chad, I will create a file with the following information: - US zip codes not in the SF + identify those that are in counties that have other zip codes services by a local office (ex 33137 and 33136 are both in Miami Dade county; 33137 is not in SF but 33136 is in SF; then i= t would worth checking if the local office could service 33137) - CA zip codes not in the SF + identify all city areas that are currently in the SF based on the current list of 10k Canadian zip codes = and match it back with the total list 850k zip codes. Ex Zip 1 is in Calgary and in SF and Zip 2 is also in Calgary but not in SF. This should decrea= se the time spent on qualifying the totality of codes but only those within target zones. I hope this works for you. Thank you. On Wed, Apr 17, 2024 at 6:24=E2=80=AFPM Chad Everitt wrote: > Sardar, > > Can we externally pull all the Postal Codes within the respective Canadia= n > provinces for review? Pulling from SalesForce may be recycling the garbag= e > in and producing garbage out. > > > > *Chad Everitt* > President- East Division & Canada > Mobile: 202.262.8318 > [image: TheKey] > > > On Wed, Apr 17, 2024 at 12:19=E2=80=AFPM Sardar Azimov > wrote: > >> OK, thank you. >> Let me try to narrow down this list and get back to you. With a list of >> missing zip codes for these areas. >> >> Sent from Outlook for iOS >> ------------------------------ >> *From:* Timothy Thomas >> *Sent:* Wednesday, April 17, 2024 5:20:52 PM >> *To:* Sardar Azimov >> *Cc:* Ray Smale ; Chad Everitt > chad.everitt@thekey.com>; Phil Chanda ; >> Gabrielle Wolfe >> *Subject:* Re: Updated zip codes for SF >> >> That's a great question. I'm not 100% sure. Perhaps Canada Post would >> have a tool based on the greater metro areas of our territories. >> >> 1. Great Montreal >> 2. Greater Toronto Area >> 3. Regional Municipality of Waterloo >> 4. Calgary Metropolitan Region >> 5. Winnipeg Metropolitan Region >> 6. Greater Vancouver >> >> On Wed, Apr 17, 2024 at 10:22=E2=80=AFAM Sardar Azimov >> wrote: >> >> Hi Timothy, >> >> The data came from SF exports. We mapped only the existing zip codes for >> counties/states and did not check if all existing zip codes were present= so >> that you could remove/add those that are missing or no longer serviced. >> >> There are over 875k zip codes in Canada and roughly 10k in SF. What woul= d >> be the best way to identify the important missing ones? >> >> >> On Wed, Apr 17, 2024 at 4:06=E2=80=AFPM Timothy Thomas w= rote: >> >> Hi Ray, >> >> The list that was provided to us last week is missing postal codes from >> our corporate territories. What source are you using to identify the cod= es? >> >> As for Halifax, this should not be a priority. We're not in a position t= o >> service clients there at the moment. >> >> On Wed, Apr 17, 2024 at 9:49=E2=80=AFAM Ray Smale = wrote: >> >> Good morning Tim, >> I