Name

st_intersects — Returns intersects between two geometries.

Synopsis

st_intersects ( in g1 any ,
  in g2 any ,
  in prec double precision );
 

Description

Returns intersects between two geometries. If prec is supplied, this is a tolerance for the matching in units of linear distance appropriate to the srid. Both geometries should have the same srid. st_intersects is true if there is at least one point in common.

Parameters

g1

The first geometry.

g2

The second geometry.

prec

A tolerance for the matching in units of linear distance appropriate to the srid. Default is 0.

Return Types

Returns int.

Examples

Example 24.144. Simple Use

SQL>SELECT st_intersects (st_point (0, 51), st_point (0, 52), 100);
callret
INTEGER
_______________________________
 0
No. of rows in result: 1

SQL>SPARQL
SELECT ?c (bif:st_intersects (?geo, bif:st_point (0, 52), 100))
WHERE
   {
     ?m geo:geometry ?geo .
     ?m a ?c .

   }
GROUP BY ?c ?geo
ORDER BY desc 2
LIMIT 10;
c                                                                callret-1
ANY                                                              ANY
__________________________________________________
http://xmlns.com/foaf/0.1/Person                                 1
http://rdf.alchemyapi.com/rdf/v1/s/aapi-schema#Disambiguation    1
http://rdf.alchemyapi.com/rdf/v1/s/aapi-schema#Disambiguation    1
http://www.w3.org/2003/12/exif/ns/IFD                            1
http://www.w3.org/2003/12/exif/ns/IFD                            1
http://www.w3.org/2003/12/exif/ns/IFD                            1
http://www.w3.org/2003/12/exif/ns/IFD                            1
http://www.w3.org/2003/12/exif/ns/IFD                            1
http://dbpedia.org/class/yago/HostCitiesOfTheCommonwealthGames   1
http://www.w3.org/2003/12/exif/ns/IFD                            1
No. of rows in result: 10