search

dcl-covid-19 / mega-map-dev

Bay Area Community support for COVID-19 - based on NC-COVID-Support
GNU General Public License v3.0
4 stars 4 forks source link

Ensure the website includes all zip codes for which we have data. #73

Open charliehoffs opened 3 years ago

charliehoffs commented 3 years ago

Sometimes, when you search a zip code beyond the Bay Area, you get a "We don't cover this area" message. For example, try searching 95060 in Santa Cruz, where we have many school meals data points. This is because Santa Cruz is beyond the traditional 9 county bounds, but our data covers a slightly larger area. Include all zip codes for which we have data.

chalkedgoose commented 3 years ago
Screen Shot 2021-02-15 at 10 18 05 PM

I have synced the latest zipcodes from the zipcode_db but that one does not seem to be in their. Is there some sort of process of someone on the data team I can ping about this?

charliehoffs commented 3 years ago

Hey @calba5141114 ! Thank you for looking into this! I think this problem is happening because we originally uploaded all the zip codes in the traditional "9 counties" of the Bay Area. However, our school meals database and a couple other categories also include zipcodes falling outside the traditional 9 counties (e.g. Santa Cruz). I suppose that one solution would be 1) figuring out which zipcodes are present in our Airtable database, that are not in CARTO, and uploading them to CARTO, or 2) simply identifying which additional counties we should upload all the zipcodes for, and uploading them in bulk. Does either solution seem better to you? If option 1, I can help show you where to identify which zipcodes are in our Airtable database, and if option 2, I can let you know which additional counties we should upload. Thank you for exploring this issue!