Hey everyone — I am building a small community site called optimum outage us. It is meant to show when Optimum internet or TV is having problems by area, with a map of user reports.
I am stuck on a few things and would love advice (no rush) 1) Best way to color Leaflet markers by how recent or how many reports are in a city
Whether I should store rollups by city/day in the DB or calculate on the fly
Any pitfalls with letting people submit outage reports without making spam easy
I am not dropping any links here — just looking for guidance from people who have built similar status or map dashboards. Thanks!
You can use circle radius size to indicate the number of reports and different colours to represent how recent the report was.
If in the last hour, use red. Amber for between one and three hours. From three to six hours use yellow. If older than six hours remove it from the map to prevent cluttering.
You can also restrict submissions to one report per ip address for 30 minutes. Add a checkbox to tick before the report can be submitted, as this may help to filter out spambots.
1) Best way to color Leaflet markers by how recent or how many reports are in a city