Colorful Spots
Visit Colorful Spots Report
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
Having 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 in the design and implentation of the relational database, and front-end interface to showcase the metadata.
Data Sources
We used GraphQL from Yelp Database to request business, and user information. Because certain information was not available in Eventbride's API we had to parse event information using Parsehub software.
Database System
To design and implement a database system we used a relational database management system such as MySQL for this project. We used SQL library to fetch the data and used Node.JS as the backend to develop the website.
Data Preview of Businesses
Data Preview of Business Categories
Outcome
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 constrainst we only provided a map view and list view of the data available in the website.