address lookup from postcode

Posted on 2013-11-06
Last Modified: 2013-11-30
Hi all,

I have been tasked with pulling address information into my till software from a postcode lookup.

I have been looking at the various types and offers out there and wanted to know which is best to interact from bespoke software.

I understand it will cost the company money and I want to get the best results for the least work but want to go down the more official route with house numbers and property names.

There are a few on the market but a lot seem to be either driven and price per lookup, or single computer license based in winforms, but I don't know how you then implement that into the software as it seems to be a program call rather than coding it into one of your forms.

Ideally I would like a solution that I could eventually roll out to the website when it is re-written (deadline march 2014), but right now I have a retail show I need to take my working till software in 2 weeks.... so the quicker the better, but ideally I would want to have it within my coding from form.

If I have to look at pricing per machine does anyone have an idea on pricing and what provider has the best interaction.

If we can go down a web service route calling from the application this would be probably the ideal solution if we could get this either on a per lookup or per month basis.

I have spent a few days looking into this and don't want to invest a lot of time on testing each possible solution as this will be a waste of development when I need to concentrate on passing the order data back to the office!!

Any input is appreciated, also any pointers to companies that you may have worked with personally would be good reflection for my next step.

Thank You

Question by:CEL_IT
LVL 45

Expert Comment

ID: 39629069
Have you looked at the USPS offering?  They are very reliable.  Depending on the volume of look-ups you need to do and the response time, they should be among your finalists.
LVL 23

Expert Comment

by:Jens Fiederer
ID: 39629127

Author Comment

ID: 39630502
Don't think I made the point that I am looking for UK based addresses.

I have been testing with PAF raw data and Data8 web service.

PAF seems quite good but is expensive, data8 again are good and just trying to speak it through with the boss.

He has just thrown a cat among the pigeons though.... does anywhere do postcode lookup with names of occupants??


DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

LVL 62

Expert Comment

by:☠ MASQ ☠
ID: 39636891
We use QAS Pro from Experian and have been for about 10 yrs as they have pretty good support and APIs for bespoke look-up links to their DB.
It's pretty much a PAF DB though although somehow we end up paying less for the licensing that if we had got through Royal Mail - doesn't use the public electoral roll data for resident names though.

Accepted Solution

CEL_IT earned 0 total points
ID: 39674316
We ended up going with Royal Mail PAF CSV Raw Data.

The plan was to create our own lookup.

29 million records, indexed on Postcode on a local sql2012 express database, worked a treat through a stored procedure and was basically instant.

We are just us8ing on a stand alone system, but if you do want to use on a website it gets very expensive!!!

The file was obviously vary large and I initially struggled to get the data out, and had to work out how to pull the data from the file in, but got there after a couple of hours using a parser.

It took about 8 hours to import the data using my tool. I thought about importing it in sql direct, after I had already started the process... think it would have been much quicker to read in using a sproc of some kind, but I was already on my way before hand. If I want to create an ongoing annual import then I will look into it.


Author Closing Comment

ID: 39686563
This was a more suggestive question asking for advice on postal references.

I ended up going with the solution I had initially looked into.

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Authentication of Web Services 3 46
Angular JS Route 3 45
consuming an asmx web service in winforms application 3 24
.Net Web Site IIS Web.Config Content-Security-Policy 1 36
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now