[postgis-tickets] [PostGIS] #4502: [raster] ST_SameAlignment() gives differing results based on which argument comes first

[PostGIS]

#4502: [raster] ST_SameAlignment() gives differing results based on which argument
comes first
-------------------------+---------------------------
  Reporter:  evanderiel  |      Owner:  Bborie Park
      Type:  defect      |     Status:  new
  Priority:  medium      |  Milestone:  PostGIS 2.5.4
 Component:  raster      |    Version:  2.5.x
Resolution:              |   Keywords:
-------------------------+---------------------------

Comment (by Algunenano):

 Also happening with current trunk:
 {{{
 WITH reference AS (SELECT rid, rast from my_schema.usgs_dem_sample LIMIT
 1)
 SELECT
 sample.rid, reference.rid,
        ST_NotSameAlignmentReason(sample.rast, reference.rast),
 ST_NotSameAlignmentReason(reference.rast, sample.rast)
 FROM my_schema.usgs_dem_sample sample, reference
 WHERE ST_SameAlignment(sample.rast, reference.rast)
        <> ST_SameAlignment(reference.rast, sample.rast);
 NOTICE:  The rasters (pixel corner coordinates) are not aligned
 NOTICE:  The rasters (pixel corner coordinates) are not aligned
 NOTICE:  The rasters (pixel corner coordinates) are not aligned
 NOTICE:  The rasters (pixel corner coordinates) are not aligned
 NOTICE:  The rasters (pixel corner coordinates) are not aligned
 NOTICE:  The rasters (pixel corner coordinates) are not aligned
 NOTICE:  The rasters (pixel corner coordinates) are not aligned
 NOTICE:  The rasters (pixel corner coordinates) are not aligned
 NOTICE:  The rasters (pixel corner coordinates) are not aligned
 NOTICE:  The rasters (pixel corner coordinates) are not aligned
    rid   |   rid   |               st_notsamealignmentreason
 | st_notsamealignmentreason
 ---------+---------+--------------------------------------------------------+---------------------------
  4503034 | 4493565 | The rasters (pixel corner coordinates) are not
 aligned | The rasters are aligned
  4503035 | 4493565 | The rasters (pixel corner coordinates) are not
 aligned | The rasters are aligned
  4503036 | 4493565 | The rasters (pixel corner coordinates) are not
 aligned | The rasters are aligned
  4503037 | 4493565 | The rasters (pixel corner coordinates) are not
 aligned | The rasters are aligned
  4503038 | 4493565 | The rasters (pixel corner coordinates) are not
 aligned | The rasters are aligned
  4503039 | 4493565 | The rasters (pixel corner coordinates) are not
 aligned | The rasters are aligned
  4503040 | 4493565 | The rasters (pixel corner coordinates) are not
 aligned | The rasters are aligned
  4503041 | 4493565 | The rasters (pixel corner coordinates) are not
 aligned | The rasters are aligned
  4503042 | 4493565 | The rasters (pixel corner coordinates) are not
 aligned | The rasters are aligned
  4503043 | 4493565 | The rasters (pixel corner coordinates) are not
 aligned | The rasters are aligned
 (10 rows)
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4502#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.