--000000000000acbfd8061686330f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Timothy and Audra, We have a call on zip codes on Monday at 9AM EST on zip codes with Gabrielle and Phil, among others. Given the situation with data completion I wonder if we should A) postpone the original call to a later date and B) use the time slot to address the topic on the missing zip codes instead. @Gabrielle Wolfe and @Phil Chanda happy to have your thoughts. Thank you. On Fri, Apr 19, 2024 at 5:36=E2=80=AFPM Chad Everitt wrote: > 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 + change= s >> 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 a= ll >> zips pertaining to Vancouver were identified and added). There is a colu= mn >> 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 offi= ces >> and are not in SF. I've also highlighted in yellow (first column) all zi= ps >> with over 1,000 estimated population so that you can focus on bigges one= s. >> Approx 350 zip codes are in this sitiuation. >> >> I'm traveling today till Tuesday, but I can find some time to have a cal= l >> 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 = 33136 >>>> are both in Miami Dade county; 33137 is not in SF but 33136 is in S= F; 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 zi