This repository holds the code for a project developing a map of food assets for the Area Asian Pacific Islander (API) community in the City of San Francisco.
I've created three milestones:
- Import Data
- Build Map
- Deploy Map
For this part of the work, I imagine us using an R script file that brings in all data, cleans it, geocodes it (where appropriate), and then saves it to an RDS file. I tend to use the structure of packages in projects as well, with data-raw and data folders. I'm not sure how much we'll need to use the data-raw for this project but it's there.
Each object should be saved as an RDS file with the following variables:
- name
- category
- street_address
- city
- state
- zip_code
The object should be geocoded with a geometry column to hold that data.
In consultation with the client, here are the categories of food resources we're working with:
- Corner Stores
- Drug Stores
- Ethnic Markets
- Farmers Markets
- Food Banks/Pantries
- Food Pharmacies
- Free Prepared Food or Hot Meals
- Liquor Stores
- Restaurants
- Restaurants (Fast Food)
- Supermarkets
There is one attribute that can apply across categories:
- Stores that Accept SNAP/WIC
We've been asked to focus on these neighborhoods in particular as they are where the API community is concentrated:
- SOMA
- Richmond
- Sunset
- Chinatown
- Japantown
- Bayview Hunters Point
- Tenderloin
- Visitacion Valley
- Excelsior
Below is a summary of the data that we have collected, with a brief synopsis of how it was collected. The categories come from the list above, with slight tweaks for readability.
Free, Prepared Food or Hot Meals
Data was copied manually from this PDF from freeprintshop.org and scraped from Bay Area 211.
Corner Stores
Data came from the OpenStreetMap API.
Drug Stores
Data came from the OpenStreetMap API.
Restaurants
Data came from the OpenStreetMap API.
Supermarkets
Data came from the OpenStreetMap API.
Liquor Stores
Data came from the OpenStreetMap API.
Farmers Markets
Data came from the OpenStreetMap API. Additional markets were collected from the San Francisco Department of the Environment.
Fast Food Restaurants
Data came from the OpenStreetMap API.
Food Banks
Data was scraped from the San Francisco Marin Food Bank website.
Food Pantries
Data was scraped from foodpantries.org.
Food Pharmacies
Data was provided by Kathleen and entered manually.
Stores that Accept SNAP/WIC
Data on stores that accept SNAP comes from the USDA website.
Data on stores that accept WIC comes from the WIC Store Locator website.
Ethnic Markets
Data was manually collected from SF Gate and a Live Journal guide from 2014.
In this phase, we'll build out the map. This will involve design decisions (colors, fonts, etc) and the actual plotting of the geospatial data from the Import Data phase on the map.
In the last phase we'll determine how exactly we'll deploy the map. I imagine it will be a deploy to Netlify situation but I'll confer with the client to confirm this.