SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Evangelist
    Join Date
    Apr 2005
    Location
    London, UK
    Posts
    506
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    List of London Areas

    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

    Thanks

  2. #2
    SitePoint Wizard bronze trophy bluedreamer's Avatar
    Join Date
    Jul 2005
    Location
    Middle England
    Posts
    3,349
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    You didn't look very far

    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. #3
    SitePoint Evangelist
    Join Date
    Apr 2005
    Location
    London, UK
    Posts
    506
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by bluedreamer View Post
    You didn't look very far

    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...
    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. #4
    SitePoint Wizard bronze trophy bluedreamer's Avatar
    Join Date
    Jul 2005
    Location
    Middle England
    Posts
    3,349
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    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. #5
    SitePoint Evangelist
    Join Date
    Apr 2005
    Location
    London, UK
    Posts
    506
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yeah I can work with this thank you


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •