I'm fairly new to PostgreSQL and PostGIS so don't expect someone to answer my question for me of course, I was just wondering if someone could point me in the right direction on where to look it up and if it is actually possible.
I have a table with a value, longitude and latitude column. I have made a geometry column using
UPDATE table SET geom = ST_Transform(
ST_GeomFromText('POINT('||longitude||' '||latitude||')', 4326), 4326);
Would it be possible to group by a specific sized grid cell and sum the value column for each point and then order it highest value to lowest? I'm using the terminal in Linux.
I am hoping to create a grid which covers every point stored in the table and then total the value per grid cell.