Solved

address lookup from postcode

Posted on 2013-11-06
6
408 Views
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 asp.net 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

David
0
Comment
Question by:CEL_IT
6 Comments
 
LVL 45

Expert Comment

by:aikimark
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.
0
 
LVL 23

Expert Comment

by:Jens Fiederer
ID: 39629127
0
 

Author Comment

by:CEL_IT
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??

Cheers

David
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 62

Expert Comment

by:☠ MASQ ☠
ID: 39636891
David
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.
0
 

Accepted Solution

by:
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 vb.net, 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.

Cheers
0
 

Author Closing Comment

by:CEL_IT
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.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
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…

758 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