• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 11523
  • Last Modified:

Database with list of UK Towns, Cities, Counties and Postcodes

Do any of our experts know where I can get a database table with a list of all UK towns, cities, counties and postcodes for checking the missing information in my existing database.

Many thanks.
0
PeterWhitts
Asked:
PeterWhitts
  • 4
  • 3
  • 3
  • +2
2 Solutions
 
Leigh PurvisDatabase DeveloperCommented:
I'm sure I remember one from somewhere... but not accurately :-(

You could perhaps start here... and progressively make your own (unless there's a download)?
:-S
http://www.information-britain.co.uk/towns.cfm?alpha=a
0
 
nico5038Commented:
The "ultimate" source would be the Postcode Finder at: http://www.royalmail.com/
However when you need more than 12 a day you´ll have to pay...

Nic;o)
0
 
PeterWhittsAuthor Commented:
Interesting site but I really need a download with all the information ready ay hand.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
puppydogbuddyCommented:
0
 
PeterWhittsAuthor Commented:

see this link:    http://forums.digitalpoint.com/showthread.php?t=5843

This is a good start but only lists the counties....which is the easy bit.

Any more suggestions greatfully welcomed as i am sure this must have been asked already but not on EE
0
 
puppydogbuddyCommented:
If you don't mind cutting and pasting:
http://freepages.genealogy.rootsweb.com/~agene/locations/

0
 
Leigh PurvisDatabase DeveloperCommented:
That is rather thorough that one...
I'm almost tempted...

But I never copy and paste
never copy and paste
never copy and paste
0
 
puppydogbuddyCommented:
http://www.information-britain.co.uk/towns.cfm

Read to the end of thread for more sources of info:
http://forums.digitalpoint.com/archive/index.php/post-codes-and-uk-towns-again/t-63767.html


On this one, if you sign in/create an account, you may be able to upload file by using upload tool from toolbox on the lower left hand side of the screen.

http://en.wikipedia.org/wiki/List_of_postal_districts_in_the_United_Kingdom


0
 
puppydogbuddyCommented:
This link has datasets for sale:
http://www.globalmapping.uk.com/data.html
0
 
Painfree888Commented:

Peter,

The download you are thinking of may be found at www.royalmail.com. This is the official source of UK postcode data. Will cost you about 400 pounds (IIRC) for a one time download, but you can sign up for a subscription and get automatic updates, if you choose. The dataset available from Royal Main has approximately 27 million records.

You could, of course, attempt to compile your own dataset, but I wonder if in the end that didn't wind up costing you a bit more than the one you could get ready made from Royal Mail. Then there is a question of how you will keep your home grown datasource up-to-date. Just a thought.

0
 
PeterWhittsAuthor Commented:
Copy and Paste...Copy and Paste...Copy and Paste...Copy and Paste...Copy and Paste...Copy and Paste...
0
 
nico5038Commented:
Another option is to use webservices like http://www.postcodeanywhere.co.uk/ this can be integrated with your Access database to allow your user(s) to obtain the necessary information.

Nic;o)
( Painfree888, check my first comment :-)
0
 
Painfree888Commented:

Nico,

Ooops, I did miss that ;-).
0
 
nico5038Commented:
No problem, happens to me too :-)

Nic;o)
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 4
  • 3
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now