Where does the 4D World Tour 2017 host events? I’d like to see that on a map and read the sequence of events at a glance.
We had to first extract the data from the 4D-Website. Then, because website-data is hardly properly organised for a database, put them into a Numbers-spreadsheet and did some enhancements. Enhancing means putting addresses into separate columns, name the columns according to keywords, add empty columns for latitude and longitude, add a second table for the teams and reference that data into the first table.
Exporting from Numbers does not support JSON, so we used CSV. Then run through MaPagenda to convert CSV into JSON. Finally the JSON opend in MaPagenda and created the maps. Those maps are included in this page by iframes.
MaPagenda learned new tricks while building these maps.
Click a map-picture to open the interactive map in a new window. Select a marker and read hotel, city, date and team.