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.

C#SQL

Last Comment

Chris Stanyon

8/22/2022 - Mon

Chris Stanyon

10/30/2017

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.

Pawan Kumar

10/30/2017

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/

ASKER CERTIFIED SOLUTION

Chris Stanyon

10/30/2017

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!