Extract text with annotated GPS POIs from Wikipedia

We would like to align the information about GPS POIs from a Wikipedia dump ( [login to view URL] ). The task is to extract the information from an SQL dump. One recent version is OK, e.g. 20190701, no auto-updates needed. Currently the SQL dumps of Wikipedia are split into multiple SQL files, we wish to generate a single SQL file that contains the following 5 fields:

- Lon

- Lat

- Wikipedia link

- Wikipedia title

- POI text

For example:

- 48.858222

- 2.2945

- [login to view URL]

- Eiffel Tower

- The Eiffel Tower is a wrought-iron lattice tower on the Champ de Mars in Paris, France. It is named after the engineer Gustave Eiffel, whose company designed and built the tower.

Constructed from 1887 to 1889 as the entrance to the 1889 World's Fair, it was initially criticised by some of France's leading artists and intellectuals for its design, but it has become a global cultural icon of France and one of the most recognisable structures in the world.[3] The Eiffel Tower is the most-visited paid monument in the world; 6.91 million people ascended it in 2015.

The tower is 324 metres (1,063 ft) tall, about the same height as an 81-storey building, and the tallest structure in Paris. Its base is square, measuring 125 metres (410 ft) on each side. During its construction, the Eiffel Tower surpassed the Washington Monument to become the tallest man-made structure in the world, a title it held for 41 years until the Chrysler Building in New York City was finished in 1930. It was the first structure to reach a height of 300 metres. Due to the addition of a broadcasting aerial at the top of the tower in 1957, it is now taller than the Chrysler Building by 5.2 metres (17 ft). Excluding transmitters, the Eiffel Tower is the second tallest free-standing structure in France after the Millau Viaduct.

The tower has three levels for visitors, with restaurants on the first and second levels. The top level's upper platform is 276 m (906 ft) above the ground – the highest observation deck accessible to the public in the European Union. Tickets can be purchased to ascend by stairs or lift to the first and second levels. The climb from ground level to the first level is over 300 steps, as is the climb from the first level to the second. Although there is a staircase to the top level, it is usually accessible only by lift.


Expected delivery:

- serialized SQL content

- reproducible source code (choose between PHP, Ruby, C#, Python, JavaScript, Java).

Relevant hints: [login to view URL] https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/GeoData/+/master/sql/[login to view URL]

Kemahiran: Javascript, PHP, MySQL, Semua Boleh

Lihat lagi: extract text fla, extract text pictures pdf, extract text google books, extract text picture, perl script extract text html tags, perl extract text html tags, extract text html, perl extract text tags, outlook 2007 macro extract text, extract text html tags using perl, outlook vba code extract text, php extract text wikipedia

Tentang Majikan:
( 0 ulasan ) Kontich, Belgium

ID Projek: #20230762

12 pekerja bebas membida secara purata €211 untuk pekerjaan ini


Hello! We are A2 Design, a Russian-Canadian web development company. Our team is interested in developing your project. Having the required skills, we will be glad to help you. We have some questions regarding y Lagi

€350 EUR dalam 3 hari
(117 Ulasan)

[login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] http://www.myfcpower.com. [login to view URL] http://mtgre Lagi

€140 EUR dalam 5 hari
(140 Ulasan)

We can fix your [login to view URL] checked it. Just give us the chance to prove ourselves....... We have some questions to clarify,please reply us so we could discuss the project in details. Thanks & Regards Moumita

€234 EUR dalam 7 hari
(179 Ulasan)

Hello, I will use Ruby, selenium and nokogiri to do this job, please send me a message so we can discuss more in detail. Thanks!!

€150 EUR dalam 7 hari
(27 Ulasan)

How are you? I have read your project proposal carefully and bid here. My main skill is webscraping and completed many scraping project. I have deep understanding in your project and I am sure I can complete your proje Lagi

€200 EUR dalam 7 hari
(32 Ulasan)

Hi Dear I read your requirements carefully. I have rich experience with full-stack development. I have developed Website and Web application projects for 7+ years. My skill is like: program a browser:JavaScript,jQuery Lagi

€140 EUR dalam 7 hari
(13 Ulasan)

Hi thanks for your posting. I have read your post. I am a expert who have many experiences in web development, so if you hire me, I can complete this project in short time as you want. I am available for now and I can Lagi

€100 EUR dalam 7 hari
(4 Ulasan)

I handle it with passion and great interest. It is the best kind of mode I’ve always wanted and gives me the chance to apply all types of creativity and resourcefulness. [login to view URL] [login to view URL] w Lagi

€150 EUR dalam 7 hari
(2 Ulasan)

i read ur all description and i have decided to bid on ur project so plz accept my bid so i can discuss further regrading the project and we can start the project on throw website 've been developer for 5+ years usi Lagi

€244 EUR dalam 7 hari
(2 Ulasan)

Hi, my name is Muhammad Qasim working as a full stack developer since 2016. Just saw your project and i think i am a very suitable person for your project.

€125 EUR dalam 7 hari
(0 Ulasan)

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Lagi

€140 EUR dalam 7 hari
(0 Ulasan)

Greetings! I hope you are doing great. I am highly professional in managing Wikipedia projects. Please message me so I may assist you further. Wikipedia Sample Work: [login to view URL] Lagi

€555 EUR dalam 9 hari
(0 Ulasan)