[Phpwm] Cleaning up addresses

Phil Beynon phil at infolinkelectronics.co.uk
Tue Mar 20 10:20:50 GMT 2007


Hi,
We had the Royal Mail list for the area file, but the rest had to be done
manually - 4 girls, a bunch of maps, and highlighter pens! :-)

Phil

> 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
>
> > > 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
>
> _______________________________________________
> Phpwm mailing list
> Phpwm at mailman.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/phpwm
>




More information about the Phpwm mailing list