Re: [postgis-users] raster intersecting geometry

2020-11-06 Thread Regina Obe
GIS Users Discussion' Subject: [postgis-users] raster intersecting geometry Hi all, could anyone help me with the below query? I'm trying to find the geometries from a table (ch04.newpoint) which intersect the raster (ch04.dumprastval). However I can't seem to get it to

[postgis-users] raster intersecting geometry

2020-11-06 Thread Amy O'Keefe
Hi all, could anyone help me with the below query? I'm trying to find the geometries from a table (ch04.newpoint) which intersect the raster (ch04.dumprastval). However I can't seem to get it to work! Thanks. SELECT CAST((gval).val As integer) AS val, ST_Union((gval).geom) As geom FROM ( SELE