Stack Overflow
Stack Overflow

Questions tagged [paf]

Postcode Address File (PAF) is a database of all known UK addresses and postcodes.

Postcode Address File is a database sold and maintained by the Royal Mail containing a list of all UK addresses.

It allows you to quicken your web checkout process with "address auto-fill" by postcode.

12 questions
20
votes
12 answers

How do I match street addresses to UK postcodes?

U.K. sites that require addresses often ask the user to provide a postcode. The site then offers the user a choice between the different addresses that match that postcode. How can I match a postcode to a street address?
ctford
  • 7,189
  • 4
  • 34
  • 51
6
votes
9 answers

Generate google map based on UK postcode

Is it possible to do a google map lookup using the google maps API from a UK postcode? I know you can search by UK postcode on their website, but this converts to lat / long. I don't have access to the PAF database to be able to convert to long /…
Robin Barnes
  • 13,133
  • 15
  • 44
  • 45
4
votes
5 answers

UK Royal Mail PAF address finder via postcode alternatives?

We need an address finder (premise level) based on postcode. We have a budget of 40k for this. But I have been assigned to find some cheaper alternatives for Royal mail PAF database. Is Google any good to find premise level address when you send…
Naren
  • 288
  • 1
  • 3
  • 17
2
votes
1 answer

Format Royal Mail PAF

I'm formatting addresses imported from the Sample Royal Mail PAF to Royal Mail Specification. In the programmer's guide there are two examples with similar fields: Table 8: Building Number in the Building Name field Field on PAF …
Asa Carter
  • 2,207
  • 5
  • 32
  • 62
1
vote
1 answer

Importing PAF file to MySQL

I recently purchased PAF files from the Royal Mail. I've received them all but now need to import the contents into a MySQL database. After taking a look at the files there seems to be no common delimiter or way to determine the individual…
BIOSTALL
  • 1,656
  • 12
  • 25
1
vote
0 answers

Rightmove deliveryPointId does not match up with Royal Mail "CSV PAF.CSV" file

I have obtained a particular property's deliveryPointId from one of their pages. I then tried to match it up with its correct address from the PAF file but find that it matches a property in a completely different part of the country. Surely the RM…
user740360
  • 57
  • 1
  • 1
  • 5
1
vote
0 answers

How to define the number of factors in parallel analysis

I conducted an Exploratory Factor Analysis (Principal Axis Factoring) on my data and wanted to determine the number of factors to extract via. Horn's Parallel Analysis. However I have two problems: The parallel analysis suggests to extract 1…
grafvale
  • 11
  • 1
1
vote
1 answer

Using Royal Mail PAF database or similar to reduce Sagepay code 2001 (Authorisation was Rejected by the vendor rule-base) errors

We've been getting too many errors on our shop with the Sagepay error 2001 (Authorisation was Rejected by the vendor rule-base), failing when the address given by the user doesn't 100% match the address held by the bank. I think the issues has…
Mark Morton
  • 111
  • 4
1
vote
1 answer

How do I look up a UK address based on house number and postcode?

Given a house number and postcode in the UK, how can I translate this into a full mailing address?
Emil Borconi
  • 3,326
  • 2
  • 24
  • 40
1
vote
0 answers

Parsing performance of row data from files to SQL Server database

I have the PAF raw data in several files (list of all addresses in the UK). My goal is to create a PostCode lookup in our software. I have created a new database but there is no need to understand it for the moment. Let's take a file, his extension…
Clement Dungler
  • 737
  • 6
  • 10
0
votes
3 answers

PAF database vs a service such as Postcode Anywhere

Would it be more cost effective for a small business (around 25 concurrent users) to buy a PAF database and code it up ourselves or use a Postcode service such as Postcode Anywhere? The Royal Mail site is really confusing!…
JMK
  • 27,273
  • 52
  • 163
  • 280
0
votes
3 answers

Import paf using php

I’m working with the royal mail PAF database in csv format (approx 29 million lines), and need to split the data into sql server using php. Can anyone recommend the best method for this to prevent timeout? Here is a sample of the data:…
Sofia Rose
  • 203
  • 2
  • 8