EXTRACT_LOCATION
Syntax
EXTRACT_LOCATION(<text>)
Description
Extracts locations from text and returns the results in a list.
Locations that will be extracted are taken from a default list made by Conference on Natural Language Learning 2003 shared task (Language-Independent Named Entity Recognition) which can be found in Datameer's plug-ins file.
Examples
EXTRACT_LOCATION(#Text_Column)
| Text column | EXTRACT_LOCATION returns |
|---|---|
| I had imagined that we were bound for Baker Street, but Holmes stopped the cab at the corner of Cavendish Square. I observed that as he stepped out he gave a most searching glance to right and left, and at every subsequent street corner he took the utmost pains to assure that he was not followed. Our route was certainly a singular one. Holmes's knowledge of the byways of London was extraordinary, and on this occasion he passed rapidly and with an assured step through a network of mews and stables, the very existence of which I had never known. We emerged at last into a small road, lined with old, gloomy houses, which led us into Manchester Street, and so to Blandford Street. Here he turned swiftly down a narrow passage, passed through a wooden gate into a deserted yard, and then opened with a key the back door of a house. We entered together, and he closed it behind us. | [Cavendish Square, London, us, Manchester Street] |
| I needed. The course of events in London did not run so well as I had hoped, for the trial of the Moriarty gang left two of its most dangerous members, my own most vindictive enemies, at liberty. I travelled for two years in Tibet, therefore, and amused myself by visiting Lhassa, and spending some days with the head lama. You may have read of the remarkable explorations of a Norwegian named Sigerson, but I am sure that it never occurred to you that you were receiving news of your friend. I then passed through Persia, looked in at Mecca, and paid a short but interesting visit to the Khalifa at Khartoum the results of which I have communicated to the Foreign Office. Returning to France, I spent some months in a research into the coal-tar derivatives, which I conducted in a laboratory at Montpellier, in the south of France. Having concluded this to my satisfaction and learning that only one of my enemies was now left in London, I was about to return when my movements were hastened by the news of this very remarkable Park Lane Mystery, which not only appealed to me by its own merits, but which seemed to offer some most peculiar personal opportunities. I came over at once to London, called in my own person at Baker Street, threw Mrs. Hudson into violent hysterics, and found that Mycroft had preserved my rooms and my papers exactly as they had always been. So it was, my dear Watson, that at two o'clock to-day I found myself in my old armchair in my own old room, and only wishing that I could have seen my old friend Watson in the other chair which he has so often adorned." | [London, Tibet, Mecca, Khartoum, France, south, France, London, London] |