[postgis-users] PostGIS heatmap generation

Sandro Santilli strk at keybit.net
Tue Mar 18 00:40:41 PDT 2014

On Mon, Mar 17, 2014 at 03:41:03PM -0700, Paul Norman wrote:

> - I have a dataset of 100 million to 500 million points 
>   across the US


> Has anyone got any suggestions for how to efficiently render heatmaps 
> from datasets this large?  I was thinking of two tables, one with the 
> raw data for high zooms and one pre-aggregated into space and time 
> bins (e.g. requests in a given box in a given time range) for use 
> in lower zooms. The aggregation operation would obviously be slow, but
> I'd only have to do it once. 

Pre-aggregation would surely help, big problem being amount
of records that need to be read from disk. You could also look
at postgis raster as the aggregation type.


 ()  ASCII ribbon campaign  --  Keep it simple !
 /\  http://strk.keybit.net/rants/ascii_mails.txt  

More information about the postgis-users mailing list