Retrieve the distance from a point to the nearest raster pixel with a given value in Postgresql
Context I have the table (hs_buildings) in my Postgresql DB containing the Point location of my buildings (hs_buildings.coordinates). Then I have a raster containing the land use in stored in a Postgresql raster table (named hs_raster_values). The resolution of the…