We want to create a Heat Map. I've done this before but the data was all US counties. There are about 3200 something US counties. We got the data from the Census Bureau's website. Dumped the data in our database. Used MapBox , C# code and displayed the heat map.
Now, we want to display a Heat Map but it's street addresses/state/zip data that we have.
The previous developer used Google API. User enters their address, clicks submit. Looks like the code calls Google API and it displays the map with that address. Too much work for the user.
I don't think we can get all the Geo data for all the addresses we have. We have about 1 million rows of data. Not all needs to be displayed on the map. It's whatever a client has...maybe 100 places to show on a map.
I'm thinking we can display a map (maybe using Map Box) , automatically call Google API and then display the map locations.