1

I have a column that contains points (all they make one tile) and I need to extract the upper left point based on point coordinates.

Is there any built-in function in PostGIS to find?

Otherwise, I am thinking to get the first Xmin and Ymax manually by sorting.

enter image description here

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
Manap Shymyr
  • 315
  • 1
  • 8
  • once you have the extent as shown in https://gis.stackexchange.com/questions/14948/bounding-box-for-postgis-table the individual corners are easy – Ian Turton Jun 17 '22 at 13:57
  • But the corners of the extent may not be points in the underlying dataset. I think a simple SQL sort is the way to go here. – dr_jts Jun 17 '22 at 16:16
  • What if there is one slightly to the right but more to the north, which is the upper left? – BERA Jun 17 '22 at 16:39
  • You have to define whether North or West has priority. – dr_jts Apr 19 '23 at 21:54

0 Answers0