Colorful Spots

Colorful Spots is a web application that serves as a directory of businesses, services, and resources for LGBTQ+ people to navigate to safe spaces and connect with their community in Atlanta.

The Goal

The goal is to provide accessible information that supports the lives of LGBTQ+ individuals and enriches their decisions towards the economic, social, and health sectors. Colorful Spots offers a database to find essential prideful places available in the city with their business information.

Users & Audience

Our system is considered for members who are part of the LBGTQ+ community and their allies who are looking to connect easier in queer spaces available in the city of Atlanta.

Team & Role

We designed the Colorful Spots project with 3 Computer Science students. Our team focused mainly on designing and implementing the relational database and front-end interface to showcase the metadata.

Data Sources

Our data was contributed by Yelp Database and we used GraphQL to request all the business details, and user information. For the event details we parsed the information from Eventbite using the Parsehub software.

ER Diagram

Takeaways

Our key findings are that Yelp provided valid data from GraphQL using specific queries. With EventBrite, event information was parsed using Parsehub as they did not have an API available with the specific values.
Some of the challenges we faced were setting up MySQL locally for the first time. Because of time constraints, we only provided a map view and list view of the data available on the website.