List of London Areas

PHP
1

Hi Guys,

Any UK guys here have a list of London areas along with their postcodes is mysql format? Would save me loads and loads of data entry?

Excuse me for posting it here :blush:

Thanks

2

You didn’t look very far :slight_smile:

A quick search for “london postcodes” revealed the basic data - http://www.milesfaster.co.uk/london-postcodes-list.htm

Create a CSV from that text and import into your database…

3

Thank you, but I already seen that and other like it. Creating a csv out of it is cumbersome, so I though someone here might already have something.

4

How about this, uses pipes as the delimeter

E1|Whitechapel, Stepney, Mile End
SE1|Waterloo, Bermondsey, Southwark, Borough
E2|Bethnal Green, Shoreditch
SE2|Abbey Wood
E3|Bow, Bromley-by-Bow
SE3|Blackheath, Westcombe Park
E4|Chingford, Highams Park
SE4|Brockley, Crofton Park, Honor Oak Park
E5|Clapton
SE5|Camberwell
E6|East Ham
SE6|Catford, Hither Green, Bellingham
E7|Forest Gate, Upton Park
SE7|Charlton
E8|Hackney, Dalston
SE8|Deptford
E9|Hackney, Homerton
SE9|Eltham, Mottingham
E10|Leyton
SE10|Greenwich
E11|Leytonstone
SE11|Lambeth
E12|Manor Park
SE12|Lee, Grove Park
E13|Plaistow
SE13|Lewisham, Hither Green
E14|Poplar, Millwall, Isle of Dogs, Docklands
SE14|New Cross, New Cross Gate
E15|Stratford, West Ham
SE15|Peckham, Nunhead
E16|Canning Town, North Woolwich, Docklands
SE16|Rotherhithe, South Bermonsey, Surrey Docks
E17|Walthamstow
SE17|Walworth, Elephant & Castle
E18|South Woodford
SE18|Woolwich, Plumstead
SE19|Upper Norwood, Crystal Palace
WC1|Bloomsbury, Gray’s Inn
SE20|Penge, Anerley
WC2|Covent Garden, Holborn, Strand
SE21|Dulwich
SE22|East Dulwich
EC1|Clerkenwell, Finsbury, Barbican
SE23|Forest Hill
EC2|Moorgate, Liverpool Street
SE24|Herne Hill
EC3|Monument, Tower Hill, Aldgate
SE25|South Norwood
EC4|Fleet Street, St. Paul’s
SE26|Sydenham
SE27|West Norwood, Tulse Hill
N1|Islington, Barnsbury, Canonbury
SE28|Thamesmead
N2|East Finchley
N3|Finchley Central
SW1|Westminster, Belgravia, Pimlico
N4|Finsbury Park, Manor House
SW2|Brixton, Streatham Hill
N5|Highbury
SW3|Chelsea, Brompton
N6|Highgate
SW4|Clapham
N7|Holloway
SW5|Earl’s Court
N8|Hornsey, Crouch End
SW6|Fulham, Parson’s Green
N9|Lower Edmonton
SW7|South Kensington
N10|Muswell Hill
SW8|South Lambeth, Nine Elms
N11|Friern Barnet, New Southgate
SW9|Stockwell, Brixton
N12|North Finchley, Woodside Park
SW10|West Brompton, World’s End
N13|Palmers Green
SW11|Battersea, Clapham Junction
N14|Southgate
SW12|Balham
N15|Seven Sisters
SW13|Barnes, Castelnau
N16|Stoke Newington, Stamford Hill
SW14|Mortlake, East Sheen
N17|Tottenham
SW15|Putney, Roehampton
N18|Upper Edmonton
SW16|Streatham, Norbury
N19|Archway, Tufnell Park
SW17|Tooting
N20|Whetstone, Totteridge
SW18|Wandsworth, Earlsfield
N21|Winchmore Hill
SW19|Wimbledon, Merton
N22|Wood Green, Alexandra Palace
SW20|South Wimbledon, Raynes Park
NW1|Regent’s Park, Camden Town
W1|Mayfair, Marylebone, Soho
NW2|Cricklewood, Neasden
W2|Bayswater, Paddington
NW3|Hampstead, Swiss Cottage
W3|Acton
NW4|Hendon, Brent Cross
W4|Chiswick
NW5|Kentish Town
W5|Ealing
NW6|West Hampstead, Kilburn, Queens Park
W6|Hammersmith
NW7|Mill Hill
W7|Hanwell
NW8|St John’s Wood
W8|Kensington
NW9|Kinsbury, Colindale
W9|Maida Vale, Warwick Avenue
NW10|Willesden, Harlesden, Kensal Green
W10|Ladbroke Grove, North Kensington
NW11|Golders Green, Hampstead Gdn Suburb
W11|Notting Hill, Holland Park
W12|Shepherd’s Bush
W13|West Ealing
W14|West Kensington

5

yeah I can work with this :slight_smile: thank you