Community Services App

A database filled with local resources

Introduction

My colleague and I created a web app filled with resources for people in underserved communities within the Merced and Stanislaus counties. We gathered data from Google and created our own database from scratch. Our app consists of six services:

Each of those services has the following information stored:

Users have the ability to find services based on its city, county and zip code, the managers at each service, and the customers that are subscribed to each service.

We didn't want regular users to be able to make major changes to our database, so we created the role of "admin". The purpose of the admin is to edit/delete managers or users. That way, changes made to the database are secure. Currently the only admins are my colleague and me.

When a user first visits our website, they are directed to our main menu, where they have the options to view all of our databases, find places that offer a specific service, or search for a subscriber or manager and view the services they are affiliated with. At any time, the user can go back to the main menu. An admin can perform the same operations, with the added ability to edit a subscriber or manager's information. When they click the "edit records" option, they are directed to a login page, where they can input their credentials. If their input is correct, they can choose to edit a subscriber or manager's name, email, or phone number.

We used HTML and CSS to create the pages and Flask (a Python library) to navigate through them. Our database is handled through SQLite, which allows us to easily make changes.

Demo

Here's a video that shows this code in action! The code for this is also in my GitHub.

Aditi Kisara | Alejandro Sanchez