[Phpwm] Cleaning up addresses

Reuben Pearse reuben.pearse at pslconnect.com
Mon Mar 19 17:24:23 GMT 2007

Hi there,

Were you using the Royal Mail PAF files for that? I did a project 
involving those last year using PHP and MySQL. The data load was a bit of 
a nightmare! Once you get the indexes right the queries come back nice and 

Reuben Pearse
Principal Technical Consultant
reuben.pearse at pslconnect.com
T +44 121 428 4440   F +44 121 428 3454
PSL  The Old Sewing Factory  5a Greenfield Road  Harborne  Birmingham  B17 
Registered in England No 2767006, VAT Registration No GB 614 0984 47

To find out more about our services please visit http://www.pslconnect.com

"Phil Beynon" <phil at infolinkelectronics.co.uk> 
Sent by: phpwm-bounces at mailman.lug.org.uk
19/03/2007 15:55
Please respond to
West Midlands PHP User Group <phpwm at mailman.lug.org.uk>

"West Midlands PHP User Group" <phpwm at mailman.lug.org.uk>

RE: [Phpwm] Cleaning up addresses

> > Welsh addresses are by far the worst! :-)
> I agree
> Try telling people you live in/at the following :
> Heol Tyn-y-Fron,
> Penparcau,
> Aberystwyth
> Ceredigion....
> You quickly learn to spell it ....
> I'm just glad I didn't live in Machynlleth...
> David.
> (previous address of mine)
> --
> David Goodwin
<smile> there's far worse than that, I've built a MySQL database of the
entire UK by primary postcode, with county, city, town, village 
by that postcode, plus all the adjacent postcodes to that postcode for a
mapping system.
All 27,000 of them!


Phpwm mailing list
Phpwm at mailman.lug.org.uk

More information about the Phpwm mailing list