From 0629a4e873935cc3824fcf801453295950ea9bb5 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 23 Jun 2010 14:36:47 +0000 Subject: [PATCH] Document ST_Intersects git-svn-id: http://svn.osgeo.org/postgis/trunk@5696 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference_wktraster.xml | 116 ++++++++++++++++++++++++++++++++++++ 1 file changed, 116 insertions(+) diff --git a/doc/reference_wktraster.xml b/doc/reference_wktraster.xml index b146c9b95..4bc5206ae 100644 --- a/doc/reference_wktraster.xml +++ b/doc/reference_wktraster.xml @@ -2327,4 +2327,120 @@ a_rid | b_rid | overleft + + + Raster and Raster Band Spatial Relationships + + + ST_Intersects + + Returns TRUE if rastA pixel in a band with non-no data band value intersects + with a geometry/raster. If band number is not specified it defaults to 1. + + + + + + boolean ST_Intersects + + + raster + + rastA + + + + geometry + + geomB + + + + + boolean ST_Intersects + + + raster + + rastA + + + + integer + + band_num + + + + geometry + + geomB + + + + + boolean ST_Intersects + + + geometry + + geomA + + + + rast + + rastB + + + + + boolean ST_Intersects + + + geometry + + geomA + + + + rast + + rastB + + band_num + + + + + + Description + + Returns true if any pixel in a raster band has a value that is not nodatavalue and that + geometry region of the pixel intersects the geometry + + This operand will make use of any indexes that may be available on the + geometries / rasters. + + + + Examples + + SELECT A.rid, g.gid , ST_Intersects(A.rast, g.geom) As inter + FROM dummy_rast AS A CROSS JOIN + (VALUES (1, ST_Point(3427928, 5793243.85) ) , + (2, ST_GeomFromText('LINESTRING(3427927.85 5793243.75,3427927.8 5793243.75,3427927.8 5793243.8)') ), + (3, ST_GeomFromText('LINESTRING(1 2, 3 4)') ) + ) As g(gid,geom) +WHERE A.rid =2 ; + + rid | gid | inter +-----+-----+------- + 2 | 1 | t + 2 | 2 | t + 2 | 3 | f + + + + -- 2.40.0