[Phpwm] Cleaning up addresses

[Reuben Pearse]

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 
fast!


-- 
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 
0ED 
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>


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

Subject
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 
encompassed
by that postcode, plus all the adjacent postcodes to that postcode for a
mapping system.
All 27,000 of them!

Phil


_______________________________________________
Phpwm mailing list
Phpwm at mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/phpwm