diff options
Diffstat (limited to 'docs')
| -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 |