[postgis-users] Location of highest point in each region?

[Birgit Laggner]

Hi Jesper, 

just from the manual: If you have the value, could you not use ST_PixelOfValue to extract the location? 

from the PostGIS-manual: 



ST_PixelOfValue — Get the columnx, rowy coordinates of the pixel whose value equals the search value. 



Regards, 
Birgit 



Von: "Jesper Kempe" <jesper.kempe at gmail.com> 
An: postgis-users at lists.osgeo.org 
Gesendet: Montag, 19. April 2021 08:34:42 
Betreff: [postgis-users] Location of highest point in each region? 

Hi 
I have loaded a DEM dataset into a Postgis raster table. And a shapefile with polygons for a number of regions into another table. 

For a couple of days now I have been trying to extract the height and location of the highest point in each of the regions. But I cannot find a way to do it. 

I am able to find the highest value in each region using ST_SummaryStats() but not the location (coordinates) of that value. 

Can anyone point me in the right direction how I should do this? 
It must be possible to do this in Postgis right? 

Thanks 
Jesper 

_______________________________________________ 
postgis-users mailing list 
postgis-users at lists.osgeo.org 
https://lists.osgeo.org/mailman/listinfo/postgis-users 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210419/9c864add/attachment.html>