geo:equals( $region-1 as cts:region, $region-2 as cts:region, [$options as xs:string*] ) as xs:boolean
Compares geospatial regions to see if they fulfill the 'equals' DE-9IM relation.
This function determines whether the two regions
R1=$region-1
and R2=$region-2
satisfy the relationship R1 equals R2.
The operations are defined by the Dimensionally Extended nine-Intersection Model (DE-9IM) of spatial relations.
The value of the precision
option takes precedence over
that implied by the governing coordinate system name, including the
value of the coordinate-system
option. For example, if the
governing coordinate system is "wgs84/double" and the precision
option is "float", then the operation uses single precision.
If $region-1
or $region-2
is a column, the column's
coordinate system will take precedence over the coordinate-system
option.
If both $region-1
and $region-2
are columns, the query
will run unoptimized. Queries with one region column and a region literal will be
optimized.
xquery version "1.0-ml"; let $r1 := cts:polygon("POLYGON((-122.38582892471908 37.61827880006116,-122.4143247132933 37.60685626556358,-122.40436835343002 37.59352775797751,-122.38582892471908 37.61827880006116))") let $r2 := cts:polygon("POLYGON((-122.38582892471908 37.61827880006116,-122.4143247132933 37.60685626556358,-122.40436835343002 37.59352775797751,-122.38582892471908 37.61827880006116))") return geo:equals($r1,$r2,("coordinate-system=wgs84","precision=double")) (: returns true :)
xquery version "1.0-ml"; import module namespace op = 'http://marklogic.com/optic' at 'MarkLogic/optic.xqy'; import module namespace ogeo = 'http://marklogic.com/optic/expression/geo' at 'MarkLogic/optic/optic-geo.xqy'; (: Optic example using the Value Processing Function ogeo:equals() :) let $pointLit := 'POINT(-92.837486 34.438328)' let $plan:= op:from-view('buildings', 'builds') =>op:where(ogeo:equals(op:col('interiorPoint'),$pointLit)) =>op:select(('name', op:col('geoid'))) =>op:order-by('geoid') return $plan=>op:result() (: ==> rows representing names and geoids where the 'poly' column is EQUAL to pointLit :)
xquery version "1.0-ml"; (: SQL example using the ST_Equals function :) let $map := map:new(map:entry('pointLit','POINT(-92.837486 34.438328)')) return xdmp:sql("select * from builds where ST_Equals(interiorPoint,@pointLit) order by geoid limit 20", (), $map) (: ==> returns rows whose 'interiorPoint' column match the DE-9IM relationship Equals with the provided WKT point :)
xquery version "1.0-ml"; (: GeoSPARQL example using geof:sfEquals() :) let $map := map:new(map:entry('pointLit','POINT(-92.837486 34.438328)')) let $query:= ' PREFIX my: <http://example.org/ApplicationSchema#> PREFIX geoml: <http://marklogic.com/geospatial#> PREFIX cts: <http://marklogic.com/cts#> PREFIX geof: <http://www.opengis.net/def/function/geosparql/> SELECT * WHERE { ?s my:hasExactGeometry ?o FILTER geof:sfEquals(?o, ?pointLit, ''coordinate-system=wgs84'') } ORDER BY ?s' return sem:sparql($query,$map) (: ==> rows representing geometries in a triple's object in the wgs84 coordinate system that fulfill the EQUALS DE-9IM relation with the WKT point 'pointLit', ordered by subject :)
Stack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.