-- MySQL dump 10.13 Distrib 5.5.22, for debian-linux-gnu (i686)
--
-- Host: localhost Database: walks
-- ------------------------------------------------------
-- Server version 5.5.22-0ubuntu1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Dumping data for table `vw_advert`
--
LOCK TABLES `vw_advert` WRITE;
/*!40000 ALTER TABLE `vw_advert` DISABLE KEYS */;
INSERT IGNORE INTO `vw_advert` VALUES (1,'http://www.vintage-walks.co.uk'),(2,'http://www.vintage-walks.co.uk'),(3,'http://www.vintage-walks.co.uk'),(4,'http://www.vintage-walks.co.uk'),(5,'http://www.vintage-walks.co.uk');
/*!40000 ALTER TABLE `vw_advert` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_comment`
--
LOCK TABLES `vw_comment` WRITE;
/*!40000 ALTER TABLE `vw_comment` DISABLE KEYS */;
INSERT IGNORE INTO `vw_comment` VALUES (5,'Will Tinsdeall','test@email.com','','My test comment',0,0),(7,'Will Tinsdeall','test@email.com','','My test comment',0,0),(8,'Will Tinsdeall','test@email.com','ivebeenlinuxed','My test comment',0,0),(9,'Will Tinsdeall','test@email.com','ivebeenlinuxed','My test comment',0,0),(11,'Will Tinsdeall','will@bcslichfield.com','ivebeenlinuxedtoo','A test comment 2',0,1);
/*!40000 ALTER TABLE `vw_comment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_geo_asset`
--
LOCK TABLES `vw_geo_asset` WRITE;
/*!40000 ALTER TABLE `vw_geo_asset` DISABLE KEYS */;
INSERT IGNORE INTO `vw_geo_asset` VALUES (14,'The Lamb',51.5230125,-0.118953799999986,'<strong>The Lamb</strong>\r\n<p>94 Lambs Conduit Street, Bloomsbury, London. WC1N 3LZ<br /></p>\r\n<p>020 7405 0713</p>\r\n<p>“Beautifully preserved Grade II listed Victorian pub and former haunt of the Bloomsbury Group”</p>',1),(15,'The Riverside bookshop',51.5058928,-0.0835336000000098,'<strong>The Riverside bookshop</strong>\r\n<p>Hays Galleria</p>\r\n<p>Counter Street, Bermondsey</p>\r\n<p>London, SE1 2HD</p>\r\n<p>020 7378 1824</p>\r\n<p>An independent bookshop which has been based in the Hay\'s Galleria for 24 years</p>',0),(16,'Tate Modern bookshop',51.5074672,-0.100154699999962,'<strong>The Tate Modern bookshop</strong>\r\n<p>Park Street</p>\r\n<p>Bankside, London SE1 9TG</p>\r\n<p>020 7887 8888</p>\r\n<p>Two shops within the Tate Modern sell books connected with the Tate\'s current exhibitions, together with books about the local area.</p>',0),(19,'Borough Market',51.5050824,-0.09008080000000969,'<strong>Borough Market</strong>\r\n<p>8 Southwark Street, London SE1 1TL</p>\r\n<p>020 7407 1002</p>\r\n<p>London\'s most renowned food market; a source of exceptional British and international produce</p>',1),(20,'The Swan at the Globe',51.5081109,-0.0965972999999849,'<p><strong>The Swan at the Globe</strong></p>\r\n<p>21 New Globe Walk, London SE1 9DT</p>\r\n<p>020 7928 9444</p>\r\n<p>A brassiere and bar offering modern British menus, wines, ales and cocktails, together with unsurpassed views across the Thames to St Paul\'s Cathedral</p>',1),(21,'Hatchards',51.5084064,-0.13797210000007,'<strong>Hatchards</strong></p>\r\n<p>187 Piccadilly, London, W1J 9LE</p>\r\n<p>Telephone: 020 7439 9921</p>\r\n<p>Booksellers since 1767, Hatchard\'s is London\'s oldest surviving bookshop</p>',0),(23,'The Inn in the Park',51.5030683,-0.130279299999984,'<strong>The Inn in the Park</strong>\r\n<p>Inn the Park, St James\'s Park, London SW1A 2BJ</p>\r\n<p>020 7451 9999</p>\r\n<p>Nestled in the midst of St James\'s Park, the Inn in the Park is a tranquil spot for food and drink</p>',1),(27,'London Review Bookshop',51.5185624,-0.124081100000012,'<strong>London Review Bookshop</strong></p>\r\n<p>14 Bury Place, London WC1A 2JL</span></p>\r\n<p>020 7269 9030</p>\r\n<p>Dedicated to providing a space for the widest range of titles for hungry minds</p>',0),(28,'Gay\'s the Word',51.5253871,-0.125170099999991,'<strong>Gay’s the Word</strong></p>\r\n<p>66 Marchmont St<br />London WC1N 1AB</p>\r\n<p>020 7278 7654</p>\r\n<p>“The UK\'s pioneering first (and is today the last surviving) lesbian and gay bookshop”</p>',0),(29,'Bookmarks: The Socialist Bookshop',51.517168,-0.12742460000004,'<strong>Bookmarks: The Socialist Bookshop</strong>\r\n<p>1 Bloomsbury St<br />London WC1B 3QE</p>\r\n<p>020 7637 1848</p>\r\n<p>“An independent socialist bookshop”</p>',0),(30,'The Lamb Bookshop',51.5214963,-0.11805049999998099,'<strong>The Lamb Bookshop</strong>\r\n<p>40 Lambs Conduit Street<br />London WC1N 3LJ</p>\r\n<p>020 7405 6536</p>\r\n<p>“Specialising in hand-selected unusual and quirky books”</p>',0),(31,'Foyles ',51.5146682,-0.13025110000001,'<strong>Foyles </strong>\r\n<p>113-119 Charing Cross Road, London WC2H OEB</p>\r\n<p>020 7437 5660</p>\r\n<p>“Flagship store of Britain\'s largest independent bookshop chain”</p>',0),(32,'Gosh! Comics',51.5177994,-0.12698069999999,'<strong>Gosh! Comics</strong>\r\n<p>39 Great Russell Street London WC1B 3NZ</p>\r\n<p>020 7636 1011</p>\r\n<p>“Remains London\'s must-visit store for those who love the medium”</p>',0),(35,'',51.5082147,-0.139509800000042,'<p><strong>Fortnum and Mason</strong></p>\r\n<p class=\"p1\">181 Piccadilly, London W1A 1ER, United Kingdom</p>\r\n<p class=\"p1\">0845 300 1707</p>\r\n<p class=\"p1\">Established in 1797, Fortnum and Mason is one of Britain\'s most iconic department stores and is also home to a celebrated restaurant and café.</p>',0),(36,'Waterstone\'s',51.5089594,-0.135989699999982,'<p><span class=\"Apple-style-span\" style=\"font-family: Arial; font-size: 13px;\"><strong>Waterstone\'s</strong></span></p>\r\n<p style=\"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial; min-height: 15.0px;\">203/206 Piccadilly, London W1J 9HD<strong></strong></p>\r\n<p style=\"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial;\">Tel:<strong> </strong>0843 290 8549</p>\r\n<p style=\"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial;\"> </p>\r\n<p style=\"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial;\"><span class=\"Apple-style-span\" style=\"font-family: sans-serif; font-size: 15px;\">Waterstone\'s Piccadilly is Europe\'s largest bookshop. On the 5th floor is a cocktail lounge and café.</span></p>\r\n<p style=\"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Arial; min-height: 15.0px;\"> </p>',0);
/*!40000 ALTER TABLE `vw_geo_asset` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_media`
--
LOCK TABLES `vw_media` WRITE;
/*!40000 ALTER TABLE `vw_media` DISABLE KEYS */;
INSERT IGNORE INTO `vw_media` VALUES (86,'Shakespeare\'s Sonnet LXXIII',2,'http://www.vintage-books.co.uk/books/0099518864/william-shakespeare/sonnets/',1,0),(87,'And the people who lived there...',2,'http://www.vintage-books.co.uk/books/1844130940/gillian-tindall/the-house-by-the-thames-and-the-people-who-lived-there/',1,0),(88,'A reading from Little Dorrit',2,'http://www.vintage-books.co.uk/books/0099529440/charles-dickens/little-dorrit/',1,0),(89,'The Great Fire of London',2,'http://www.vintage-books.co.uk/books/0712668470/adrian-tinniswood/by-permission-of-heaven-the-story-of-the-great-fire-of-london/',1,0),(90,'A reading from Oliver Twist',2,'http://www.vintage-books.co.uk/books/0099511932/charles-dickens/oliver-twist/',1,0),(91,'What Words Can Really Do',3,'http://www.vintage-books.co.uk/books/0099458284/sebastian-faulks/a-week-in-december/',1,0),(92,'Introducing Shakespeare\'s Sonnets',3,'http://www.vintage-books.co.uk/books/0099518864/william-shakespeare/sonnets/',1,0),(93,'Thames, Sacred River',3,'http://www.vintage-books.co.uk/books/0099422557/peter-ackroyd/thames-sacred-river/',1,0),(95,'A reading from I Capture the Castle',2,'http://www.vintage-books.co.uk/books/0099460874/dodie-smith/i-capture-the-castle/',1,0),(96,'A reading from Mrs Dalloway',2,'http://www.vintage-books.co.uk/books/0099541335/virginia-woolf/mrs-dalloway-s-party-a-short-story-sequence/',1,0),(97,'From Peter Ackroyd\'s London',3,'http://www.vintage-books.co.uk/books/0099422581/peter-ackroyd/london-the-biography/',1,0),(98,'From The Perfect Picnic',3,'http://www.vintage-books.co.uk/books/0224086782/hilda-leyel/the-perfect-picnic/',1,0),(99,'Composed on Westminster Bridge',3,'',1,0),(100,'Virginia Woolf slideshow',0,'http://www.vintage-books.co.uk/authors/269592/virginia-woolf/',1,0),(101,'Jenny Uglow on Virginia Woolf',2,'',1,0),(103,'Ruth Padel on Darwin',2,'http://www.vintage-books.co.uk/books/0099547058/ruth-padel/darwin-a-life-in-poems/',1,0),(104,'Jonathan Keates on Handel',3,'http://www.vintage-books.co.uk/books/1845951158/jonathan-keates/handel-the-man-his-music/',1,0),(105,'A reading from Peter Pan',2,'http://www.vintage-books.co.uk/books/0099511797/james-matthew-barrie/peter-pan/',1,0),(106,'Recommended Reading, Possession by AS Byatt',0,'http://www.vintage-books.co.uk/books/0099800403/a-s-byatt/possession-a-romance/',1,0),(107,'Tavistock Square slideshow',0,'',1,0),(109,'Near Great Ormond Street',0,'',1,0),(110,'On the Origin of Species',3,'http://www.vintage-books.co.uk/books/0099519178/charles-darwin/the-origin-of-species-and-the-voyage-of-the-beagle/',1,0),(111,'Bloomsbury bookshops',0,'',1,0),(112,'From the Casebook of Sherlock Holmes',3,'http://www.vintage-books.co.uk/books/0099529939/arthur-conan-doyle/the-complete-sherlock-holmes/',1,0),(113,'Handel\'s Foundling Anthem',2,'',1,0),(117,'Hermione Lee on Virginia Woolf',3,'http://www.vintage-books.co.uk/books/0099732513/hermione-lee/virginia-woolf/',1,0),(118,'Composed on Westminster Bridge',3,'',1,0),(119,'Suggested Reading, On the Origin of Species',3,'http://www.vintage-books.co.uk/books/0099519178/charles-darwin/the-origin-of-species-and-the-voyage-of-the-beagle/',1,0),(340,'The British Museum is Falling Down read by David Lodge',1,'http://www.vintage-books.co.uk/books/0099554224/david-lodge/the-british-museum-is-falling-down/',1,0),(341,'David Lodge on Henry James',1,'http://www.vintage-books.co.uk/books/1846550033/david-lodge/the-year-of-henry-james-the-story-of-a-novel-with-other-essays-on-the-genesis-composition-and-reception-of-literary-fiction/',1,0),(344,'Anthony Quinn on St Georges Church',1,'',1,0),(347,'Recommended Read, Little Dorrit by Charles Dickens',0,'',1,0),(348,'I Capture the Castle',0,'',1,0),(349,'I Capture the castle',0,'',1,0),(352,'Bright Star',0,'',1,0),(353,'Oli Harris audio',2,'',1,0),(354,'Mrs Dalloway',0,'',1,0);
/*!40000 ALTER TABLE `vw_media` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_media_file`
--
LOCK TABLES `vw_media_file` WRITE;
/*!40000 ALTER TABLE `vw_media_file` DISABLE KEYS */;
INSERT IGNORE INTO `vw_media_file` VALUES (107,'A reading of Sonnet LXXIII',86),(108,'By closely examining the history of one house, Gillian Tindall tells the story of Southwark and the south bank, the river Thames and indeed of London itself.',87),(109,'St George the Martyr in Borough is the setting for Little Dorrit\'s marriage. There is a small representation of her in the east window of the church.',88),(110,'Adrian Tinniswood, author of By Permission of Heaven on his thrilling account of one of the most dramatic moments in English history - The Great Fire of London.',89),(111,'Dickens masterful depiction of the London Underworld',90),(112,'',91),(113,'',92),(114,'',93),(116,'From Dodie Smith\'s enchanting novel about the growing up of Cassandra Mortmain.',95),(117,'A day in the life of Clarissa Dalloway - a short audio reading',96),(118,'',97),(119,'',98),(120,'',99),(121,'Virginia Woolf by Gisele Freund, 1939',100),(122,'Note by Virginia Woolf on a dinner party with Yeats and Lytton Strachey',100),(123,'Hogarth House, where Leonard and Virginia Woolf lived and worked',100),(124,'',100),(128,'Jenny Uglow talks about Virginia Woolf and Hogarth Press',101),(130,'Ruth Padel reads two of her poems about Darwin\'s time in London: Notebook B & On the Propagation of Mistletoe ',103),(131,'',104),(132,'JM Barrie\'s much loved children\'s book, which continues to support the Great Ormond Street Hospital through its royalties',105),(133,'Possession is an exhilarating novel, at once a literary detective novel and a touching love story. A pair of young scholars investigate the lives of two Victorian poets. The Booker prize-winning novel opens in the British Museum. ',106),(134,'The Tavistock Hotel stands on the site that was once the home of Virginia and Leonard Woolf',107),(135,'The original building that housed the Hogarth Press before it was destroyed by a bomb in World War II',107),(136,'The memorial to Virginia Woolf',107),(137,'The memorial to Mahatma Ghandi',107),(138,'A cherry planted in memory of the victims of Hiroshima',107),(139,'Great Ormond Street Hospital was founded in 1842 as the first hospital specifically for children',109),(140,'The People\'s Supermarket is a sustainable food co-operative run by local residents',109),(141,'Persephone Books reprints neglected classics from the Twentieth Century',109),(142,'The Lamb is a beautifully preserved, Grade II listed Victorian pub',109),(143,'A street named after one of Dickens\' best loved characters',109),(144,'',110),(145,'The London Review Bookshop opened in Bloomsbury in May 2003. It is now one of the most distinctive independent bookshops in London. ',111),(146,'It also sells tea, coffee and cakes',111),(147,'With a 24-year track record in the industry and enthusiastic, knowledgeable staff, Gosh! Comics remains London\'s must-visit store for those who love the medium.',111),(148,'',112),(149,'The Foundling Hospital Anthem was Handel\'s first performance to raise money for the Hospital. There were more than a hundred performers and an audience of a thousand, including the Prince of Wales.',113),(155,'',117),(156,'',118),(157,'',119),(162,'The British Museum is Falling Down is a brilliant comic satire of academia, religion and human entanglements.',340),(163,'The Year of Henry James: The story of a novel: With other essays on the genesis, composition and reception of literary fiction',341),(164,'Antony Quinn’s latest novel half the Human Race is available from Jonathan Cape',344),(167,'‘Thirty years ago there stood…in the borough of Southwark … the Marshalsea Prison. It had stood there many years before, and it remained there some years afterwards; but it is gone now, and the world is none the worse without it.\' ',347),(168,'A wonderful story of an eccentric family.',348),(169,'I Capture the castle..',349),(172,'Bright Star',352),(173,'Oliver Harris talks about blah bah blah',353),(174,'',354);
/*!40000 ALTER TABLE `vw_media_file` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_point`
--
LOCK TABLES `vw_point` WRITE;
/*!40000 ALTER TABLE `vw_point` DISABLE KEYS */;
INSERT IGNORE INTO `vw_point` VALUES (1,'Test title',52.6787,-1.83469,'<p>This is a <strong>test point 123</strong></p>',0,0,1,0,1),(12,'Tate Modern/ The Millenium Bridge',51.5081,-0.100286,'<p>The Tate Modern, which is based in the former Bankside Power Station, is the most visited modern-art gallery in the world. The station was commissioned following a power shortage in 1947 – the chimney’s height was limited to less than the spire of St Paul’s Cathedral, which sits on the opposite bank – and generated electricity from 1952 to 1981, but has been a museum since 2000. The bar on the top floor offers views across the river to St Paul’s.</p>\r\n<p>Outside the Tate Modern stands the Millennium Bridge, which was originally opened in 2000 but was closed after only two days, for two years worth of repairs. The bridge was used as the location for the photoshoot for the Vintage paperback jacket for Sebastian Faulks’ <em>A Week in December</em>.</p>',0,0,1,1,1),(13,'The Globe and the House by the Thames',51.5081,-0.0982482,'<p>A few minutes walk from the Globe theatre stands 49 Bankside – <a href=\"http://www.vintage-books.co.uk/books/1844130940/gillian-tindall/the-house-by-the-thames-and-the-people-who-lived-there/\">The House by the Thames</a> – which was built in 1710 on the foundations of a pub called the Cardinal’s Hat. Although the plaque on the outside of the house claims that Sir Christopher Wren lived there during the building of St Paul’s Cathedral, the house was built in the same year that the cathedral was completed, making it unlikely that Wren could have stayed on the site to watch his masterpiece take shape across the river, but the presence of the plaque is likely to have saved the house from being torn down, and the site redeveloped, after the war.</p>\r\n<p class=\"p1\"><span class=\"s1\">The Globe Theatre is a reconstruction of the original open air playhouse that was originally built in 1599 by Shakespeare’s playing company, The Lord Chamberlain’s Men. The Globe was constructed using timber from an earlier theatre, The Theatre in Shoreditch; after a dispute over the lease of the land on which the theatre stood, the company leased a plot of land on the other side of the river, dismantled the theatre beam by beam and carried the timber across the river to the new site. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">The original Globe theatre was destroyed by fire on the 29 June, 1613 after wadding from a stage cannon ignited the thatched roof during a performance of Henry VIII. The theatre was quickly rebuilt – this time with a tiled roof – but, like all the other theatres in London, was closed down by the Puritans in 1642. It was demolished to make room for tenements in 1644.</span></p>\r\n<p class=\"p1\"><span class=\"s1\">The current Shakespeare’s Globe opened in 1997 with a production of Henry V, and was built approximately 230 metres (750 ft) from the site of the original theatre. The American actor, director and producer Sam Wanamaker founded the Shakespeare’s Globe Trust in 1970 with the objective of building a faithful recreation of Shakespeare’s Globe close to its original Bankside location but died in 1993, at which point the site had been secured, the exhibition undercroft was structurally complete and a few timber bays of the theatre were in place.</span></p>',0,0,1,1,1),(14,'Southwark Cathedral/ London Bridge',51.5061,-0.0897733,'<p>Southwark Cathedral has been a place of worship for over a thousand years – the first written reference to it is the mention of a \'minster\' in the Domesday Book in 1068 – although it only became a cathedral in 1905. William Shakespeare buried his brother, Edmund, here in 1607: the grave is unmarked, but there is a commemorative stone in the paving of the choir which was placed there at a later date. The Cathedral also contains a large 19th century stained glass window dedicated to Shakespeare, depicting scenes from all of his plays, at the base of which is a statue of a reclining William Shakespeare holding a quill. </p>\r\n<p>A ten minute stroll from Southwark Cathedral – longer if you call into Borough Market on your way for some reviving food and drink – lies the church of St George the Martyr where the eponymous heroine of Charles Dickens’ <em>Little Dorrit</em> marries: there is a small representation of her in the east window of the church. Dickens’ father was imprisoned for debt in the Marshalsea prison and the surviving wall of the prison adjoins the north side of the churchyard. Little Dorrit Court and Little Dorrit Playground can be seen on your right as you walk down to the church along Borough High Street. On the way back up from the church towards London Bridge you pass by Talbot Yard, which was once home to The Tabard – the inn in which Chaucer’s pilgrims first meet on their journey to Canterbury.</p>',0,0,1,1,1),(16,'London Bridge/ Monument',51.5102,-0.0859246,'<p>A bridge has existed on the same site for at least the past two thousand years: the first bridge across the Thames was built by the Romans in around 50 AD and was made of wood. The southern gatehouse of a later incarnation of the bridge, the Stone Gateway, became notorious as the site where traitor’s heads were displayed, dipped in tar to preserve them against the elements and then impaled on spikes. The first head displayed was that of William Wallace in 1305 and the practice continued for another 350 years until it was stopped by Charles II, following his restoration to the throne. A stone bridge was opened in 1831 to replace the crumbling 600 year old stone bridge, and it is likely that it was this bridge on which Nancy met Mr Brownlow and Rose Maylie in <em>Oliver Twist</em>, and which Pip walked over in despair after discovering that Estella was engaged to marry Bentley Drummle in <em>Great Expectations</em>. In 1896, it was estimated that the bridge was the busiest point in London, with 8,000 people crossing the bridge by foot and 900 crossing in vehicles every hour. The current London Bridge was opened in 1973 and the steps on the west side of the bridge are known as Nancy’s Steps after the character in <em>Oliver Twist</em>. </p>\r\n<p class=\"p1\"><span class=\"s1\">Feeling inspired by all these literary connections? Before you cross over the river to our final stop, why not cross over the bridge towards London Bridge station, walk down Tooley Street and take the third road on your left, Hay’s Lane, where you’ll find Hays Galleria – home to the independent bookshop, Riverside Bookshop. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">Across the bridge, on the other side of the river,</span><span class=\"s1\">stands the Monument to the Great Fire of London</span><span class=\"s2\">. It was built between 1671 and 1677 and</span><span class=\"s1\"> stands at the junction of Monument Street and Fish Street Hill; another monument, the Golden Boy of Pye Corner, marks the point near Smithfield where the fire stopped. The Monument is 61 metres high (202 feet) – the exact distance between it and the site in Pudding Lane where the fire began. </span><span class=\"s2\">Charles Dickens described the appearance of the Monument in <em>Martin Chuzzlewit</em>:</span></p>\r\n<p class=\"p1\"><span class=\"s2\">‘If the day were bright, you observed upon the house–tops, stretching far away, a long dark path; the shadow of the Monument; and turning round, the tall original was close beside you, with every hair erect upon his golden head, as if the doings of the city frightened him.’</span></p>',0,0,1,1,1),(18,'Piccadilly',51.5092,-0.136805,'<p>Piccadilly was originally known as Portugal Street; it is believed that its new name, the name we use to this day, arose as a result of the success of a tailor called Robert Baker, who owned a shop on the Strand at the end of the sixteenth century. Baker amassed a considerable fortune through making and then selling <em>piccadills</em>, which were stiff collars with scalloped edges and a lace border, and went on to buy what was then open countryside to the west of London, where he built a large mansion which soon became known as Piccadilly Hall. Charles Dickens Junior, son of the famous author, described the road as: \'the great thoroughfare leading from the Haymarket and Regent-street westward to Hyde Park-corner, [it] is the nearest approach to the Parisian boulevard of which London can boast.\'</p>\r\n<p class=\"p1\"><span class=\"s1\">As one of the richest and most famous streets in London, Piccadilly unsurprisingly has a strong literary heritage: in Bram Stoker\'s novel, <em>Dracula</em>, the count owns a house in Piccadilly and P. G. Wodehouse’s charming hero, Bertie Wooster lived just off Piccadilly, in Half Moon Street, and his club, the Drones Club, was based in Dover Street, while Margery Allingham\'s detective Albert Campion lived in a flat on Piccadilly.</span></p>\r\n<p class=\"p1\"><span class=\"s1\">Luxury department store Fortnum and Mason, which was opened in 1707, is a useful place to stop and browse for ingredients for a picnic to enjoy later in St James’s Park, before moving on to browse through Hatchards, London\'s oldest surviving bookshop. Booksellers since 1797, Hatchards\' customers have included the great and the good, from Prime Minister Benjamin Disraeli to writer Rudyard Kipling, and the shop is a must-visit for any book-lover. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">A few minutes walk away from Hatchards sits St James’ Church, which was consecrated on 13 July, 1684 and is said to be the favourite church of its architect, Sir Christopher Wren. Carvings by acclaimed sculptor and wood carver, Grinling Gibbons can be seen on the altar and the organ, and Gibbons also carved the font of the church, in which the poet William Blake was baptised.</span></p>\r\n<p class=\"p2\"><span class=\"s1\">Piccadilly was also once home to Simpsons of Piccadilly, a quality clothing store which first opened for business in April 1936: when it opened, it claimed to be the largest menswear store in London, and possibly even the world. For Simpson\'s opening day, designer Laszlo Moholy-Nagy, a Hungarian refugee from Nazi Germany, furnished the fifth floor with three full-sized aircraft as part of an in-store aviation theme. The building was sold to the Waterstone\'s chain of booksellers in 1999, and it is now their flagship store and the largest book store in Europe. The bar on the fifth floor 5</span><span class=\"s2\"><sup>th</sup></span><span class=\"s1\"> View offers visitors views across London towards Big Ben and Westminster Abbey, the last stop on our walk. </span></p>\r\n<p class=\"p2\"><span class=\"s1\">If you were to carry on down Piccadilly, beyond Waterstones, you would reach Piccadilly Circus, home to what is popularly known as the Eros Statue, although it is actually a statue of his brother Anteros, The God of Selfless Love, which was erected in memory of the Victorian philanthropist Lord Shaftesbury. The Criterion Theatre, on Piccadilly Circus, is where John Watson first heard of Sherlock Holmes, while the Café Royal on nearby Regent Street is where Holmes was attacked in ‘The Adventure of the Illustrious Client’</span></p>',0,0,1,1,1),(19,'St James\'s Square and St James\'s Park',51.507,-0.135749,'<p>St James\' Square Gardens, to the south of Piccadilly, is home to the London Library, the world’s largest independent lending library. The Library was founded in 1841by Thomas Carlyle and briefly occupied the first floor of the Traveller’s Club in Pall Mall, before moving to its current home in 1845. Past presidents and vice-presidents of the Library include Rudyard Kipling, Tennyson, T. S. Eliot and Isaiah Berlin and the Library’s current president is Tom Stoppard. AS Byatt’s Booker prize-winning novel, <em>Possession</em> opens in the London Library:</p>\r\n<p class=\"p1\"><span class=\"s1\">‘The London Library was Roland’s favourite place. It was shabby but civilised, alive with history but inhabited also by living poets and thinkers who could be found squatting on the slotted metal floor of the stacks, or arguing pleasantly at the turn of the stair. Here Carlyle had come, here George Eliot had progressed through bookshelves. Roland saw her black silk skirts, her velvet trains, sweeping compressed between the Fathers of the Church, and heard her firm foot ring on metal among the German poets’.</span></p>\r\n<p class=\"p1\"><span class=\"s1\">To the south of St James’s Square lies Pall Mall, the first public street in the world to be artificially lit with gas, and beyond it, St James’s Park. St James’s Park is the oldest Royal Park in London; Henry VIII purchased the land from Eton College in 1532 and when King James I ascended the throne in 1603 he ordered that the land be drained and landscaped. James kept exotic animals, including camels and crocodiles, in the park and it wasn’t until Charles II took the throne that the park was opened to the public. The colony of pelicans that live in the park date back to a gift from the Russian ambassador in 1664.</span></p>\r\n<p class=\"p1\"><span class=\"s1\">The Inn in the Park is open all year round for food and drink, but on a sunny day why not bring your own picnic and enjoy a view of either Buckingham Palace or Whitehall as you eat?</span></p>',0,0,1,1,1),(20,'Westminster Abbey',51.5018,-0.129626,'<p>At the edge of St James’s Park lies the Churchill War Rooms, one of the five branches of the Imperial War Museum. The museum contains the Cabinet War Rooms, in which Churchill announced ‘This is the room from which I will direct the war\' as well as the Churchill Museum. </p>\r\n<p class=\"p1\"><span class=\"s1\">A few minutes walk from the Churchill War Rooms, by way of Parliament Square, which contains statues of many famous statesman including Benjamin Disraeli and Abraham Lincoln, lie our final points of interest: Westminster Abbey and Big Ben. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">Westminster Abbey is one of the most important Gothic buildings in the country. Benedictine monks first came to the site in the middle of the tenth century; the Abbey, officially the Collegiate Church of St. Peter, Westminster, has been the coronation church since 1066 and is the final resting place of seventeen monarchs and countless aristocrats and authors. </span></p>\r\n<p class=\"p1\"><span class=\"s1\">Poets’ Corner lies in the South Transept of the Abbey – Chaucer was buried here in 1400 as a result of his employment as Clerk of the King’s Works but 150 years later his remains were moved into the magnificent tomb that can be seen today. Poet Edmund Spenser was laid to rest near Chaucer’s tomb and other poets and prose authors, including Charles Dickens, George Eliot, Jane Austen and Henry James, were buried or memorialised near the two great poets. Many of the memorials happened some time after the death of the writer – Lord Byron died in 1824 and was only given a memorial in 1969 and even Shakespeare had to wait until 1740 before he was granted a monument. An effigy of Oliver Cromwell was originally buried here after an elaborate funeral – Cromwell’s religious principles dictated that his burial be without ceremony so his body was buried privately in a vault – but when Charles II was restored to the throne he had Cromwell disinterred and posthumously hanged, before his head was cut off and stuck on a spike. </span></p>\r\n<p class=\"p2\"><span class=\"s1\">Although Big Ben is often used to refer to the whole clock, the name officially refers to the largest bell within the clock that stands at the north end of the Palace of Westminster. It is the largest four-faced chiming clock in the world and was completed in 1858. In <em>Mrs Dalloway</em> Virginia Woolf’s eponymous heroine reflects that:</span></p>\r\n<p class=\"p2\"><span class=\"s1\">‘For having lived in Westminster – how many years now? over twenty – one feels even in the midst of traffic, or waking at night, Clarissa was positive, a particular hush, or solemnity; an indescribable pause; a suspense (but that might be her heart, affected, they say, by influenza) before Big Ben strikes. There! Out it boomed. First a warning, musical; then the hour, irrevocable.’</span></p>',0,0,1,1,1),(21,'30 Bedford Square and Gower Street',51.519,-0.131385,'<p>Number 30 Bedford Square is the original home of Jonathan Cape so a fitting start to this walk in an area so steeped in literary history. Cape was founded in 1921 by Jonathan Cape and Wren Howard. The firm quickly established itself as one of the leading literary publishers in London, publishing T.E. Lawrence’s The Seven Pillars of Wisdom, Ernest Hemingway, Arthur Ransome’s Swallows and Amazons (all the books in the series are still in print today in the original editions) and, in 1953, Ian Fleming\'s Casino Royale, the first of the James Bond books.</p>\r\n<p>Gower Street runs along the Eastern side of the Square and it is at 110 Gower Street (formerly 12 Upper Gower Street) that Charles Darwin lived between 1838 and 1842, where he wrote part of <em>The Origin of Species</em>. The house is now the UCL Darwin Building. Darwin christened the house \"Macaw Cottage\" because of the “gaudy colours” of the furnishings. By the time he came to Gower Street, Darwin had already returned from his famous voyage on HMS Beagle and it was in this house that Darwin’s theory of Natural Selection made progress but it was not until 1859, when the he and his family had moved out to Kent that <em>On the Origin of Species was published.</em> 1,250 copies were sold on the first day of its publication</p>\r\n<p>It is also worth noting that No. 7 Gower Street was once the house of John Millais\'s parents and the birthplace of the artistic movement the Pre-Raphaelite Brotherhood.</p>',0,0,1,1,1),(22,'Tavistock Square ',51.5245,-0.128231,'<p>The Tavistock hotel stands on the site of what was once 52 Tavistock Square, the home of Virginia and Leonard Woolf and the Hogarth Press from 1923 until it was destroyed by a bomb in World War II. Virginia wrote most of her greatest novels here - Mrs Dalloway, To The Lighthouse, Orlando (which was inspired by her affair with Vita Sackville West in the twenties), The Waves, and The Years. The couple ran the Hogarth Press in the basement of No. 52 and published some of the most significant writers of the 20th Century including Freud, T.S. Eliot, Chekhov, Dostoevsky, Katherine Mansfield, E.M Forster, Christopher Isherwood and countless others. The first publications were hand-set using boxes of type but as the press grew they were able to afford more sophisticated printing equipment. Particularly distinctive were the book jackets designed by other Bloomsbury Group members such as Vanessa Bell and Dora Carrington. It was in nearby Gordon Square where the Bloomsbury Group was formed.</p>\r\n<p class=\"p1\">Dickens also lived in old Tavistock House (now the BMA building), between 1851 and 1860. It was here that he wrote Bleak House, Little Dorritt, Hard Times, A Tale of Two Cities and part of Great Expectations.</p>\r\n<p class=\"p1\">Walking through the gardens you will see a memorial to Virginia Woolf in the South West corner of the square and there is a Gingko Biloba tree dedicated to Leonard Woolf. At the centre of the garden is a statue of Mahatma Gandhi. There is also a cherry tree planted in memory of the victims of the nuclear bombing of Hiroshima and a memorial to Conscientious Objectors. Tavistock Square was designed in the 1820s by the architect Thomas Cubitt and is part of an estate owned by the Duke of Bedford.</p>',0,0,1,1,1),(23,'The Foundling Hospital',51.5236,-0.119486,'<p>Founded in 1742, The Foundling Hospital was a place where unwanted children such as street children and orphans could be left and it was the first of its kind. It was founded by the campaigner and philanthropist Thomas Coram. In 18<span class=\"s1\">th </span>century London huge numbers of children were abandoned or thrown on the mercies of the parish church who were paid a lump sum by the parents to take them on, but many died in the parish poor houses or workhouses. At this time <span class=\"s2\">over 74% of children born in London died before they were five. In workhouses the death rate increased to over 90%. Coram was horrified by the fate of poor children in London and campaigned tirelessly to establish the hospital and despite much opposition on the basis the hospital would encourage prostitution and immorality the first children were admitted in 1741. Dickens based his character Mr Brownlow, who takes Oliver Twist into his care, on Coram.</span></p>\r\n<p class=\"p2\">The hospital soon became London’s most popular charity. William Hogarth became a governor, designing the uniforms and coat of arms as well as fostering children. Hogarth and other British artists donated art work to the hospital and in a sense it became the first gallery of contemporary British art. You can view the incredible collection of art in the museum today. The composer Handel was also a governor and benefactor, composing the Foundling anthem. <span class=\"s3\">Annual performances of the Messiah provided vital sources of income for the Hospital and he bequeathed the manuscript to the hospital. The Museum holds the Gerald Coke Handel Collection, an internationally important collection of material relating to Handel and his contemporaries, including manuscripts, printed books and music, libretti, paintings and engravings, memorabilia, art works and ephemera.</span></p>\r\n<p class=\"p2\"><span class=\"s3\">In front of the hospital is Coram Fields which is a playground and park for children. Sadly adults can’t enter the park unless accompanied by children.<br /></span></p>',0,0,1,1,1),(24,'Great Ormond Street Children\'s Hospital',51.5219,-0.120354,'<p>Great Ormond Street Hospital was founded in 1842 as the first hospital specifically for children. Dickens was an active fundraiser and J.M. Barrie donated the copyright of his book Peter Pan to the hospital. When the rights expired in 1987 the government granted the hospital a perpetual right to collect royalties for public performances, commercial publication, or other communications to the public of the work.</p>\r\n<p>If you are in need of a drink you might like to stop at The Lamb, a historic pub on nearby Lamb’s Conduit Street which was once the meeting place for the Bloomsbury Group.</p>',-71.6,8.6,1,1,1),(25,'St George\'s Church, Bloomsbury',51.5176,-0.124482,'<p>Commissioned as part of the 1711 Act of Parliament for building Fifty New Churches, St George’s was designed by baroque architect Hawskmoor (the sixth and last of his London churches). It was built in 1730 in the parish of St Giles in the Fields which was considered much in need of a place of worship.</p>\r\n<p>In 1913, the funeral of the suffragette Emily Wilding Davison was held in this church. Emily was killed when she threw herself in front of the king\'s horse at Epsom racecourse during the Derby to protest the right for women to vote. Her funeral was attended by thousands of women, all wearing black and purple, green and white (the colours of the suffragette movement).</p>\r\n<p>The novelist Antony Trollope was baptised here in 1834 and Charles Dickens used St George\'s as the setting for \"The Bloomsbury Christening\" in Sketches by Boz.</p>\r\n<p>The church has only recently been reopened after undergoing extensive restoration after it fell into disrepair in the second half of the 20<sup>th</sup> century.</p>',0,0,1,1,1),(26,'The British Museum',51.5183,-0.126117,'<p>The British Museum, which first opened to the public in 1759 in Montagu House, is at the heart of Bloomsbury. The Reading Room opened on 2 May 1857 and its design was inspired by the domed Pantheon in Rome. Bookstacks made of iron were built surrounding the new Reading Room to take the weight of the books and protect them against fire. In all they contained three miles of bookcases and twenty-five miles of shelves. The books have since been moved to the British Library and the room was opened to the public for the first time in 2000.</p>\r\n<p>Those wanting to use the Reading Room had to apply in writing and were issued a reader’s ticket by the Principal Librarian. Among those granted tickets were Karl Marx, Lenin (who signed in under the name Jacob Richter), Bram Stoker, Sir Arthur Conan Doyle, Virginia Woolf, Oscar Wilde, H.G. Wells, Mark Twain, and George Orwell. David Lodge’s protagonist Adam Appleby in the novel The British Museum is Falling Down spends much of his time trying but failing to get down to his PhD dissertation work.</p>',0,0,1,1,1),(27,'Bond Street',51.5116,-0.143287,'<p>Our walk begins in Bond Street, where Virginia Woolf\'s heroine Mrs Dalloway buys her gloves in the short story \'Mrs Dalloway in Bond Street’, taken from the collection <em>Mrs Dalloway\'s Party</em>. Technically, Bond Street itself doesn\'t exist: the road is instead divided into two sections, New Bond Street to the North and Old Bond Street to the South. The road is named after the seventeenth century nobleman, Sir Thomas Bond, who was one of a consortium of investors who bought Clarendon House – described as one of the first great classical houses in London – before demolishing it and building Dover Street, Albermale Street and Old Bond Street on the site. Clarendon House would have originally faced directly down St James\'s Street.</p>',0,0,1,1,1),(28,'Highgate Cemetery',51.5567,-0.201824,'<p>This intriguing Victorian cemetery is the final stop on this walk and the final resting place of among others George Eliot (though her grave name is Mary Ann Cross), Douglas Adams, Radclyffe Hall, Christina Rossetti, most of Charles Dickens’ family and of course Karl Marx. The cemetery was opened in 1839 to deal with the crisis in the lack of adequate burial spaces due to an increase in the mortality rate. Previously grave yards and burial grounds were crammed in between shops, houses and taverns wherever there was space. Highgate was to be one of seven large cemeteries to be built around London to ease the problem. The abundance of ornate gothic tombs and buildings very much reflect the fashion of the time. This atmospheric place has featured in many novels and films, most notably in Bram Stoker’s Dracula: the Count\'s young victim, Lucy Westenra, is buried in Highgate Cemetery, where she later preys on young children as a vampire. The French crime writer Fred Vargas also chose the cemetery for the opening of her novel An Uncertain Place. Audrey Niffenegger set her novel Her Fearful Symmetry in and around the cemetery and the author acted as a tour guide whilst carrying out her research. For a taste of Audrey’s tour we’ve included a video of the author at the cemetery.</p>',0,0,1,1,1);
/*!40000 ALTER TABLE `vw_point` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_point_comment`
--
LOCK TABLES `vw_point_comment` WRITE;
/*!40000 ALTER TABLE `vw_point_comment` DISABLE KEYS */;
/*!40000 ALTER TABLE `vw_point_comment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_point_media`
--
LOCK TABLES `vw_point_media` WRITE;
/*!40000 ALTER TABLE `vw_point_media` DISABLE KEYS */;
INSERT IGNORE INTO `vw_point_media` VALUES (3,91,1),(93,91,12),(95,86,13),(96,87,13),(94,92,13),(98,88,14),(97,347,14),(99,89,16),(100,90,16),(101,93,16),(71,95,18),(72,112,18),(75,98,19),(76,106,19),(85,118,20),(86,341,20),(25,103,21),(26,110,21),(27,119,21),(28,101,22),(29,107,22),(30,117,22),(31,90,23),(32,104,23),(33,113,23),(34,105,24),(35,109,24),(58,344,25),(54,111,26),(56,340,26),(105,86,27),(106,87,27),(102,96,27),(103,97,27),(104,100,27),(89,340,28);
/*!40000 ALTER TABLE `vw_point_media` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_settings`
--
LOCK TABLES `vw_settings` WRITE;
/*!40000 ALTER TABLE `vw_settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `vw_settings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_walk`
--
LOCK TABLES `vw_walk` WRITE;
/*!40000 ALTER TABLE `vw_walk` DISABLE KEYS */;
INSERT IGNORE INTO `vw_walk` VALUES (9,'From Tate Modern to Monument','<p>From the Tate Modern to the Monument to the Great Fire of London, this walk takes you along and across the river Thames, through some of London’s key literary – and historical – sites. Listen to a reading of one of Shakespeare’s Sonnets as you pass by the Globe Theatre, enjoy an interview with acclaimed historian Gillian Tindall about one of the most interesting houses in London and read an extract from Little Dorrit when you visit the church in which Dickens’ eponymous heroine marries.</p>','<p>Main content article</p>',1,1),(10,'A Walk Around Bloomsbury','<p>From the birthplace of Jonathan Cape and the blitzed home of the Hogarth Press, to the grand Reading Room of the British Museum and the first charitable institution for orphaned children, this walk takes you through the squares and leafy gardens of unreservedly literary Bloomsbury. Listen to Jenny Uglow describe Virginia Woolf’s home, Ruth Padel read poems about Darwin, her great-great-grandfather and hear publisher Dan Franklin recount the vivid history of Jonathan Cape.</p>','<p>Main content article</p>',1,1),(22,'From Bond Street to Westminster Abbey','<p>From refined Bond Street to Westminster Abbey, this walks takes you through some of the most elegant streets in London. Starting and finishing with Virginia Woolf, you can listen to a reading from <em>Mrs Dalloway’s Party</em>, watch Booker shortlisted author David Lodge discuss Henry James, and enjoy some Perfect Picnic recipes in London’s oldest Royal Park.</p>','<p>Our walk begins in Bond Street, where Virginia Woolf\'s heroine Mrs Dalloway buys her gloves in the short story \'Mrs Dalloway in Bond Street’, taken from the collection <em>Mrs Dalloway\'s Party</em>. Technically, Bond Street itself doesn\'t exist: the road is instead divided into two sections, New Bond Street to the North and Old Bond Street to the South. The road is named after the seventeenth century nobleman, Sir Thomas Bond, who was one of a consortium of investors who bought Clarendon House – described as one of the first great classical houses in London – before demolishing it and building Dover Street, Albermale Street and Old Bond Street on the site. Clarendon House would have originally faced directly down St James\'s Street.</p>\r\n<p> </p>\r\n<p>(Audio reading from Mrs Dalloway’s Party, book jacket for Mrs Dalloway and 2 versions of the jacket for Mrs Dalloway’s Party – one the original Hogarth Press hb and one the 2010 Classics edition)</p>',1,1),(23,'Untitled','<p>Write Introduction Here</p>',NULL,0,1),(24,'Untitled 2','<p>Write Introduction Here 123</p>',NULL,0,1);
/*!40000 ALTER TABLE `vw_walk` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_walk_comment`
--
LOCK TABLES `vw_walk_comment` WRITE;
/*!40000 ALTER TABLE `vw_walk_comment` DISABLE KEYS */;
INSERT IGNORE INTO `vw_walk_comment` VALUES (22,11);
/*!40000 ALTER TABLE `vw_walk_comment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_walk_media`
--
LOCK TABLES `vw_walk_media` WRITE;
/*!40000 ALTER TABLE `vw_walk_media` DISABLE KEYS */;
INSERT IGNORE INTO `vw_walk_media` VALUES (9,86),(9,87),(22,86),(22,87),(22,88),(22,90),(24,86),(24,92),(24,97);
/*!40000 ALTER TABLE `vw_walk_media` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping data for table `vw_walk_point`
--
LOCK TABLES `vw_walk_point` WRITE;
/*!40000 ALTER TABLE `vw_walk_point` DISABLE KEYS */;
INSERT IGNORE INTO `vw_walk_point` VALUES (1,12,9),(2,13,9),(3,14,9),(4,16,9),(70,21,10),(71,22,10),(72,23,10),(73,24,10),(74,25,10),(75,26,10),(114,18,22),(115,19,22),(116,20,22),(113,27,22),(118,12,24),(119,13,24),(117,14,24);
/*!40000 ALTER TABLE `vw_walk_point` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2012-05-16 0:43:00
|
Download
