summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorSergey Fedoseev <fedoseev.sergey@gmail.com>2018-06-22 14:13:49 +0500
committerTim Graham <timograham@gmail.com>2018-06-22 09:54:41 -0400
commit9af83a62e7639567afde8b76ce70e7982873e4c5 (patch)
tree598627b6d657017b6fa7be5add62640ec59acfe4 /docs
parent7cdeb23ae7ef2d125276840ff298dbb9683959f2 (diff)
Added description, example, and SQL equivalents for equals and same_as GIS lookups.
Diffstat (limited to 'docs')
-rw-r--r--docs/ref/contrib/gis/geoquerysets.txt32
1 files changed, 32 insertions, 0 deletions
diff --git a/docs/ref/contrib/gis/geoquerysets.txt b/docs/ref/contrib/gis/geoquerysets.txt
index b7bd83b3a3..d88454ed28 100644
--- a/docs/ref/contrib/gis/geoquerysets.txt
+++ b/docs/ref/contrib/gis/geoquerysets.txt
@@ -279,6 +279,21 @@ SpatiaLite ``Disjoint(poly, geom)``
*Availability*: `PostGIS <https://postgis.net/docs/ST_Equals.html>`__,
Oracle, MySQL, SpatiaLite, PGRaster (Conversion)
+Tests if the geometry field is spatially equal to the lookup geometry.
+
+Example::
+
+ Zipcode.objects.filter(poly__equals=geom)
+
+========== =================================================
+Backend SQL Equivalent
+========== =================================================
+PostGIS ``ST_Equals(poly, geom)``
+Oracle ``SDO_EQUAL(poly, geom)``
+MySQL ``MBREquals(poly, geom)``
+SpatiaLite ``Equals(poly, geom)``
+========== =================================================
+
.. fieldlookup:: exact
.. fieldlookup:: same_as
@@ -288,6 +303,23 @@ Oracle, MySQL, SpatiaLite, PGRaster (Conversion)
*Availability*: `PostGIS <https://postgis.net/docs/ST_Geometry_Same.html>`__,
Oracle, MySQL, SpatiaLite, PGRaster (Bilateral)
+Tests if the geometry field is "equal" to the lookup geometry. On Oracle and
+SpatiaLite it tests spatial equality, while on MySQL and PostGIS it tests
+equality of bounding boxes.
+
+Example::
+
+ Zipcode.objects.filter(poly=geom)
+
+========== =================================================
+Backend SQL Equivalent
+========== =================================================
+PostGIS ``poly ~= geom``
+Oracle ``SDO_EQUAL(poly, geom)``
+MySQL ``MBREquals(poly, geom)``
+SpatiaLite ``Equals(poly, geom)``
+========== =================================================
+
.. fieldlookup:: intersects
``intersects``