FisaFoodie

Project Duration: 2025.01.15 - 2025.01.16

A platform for discovering the best lunch spots around Sangam-dong, tailored for FISA students.

• Tech Stack: Python, Streamlit, OpenStreetMap (OSM), MySQL
• Team Size: 5 members
• GitHub: FisaFoodie

📌 Project Overview
FisaFoodie is a location-based data platform that provides curated restaurant information for FISA students around Sangam-dong.
Built with Streamlit, the dashboard presents restaurant details, locations, and user reviews to help users make the most of their lunch breaks.

📌 Why This Topic?
- Help students manage their lunch time more efficiently by recommending suitable restaurants near the campus
- Provide reliable, community-driven data rather than generic reviews from large platforms like Naver or Kakao

📘 Key Features
- Input and save individual lunch records
- Statistics on restaurant visits by class and week
- Map view of training center and nearby restaurants
- View and write restaurant reviews

🙋‍♂️ My Role & Takeaways
- Handled database setup and integration, map implementation, and review management
- Stored photos in the DB as BLOBs instead of using S3
- Implemented map markers using the Folium library and OpenStreetMap API
- Developed pagination and review display logic
- Troubleshot name-matching issues between local stores and OSM entries
- Project Blog

📖 Development Process
- Quickly built and deployed a prototype using Streamlit
- Built and loaded data into a MySQL database
- Implemented map-based location services with Folium
- Developed review submission, image upload, and viewing functionalities

🐿️ Deployment
FisaFoodie