[postgis-users] PostGIS - Simple Raster Point Query

Pierre Racine Pierre.Racine at sbf.ulaval.ca
Sat Dec 8 23:24:33 PST 2012


> 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


More information about the postgis-users mailing list