Service Details

FisaFoodie

Project Duration: 2025.01.15 - 2025.01.16

A platform to explore restaurants around Sangam-dong for FISA students

  • Tech Stack: Python, Streamlit, MySQL, OpenStreetMap
  • Team & Role: 5 members (My role – DB design, map view, review feature)
  • GitHub: FisaFoodie
  • Deployment: FisaFoodie

📌 Overview
• A location-based restaurant info platform for FISA students, offering a map UI and review features.

🎯 Motivation & Goal
• Reduce time spent searching for lunch options
• Provide community-driven customized reviews

🚀 Key Features
• Lunch record input and weekly stats
• Restaurant location view using Folium + OSM
• Write/read reviews and upload images

💻 Development Role
• Designed and connected MySQL DB
• Developed review board and image handling
• Implemented map visualization using Folium markers
• Troubleshot OSM name-matching errors

🛠️ Troubleshooting
1. Map search mismatch issue
• Issue: "Kimchi Doga Sangam" was searchable, but "Kimchi Doga Sangam Branch" was not
• Cause: OSM naming was inconsistent, failing partial matches
• Solution: Built a dictionary like { "Kimchi Doga": ["Kimchi Doga Sangam", "Kimchi Doga Sangam Branch"] } to support soft matching
• Result: Improved mapping coverage and user search effectiveness

2. Malicious input issue
• Issue: Invalid or fake place entries
• Cause: Lack of validation for free-text user input
• Solution: Implemented filtering against OSM data

✅ Outcome & Retrospective
• Built a working prototype using Streamlit in a short time
• Incorporated user feedback for iterative improvement
• Blog post completed
• Blog Post