--0000000000002891c8061674db0f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Sardar, My availability is limited on Monday however so please include Tim and Audra on the call when you do schedule. Chad *Chad Everitt* President- East Division & Canada Mobile: 202.262.8318 [image: TheKey] On Fri, Apr 19, 2024 at 9:31=E2=80=AFAM Sardar Azimov wrote: > Hi Chad, > > Please find the link to the Excel file with 3 tabs: > https://docs.google.com/spreadsheets/d/151PcWGhgqon1jfqq262lGU63Yg8ppdOt/= edit?usp=3Dsharing&ouid=3D101409043019553880832&rtpof=3Dtrue&sd=3Dtrue > > 1) The initial SF data enriched with counties and other details + changes > that were shared by each division > 2) The CA related zip codes based on the matching of cities that are > currently serviced by local offices (ex if Vancouver was serviced then al= l > zips pertaining to Vancouver were identified and added). There is a colum= n > specifying if the zip is already in SF. Heads up, there are nearly 290k > non-identified zips for Canada in the cities serviced by local offices. > That might take you a while to identify. > 3) Same for the US but this time based on the county level. I've > identified the missing zips for counties that are serviced by local offic= es > and are not in SF. I've also highlighted in yellow (first column) all zip= s > with over 1,000 estimated population so that you can focus on bigges ones= . > Approx 350 zip codes are in this sitiuation. > > I'm traveling today till Tuesday, but I can find some time to have a call > either today or on Monday to go through this. > Thank you, > > On Thu, Apr 18, 2024 at 5:01=E2=80=AFPM Chad Everitt > wrote: > >> 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 3= 3136 >>> 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 co= des and >>> match it back with the total list 850k zip codes. Ex Zip 1 is in Cal= gary >>> and in SF and Zip 2 is also in Calgary but not in SF. This should de= crease >>> the time spent on qualifying the totality of codes but only those wi= thin >>> 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 fr