[postgis-devel] PostGIS Raster

[Mateusz Loskot]

On 21/12/10 09:10, cesius wrote:
> 
> Hello,
> 
> I have to develop an application where it's necessary to find the satellite
> image (GeoTIFF) which a point, given its lat-long, belongs to.


SELECT * FROM mytable
  WHERE ST_Intersects(raster, ST_Envelope('POINT(3 3)'::geometry))

> Can PostGIS Raster do a query of this kind? How coul I do it? I have find
> the ST_Envelope function but it returns the four corners of a rectangle and
> my images are no regular polygons.

The fact you are interested in finding raster related to a point
instead of a box or polygon should not really matter.

You can think of a tiny tiny envelope :-)

Best regards,
-- 
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org
Member of ACCU, http://accu.org