Ongoing
Food Deserts
Baltimore is an area facing a high number of food deserts. There is a disproportionate amount of convenience stores to grocery stores, which results in diffuclty accessing healthy foods. This link is intended to provide resources to families in food deserts about where to obtain healthy food, use food benefits and find store locations with high health indices in their areas (using SQL). Site can be accessed here.
Sample Code
DROP PROCEDURE IF EXISTS SuperMarketsNearMe //
CREATE PROCEDURE SuperMarketsNearMe(IN ss VARCHAR(5))
BEGIN
IF EXISTS(SELECT zipcode FROM FoodStore WHERE zipCode=ss) THEN
SELECT *
FROM FoodStore
WHERE zipcode = ss
ORDER BY type ASC;
ELSE
SELECT *
FROM FoodStore
WHERE zipCode IN (SELECT zipCode FROM FoodStore ORDER BY type ASC)
ORDER BY ABS(zipCode - ss) ASC;
END IF;
END;