[postgis-users] PostGIS - Simple Raster Point Query

[Pierre Racine]

> I made the tile size 1200x1200 and used the -R option when doing the
> raster2pgsql import because the raster is a .img/.ige file which is 26GB. But this
> query result tells me it got the right geo transform.

If your coverage is tiled, your query should look like:

SELECT ST_Value(rast,ST_SetSRID(ST_Point(1821416, 5649720), 2193)) 
FROM nzdem3
WHERE  ST_Intersects(rast,ST_SetSRID(ST_Point(1821416, 5649720), 2193))

Pierre