I have a postgis database with over 50 million rows. Every row consists of a POINT corresponding to lon,lat and a value (number 1-100)
I'm trying to create tiles for zoom levels 5-20 that I want to represent on google maps with the help of GeoServer.
Depending on the value of the point I want to paint it in a different color. As many of points are close to each other I want to paint based on their combined average value. Obviously which points are combined is depending on the current zoom level. Does Geoserver/PostGIS provide a good solution to this problem?
My current solution is to use ST_SnapToGrid and use different tables for every zoom level with different grid sizes. A solution I'm not very happy with.