Free Map Tools

Cambridge info i found: CB21 52.127,0.28244 CB22 52.127,0.13593 CB23 52.215,-0.03011 CB24 52.277,0.08374 CB25 52.260,0.25305
On 11/03/2010

I have an issue with lattitudes and longitude on my tomtom gps in Australia. I can only use the particular co-ordinates for that day only. If I plug in the same co-ordinates the next day I am lost. Can anyone help me harshalabharath@yahoo.com
By Barry on 24/12/2009

Could yu please coorect the map location of my village. North Nibey is located on teh road between Dursley and wotton under Edge. It is currently shown about 3 miles to the east located between Dursley and Tetbury
On 29/11/2009

Thank You for Your help
By kandy on 12/11/2009

Thank you for your list. Great work
By Sergio on 21/10/2009

Dr Paul A Daniels, This has now been updated on your original comment.
By Free Map Tools on 06/10/2009

This editor is mangling the input. There should be a 'plus' sign after the first '^2' in place of the space.
By Dr Paul A Daniels on 06/10/2009

The formula given by Nick is wrong; it should be =SQRT((69.1674*(C2-C3))^2+(41.6076*(D2-D3))^2) for the UK. The formula Nick used comes from a US site and assumes a mean latitude of 40deg. The first constant of 69.1674 comes from the Earth's circumference through the poles divided by 360 degrees and is just a conversion factor from degrees of latitude on the Earth's surface to miles. The second factor, however, is the circumference of the latitude circle (i.e. perpendicular to the Earth's axis) at the mean latitude for the database divided by 360 degrees, i.e. R*cos(lat)/360 (where R is the Earth's mean radius); on the source US website this is a larger value because the latitude circle has a larger circumference at lower latitudes. This approximate formula considers the lat/long pairs to be on a plane and ignores spherical considerations. This is probably good enough when the points are close together but will be less accurate calculating the distance from, say, New York to Bombay (or even Plymouth to Aberdeen). The 27% difference in the second constant would mostly show when the distance between two places on similar latitudes was being calculated.
By Dr Paul A Daniels on 06/10/2009

Interesting - as a REAL novice, tried the formula in Open Office (Excel, why?)from Nick's posting using these data, and got distance = 0 miles when it's around 7 ?? 52.612000° -2.480000° 52.512000° -2.480000°
By Peter on 06/10/2009

Thanks Elliott for the distance calc in Excel. However, you made a typo and missed out a ' '. The working rule for anyone else struggling should be: =SQRT((69.1*(C2-C3))^2 (53*(D2-D3))^2) As an excel novice I pasted the CSV postcode data into a 2nd sheet in my XLS file, and used VLOOKUP's to locate the corresponding lat/lng values. For example, I lookup the postcode entered in cell A3 on sheet 1 in my sheet labelled 'Postcode' as follows: =VLOOKUP(A3,Postcode!B2:D2853,2,FALSE) This looks at the whole table of data and returns column 2 when a match is found to match identically. Good luck fellow excel noobies :)
By Nick on 24/07/2009

A very useful file. I've used it in Excel with a macro that will find the distance from a single source postcode to all the other postcodes listed. Missing: NR7 - NORWICH [Sprowston, Thorpe St. Andrew, Heartsease] = (52.642606, 1.335567) and Missing: PH37 - GLENFINNAN [Glenfinnan, Polloch] = (56.816195, -5.528405)
By DM on 05/05/2009

It would appear that the OX6 postcode area no longer exists and is now in other areas (ox28 to name but one). How often is the db updated?
On 28/04/2009

Hi, this is fantastic help. Can anyone talk me through creating my own map with this, ideally to create a radius of each postcode? thanks
By Kelly Elsworth on 14/04/2009

This is a really useful database. Thanks for providing. By the way, what is your source for this data?
By Dave on 02/04/2009

Doing the calculation in excel is simple (I did this 3 years ago! - Outcode only). Happy to send a copy to anyone that wants it (It also maps the post code onto a map). Email me at david (dot) rignall (at) gmail (dot) com I did write a macro to do a full post code map but it's too slow.
By Dave R on 18/03/2009

Hi, many thanks for the for postcodes! For those needing an Excel formulation for distance that's a close approximation, use the below: =SQRT((69.1 * (C1-C2))^2 (53 *(D1 -D2))^2) Where C1 and C2 are your two latitude cells and D1 and D2 are longitude. To find out where the 69.1 and 53 came from, go to: http://www.meridianworlddata.com/Distance-Calculation.asp Seems accurate enough, I put the postcodes in Google Maps to check the distance and selected the new 'walking' option - obviously though Google will plot the best road/path to take not a direct line so you would expect it to be slightly more!! Now I need to convert to an ASP loop to find all postcodes within a certain radius :)
By Elliott on 05/03/2009

PH37 is missing from the range
By Matthew on 16/02/2009

distance = square-root ( (Xb-Xa)2 (Yb - Ya)2 ) that is the formula for calculating distance between 2 codes
By Marty on 07/02/2009

I have managed to get the lat and lon values for every outcode I have but need a full list of outcodes can anyone help?
By Paramiliar.com on 06/02/2009

For the Excel question: =ACOS(SIN(lat1)*SIN(lat2) COS(lat1)*COS(lat2)*COS(lon2-lon1))*6371 Richard: Correct, they are for the IOM. Google Maps/Earth now supports IMX postcodes so this data is easy to collect.
By Sharry on 22/10/2008

Showing the most recent 20 out of 32 comments. Click to see all the comments.

Add your own comment below and let others know what you think: