Over the course of the pandemic, the NZCovidMap reached over 200,000 Kiwis across New Zealand, with a peak of 15,000 daily unique visitors. This tool provided people with a mobile-friendly view of Covid-19 Locations of Interest published by the NZ Ministry of Health.
- - 4.5k users in the first month
- - Circle-based location selection method
- A Mobile-friendly map view
- - Location specific url pathing query params + "share link to location"
- - Generation of location-specific meta screenshots for engaging social media preview images.
- - Reddit Integration - Including Auto-Generate & Update of a "Location of Interest summary" for each subreddit & auto-post/update posts in relevant subreddit
Each hour, the application would check for new locations in specific communities and (if a sub-reddit exists) posts for any new locations in a standard post format:
- Provide a Mobile-friendly view of Locations of Interest
- Raise awareness of Locations of Interests in our community.
- Lower anxiety for those seeking updates about their community.
Tech
- Up-to-date social Media sharing icons created for each town/city
- [Ingest] An n8n workflow that reads the CSV file published by the MoH. Locations are then categorized and saved in a sqllite db via n8n.
- An endpoint (also n8n) that returns all the locations in the last 30 days.
- A statically rendered Next.JS site that is published each hour. A mobile-friendly interactive map with all locations marked.
- A hourly job to build sub-reddit content and sent updates to places with new/updated Locations of Interest.
- Self-referential automatic meta image generation
Why so complex?
To reduce the complexity, cost and on-going maintenance cost of the application, i removed the n8n workflow the Next.JS site build on and replaced it with direct calls to the MoH API.
This allowed the site to be fully independent of my own local infrastructure and for its whole lifetime, run entirely for free on Vercel