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

Birgit Laggner birgit.laggner at thuenen.de
Sun Apr 18 23:48:06 PDT 2021

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. 


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? 

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? 


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

More information about the postgis-users mailing list