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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.