--000000000000853df306166040ea Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Yes thanks. Otherwise, we are simply recycling the missing content. *Chad Everitt* President- East Division & Canada Mobile: 202.262.8318 [image: TheKey] On Thu, Apr 18, 2024 at 10:50=E2=80=AFAM Sardar Azimov wrote: > 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 331= 36 > are both in Miami Dade county; 33137 is not in SF but 33136 is in SF; = then > it 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 code= s and > match it back with the total list 850k zip codes. Ex Zip 1 is in Calga= ry > and in SF and Zip 2 is also in Calgary but not in SF. This should decr= ease > the time spent on qualifying the totality of codes but only those with= in > 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 >> Canadian provinces for review? Pulling from SalesForce may be recycling = the >> garbage 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 fo= r >>> counties/states and did not check if all existing zip codes were presen= t 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 >>> would be the best way to identify the important missing ones? >>> >>> >>> On Wed, Apr 17, 2024 at 4:06=E2=80=AFPM Timothy Thomas = wrote: >>> >>> Hi Ray, >>> >>> The list that was provided to us last week is