UK postcodes

Greetings Experts,

I have a database table with postcodes and am starting to look at how I can sort them onto a google map or similar to show the location by region of each facility (80,000+ locations) At the moment the table just has a postcode column, no lat/long details.  I am using SQL Server 2014, as well as Visual Studio 2017 and usually create solutions within c# and MVC.

Any guidance on tools out there or the approach i should take much appreciated.

Kind regards.
sunny-jAsked:
Who is Participating?
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.

Chris StanyonWebDevCommented:
Google Maps offers a GeoCode API which would allow you to pass in a Postcode and retrieve a Geographic Location (Lat/Long) that you could then place on your Map.

As a starting point, have a read up on the official docs: https://developers.google.com/maps/documentation/geocoding/intro

Once you've got your head around the concepts, come back with any specific questions you have.
0
Pawan KumarDatabase ExpertCommented:
As per below site -

Google Maps API provides a geocoding feature, for finding the latitude and longitude of places or addresses; but it does not work for UK postcodes. This is thanks to Royal Mail who have a copyright on the data, and are very restrictive with their (expensive) licenses for it. "

http://www.tomanthony.co.uk/blog/geocoding-uk-postcodes-with-google-map-api/
0
Chris StanyonWebDevCommented:
That info is from a post published 10 years ago. Not sure it's still accurate. I've had no problems getting the location info from Google's GeoCode based on a PostCode.

If you do find problems with it, then take a look at the API from https://postcodes.io/. You can use that to get the Lat/Lng from a postcode
1

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
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
SQL

From novice to tech pro — start learning today.

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.