I have GIS data in a PostGIS data base and would like to generate a density map and display them on a Leaflet/Google Maps.
Question: What is the recommended/typical method for doing so, without transferring ALL (millions) the data points within the map's viewpoint to the Leaflet/Gmaps map? No user intervention (ie. Import data into ArcGIS to generate the map) should be required unless automation is possible via CLI etc.
Currently using Postgresql/PostGIS as the spatial database and Leaflet on the browser.