We need all the data from Wikipedia, with geolocation information, example: [login to view URL]:Nearby.
The data must be in MS Access, SQL Server or Mongodb.
Table 1: One registry for article
Field Notes
Id ==> Id of Wikipedia (200989)
Url ==> Article url, the origin ([login to view URL])
Title ==> Article title (Checkpoint Charlie)
ImageURL ==> Image url ([login to view URL])
ImageWidth ==> Image width in px (180)
ImageHeight ==> Image height in px (116)
ImageName ==> Image name ([login to view URL])
Lat ==> Latitude (52.31)
Lon ==> Longitude (13.3828)
Category ==> Look [login to view URL]
Table 2: One registry for every one section of every article.
Id ==> Id of Wikipedia (200989)
SectionTile ==> Section name (Checkpoint Charlie, Background, The Checkpoint,…)
SectionContent ==> Section content (Checkpoint Charlie (or "Checkpoint C") was the name given by the Western Allies to the best-known Berlin Wall crossing point between East Berlin and West Berlin during the Cold War…….)
Order ==> 1,2,3… in order or publication on Wikipedia.