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 difficulty 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). The 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;

Complete

Netflix Re-imagined

Using Human-Computer Interaction techniques, this site attempts to improve the usability of the popular Netflix.com site for viewers. Please view site here for correct formatting.

Complete

Gomuku Game

Javascript game designed for entertainment purposes. Utilizing multiple clients among a Flask development server. This project was completed using HTML/CSS/JS. The site can be accessed here.

Sample Code

@app.route('/', methods=["POST"])
def login():
    name = request.form['name']
    if name in players and name in nameList:
        return jsonify(status = 'Logged')
    if name in nameList and not name in players:
        players.append(name)
    if len(players) == 1 and name in nameList:
        return jsonify(player1 = name, status = 'Wait')
    elif len(players) == 2 and name in nameList:
        return jsonify(player1 = players[0], player2 = players[1], status = 'Yes')
    elif len(players) > 2 and name in nameList:
        return jsonify(playerWaiting = name, status = 'Busy')
    return jsonify(player1 =  name, status = 'No')

if __name__ == '__main__':
    app.run(host = "localhost", port = 8080, debug = True)