Data
Map your data
Plot locations from a spreadsheet, with clustering, colour and filters.
Fill it in
A file with coordinates or addresses.
Which column drives the colour.
Which column drives marker size.
Group markers when zoomed out.
Your prompt
Plot these locations on a map. Colour by [your colour by]. Size by [your size by]. If the file has addresses rather than coordinates, geocode them and report how many failed. A map that silently drops the rows it could not place looks complete and is not, and that is the failure mode nobody catches. Check the coordinates before plotting. Latitude and longitude swapped puts Europe in the Indian Ocean, which is obvious on a map and invisible in a CSV. Cluster markers at low zoom so a dense city is one readable number rather than a black blob. One self-contained HTML file with a legend, a category filter and popups.
Use Map your dataOpens with everything above already filled in.
Why this works
A map that silently drops the rows it could not geocode looks complete and is not. This reports the failures, and it checks for swapped latitude and longitude, which puts Europe in the Indian Ocean on a map and is invisible in a CSV.
Questions
- Addresses or coordinates?
- Either. Addresses get geocoded, and you are told how many failed.