Looking for UK cities database

[eluser]Ingonyama[/eluser]
Hi all, this isn't really CI-related but could anyone tell me where I might be able to find a MySQL database of all cities in the UK. At a minimum I need the town name and coordinates (longitude, latitude).

Thanks.

[eluser]pistolPete[/eluser]
Have a look at:
http://www.acmultimedia.co.uk/blog/artic...?blogID=59 or http://www.easypeasy.com/guides/article.php?article=64
They provide "a database of post codes with their corresponding longitude/latitude values".

An alternative could be GeoNames, OpenStreetMap or
freethepostcode.org.

But I don't know how accurate and up-to-date these databases are.

Of course you could also buy it from Royal Mail.

[eluser]Ingonyama[/eluser]
Thanks very much! Thats exactly what I was looking for