Extract text with annotated GPS POIs from Wikipedia

終了済み 投稿 4年前 着払い
終了済み 着払い

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]

JavaScript PHP MySQL Odd Jobs

プロジェクトID: #20230762

プロジェクトについて

6個の提案 リモートプロジェクト アクティブ 4年前

6人のフリーランサーが、平均€259 で、この仕事に入札しています。

bhavesh1508

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 7日以内
(31件のレビュー)
6.5
m1990sami

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 7日以内
(0件のレビュー)
0.0