You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jan 25, 2024. It is now read-only.
I am using the trackmap panel in a dashboard to explore a GBIF dataset. Using the following query I can zoom in to streetlevel, and show the number of records in the tooltip for each cluster.
WITH a AS (
SELECT
eventdate AStime,
decimallatitude,
decimallongitude,
geom,
COUNT(*) OVER() AS cnt
FROMexplore.gbifWHERE $__timeFilter(eventdate)
AND decimallatitude >= $minLat
AND decimallatitude <= $maxLat
AND decimallongitude >= $minLon
AND decimallongitude <= $maxLon
), b AS (
SELECTtime,
decimallatitude,
decimallongitude,
ST_ClusterKMeans(geom, LEAST(cnt::integer, 200)) OVER() AS clusters
FROM a
)
SELECT
clusters,
COUNT(clusters) AS tooltip,
AVG(decimallatitude) AS latitude,
AVG(decimallongitude) AS longitude
FROM b
GROUP BY1ORDER BY1;
Is it possible to use the number of records in a cluster to set the size of the marker? Or an option to use circles with sizes depending on the number of records in a cluster, like available in the worldmap panel?
Maximum zoom using LEAST and COUNT OVER():
The text was updated successfully, but these errors were encountered:
rudibroekhuizen
changed the title
Tooltip size
Marker size based on number of records in cluster
Nov 25, 2020
Sign up for freeto subscribe to this conversation on GitHub.
Already have an account?
Sign in.
I am using the trackmap panel in a dashboard to explore a GBIF dataset. Using the following query I can zoom in to streetlevel, and show the number of records in the tooltip for each cluster.
Is it possible to use the number of records in a cluster to set the size of the marker? Or an option to use circles with sizes depending on the number of records in a cluster, like available in the worldmap panel?
Maximum zoom using LEAST and COUNT OVER():
The text was updated successfully, but these errors were encountered: