How can I get geo data (longitude / latitude) for addresses?

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.


Any ideas?
LVL 8
CamilliaAsked:
Who is Participating?
 
David Johnson, CD, MVPOwnerCommented:
what you can do is a one time search for all 1 million addresses and store the results in a database and use the results in subsequent mapping calls. How are you planning on winnowing down the data from 1 Million to 1 Thousand or 1 Hundred? Are you planning on comparing 2 locations and if they are within a specific radius dropping one of them?
0
 
CamilliaAuthor Commented:
what you can do is a one time search for all 1 million addresses

So, get the latitude/longitude of one by one? how can we do that....using Google Maps? for the US states or counties, we got the Geo data from the census bureau's site

Are you planning on comparing 2 locations and if they are within a specific radius dropping one of them?

I don't know. I'm new at this job, my understanding is the locations for one company are not close to each other.
0
 
CamilliaAuthor Commented:
what you can do is a one time search for all 1 million addresses

I think we can write code to loop thru the addresses, call Google Map API and get the data and save in the database. Right?
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
David Johnson, CD, MVPOwnerCommented:
Yes that is my advice. Note: google maps api's have usage limits unless you accept pay for usage over these limits.
https://developers.google.com/maps/faq#usage_pricing
0
 
CamilliaAuthor Commented:
Thanks. I'll take a look. I'll run this by our manager.
0
 
Kyle AbrahamsSenior .Net DeveloperCommented:
Just a note that you can do 2500 per day.  So 400 days to populate the 1 million records going the free route.  But definitely agree that using a one time lookup and storing it in the DB is the way to go.
0
 
CamilliaAuthor Commented:
Thanks, Kyle. I emailed my manager. I'll see what he says.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.