Display Multiple locations from a row on a map


Use case: I have a grid of store locations. Each store location has an address and a lat-long coordinate pair.

What I’d like to do is show the potential discrepancy between the geocoded address and the lat-long. Except, not as a number, but as either

  1. two map pins, different colors

  2. a line segment, where one end is the geocoded lat-long and the other the given lat-long

I’ve done this in the past, in tools like Tableau, carto.db and even GoogleMaps (where I’ve calculated the line segment behind the scenes in MS-SQL)

Something like this, but obviously at a much, much smaller scale