[datahound]

Does anyone have a complete database of UK postcodes with lat and long?

Just bought one, installed and compared to 2000 random postcodes and 50 - 100 are not listed.

Or perhaps a method of getting lat and long for a given postcode?

Does anyone know how many UK postcodes there are?

[Limbo]

Postcodes are added & amended, like houses and roads, daily - so live data is essential.

You can buy postcode web services - it's expensive but let's you interrogate a live database - we did some work with a development agency who sorted this side and the used the royal mail...

[freelancr]

UK and international address management and postcode finder web services and more

[woodss]

Yup, we're using the postcodeanywhere XMLs

[datahound]

Thanks very useful.

[88mph]

does anyone know of a service that can return distances based on postcodes, for delivery costs?

[freelancr]

Originally Posted by 88mph

does anyone know of a service that can return distances based on postcodes, for delivery costs?

Postcode Anywhere can... but the Google Maps API might do it for free?

[88mph]

thats what i have been looking into, yet to find a definite yes or no yet

[datahound]

From postcodes you need longitude and latitude. From this you can calc distance between two postcodes.

PHP Code:

<?php

function getDistance($lat1, $long1, $lat2, $long2)
{
//$earth = 6371; //km change accordingly
$earth = 3960; //miles

//Point 1 cords
$lat1 = deg2rad($lat1);
$long1= deg2rad($long1);

//Point 2 cords
$lat2 = deg2rad($lat2);
$long2= deg2rad($long2);

//Haversine Formula
$dlong=$long2-$long1;
$dlat=$lat2-$lat1;

$sinlat=sin($dlat/2);
$sinlong=sin($dlong/2);

$a=($sinlat*$sinlat)+cos($lat1)*cos($lat2)*($sinlong*$sinlong);

$c=2*asin(min(1,sqrt($a)));

$d=round($earth*$c,2);

return $d;
}

?>

[freelancr]

It's not a useful distance for deliveries, better off getting how many miles it is by road from Google Maps API.

[datahound]

Sorry about that.