WorldMap + Mysql

1

Hi all,

In my Mysql database I have this kind of data :

| Id | ceatedAt | updatedAt | latitude | longitude |
| cjzx6oglih8xa0974faalw7y4 | 2019-08-29 21:11:42.337 | 2019-08-29 21:11:42.337 | 49.09000 | 2.57000 |
| cjzx6oglkh8xb0974jv9jubuu | 2019-08-29 21:11:42.337 | 2020-03-01 10:55:07.910 | 48.78700 | 2.22400 |

How can I show then on the map with WorldMap ? ( Or another Map tool )

Regards

2

I did this:

  • “Map Data Options”-> “Location Data” to “table”,
  • “Field Mapping”->“Table Query Format” to “coordinates”

I did this query :

SELECT
createdAt AS “time”,
latitude AS “latitude”,
longitude AS “longitude”,
id AS “value”,
id AS “name”
FROM Location
WHERE
$__timeFilter(createdAt)
ORDER BY createdAt

Now I have something which is displayed.

Changed “Map Visual Options” to :

  • Initial Zoom : 6
  • Min Circle Size : 0
  • Max Circle Size : 1
3 Likes
3

Dear @larzack,

thanks for sharing how Worldmap works with Mysql. For more advanced features, you might be happy to try our fork.

With kind regards,
Andreas.