💡 Version française ci-dessous • report error / signaler une erreur

One of the coolest things we did, and one which really started the spark of excitement in town, was the Interactive Map of Visitors.

You can see the map at https://map.NanaimoInfusion.ca

CleanShot 2026-04-30 at 12.55.03@2x.png

The data came from The Voluntary RSVP Form and AI generated the map.

How to make the map

  1. Download a CSV of responses from The Voluntary RSVP Form
  2. Use a spreadsheet program to remove all fields except number of people, location, and how many people are healthcare workers (this is so that AI never gets people’s personal data like name or email address).
  3. Use the prompt below at claude.ai
  4. It should generate a map and let you publish it to the web. Because we owned the domain NanaimoInfusion.ca we added the subdomain map.NanaimoInfusion.ca to make it easier to remember.

The prompt

I have a data file with three columns: number of people in each group, city/location they're coming from, and whether anyone in the group is a healthcare worker (Yes/No). The file may be CSV or TSV, and may or may not have a header row.

Create a published artifact with an interactive map (using Leaflet.js and OpenStreetMap tiles) that plots every registration on the map. Here are the requirements:

  1. Parse each row and geocode the city to latitude/longitude coordinates. Aggregate entries from the same location into a single marker. Skip any rows with empty or invalid city fields.
  2. Use circle markers sized proportionally to the number of people from that location.
  3. Colour coding: blue circles for locations where at least one group includes a healthcare worker. Red circles for locations with no healthcare workers.
  4. On hover and on click, show a tooltip with the city name, how many people are coming, and whether the group has a healthcare worker.
  5. Include a header bar at the top showing total people and total groups.
  6. Include a legend in the bottom right corner explaining the colours: blue means "Groups have a healthcare worker" and red means "Other attendees."
  7. Use the standard OpenStreetMap tile layer so the underlying map is fully visible.