Skip to Main Content

Geo Heatmap

This map renders the data as a Heatmap.

Query for map plugin: select round(lat,3), round(lng,3), sum(10*(mag+1)) from jk64demo_earthquakes where mag+1>=0 group by round(lat,3), round(lng,3)

Adding the SUM() and GROUP BY helps to reduce the volume of data sent to the client. For a heatmap, sending 5 rows with the same position and weight "1" is the same as sending a single row with weight "5".

Source data

-63.043145.00268
-62.99146.89356
-62.233155.21961
-59.873-28.63858
-59.748-25.56256
-58.884-23.51960
-57.491-66.40562
-56.491-26.96862
-56.44-27.09667
-56.357-27.28363
-56.159-122.95457
-56.02-27.15862
-55.709146.74460
-55.35-27.28755
-54.801-39.3653