Search: queryset - djangodocs.org

contains_properly

Availability: PostGIS, PGRaster (Bilateral) Returns true if the lookup geometry intersects the interior of the geometry field, but not the boundary (or exterior).

dev

coveredby

Reference GIS QuerySet API Reference

Availability: PostGIS, Oracle, MariaDB, MySQL, PGRaster (Bilateral), SpatiaLite Tests if no point in the geometry field is outside the lookup geometry.

dev

covers

Reference GIS QuerySet API Reference

Availability: PostGIS, Oracle, MySQL, PGRaster (Bilateral), SpatiaLite Tests if no point in the lookup geometry is outside the geometry field.

dev

crosses

Reference GIS QuerySet API Reference

Availability: PostGIS, MariaDB, MySQL, SpatiaLite, PGRaster (Conversion) Tests if the geometry field spatially crosses the lookup geometry.

dev

disjoint

Reference GIS QuerySet API Reference

Availability: PostGIS, Oracle, MariaDB, MySQL, SpatiaLite, PGRaster (Bilateral) Tests if the geometry field is spatially disjoint from the lookup geometry.

dev

equals

Reference GIS QuerySet API Reference

Availability: PostGIS, Oracle, MariaDB, MySQL, SpatiaLite, PGRaster (Conversion) Tests if the geometry field is spatially equal to the lookup geometry.

dev

Availability: PostGIS, Oracle, MariaDB, MySQL, SpatiaLite, PGRaster (Bilateral) Tests if the geometry field is “equal” to the lookup geometry. On Oracle, MySQL, and SpatiaLite, it tests spatial equality, while on PostGIS it tests equality of bounding boxes.

dev

intersects

Reference GIS QuerySet API Reference

Availability: PostGIS, Oracle, MariaDB, MySQL, SpatiaLite, PGRaster (Bilateral) Tests if the geometry field spatially intersects the lookup geometry.

dev

isempty

Reference GIS QuerySet API Reference

Availability: PostGIS, SpatiaLite Tests if the geometry is empty. Example: NOTE: Changed in version 6.1: SpatiaLite support was added.

dev

isvalid

Reference GIS QuerySet API Reference

Availability: MariaDB, MySQL, PostGIS, Oracle, SpatiaLite Tests if the geometry is valid. Example: | Backend | SQL Equivalent | | --- | --- | | MariaDB, MySQL, PostGIS, SpatiaLite | ST_IsValid(poly) | | Oracle | SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(poly, 0.05) = 'TRUE' |

dev

geom_type

Reference GIS QuerySet API Reference

Availability: PostGIS, Oracle 23c+, MariaDB, MySQL, SpatiaLite Returns the geometry type of the geometry field.

dev

num_dimensions

Reference GIS QuerySet API Reference

NOTE: Added in version 6.1. Availability: PostGIS, SpatiaLite Returns the number of dimensions used by the geometry. Example: | Backend | SQL Equivalent | | --- | --- | | PostGIS, SpatiaLite | ST_NDims(geom) |

dev

overlaps

Reference GIS QuerySet API Reference

Availability: PostGIS, Oracle, MariaDB, MySQL, SpatiaLite, PGRaster (Bilateral) Tests if the geometry field spatially overlaps the lookup geometry.

dev

relate

Reference GIS QuerySet API Reference

Availability: PostGIS, MariaDB, Oracle, SpatiaLite, PGRaster (Conversion) Tests if the geometry field is spatially related to the lookup geometry by the values given in the given pattern.

dev

MariaDB, PostGIS, and SpatiaLite

Reference GIS QuerySet API Reference

On these spatial backends the intersection pattern is a string comprising nine characters, which define intersections between the interior, boundary, and exterior of the geometry field and the lookup geometry.

dev

Oracle

Reference GIS QuerySet API Reference

Here the relation pattern is comprised of at least one of the nine relation strings: TOUCH, OVERLAPBDYDISJOINT, OVERLAPBDYINTERSECT, EQUAL, INSIDE, COVEREDBY, CONTAINS, COVERS, ON, and ANYINTERACT. Multiple strings may be combined with the logical Boolean operator OR, for example, 'inside+touch'.

dev

touches

Reference GIS QuerySet API Reference

Availability: PostGIS, Oracle, MariaDB, MySQL, SpatiaLite Tests if the geometry field spatially touches the lookup geometry.

dev

within

Reference GIS QuerySet API Reference

Availability: PostGIS, Oracle, MariaDB, MySQL, SpatiaLite, PGRaster (Bilateral) Tests if the geometry field is spatially within the lookup geometry.

dev

left

Reference GIS QuerySet API Reference

Availability: PostGIS, PGRaster (Conversion) Tests if the geometry field’s bounding box is strictly to the left of the lookup geometry’s bounding box. Example: PostGIS equivalent:

dev

right

Reference GIS QuerySet API Reference

Availability: PostGIS, PGRaster (Conversion) Tests if the geometry field’s bounding box is strictly to the right of the lookup geometry’s bounding box. Example: PostGIS equivalent:

dev