POSTGIS Join tables on ST_ClosestPoint

Question

In an attempt to join two rasters with a very small offset, the join on ST_ClosestPoint geometry column is logical to me:

SELECT s.geom, s.val, c.val
FROM s
JOIN c ON ST_ClosestPoint(s.geom , c.geom) = s.geom

But this does not return any results.

(PostGIS v2.2.1 and PostgreSQL v9.5)

Perhaps try with ST_SnapToGrid, the raster version, and use ST_Intersects for the join condition? — John Powell, Aug 25 '16 at 11:30
what is an example of the actual geometry of s.geom and c.geom? eg: 'POINT(-90.3928339896896 36.7569372904341)' — kttii, Aug 25 '16 at 13:23

score 0 · Accepted Answer · answered Jan 07 '21 at 18:08

0

ST_ClosestPoint returns an actual point, not a boolean as would be needed for a JOIN.

answered Jan 07 '21 at 18:08

bugmenot123

1 Answers1