diff options
| author | Sergey Fedoseev <fedoseev.sergey@gmail.com> | 2017-03-23 22:07:50 +0500 |
|---|---|---|
| committer | Tim Graham <timograham@gmail.com> | 2017-03-23 13:07:50 -0400 |
| commit | 075f13e44f203ee04f0c3abffc7d7a86c672cfe8 (patch) | |
| tree | 957778fd5e381f47324fb06ba78db9dc9757fc0a | |
| parent | b00ee5471df5741ff3c0f55321eba676c978618a (diff) | |
Refs #27556, #27488 -- Updated support backends docs for isvalid lookup.
| -rw-r--r-- | docs/ref/contrib/gis/geoquerysets.txt | 14 |
1 files changed, 11 insertions, 3 deletions
diff --git a/docs/ref/contrib/gis/geoquerysets.txt b/docs/ref/contrib/gis/geoquerysets.txt index 8ca79b2ad0..d7135a7c39 100644 --- a/docs/ref/contrib/gis/geoquerysets.txt +++ b/docs/ref/contrib/gis/geoquerysets.txt @@ -306,7 +306,8 @@ SpatiaLite ``Intersects(poly, geom)`` ``isvalid`` ----------- -*Availability*: `PostGIS <https://postgis.net/docs/ST_IsValid.html>`__ +*Availability*: `PostGIS <https://postgis.net/docs/ST_IsValid.html>`__, +Oracle, SpatiaLite Tests if the geometry is valid. @@ -314,9 +315,16 @@ Example:: Zipcode.objects.filter(poly__isvalid=True) -PostGIS equivalent:: +=================== ================================================================ +Backend SQL Equivalent +=================== ================================================================ +PostGIS, SpatiaLite ``ST_IsValid(poly)`` +Oracle ``SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(poly, 0.05) = 'TRUE'`` +=================== ================================================================ + +.. versionchanged:: 1.11 - SELECT ... WHERE ST_IsValid(poly) + Oracle and SpatiaLite support was added. .. fieldlookup:: overlaps |