Postal Address from PostCode (1 Viewer)

Andrew Thorpe

Registered User.
Local time
Today, 09:27
Joined
Apr 18, 2009
Messages
59
Is there an add-on program for Access whereby you could type in a UK postcode and it would display the addresses belonging to that postcode?
 

isladogs

MVP / VIP
Local time
Today, 09:27
Joined
Jan 14, 2017
Messages
18,186
I suspect that you'd either have to pay for this data or compile it yourself from various sources such as the Land Registry

However you may find the GetAddress site useful: https://getaddress.io/



You may also be interested in the fully searchable UK postcode database I uploaded yesterday:
https://www.access-programmers.co.uk/forums/showthread.php?t=295233

This uses the freely available UK postcodes dataset from www.doogal.co.uk

NOTE:
If you get a free API key from the GetAddress site, you can download a full list of addresses for a particular postcode in JSON format
There is a limit of 20 API calls per day

In theory you could combine that with the list of postcodes I got from www.doogal.co.uk to get the dataset for the whole country BUT:
a) you'd have to pay for a licence allowing additional downloads - up to 5000 API calls per day
b) it would take forever to download
There are around 2.5 million UK postcodes (not all in use) so at 5000 per day it will take you 500 days .... AND the dataset will be mind boggingly huge

If you do find a freely available data source for what you want, please post the link here :)

UPDATE:
This site may also be useful https://www.hopewiser.com/address-postcode-finder
It offers a similar feature set to GetAddress - a limited number of free downloads then you have to pay.
 

Attachments

  • Capture.jpg
    Capture.jpg
    82.7 KB · Views: 667
Last edited:

isladogs

MVP / VIP
Local time
Today, 09:27
Joined
Jan 14, 2017
Messages
18,186
You might be pleased to know that I have just created a new sample database that does exactly what you were asking for.

You can use it to obtain a full list of postal addresses for selected postcodes.
It does this by downloading the data 'on the fly' from an online site

This is now in the sample databases area: UK Postal Addresses Database

 

Attachments

  • UKPostalAddressesForm.jpg
    UKPostalAddressesForm.jpg
    102.4 KB · Views: 507

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 09:27
Joined
Sep 12, 2006
Messages
15,613
My understanding was that in the UK (unlike the US) the post code database is copyright of the Post Office, which is why you have to pay for these apps.

It's also why Google won't return the exact co-ordinates for a complete UK post code

It's neat of Ridders to provide a solution.
 

Users who are viewing this thread

Top Bottom