Name
st_within — Returns true if all points of a given geometry g1 are in another geometry g2.
Synopsis
st_within
(
|
in g1 any , |
in g2 any , | |
in
prec
double precision
) ; |
Description
Returns true if all points of g1 are in g2. 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.146. Simple Use
SQL>SPARQL SELECT ?c ?geo WHERE { ?m geo:geometry ?geo . ?m a ?c . FILTER (bif:st_within(?geo, bif:st_point (0, 52), 100)) } LIMIT 10; c geo ANY ANY _______________________________ http://linkedgeodata.org/vocabulary#node POINT(0.0197 51.1005) http://linkedgeodata.org/vocabulary#node POINT(0.0207 51.1006) http://linkedgeodata.org/vocabulary#node POINT(0.0148 51.1006) http://linkedgeodata.org/vocabulary#node POINT(0.0217 51.1006) http://linkedgeodata.org/vocabulary#node POINT(0.0021 51.1008) http://linkedgeodata.org/vocabulary#node POINT(0.0029 51.1008) http://linkedgeodata.org/vocabulary#node POINT(0.0467 51.1007) http://linkedgeodata.org/vocabulary#node POINT(0.0217 51.1007) http://linkedgeodata.org/vocabulary#node POINT(0.0148 51.1007) http://linkedgeodata.org/vocabulary#node POINT(0.0217 51.1008) No. of rows in result: 10