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.
Best Answer
You can try using middleware such as Geoserver which can generate heatmaps for you: http://docs.geoserver.org/stable/en/user/styling/sld-extensions/rendering-transform.html#heatmap-generation