[Phpwm] Cleaning up addresses

[Dave Holmes]

I really must be missing something here Phil when you say adjacent postcodes
are you using this / were using this to work out the nearest location of a
relevant resource or service... i.e. you nearest shop is in postcode XYZ

I just be interested to know what the problem was you put the solution in
for as it still seems overly complicated

-----Original Message-----
From: phpwm-bounces at mailman.lug.org.uk
[mailto:phpwm-bounces at mailman.lug.org.uk] On Behalf Of Phil Beynon
Sent: 20 March 2007 10:18
To: West Midlands PHP User Group
Subject: RE: [Phpwm] Cleaning up addresses

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
>


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