I have a raster in PostGIS and a table of points. I want to calculate the distance of each pixel to each point.
How can I do that?
For example, if 9 pixels and 3 points, then I want to calculate 27 distances.
Your idea looks good. Actually I am trying to create a heatmap from a set of points that are trajectory of GPS.
I thought to first create a raster of the convex hull of the points, then calculate the distance of each pixel to each point. After that, I want to assign a degree to each pixel that represents its closeness to points. Now, I will use your idea for the middle part and at the end I create a rater from it.
Do you have any faster idea for creating heatmaps because I have really big data?