Name

st_contains — Returns true if all points of a given geometry g2 are in another geometry g1.

Synopsis

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

Description

Returns true if all points of a given geometry g2 are in another geometry g1. 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.

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.145. Simple Use

SQL>SPARQL
SELECT ?c COUNT (*)
WHERE
  {
    ?m geo:geometry ?geo .
    ?m a ?c .
    FILTER (bif:st_contains (?geo, bif:st_point (0, 52)))
  }
GROUP BY ?c ?geo
ORDER BY DESC 2;

c                                                                     callret-1
ANY                                                                   ANY
________________________________________________________________________________
 http://dbpedia.org/class/yago/Landmark108624891                      12
 http://www.w3.org/2002/07/owl#Thing                                  3
 http://dbpedia.org/ontology/Place                                    3
 http://dbpedia.org/ontology/PopulatedPlace                           2
 http://dbpedia.org/class/yago/TowersInTheNetherlands                 2
 http://dbpedia.org/class/yago/TowersInGermany                        1
 http://dbpedia.org/class/yago/HillsOfWarwickshire                    1
 http://dbpedia.org/class/yago/PrehistoricSitesInPembrokeshire        1
 http://dbpedia.org/class/yago/HillsOfSomerset                        1
 http://dbpedia.org/class/yago/PeninsulasOfTheFalklandIslands         1
 http://dbpedia.org/class/yago/HillsOfWiltshire                       1
 http://dbpedia.org/class/yago/HillsOfOxfordshire                     1
 http://dbpedia.org/class/yago/HillsOfGloucestershire                 1
 http://dbpedia.org/ontology/City                                     1
 http://dbpedia.org/class/yago/HillsOfWorcestershire                  1
 http://dbpedia.org/class/yago/GuyedMasts                             1
 http://dbpedia.org/ontology/Building                                 1
 http://dbpedia.org/class/yago/Cities,TownsAndVillagesInGelderland    1
 http://dbpedia.org/ontology/Area                                     1
 http://dbpedia.org/class/yago/FormerMunicipalitiesOfGelderland       1
No. of rows in result: 20