Interactive Fishing Location Map

Built an interactive map that connects to Google Sheets to visualize fishing locations and catch data. The map updates automatically as new data is added, making it easy to track successful spots and plan future trips.


Overview

Tracking fishing locations and catch data was scattered across multiple spreadsheets and notes. There was no easy way to visualize where successful fishing spots were located or to see patterns in catch data over time. A solution was needed that would make it simple to log locations and instantly see them on a map.

Solution

I developed an interactive map using Leaflet.js that connects directly to a Google Sheets data source. The solution includes:

  • Real-time data synchronization from Google Sheets
  • Color-coded markers showing catch success (green for fish caught, gray for no fish)
  • Interactive popups with location details, flies used, and notes
  • Automatic map bounds adjustment to show all locations
  • Responsive design that works on desktop and mobile devices

Results

The map makes it easy to visualize fishing locations and identify patterns in successful spots. Adding new locations is as simple as updating the Google Sheet, and the map automatically reflects the changes. This has made trip planning much more efficient and helped identify the most productive areas.

Technologies Used

Leaflet.js Google Sheets API JavaScript CSS