<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>GeoQuerySet API Reference — Django 1.5.9 documentation</title> <link rel="stylesheet" href="../../../_static/default.css" type="text/css" /> <link rel="stylesheet" href="../../../_static/pygments.css" type="text/css" /> <script type="text/javascript"> var DOCUMENTATION_OPTIONS = { URL_ROOT: '../../../', VERSION: '1.5.9', COLLAPSE_INDEX: false, FILE_SUFFIX: '.html', HAS_SOURCE: true }; </script> <script type="text/javascript" src="../../../_static/jquery.js"></script> <script type="text/javascript" src="../../../_static/underscore.js"></script> <script type="text/javascript" src="../../../_static/doctools.js"></script> <link rel="top" title="Django 1.5.9 documentation" href="../../../index.html" /> <link rel="up" title="GeoDjango" href="index.html" /> <link rel="next" title="Measurement Objects" href="measure.html" /> <link rel="prev" title="GeoDjango Database API" href="db-api.html" /> <script type="text/javascript" src="../../../templatebuiltins.js"></script> <script type="text/javascript"> (function($) { if (!django_template_builtins) { // templatebuiltins.js missing, do nothing. return; } $(document).ready(function() { // Hyperlink Django template tags and filters var base = "../../templates/builtins.html"; if (base == "#") { // Special case for builtins.html itself base = ""; } // Tags are keywords, class '.k' $("div.highlight\\-html\\+django span.k").each(function(i, elem) { var tagname = $(elem).text(); if ($.inArray(tagname, django_template_builtins.ttags) != -1) { var fragment = tagname.replace(/_/, '-'); $(elem).html("<a href='" + base + "#" + fragment + "'>" + tagname + "</a>"); } }); // Filters are functions, class '.nf' $("div.highlight\\-html\\+django span.nf").each(function(i, elem) { var filtername = $(elem).text(); if ($.inArray(filtername, django_template_builtins.tfilters) != -1) { var fragment = filtername.replace(/_/, '-'); $(elem).html("<a href='" + base + "#" + fragment + "'>" + filtername + "</a>"); } }); }); })(jQuery); </script> </head> <body> <div class="document"> <div id="custom-doc" class="yui-t6"> <div id="hd"> <h1><a href="../../../index.html">Django 1.5.9 documentation</a></h1> <div id="global-nav"> <a title="Home page" href="../../../index.html">Home</a> | <a title="Table of contents" href="../../../contents.html">Table of contents</a> | <a title="Global index" href="../../../genindex.html">Index</a> | <a title="Module index" href="../../../py-modindex.html">Modules</a> </div> <div class="nav"> « <a href="db-api.html" title="GeoDjango Database API">previous</a> | <a href="../../index.html" title="API Reference" accesskey="U">up</a> | <a href="measure.html" title="Measurement Objects">next</a> »</div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g" id="ref-contrib-gis-geoquerysets"> <div class="section" id="s-geoqueryset-api-reference"> <span id="s-ref-geoquerysets"></span><span id="geoqueryset-api-reference"></span><span id="ref-geoquerysets"></span><h1>GeoQuerySet API Reference<a class="headerlink" href="#geoqueryset-api-reference" title="Permalink to this headline">¶</a></h1> <dl class="class"> <dt id="django.contrib.gis.db.models.GeoQuerySet"> <em class="property">class </em><tt class="descname">GeoQuerySet</tt>(<span class="optional">[</span><em>model=None</em><span class="optional">]</span>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <div class="section" id="s-spatial-lookups"> <span id="s-id1"></span><span id="spatial-lookups"></span><span id="id1"></span><h2>Spatial Lookups<a class="headerlink" href="#spatial-lookups" title="Permalink to this headline">¶</a></h2> <p>Just like when using the <a class="reference internal" href="../../models/querysets.html#queryset-api"><em>QuerySet API</em></a>, interaction with <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> by <a class="reference internal" href="../../../topics/db/queries.html#chaining-filters"><em>chaining filters</em></a>. Instead of the regular Django <a class="reference internal" href="../../models/querysets.html#field-lookups"><em>Field lookups</em></a>, the spatial lookups in this section are available for <a class="reference internal" href="model-api.html#django.contrib.gis.db.models.GeometryField" title="django.contrib.gis.db.models.GeometryField"><tt class="xref py py-class docutils literal"><span class="pre">GeometryField</span></tt></a>.</p> <p>For an introduction, see the <a class="reference internal" href="db-api.html#spatial-lookups-intro"><em>spatial lookups introduction</em></a>. For an overview of what lookups are compatible with a particular spatial backend, refer to the <a class="reference internal" href="db-api.html#spatial-lookup-compatibility"><em>spatial lookup compatibility table</em></a>.</p> <div class="section" id="s-bbcontains"> <span id="s-std:fieldlookup-bbcontains"></span><span id="bbcontains"></span><span id="std:fieldlookup-bbcontains"></span><h3>bbcontains<a class="headerlink" href="#bbcontains" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, MySQL, SpatiaLite</p> <p>Tests if the geometry field’s bounding box completely contains the lookup geometry’s bounding box.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__bbcontains</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="27%" /> <col width="73%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">poly</span> <span class="pre">~</span> <span class="pre">geom</span></tt></td> </tr> <tr class="row-odd"><td>MySQL</td> <td><tt class="docutils literal"><span class="pre">MBRContains(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-even"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">MbrContains(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-bboverlaps"> <span id="s-std:fieldlookup-bboverlaps"></span><span id="bboverlaps"></span><span id="std:fieldlookup-bboverlaps"></span><h3>bboverlaps<a class="headerlink" href="#bboverlaps" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, MySQL, SpatiaLite</p> <p>Tests if the geometry field’s bounding box overlaps the lookup geometry’s bounding box.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__bboverlaps</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="27%" /> <col width="73%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">poly</span> <span class="pre">&&</span> <span class="pre">geom</span></tt></td> </tr> <tr class="row-odd"><td>MySQL</td> <td><tt class="docutils literal"><span class="pre">MBROverlaps(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-even"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">MbrOverlaps(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-contained"> <span id="s-std:fieldlookup-contained"></span><span id="contained"></span><span id="std:fieldlookup-contained"></span><h3>contained<a class="headerlink" href="#contained" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, MySQL, SpatiaLite</p> <p>Tests if the geometry field’s bounding box is completely contained by the lookup geometry’s bounding box.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__contained</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="28%" /> <col width="72%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">poly</span> <span class="pre">@</span> <span class="pre">geom</span></tt></td> </tr> <tr class="row-odd"><td>MySQL</td> <td><tt class="docutils literal"><span class="pre">MBRWithin(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-even"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">MbrWithin(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-contains"> <span id="s-std:fieldlookup-gis-contains"></span><span id="contains"></span><span id="std:fieldlookup-gis-contains"></span><h3>contains<a class="headerlink" href="#contains" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle, MySQL, SpatiaLite</p> <p>Tests if the geometry field spatially contains the lookup geometry.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__contains</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="26%" /> <col width="74%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_Contains(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_CONTAINS(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-even"><td>MySQL</td> <td><tt class="docutils literal"><span class="pre">MBRContains(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">Contains(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-contains-properly"> <span id="s-std:fieldlookup-contains_properly"></span><span id="contains-properly"></span><span id="std:fieldlookup-contains_properly"></span><h3>contains_properly<a class="headerlink" href="#contains-properly" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS</p> <p>Returns true if the lookup geometry intersects the interior of the geometry field, but not the boundary (or exterior). <a class="footnote-reference" href="#fncontainsproperly" id="id2">[4]</a></p> <div class="admonition note"> <p class="first admonition-title">Note</p> <p class="last">Requires PostGIS 1.4 and above.</p> </div> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__contains_properly</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="22%" /> <col width="78%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_ContainsProperly(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-coveredby"> <span id="s-std:fieldlookup-coveredby"></span><span id="coveredby"></span><span id="std:fieldlookup-coveredby"></span><h3>coveredby<a class="headerlink" href="#coveredby" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle</p> <p>Tests if no point in the geometry field is outside the lookup geometry. <a class="footnote-reference" href="#fncovers" id="id3">[3]</a></p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__coveredby</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="26%" /> <col width="74%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_CoveredBy(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_COVEREDBY(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-covers"> <span id="s-std:fieldlookup-covers"></span><span id="covers"></span><span id="std:fieldlookup-covers"></span><h3>covers<a class="headerlink" href="#covers" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle</p> <p>Tests if no point in the lookup geometry is outside the geometry field. <a class="footnote-reference" href="#fncovers" id="id4">[3]</a></p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__covers</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="28%" /> <col width="72%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_Covers(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_COVERS(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-crosses"> <span id="s-std:fieldlookup-crosses"></span><span id="crosses"></span><span id="std:fieldlookup-crosses"></span><h3>crosses<a class="headerlink" href="#crosses" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, SpatiaLite</p> <p>Tests if the geometry field spatially crosses the lookup geometry.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__crosses</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="28%" /> <col width="72%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_Crosses(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">Crosses(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-disjoint"> <span id="s-std:fieldlookup-disjoint"></span><span id="disjoint"></span><span id="std:fieldlookup-disjoint"></span><h3>disjoint<a class="headerlink" href="#disjoint" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle, MySQL, SpatiaLite</p> <p>Tests if the geometry field is spatially disjoint from the lookup geometry.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__disjoint</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="17%" /> <col width="83%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_Disjoint(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_GEOM.RELATE(poly,</span> <span class="pre">'DISJOINT',</span> <span class="pre">geom,</span> <span class="pre">0.05)</span></tt></td> </tr> <tr class="row-even"><td>MySQL</td> <td><tt class="docutils literal"><span class="pre">MBRDisjoint(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">Disjoint(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-equals"> <span id="equals"></span><h3>equals<a class="headerlink" href="#equals" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle, MySQL, SpatiaLite</p> <span class="target" id="std:fieldlookup-exact"></span></div> <div class="section" id="s-exact-same-as"> <span id="s-std:fieldlookup-same_as"></span><span id="exact-same-as"></span><span id="std:fieldlookup-same_as"></span><h3>exact, same_as<a class="headerlink" href="#exact-same-as" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle, MySQL, SpatiaLite</p> </div> <div class="section" id="s-intersects"> <span id="s-std:fieldlookup-intersects"></span><span id="intersects"></span><span id="std:fieldlookup-intersects"></span><h3>intersects<a class="headerlink" href="#intersects" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle, MySQL, SpatiaLite</p> <p>Tests if the geometry field spatially intersects the lookup geometry.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__intersects</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="17%" /> <col width="83%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_Intersects(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_OVERLAPBDYINTERSECT(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-even"><td>MySQL</td> <td><tt class="docutils literal"><span class="pre">MBRIntersects(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">Intersects(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-overlaps"> <span id="s-std:fieldlookup-overlaps"></span><span id="overlaps"></span><span id="std:fieldlookup-overlaps"></span><h3>overlaps<a class="headerlink" href="#overlaps" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle, MySQL, SpatiaLite</p> </div> <div class="section" id="s-relate"> <span id="s-std:fieldlookup-relate"></span><span id="relate"></span><span id="std:fieldlookup-relate"></span><h3>relate<a class="headerlink" href="#relate" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle, SpatiaLite</p> <p>Tests if the geometry field is spatially related to the lookup geometry by the values given in the given pattern. This lookup requires a tuple parameter, <tt class="docutils literal"><span class="pre">(geom,</span> <span class="pre">pattern)</span></tt>; the form of <tt class="docutils literal"><span class="pre">pattern</span></tt> will depend on the spatial backend:</p> <div class="section" id="s-postgis-spatialite"> <span id="postgis-spatialite"></span><h4>PostGIS & SpatiaLite<a class="headerlink" href="#postgis-spatialite" title="Permalink to this headline">¶</a></h4> <p>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. The intersection pattern matrix may only use the following characters: <tt class="docutils literal"><span class="pre">1</span></tt>, <tt class="docutils literal"><span class="pre">2</span></tt>, <tt class="docutils literal"><span class="pre">T</span></tt>, <tt class="docutils literal"><span class="pre">F</span></tt>, or <tt class="docutils literal"><span class="pre">*</span></tt>. This lookup type allows users to “fine tune” a specific geometric relationship consistent with the DE-9IM model. <a class="footnote-reference" href="#fnde9im" id="id5">[1]</a></p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="c"># A tuple lookup parameter is used to specify the geometry and</span> <span class="c"># the intersection pattern (the pattern here is for 'contains').</span> <span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__relate</span><span class="p">(</span><span class="n">geom</span><span class="p">,</span> <span class="s">'T*T***FF*'</span><span class="p">))</span> </pre></div> </div> <p>PostGIS SQL equivalent:</p> <div class="highlight-python"><pre>SELECT ... WHERE ST_Relate(poly, geom, 'T*T***FF*')</pre> </div> <p>SpatiaLite SQL equivalent:</p> <div class="highlight-python"><pre>SELECT ... WHERE Relate(poly, geom, 'T*T***FF*')</pre> </div> </div> <div class="section" id="s-oracle"> <span id="oracle"></span><h4>Oracle<a class="headerlink" href="#oracle" title="Permalink to this headline">¶</a></h4> <p>Here the relation pattern is comprised at least one of the nine relation strings: <tt class="docutils literal"><span class="pre">TOUCH</span></tt>, <tt class="docutils literal"><span class="pre">OVERLAPBDYDISJOINT</span></tt>, <tt class="docutils literal"><span class="pre">OVERLAPBDYINTERSECT</span></tt>, <tt class="docutils literal"><span class="pre">EQUAL</span></tt>, <tt class="docutils literal"><span class="pre">INSIDE</span></tt>, <tt class="docutils literal"><span class="pre">COVEREDBY</span></tt>, <tt class="docutils literal"><span class="pre">CONTAINS</span></tt>, <tt class="docutils literal"><span class="pre">COVERS</span></tt>, <tt class="docutils literal"><span class="pre">ON</span></tt>, and <tt class="docutils literal"><span class="pre">ANYINTERACT</span></tt>. Multiple strings may be combined with the logical Boolean operator OR, for example, <tt class="docutils literal"><span class="pre">'inside+touch'</span></tt>. <a class="footnote-reference" href="#fnsdorelate" id="id6">[2]</a> The relation strings are case-insensitive.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__relate</span><span class="p">(</span><span class="n">geom</span><span class="p">,</span> <span class="s">'anyinteract'</span><span class="p">))</span> </pre></div> </div> <p>Oracle SQL equivalent:</p> <div class="highlight-python"><pre>SELECT ... WHERE SDO_RELATE(poly, geom, 'anyinteract')</pre> </div> </div> </div> <div class="section" id="s-touches"> <span id="s-std:fieldlookup-touches"></span><span id="touches"></span><span id="std:fieldlookup-touches"></span><h3>touches<a class="headerlink" href="#touches" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle, MySQL, SpatiaLite</p> <p>Tests if the geometry field spatially touches the lookup geometry.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__touches</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="28%" /> <col width="72%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_Touches(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>MySQL</td> <td><tt class="docutils literal"><span class="pre">MBRTouches(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-even"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_TOUCH(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">Touches(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-within"> <span id="s-std:fieldlookup-within"></span><span id="within"></span><span id="std:fieldlookup-within"></span><h3>within<a class="headerlink" href="#within" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle, MySQL, SpatiaLite</p> <p>Tests if the geometry field is spatially within the lookup geometry.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__within</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="28%" /> <col width="72%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_Within(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>MySQL</td> <td><tt class="docutils literal"><span class="pre">MBRWithin(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-even"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_INSIDE(poly,</span> <span class="pre">geom)</span></tt></td> </tr> <tr class="row-odd"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">Within(poly,</span> <span class="pre">geom)</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-left"> <span id="s-std:fieldlookup-left"></span><span id="left"></span><span id="std:fieldlookup-left"></span><h3>left<a class="headerlink" href="#left" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS</p> <p>Tests if the geometry field’s bounding box is strictly to the left of the lookup geometry’s bounding box.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__left</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <p>PostGIS equivalent:</p> <div class="highlight-python"><pre>SELECT ... WHERE poly << geom</pre> </div> </div> <div class="section" id="s-right"> <span id="s-std:fieldlookup-right"></span><span id="right"></span><span id="std:fieldlookup-right"></span><h3>right<a class="headerlink" href="#right" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS</p> <p>Tests if the geometry field’s bounding box is strictly to the right of the lookup geometry’s bounding box.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__right</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <p>PostGIS equivalent:</p> <div class="highlight-python"><pre>SELECT ... WHERE poly >> geom</pre> </div> </div> <div class="section" id="s-overlaps-left"> <span id="s-std:fieldlookup-overlaps_left"></span><span id="overlaps-left"></span><span id="std:fieldlookup-overlaps_left"></span><h3>overlaps_left<a class="headerlink" href="#overlaps-left" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS</p> <p>Tests if the geometry field’s bounding box overlaps or is to the left of the lookup geometry’s bounding box.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__overlaps_left</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <p>PostGIS equivalent:</p> <div class="highlight-python"><pre>SELECT ... WHERE poly &< geom</pre> </div> </div> <div class="section" id="s-overlaps-right"> <span id="s-std:fieldlookup-overlaps_right"></span><span id="overlaps-right"></span><span id="std:fieldlookup-overlaps_right"></span><h3>overlaps_right<a class="headerlink" href="#overlaps-right" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS</p> <p>Tests if the geometry field’s bounding box overlaps or is to the right of the lookup geometry’s bounding box.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__overlaps_right</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <p>PostGIS equivalent:</p> <div class="highlight-python"><pre>SELECT ... WHERE poly &> geom</pre> </div> </div> <div class="section" id="s-overlaps-above"> <span id="s-std:fieldlookup-overlaps_above"></span><span id="overlaps-above"></span><span id="std:fieldlookup-overlaps_above"></span><h3>overlaps_above<a class="headerlink" href="#overlaps-above" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS</p> <p>Tests if the geometry field’s bounding box overlaps or is above the lookup geometry’s bounding box.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__overlaps_above</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <p>PostGIS equivalent:</p> <div class="highlight-python"><pre>SELECT ... WHERE poly |&> geom</pre> </div> </div> <div class="section" id="s-overlaps-below"> <span id="s-std:fieldlookup-overlaps_below"></span><span id="overlaps-below"></span><span id="std:fieldlookup-overlaps_below"></span><h3>overlaps_below<a class="headerlink" href="#overlaps-below" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS</p> <p>Tests if the geometry field’s bounding box overlaps or is below the lookup geometry’s bounding box.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__overlaps_below</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <p>PostGIS equivalent:</p> <div class="highlight-python"><pre>SELECT ... WHERE poly &<| geom</pre> </div> </div> <div class="section" id="s-strictly-above"> <span id="s-std:fieldlookup-strictly_above"></span><span id="strictly-above"></span><span id="std:fieldlookup-strictly_above"></span><h3>strictly_above<a class="headerlink" href="#strictly-above" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS</p> <p>Tests if the geometry field’s bounding box is strictly above the lookup geometry’s bounding box.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__strictly_above</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <p>PostGIS equivalent:</p> <div class="highlight-python"><pre>SELECT ... WHERE poly |>> geom</pre> </div> </div> <div class="section" id="s-strictly-below"> <span id="s-std:fieldlookup-strictly_below"></span><span id="strictly-below"></span><span id="std:fieldlookup-strictly_below"></span><h3>strictly_below<a class="headerlink" href="#strictly-below" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS</p> <p>Tests if the geometry field’s bounding box is strictly above the lookup geometry’s bounding box.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__strictly_above</span><span class="o">=</span><span class="n">geom</span><span class="p">)</span> </pre></div> </div> <p>PostGIS equivalent:</p> <div class="highlight-python"><pre>SELECT ... WHERE poly |>> geom</pre> </div> </div> </div> <div class="section" id="s-distance-lookups"> <span id="s-id7"></span><span id="distance-lookups"></span><span id="id7"></span><h2>Distance Lookups<a class="headerlink" href="#distance-lookups" title="Permalink to this headline">¶</a></h2> <p><em>Availability</em>: PostGIS, Oracle, SpatiaLite</p> <p>For an overview on performing distance queries, please refer to the <a class="reference internal" href="db-api.html#distance-queries"><em>distance queries introduction</em></a>.</p> <p>Distance lookups take the following form:</p> <div class="highlight-python"><pre><field>__<distance lookup>=(<geometry>, <distance value>[, 'spheroid'])</pre> </div> <p>The value passed into a distance lookup is a tuple; the first two values are mandatory, and are the geometry to calculate distances to, and a distance value (either a number in units of the field or a <a class="reference internal" href="measure.html#django.contrib.gis.measure.Distance" title="django.contrib.gis.measure.Distance"><tt class="xref py py-class docutils literal"><span class="pre">Distance</span></tt></a> object). On every distance lookup but <a class="reference internal" href="#std:fieldlookup-dwithin"><tt class="xref std std-lookup docutils literal"><span class="pre">dwithin</span></tt></a>, an optional third element, <tt class="docutils literal"><span class="pre">'spheroid'</span></tt>, may be included to tell GeoDjango to use the more accurate spheroid distance calculation functions on fields with a geodetic coordinate system (e.g., <tt class="docutils literal"><span class="pre">ST_Distance_Spheroid</span></tt> would be used instead of <tt class="docutils literal"><span class="pre">ST_Distance_Sphere</span></tt>).</p> <div class="section" id="s-distance-gt"> <span id="s-std:fieldlookup-distance_gt"></span><span id="distance-gt"></span><span id="std:fieldlookup-distance_gt"></span><h3>distance_gt<a class="headerlink" href="#distance-gt" title="Permalink to this headline">¶</a></h3> <p>Returns models where the distance to the geometry field from the lookup geometry is greater than the given distance value.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__distance_gt</span><span class="o">=</span><span class="p">(</span><span class="n">geom</span><span class="p">,</span> <span class="n">D</span><span class="p">(</span><span class="n">m</span><span class="o">=</span><span class="mi">5</span><span class="p">)))</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="18%" /> <col width="82%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_Distance(poly,</span> <span class="pre">geom)</span> <span class="pre">></span> <span class="pre">5</span></tt></td> </tr> <tr class="row-odd"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_GEOM.SDO_DISTANCE(poly,</span> <span class="pre">geom,</span> <span class="pre">0.05)</span> <span class="pre">></span> <span class="pre">5</span></tt></td> </tr> <tr class="row-even"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">Distance(poly,</span> <span class="pre">geom)</span> <span class="pre">></span> <span class="pre">5</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-distance-gte"> <span id="s-std:fieldlookup-distance_gte"></span><span id="distance-gte"></span><span id="std:fieldlookup-distance_gte"></span><h3>distance_gte<a class="headerlink" href="#distance-gte" title="Permalink to this headline">¶</a></h3> <p>Returns models where the distance to the geometry field from the lookup geometry is greater than or equal to the given distance value.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__distance_gte</span><span class="o">=</span><span class="p">(</span><span class="n">geom</span><span class="p">,</span> <span class="n">D</span><span class="p">(</span><span class="n">m</span><span class="o">=</span><span class="mi">5</span><span class="p">)))</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="17%" /> <col width="83%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_Distance(poly,</span> <span class="pre">geom)</span> <span class="pre">>=</span> <span class="pre">5</span></tt></td> </tr> <tr class="row-odd"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_GEOM.SDO_DISTANCE(poly,</span> <span class="pre">geom,</span> <span class="pre">0.05)</span> <span class="pre">>=</span> <span class="pre">5</span></tt></td> </tr> <tr class="row-even"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">Distance(poly,</span> <span class="pre">geom)</span> <span class="pre">>=</span> <span class="pre">5</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-distance-lt"> <span id="s-std:fieldlookup-distance_lt"></span><span id="distance-lt"></span><span id="std:fieldlookup-distance_lt"></span><h3>distance_lt<a class="headerlink" href="#distance-lt" title="Permalink to this headline">¶</a></h3> <p>Returns models where the distance to the geometry field from the lookup geometry is less than the given distance value.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__distance_lt</span><span class="o">=</span><span class="p">(</span><span class="n">geom</span><span class="p">,</span> <span class="n">D</span><span class="p">(</span><span class="n">m</span><span class="o">=</span><span class="mi">5</span><span class="p">)))</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="18%" /> <col width="82%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_Distance(poly,</span> <span class="pre">geom)</span> <span class="pre"><</span> <span class="pre">5</span></tt></td> </tr> <tr class="row-odd"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_GEOM.SDO_DISTANCE(poly,</span> <span class="pre">geom,</span> <span class="pre">0.05)</span> <span class="pre"><</span> <span class="pre">5</span></tt></td> </tr> <tr class="row-even"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">Distance(poly,</span> <span class="pre">geom)</span> <span class="pre"><</span> <span class="pre">5</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-distance-lte"> <span id="s-std:fieldlookup-distance_lte"></span><span id="distance-lte"></span><span id="std:fieldlookup-distance_lte"></span><h3>distance_lte<a class="headerlink" href="#distance-lte" title="Permalink to this headline">¶</a></h3> <p>Returns models where the distance to the geometry field from the lookup geometry is less than or equal to the given distance value.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__distance_lte</span><span class="o">=</span><span class="p">(</span><span class="n">geom</span><span class="p">,</span> <span class="n">D</span><span class="p">(</span><span class="n">m</span><span class="o">=</span><span class="mi">5</span><span class="p">)))</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="17%" /> <col width="83%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_Distance(poly,</span> <span class="pre">geom)</span> <span class="pre"><=</span> <span class="pre">5</span></tt></td> </tr> <tr class="row-odd"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_GEOM.SDO_DISTANCE(poly,</span> <span class="pre">geom,</span> <span class="pre">0.05)</span> <span class="pre"><=</span> <span class="pre">5</span></tt></td> </tr> <tr class="row-even"><td>SpatiaLite</td> <td><tt class="docutils literal"><span class="pre">Distance(poly,</span> <span class="pre">geom)</span> <span class="pre"><=</span> <span class="pre">5</span></tt></td> </tr> </tbody> </table> </div> <div class="section" id="s-dwithin"> <span id="s-std:fieldlookup-dwithin"></span><span id="dwithin"></span><span id="std:fieldlookup-dwithin"></span><h3>dwithin<a class="headerlink" href="#dwithin" title="Permalink to this headline">¶</a></h3> <p>Returns models where the distance to the geometry field from the lookup geometry are within the given distance from one another.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__dwithin</span><span class="o">=</span><span class="p">(</span><span class="n">geom</span><span class="p">,</span> <span class="n">D</span><span class="p">(</span><span class="n">m</span><span class="o">=</span><span class="mi">5</span><span class="p">)))</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="21%" /> <col width="79%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Backend</th> <th class="head">SQL Equivalent</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>PostGIS</td> <td><tt class="docutils literal"><span class="pre">ST_DWithin(poly,</span> <span class="pre">geom,</span> <span class="pre">5)</span></tt></td> </tr> <tr class="row-odd"><td>Oracle</td> <td><tt class="docutils literal"><span class="pre">SDO_WITHIN_DISTANCE(poly,</span> <span class="pre">geom,</span> <span class="pre">5)</span></tt></td> </tr> </tbody> </table> <div class="admonition note"> <p class="first admonition-title">Note</p> <p class="last">This lookup is not available on SpatiaLite.</p> </div> </div> </div> <div class="section" id="s-geoqueryset-methods"> <span id="s-std:fieldlookup-equals"></span><span id="geoqueryset-methods"></span><span id="std:fieldlookup-equals"></span><h2><tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> Methods<a class="headerlink" href="#geoqueryset-methods" title="Permalink to this headline">¶</a></h2> <p><tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> methods specify that a spatial operation be performed on each patial operation on each geographic field in the queryset and store its output in a new attribute on the model (which is generally the name of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> method).</p> <p>There are also aggregate <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> methods which return a single value instead of a queryset. This section will describe the API and availability of every <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> method available in GeoDjango.</p> <div class="admonition note"> <p class="first admonition-title">Note</p> <p class="last">What methods are available depend on your spatial backend. See the <a class="reference internal" href="db-api.html#geoqueryset-method-compatibility"><em>compatibility table</em></a> for more details.</p> </div> <p>With a few exceptions, the following keyword arguments may be used with all <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> methods:</p> <table class="docutils"> <colgroup> <col width="28%" /> <col width="72%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Keyword Argument</th> <th class="head">Description</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td><tt class="docutils literal"><span class="pre">field_name</span></tt></td> <td><p class="first">By default, <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> methods use the first geographic field encountered in the model. This keyword should be used to specify another geographic field (e.g., <tt class="docutils literal"><span class="pre">field_name='point2'</span></tt>) when there are multiple geographic fields in a model.</p> <p class="last">On PostGIS, the <tt class="docutils literal"><span class="pre">field_name</span></tt> keyword may also be used on geometry fields in models that are related via a <tt class="docutils literal"><span class="pre">ForeignKey</span></tt> relation (e.g., <tt class="docutils literal"><span class="pre">field_name='related__point'</span></tt>).</p> </td> </tr> <tr class="row-odd"><td><tt class="docutils literal"><span class="pre">model_att</span></tt></td> <td><p class="first">By default, <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> methods typically attach their output in an attribute with the same name as the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> method. Setting this keyword with the desired attribute name will override this default behavior. For example, <tt class="docutils literal"><span class="pre">qs</span> <span class="pre">=</span> <span class="pre">Zipcode.objects.centroid(model_att='c')</span></tt> will attach the centroid of the <tt class="docutils literal"><span class="pre">Zipcode</span></tt> geometry field in a <tt class="docutils literal"><span class="pre">c</span></tt> attribute on every model rather than in a <tt class="docutils literal"><span class="pre">centroid</span></tt> attribute.</p> <p class="last">This keyword is required if a method name clashes with an existing <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> method – if you wanted to use the <tt class="docutils literal"><span class="pre">area()</span></tt> method on model with a <tt class="docutils literal"><span class="pre">PolygonField</span></tt> named <tt class="docutils literal"><span class="pre">area</span></tt>, for example.</p> </td> </tr> </tbody> </table> <div class="section" id="s-measurement"> <span id="measurement"></span><h3>Measurement<a class="headerlink" href="#measurement" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle, SpatiaLite</p> <div class="section" id="s-area"> <span id="area"></span><h4><tt class="docutils literal"><span class="pre">area</span></tt><a class="headerlink" href="#area" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.area"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">area</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.area" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the area of the geographic field in an <tt class="docutils literal"><span class="pre">area</span></tt> attribute on each element of this GeoQuerySet.</p> </div> <div class="section" id="s-distance"> <span id="distance"></span><h4><tt class="docutils literal"><span class="pre">distance</span></tt><a class="headerlink" href="#distance" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.distance"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">distance</tt>(<em>geom</em>, <em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.distance" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>This method takes a geometry as a parameter, and attaches a <tt class="docutils literal"><span class="pre">distance</span></tt> attribute to every model in the returned queryset that contains the distance (as a <a class="reference internal" href="measure.html#django.contrib.gis.measure.Distance" title="django.contrib.gis.measure.Distance"><tt class="xref py py-class docutils literal"><span class="pre">Distance</span></tt></a> object) to the given geometry.</p> <p>In the following example (taken from the <a class="reference external" href="https://github.com/django/django/blob/master/django/contrib/gis/tests/distapp/models.py">GeoDjango distance tests</a>), the distance from the <a class="reference external" href="http://en.wikipedia.org/wiki/Tasmania">Tasmanian</a> city of Hobart to every other <a class="reference internal" href="model-api.html#django.contrib.gis.db.models.PointField" title="django.contrib.gis.db.models.PointField"><tt class="xref py py-class docutils literal"><span class="pre">PointField</span></tt></a> in the <tt class="docutils literal"><span class="pre">AustraliaCity</span></tt> queryset is calculated:</p> <div class="highlight-python"><div class="highlight"><pre><span class="gp">>>> </span><span class="n">pnt</span> <span class="o">=</span> <span class="n">AustraliaCity</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="n">name</span><span class="o">=</span><span class="s">'Hobart'</span><span class="p">)</span><span class="o">.</span><span class="n">point</span> <span class="gp">>>> </span><span class="k">for</span> <span class="n">city</span> <span class="ow">in</span> <span class="n">AustraliaCity</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">distance</span><span class="p">(</span><span class="n">pnt</span><span class="p">):</span> <span class="k">print</span><span class="p">(</span><span class="n">city</span><span class="o">.</span><span class="n">name</span><span class="p">,</span> <span class="n">city</span><span class="o">.</span><span class="n">distance</span><span class="p">)</span> <span class="go">Wollongong 990071.220408 m</span> <span class="go">Shellharbour 972804.613941 m</span> <span class="go">Thirroul 1002334.36351 m</span> <span class="go">Mittagong 975691.632637 m</span> <span class="go">Batemans Bay 834342.185561 m</span> <span class="go">Canberra 598140.268959 m</span> <span class="go">Melbourne 575337.765042 m</span> <span class="go">Sydney 1056978.87363 m</span> <span class="go">Hobart 0.0 m</span> <span class="go">Adelaide 1162031.83522 m</span> <span class="go">Hillsdale 1049200.46122 m</span> </pre></div> </div> <div class="admonition note"> <p class="first admonition-title">Note</p> <p class="last">Because the <tt class="docutils literal"><span class="pre">distance</span></tt> attribute is a <a class="reference internal" href="measure.html#django.contrib.gis.measure.Distance" title="django.contrib.gis.measure.Distance"><tt class="xref py py-class docutils literal"><span class="pre">Distance</span></tt></a> object, you can easily express the value in the units of your choice. For example, <tt class="docutils literal"><span class="pre">city.distance.mi</span></tt> is the distance value in miles and <tt class="docutils literal"><span class="pre">city.distance.km</span></tt> is the distance value in kilometers. See the <a class="reference internal" href="measure.html#ref-measure"><em>Measurement Objects</em></a> for usage details and the list of <a class="reference internal" href="measure.html#supported-units"><em>Supported units</em></a>.</p> </div> </div> <div class="section" id="s-length"> <span id="length"></span><h4><tt class="docutils literal"><span class="pre">length</span></tt><a class="headerlink" href="#length" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.length"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">length</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.length" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the length of the geometry field in a <tt class="docutils literal"><span class="pre">length</span></tt> attribute (a <a class="reference internal" href="measure.html#django.contrib.gis.measure.Distance" title="django.contrib.gis.measure.Distance"><tt class="xref py py-class docutils literal"><span class="pre">Distance</span></tt></a> object) on each model in the queryset.</p> </div> <div class="section" id="s-perimeter"> <span id="perimeter"></span><h4><tt class="docutils literal"><span class="pre">perimeter</span></tt><a class="headerlink" href="#perimeter" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.perimeter"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">perimeter</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.perimeter" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the perimeter of the geometry field in a <tt class="docutils literal"><span class="pre">perimeter</span></tt> attribute (a <a class="reference internal" href="measure.html#django.contrib.gis.measure.Distance" title="django.contrib.gis.measure.Distance"><tt class="xref py py-class docutils literal"><span class="pre">Distance</span></tt></a> object) on each model in the queryset.</p> </div> </div> <div class="section" id="s-geometry-relationships"> <span id="geometry-relationships"></span><h3>Geometry Relationships<a class="headerlink" href="#geometry-relationships" title="Permalink to this headline">¶</a></h3> <p>The following methods take no arguments, and attach geometry objects each element of the <a class="reference internal" href="#django.contrib.gis.db.models.GeoQuerySet" title="django.contrib.gis.db.models.GeoQuerySet"><tt class="xref py py-class docutils literal"><span class="pre">GeoQuerySet</span></tt></a> that is the result of relationship function evaluated on the geometry field.</p> <div class="section" id="s-centroid"> <span id="centroid"></span><h4><tt class="docutils literal"><span class="pre">centroid</span></tt><a class="headerlink" href="#centroid" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.centroid"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">centroid</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.centroid" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, Oracle, SpatiaLite</p> <p>Returns the <tt class="docutils literal"><span class="pre">centroid</span></tt> value for the geographic field in a <tt class="docutils literal"><span class="pre">centroid</span></tt> attribute on each element of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt>.</p> </div> <div class="section" id="s-envelope"> <span id="envelope"></span><h4><tt class="docutils literal"><span class="pre">envelope</span></tt><a class="headerlink" href="#envelope" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.envelope"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">envelope</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.envelope" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, SpatiaLite</p> <p>Returns a geometry representing the bounding box of the geometry field in an <tt class="docutils literal"><span class="pre">envelope</span></tt> attribute on each element of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt>.</p> </div> <div class="section" id="s-point-on-surface"> <span id="point-on-surface"></span><h4><tt class="docutils literal"><span class="pre">point_on_surface</span></tt><a class="headerlink" href="#point-on-surface" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.point_on_surface"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">point_on_surface</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.point_on_surface" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, Oracle, SpatiaLite</p> <p>Returns a Point geometry guaranteed to lie on the surface of the geometry field in a <tt class="docutils literal"><span class="pre">point_on_surface</span></tt> attribute on each element of the queryset; otherwise sets with None.</p> </div> </div> <div class="section" id="s-geometry-editors"> <span id="geometry-editors"></span><h3>Geometry Editors<a class="headerlink" href="#geometry-editors" title="Permalink to this headline">¶</a></h3> <div class="section" id="s-force-rhr"> <span id="force-rhr"></span><h4><tt class="docutils literal"><span class="pre">force_rhr</span></tt><a class="headerlink" href="#force-rhr" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.force_rhr"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">force_rhr</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.force_rhr" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS</p> <p>Returns a modified version of the polygon/multipolygon in which all of the vertices follow the Right-Hand-Rule, and attaches as a <tt class="docutils literal"><span class="pre">force_rhr</span></tt> attribute on each element of the queryset.</p> </div> <div class="section" id="s-reverse-geom"> <span id="reverse-geom"></span><h4><tt class="docutils literal"><span class="pre">reverse_geom</span></tt><a class="headerlink" href="#reverse-geom" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.reverse_geom"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">reverse_geom</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.reverse_geom" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, Oracle</p> <p>Reverse the coordinate order of the geometry field, and attaches as a <tt class="docutils literal"><span class="pre">reverse</span></tt> attribute on each element of the queryset.</p> </div> <div class="section" id="s-scale"> <span id="scale"></span><h4><tt class="docutils literal"><span class="pre">scale</span></tt><a class="headerlink" href="#scale" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.scale"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">scale</tt>(<em>x</em>, <em>y</em>, <em>z=0.0</em>, <em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.scale" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, SpatiaLite</p> </div> <div class="section" id="s-snap-to-grid"> <span id="snap-to-grid"></span><h4><tt class="docutils literal"><span class="pre">snap_to_grid</span></tt><a class="headerlink" href="#snap-to-grid" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.snap_to_grid"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">snap_to_grid</tt>(<em>*args</em>, <em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.snap_to_grid" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Snap all points of the input geometry to the grid. How the geometry is snapped to the grid depends on how many numeric (either float, integer, or long) arguments are given.</p> <table class="docutils"> <colgroup> <col width="26%" /> <col width="74%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Number of Arguments</th> <th class="head">Description</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td>1</td> <td>A single size to snap bot the X and Y grids to.</td> </tr> <tr class="row-odd"><td>2</td> <td>X and Y sizes to snap the grid to.</td> </tr> <tr class="row-even"><td>4</td> <td>X, Y sizes and the corresponding X, Y origins.</td> </tr> </tbody> </table> </div> <div class="section" id="s-transform"> <span id="transform"></span><h4><tt class="docutils literal"><span class="pre">transform</span></tt><a class="headerlink" href="#transform" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.transform"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">transform</tt>(<em>srid=4326</em>, <em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.transform" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, Oracle, SpatiaLite</p> <p>The <tt class="docutils literal"><span class="pre">transform</span></tt> method transforms the geometry field of a model to the spatial reference system specified by the <tt class="docutils literal"><span class="pre">srid</span></tt> parameter. If no <tt class="docutils literal"><span class="pre">srid</span></tt> is given, then 4326 (WGS84) is used by default.</p> <div class="admonition note"> <p class="first admonition-title">Note</p> <p class="last">Unlike other <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> methods, <tt class="docutils literal"><span class="pre">transform</span></tt> stores its output “in-place”. In other words, no new attribute for the transformed geometry is placed on the models.</p> </div> <div class="admonition note"> <p class="first admonition-title">Note</p> <p class="last">What spatial reference system an integer SRID corresponds to may depend on the spatial database used. In other words, the SRID numbers used for Oracle are not necessarily the same as those used by PostGIS.</p> </div> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="gp">>>> </span><span class="n">qs</span> <span class="o">=</span> <span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">all</span><span class="p">()</span><span class="o">.</span><span class="n">transform</span><span class="p">()</span> <span class="c"># Transforms to WGS84</span> <span class="gp">>>> </span><span class="n">qs</span> <span class="o">=</span> <span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">all</span><span class="p">()</span><span class="o">.</span><span class="n">transform</span><span class="p">(</span><span class="mi">32140</span><span class="p">)</span> <span class="c"># Transforming to "NAD83 / Texas South Central"</span> <span class="gp">>>> </span><span class="k">print</span><span class="p">(</span><span class="n">qs</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span><span class="o">.</span><span class="n">poly</span><span class="o">.</span><span class="n">srid</span><span class="p">)</span> <span class="go">32140</span> <span class="gp">>>> </span><span class="k">print</span><span class="p">(</span><span class="n">qs</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span><span class="o">.</span><span class="n">poly</span><span class="p">)</span> <span class="go">POLYGON ((234055.1698884720099159 4937796.9232223574072123 ...</span> </pre></div> </div> </div> <div class="section" id="s-translate"> <span id="translate"></span><h4><tt class="docutils literal"><span class="pre">translate</span></tt><a class="headerlink" href="#translate" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.translate"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">translate</tt>(<em>x</em>, <em>y</em>, <em>z=0.0</em>, <em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.translate" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, SpatiaLite</p> <p>Translates the geometry field to a new location using the given numeric parameters as offsets.</p> </div> </div> <div class="section" id="s-geometry-operations"> <span id="geometry-operations"></span><h3>Geometry Operations<a class="headerlink" href="#geometry-operations" title="Permalink to this headline">¶</a></h3> <p><em>Availability</em>: PostGIS, Oracle, SpatiaLite</p> <p>The following methods all take a geometry as a parameter and attach a geometry to each element of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> that is the result of the operation.</p> <div class="section" id="s-difference"> <span id="difference"></span><h4><tt class="docutils literal"><span class="pre">difference</span></tt><a class="headerlink" href="#difference" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.difference"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">difference</tt>(<em>geom</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.difference" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the spatial difference of the geographic field with the given geometry in a <tt class="docutils literal"><span class="pre">difference</span></tt> attribute on each element of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt>.</p> </div> <div class="section" id="s-intersection"> <span id="intersection"></span><h4><tt class="docutils literal"><span class="pre">intersection</span></tt><a class="headerlink" href="#intersection" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.intersection"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">intersection</tt>(<em>geom</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.intersection" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the spatial intersection of the geographic field with the given geometry in an <tt class="docutils literal"><span class="pre">intersection</span></tt> attribute on each element of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt>.</p> </div> <div class="section" id="s-sym-difference"> <span id="sym-difference"></span><h4><tt class="docutils literal"><span class="pre">sym_difference</span></tt><a class="headerlink" href="#sym-difference" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.sym_difference"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">sym_difference</tt>(<em>geom</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.sym_difference" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the symmetric difference of the geographic field with the given geometry in a <tt class="docutils literal"><span class="pre">sym_difference</span></tt> attribute on each element of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt>.</p> </div> <div class="section" id="s-union"> <span id="union"></span><h4><tt class="docutils literal"><span class="pre">union</span></tt><a class="headerlink" href="#union" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.union"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">union</tt>(<em>geom</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.union" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the union of the geographic field with the given geometry in an <tt class="docutils literal"><span class="pre">union</span></tt> attribute on each element of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt>.</p> </div> </div> <div class="section" id="s-geometry-output"> <span id="geometry-output"></span><h3>Geometry Output<a class="headerlink" href="#geometry-output" title="Permalink to this headline">¶</a></h3> <p>The following <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> methods will return an attribute that has the value of the geometry field in each model converted to the requested output format.</p> <div class="section" id="s-geohash"> <span id="geohash"></span><h4><tt class="docutils literal"><span class="pre">geohash</span></tt><a class="headerlink" href="#geohash" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.geohash"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">geohash</tt>(<em>precision=20</em>, <em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.geohash" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Attaches a <tt class="docutils literal"><span class="pre">geohash</span></tt> attribute to every model the queryset containing the <a class="reference external" href="http://geohash.org/">GeoHash</a> representation of the geometry.</p> </div> <div class="section" id="s-geojson"> <span id="geojson"></span><h4><tt class="docutils literal"><span class="pre">geojson</span></tt><a class="headerlink" href="#geojson" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.geojson"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">geojson</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.geojson" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, SpatiaLite</p> <div class="versionchanged"> <span class="title">Changed in Django 1.5:</span> <tt class="docutils literal"><span class="pre">geojson</span></tt> support for Spatialite > 3.0 has been added.</div> <p>Attaches a <tt class="docutils literal"><span class="pre">geojson</span></tt> attribute to every model in the queryset that contains the <a class="reference external" href="http://geojson.org/">GeoJSON</a> representation of the geometry.</p> <table class="docutils"> <colgroup> <col width="28%" /> <col width="72%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Keyword Argument</th> <th class="head">Description</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td><tt class="docutils literal"><span class="pre">precision</span></tt></td> <td>It may be used to specify the number of significant digits for the coordinates in the GeoJSON representation – the default value is 8.</td> </tr> <tr class="row-odd"><td><tt class="docutils literal"><span class="pre">crs</span></tt></td> <td>Set this to <tt class="docutils literal"><span class="pre">True</span></tt> if you want the coordinate reference system to be included in the returned GeoJSON.</td> </tr> <tr class="row-even"><td><tt class="docutils literal"><span class="pre">bbox</span></tt></td> <td>Set this to <tt class="docutils literal"><span class="pre">True</span></tt> if you want the bounding box to be included in the returned GeoJSON.</td> </tr> </tbody> </table> </div> <div class="section" id="s-gml"> <span id="gml"></span><h4><tt class="docutils literal"><span class="pre">gml</span></tt><a class="headerlink" href="#gml" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.gml"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">gml</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.gml" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, Oracle, SpatiaLite</p> <p>Attaches a <tt class="docutils literal"><span class="pre">gml</span></tt> attribute to every model in the queryset that contains the <a class="reference external" href="http://en.wikipedia.org/wiki/Geography_Markup_Language">Geographic Markup Language (GML)</a> representation of the geometry.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="gp">>>> </span><span class="n">qs</span> <span class="o">=</span> <span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">all</span><span class="p">()</span><span class="o">.</span><span class="n">gml</span><span class="p">()</span> <span class="gp">>>> </span><span class="k">print</span><span class="p">(</span><span class="n">qs</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span><span class="o">.</span><span class="n">gml</span><span class="p">)</span> <span class="go"><gml:Polygon srsName="EPSG:4326"><gml:OuterBoundaryIs>-147.78711,70.245363 ... -147.78711,70.245363</gml:OuterBoundaryIs></gml:Polygon></span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="28%" /> <col width="72%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Keyword Argument</th> <th class="head">Description</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td><tt class="docutils literal"><span class="pre">precision</span></tt></td> <td>This keyword is for PostGIS only. It may be used to specify the number of significant digits for the coordinates in the GML representation – the default value is 8.</td> </tr> <tr class="row-odd"><td><tt class="docutils literal"><span class="pre">version</span></tt></td> <td>This keyword is for PostGIS only. It may be used to specify the GML version used, and may only be values of 2 or 3. The default value is 2.</td> </tr> </tbody> </table> </div> <div class="section" id="s-kml"> <span id="kml"></span><h4><tt class="docutils literal"><span class="pre">kml</span></tt><a class="headerlink" href="#kml" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.kml"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">kml</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.kml" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, SpatiaLite</p> <p>Attaches a <tt class="docutils literal"><span class="pre">kml</span></tt> attribute to every model in the queryset that contains the <a class="reference external" href="https://developers.google.com/kml/documentation/">Keyhole Markup Language (KML)</a> representation of the geometry fields. It should be noted that the contents of the KML are transformed to WGS84 if necessary.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="gp">>>> </span><span class="n">qs</span> <span class="o">=</span> <span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">all</span><span class="p">()</span><span class="o">.</span><span class="n">kml</span><span class="p">()</span> <span class="gp">>>> </span><span class="k">print</span><span class="p">(</span><span class="n">qs</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span><span class="o">.</span><span class="n">kml</span><span class="p">)</span> <span class="go"><Polygon><outerBoundaryIs><LinearRing><coordinates>-103.04135,36.217596,0 ... -103.04135,36.217596,0</coordinates></LinearRing></outerBoundaryIs></Polygon></span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="28%" /> <col width="72%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Keyword Argument</th> <th class="head">Description</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td><tt class="docutils literal"><span class="pre">precision</span></tt></td> <td>This keyword may be used to specify the number of significant digits for the coordinates in the KML representation – the default value is 8.</td> </tr> </tbody> </table> </div> <div class="section" id="s-svg"> <span id="svg"></span><h4><tt class="docutils literal"><span class="pre">svg</span></tt><a class="headerlink" href="#svg" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.svg"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">svg</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.svg" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, SpatiaLite</p> <p>Attaches a <tt class="docutils literal"><span class="pre">svg</span></tt> attribute to every model in the queryset that contains the <a class="reference external" href="http://www.w3.org/Graphics/SVG/">Scalable Vector Graphics (SVG)</a> path data of the geometry fields.</p> <table class="docutils"> <colgroup> <col width="28%" /> <col width="72%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Keyword Argument</th> <th class="head">Description</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td><tt class="docutils literal"><span class="pre">relative</span></tt></td> <td>If set to <tt class="docutils literal"><span class="pre">True</span></tt>, the path data will be implemented in terms of relative moves. Defaults to <tt class="docutils literal"><span class="pre">False</span></tt>, meaning that absolute moves are used instead.</td> </tr> <tr class="row-odd"><td><tt class="docutils literal"><span class="pre">precision</span></tt></td> <td>This keyword may be used to specify the number of significant digits for the coordinates in the SVG representation – the default value is 8.</td> </tr> </tbody> </table> </div> </div> <div class="section" id="s-miscellaneous"> <span id="miscellaneous"></span><h3>Miscellaneous<a class="headerlink" href="#miscellaneous" title="Permalink to this headline">¶</a></h3> <div class="section" id="s-mem-size"> <span id="mem-size"></span><h4><tt class="docutils literal"><span class="pre">mem_size</span></tt><a class="headerlink" href="#mem-size" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.mem_size"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">mem_size</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.mem_size" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS</p> <p>Returns the memory size (number of bytes) that the geometry field takes in a <tt class="docutils literal"><span class="pre">mem_size</span></tt> attribute on each element of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt>.</p> </div> <div class="section" id="s-num-geom"> <span id="num-geom"></span><h4><tt class="docutils literal"><span class="pre">num_geom</span></tt><a class="headerlink" href="#num-geom" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.num_geom"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">num_geom</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.num_geom" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, Oracle, SpatiaLite</p> <p>Returns the number of geometries in a <tt class="docutils literal"><span class="pre">num_geom</span></tt> attribute on each element of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> if the geometry field is a collection (e.g., a <tt class="docutils literal"><span class="pre">GEOMETRYCOLLECTION</span></tt> or <tt class="docutils literal"><span class="pre">MULTI*</span></tt> field); otherwise sets with <tt class="docutils literal"><span class="pre">None</span></tt>.</p> </div> <div class="section" id="s-num-points"> <span id="num-points"></span><h4><tt class="docutils literal"><span class="pre">num_points</span></tt><a class="headerlink" href="#num-points" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.num_points"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">num_points</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.num_points" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, Oracle, SpatiaLite</p> <p>Returns the number of points in the first linestring in the geometry field in a <tt class="docutils literal"><span class="pre">num_points</span></tt> attribute on each element of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt>; otherwise sets with <tt class="docutils literal"><span class="pre">None</span></tt>.</p> </div> </div> </div> <div class="section" id="s-spatial-aggregates"> <span id="spatial-aggregates"></span><h2>Spatial Aggregates<a class="headerlink" href="#spatial-aggregates" title="Permalink to this headline">¶</a></h2> <div class="section" id="s-aggregate-methods"> <span id="aggregate-methods"></span><h3>Aggregate Methods<a class="headerlink" href="#aggregate-methods" title="Permalink to this headline">¶</a></h3> <div class="section" id="s-collect"> <span id="collect"></span><h4><tt class="docutils literal"><span class="pre">collect</span></tt><a class="headerlink" href="#collect" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.collect"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">collect</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.collect" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS</p> <p>Returns a <tt class="docutils literal"><span class="pre">GEOMETRYCOLLECTION</span></tt> or a <tt class="docutils literal"><span class="pre">MULTI</span></tt> geometry object from the geometry column. This is analagous to a simplified version of the <a class="reference internal" href="#django.contrib.gis.db.models.GeoQuerySet.unionagg" title="django.contrib.gis.db.models.GeoQuerySet.unionagg"><tt class="xref py py-meth docutils literal"><span class="pre">GeoQuerySet.unionagg()</span></tt></a> method, except it can be several orders of magnitude faster than peforming a union because it simply rolls up geometries into a collection or multi object, not caring about dissolving boundaries.</p> </div> <div class="section" id="s-extent"> <span id="extent"></span><h4><tt class="docutils literal"><span class="pre">extent</span></tt><a class="headerlink" href="#extent" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.extent"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">extent</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.extent" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, Oracle</p> <p>Returns the extent of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> as a four-tuple, comprising the lower left coordinate and the upper right coordinate.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="gp">>>> </span><span class="n">qs</span> <span class="o">=</span> <span class="n">City</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">name__in</span><span class="o">=</span><span class="p">(</span><span class="s">'Houston'</span><span class="p">,</span> <span class="s">'Dallas'</span><span class="p">))</span> <span class="gp">>>> </span><span class="k">print</span><span class="p">(</span><span class="n">qs</span><span class="o">.</span><span class="n">extent</span><span class="p">())</span> <span class="go">(-96.8016128540039, 29.7633724212646, -95.3631439208984, 32.782058715820)</span> </pre></div> </div> </div> <div class="section" id="s-extent3d"> <span id="extent3d"></span><h4><tt class="docutils literal"><span class="pre">extent3d</span></tt><a class="headerlink" href="#extent3d" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.extent3d"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">extent3d</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.extent3d" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS</p> <p>Returns the 3D extent of the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> as a six-tuple, comprising the lower left coordinate and upper right coordinate.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="gp">>>> </span><span class="n">qs</span> <span class="o">=</span> <span class="n">City</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">name__in</span><span class="o">=</span><span class="p">(</span><span class="s">'Houston'</span><span class="p">,</span> <span class="s">'Dallas'</span><span class="p">))</span> <span class="gp">>>> </span><span class="k">print</span><span class="p">(</span><span class="n">qs</span><span class="o">.</span><span class="n">extent3d</span><span class="p">())</span> <span class="go">(-96.8016128540039, 29.7633724212646, 0, -95.3631439208984, 32.782058715820, 0)</span> </pre></div> </div> </div> <div class="section" id="s-make-line"> <span id="make-line"></span><h4><tt class="docutils literal"><span class="pre">make_line</span></tt><a class="headerlink" href="#make-line" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.make_line"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">make_line</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.make_line" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS</p> <p>Returns a <tt class="docutils literal"><span class="pre">LineString</span></tt> constructed from the point field geometries in the <tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt>. Currently, ordering the queryset has no effect.</p> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="gp">>>> </span><span class="k">print</span><span class="p">(</span><span class="n">City</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">name__in</span><span class="o">=</span><span class="p">(</span><span class="s">'Houston'</span><span class="p">,</span> <span class="s">'Dallas'</span><span class="p">))</span><span class="o">.</span><span class="n">make_line</span><span class="p">())</span> <span class="go">LINESTRING (-95.3631510000000020 29.7633739999999989, -96.8016109999999941 32.7820570000000018)</span> </pre></div> </div> </div> <div class="section" id="s-unionagg"> <span id="unionagg"></span><h4><tt class="docutils literal"><span class="pre">unionagg</span></tt><a class="headerlink" href="#unionagg" title="Permalink to this headline">¶</a></h4> <dl class="method"> <dt id="django.contrib.gis.db.models.GeoQuerySet.unionagg"> <tt class="descclassname">GeoQuerySet.</tt><tt class="descname">unionagg</tt>(<em>**kwargs</em>)<a class="headerlink" href="#django.contrib.gis.db.models.GeoQuerySet.unionagg" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p><em>Availability</em>: PostGIS, Oracle, SpatiaLite</p> <p>This method returns a <a class="reference internal" href="geos.html#django.contrib.gis.geos.GEOSGeometry" title="django.contrib.gis.geos.GEOSGeometry"><tt class="xref py py-class docutils literal"><span class="pre">GEOSGeometry</span></tt></a> object comprising the union of every geometry in the queryset. Please note that use of <tt class="docutils literal"><span class="pre">unionagg</span></tt> is processor intensive and may take a significant amount of time on large querysets.</p> <div class="admonition note"> <p class="first admonition-title">Note</p> <p class="last">If the computation time for using this method is too expensive, consider using <a class="reference internal" href="#django.contrib.gis.db.models.GeoQuerySet.collect" title="django.contrib.gis.db.models.GeoQuerySet.collect"><tt class="xref py py-meth docutils literal"><span class="pre">GeoQuerySet.collect()</span></tt></a> instead.</p> </div> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="gp">>>> </span><span class="n">u</span> <span class="o">=</span> <span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">unionagg</span><span class="p">()</span> <span class="c"># This may take a long time.</span> <span class="gp">>>> </span><span class="n">u</span> <span class="o">=</span> <span class="n">Zipcode</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">poly__within</span><span class="o">=</span><span class="n">bbox</span><span class="p">)</span><span class="o">.</span><span class="n">unionagg</span><span class="p">()</span> <span class="c"># A more sensible approach.</span> </pre></div> </div> <table class="docutils"> <colgroup> <col width="28%" /> <col width="72%" /> </colgroup> <thead valign="bottom"> <tr class="row-odd"><th class="head">Keyword Argument</th> <th class="head">Description</th> </tr> </thead> <tbody valign="top"> <tr class="row-even"><td><tt class="docutils literal"><span class="pre">tolerance</span></tt></td> <td>This keyword is for Oracle only. It is for the tolerance value used by the <tt class="docutils literal"><span class="pre">SDOAGGRTYPE</span></tt> procedure; the <a class="reference external" href="http://docs.oracle.com/html/B14255_01/sdo_intro.htm#sthref150">Oracle documentation</a> has more details.</td> </tr> </tbody> </table> </div> </div> <div class="section" id="s-aggregate-functions"> <span id="aggregate-functions"></span><h3>Aggregate Functions<a class="headerlink" href="#aggregate-functions" title="Permalink to this headline">¶</a></h3> <p>Example:</p> <div class="highlight-python"><div class="highlight"><pre><span class="gp">>>> </span><span class="kn">from</span> <span class="nn">django.contrib.gis.db.models</span> <span class="kn">import</span> <span class="n">Extent</span><span class="p">,</span> <span class="n">Union</span> <span class="gp">>>> </span><span class="n">WorldBorder</span><span class="o">.</span><span class="n">objects</span><span class="o">.</span><span class="n">aggregate</span><span class="p">(</span><span class="n">Extent</span><span class="p">(</span><span class="s">'mpoly'</span><span class="p">),</span> <span class="n">Union</span><span class="p">(</span><span class="s">'mpoly'</span><span class="p">))</span> </pre></div> </div> <div class="section" id="s-id16"> <span id="id16"></span><h4><tt class="docutils literal"><span class="pre">Collect</span></tt><a class="headerlink" href="#id16" title="Permalink to this headline">¶</a></h4> <dl class="class"> <dt id="django.contrib.gis.db.models.Collect"> <em class="property">class </em><tt class="descname">Collect</tt>(<em>geo_field</em>)<a class="headerlink" href="#django.contrib.gis.db.models.Collect" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the same as the <a class="reference internal" href="#django.contrib.gis.db.models.GeoQuerySet.collect" title="django.contrib.gis.db.models.GeoQuerySet.collect"><tt class="xref py py-meth docutils literal"><span class="pre">GeoQuerySet.collect()</span></tt></a> aggregate method.</p> </div> <div class="section" id="s-id17"> <span id="id17"></span><h4><tt class="docutils literal"><span class="pre">Extent</span></tt><a class="headerlink" href="#id17" title="Permalink to this headline">¶</a></h4> <dl class="class"> <dt id="django.contrib.gis.db.models.Extent"> <em class="property">class </em><tt class="descname">Extent</tt>(<em>geo_field</em>)<a class="headerlink" href="#django.contrib.gis.db.models.Extent" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the same as the <a class="reference internal" href="#django.contrib.gis.db.models.GeoQuerySet.extent" title="django.contrib.gis.db.models.GeoQuerySet.extent"><tt class="xref py py-meth docutils literal"><span class="pre">GeoQuerySet.extent()</span></tt></a> aggregate method.</p> </div> <div class="section" id="s-id18"> <span id="id18"></span><h4><tt class="docutils literal"><span class="pre">Extent3D</span></tt><a class="headerlink" href="#id18" title="Permalink to this headline">¶</a></h4> <dl class="class"> <dt id="django.contrib.gis.db.models.Extent3D"> <em class="property">class </em><tt class="descname">Extent3D</tt>(<em>geo_field</em>)<a class="headerlink" href="#django.contrib.gis.db.models.Extent3D" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the same as the <a class="reference internal" href="#django.contrib.gis.db.models.GeoQuerySet.extent3d" title="django.contrib.gis.db.models.GeoQuerySet.extent3d"><tt class="xref py py-meth docutils literal"><span class="pre">GeoQuerySet.extent3d()</span></tt></a> aggregate method.</p> </div> <div class="section" id="s-makeline"> <span id="makeline"></span><h4><tt class="docutils literal"><span class="pre">MakeLine</span></tt><a class="headerlink" href="#makeline" title="Permalink to this headline">¶</a></h4> <dl class="class"> <dt id="django.contrib.gis.db.models.MakeLine"> <em class="property">class </em><tt class="descname">MakeLine</tt>(<em>geo_field</em>)<a class="headerlink" href="#django.contrib.gis.db.models.MakeLine" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the same as the <a class="reference internal" href="#django.contrib.gis.db.models.GeoQuerySet.make_line" title="django.contrib.gis.db.models.GeoQuerySet.make_line"><tt class="xref py py-meth docutils literal"><span class="pre">GeoQuerySet.make_line()</span></tt></a> aggregate method.</p> </div> <div class="section" id="s-id19"> <span id="id19"></span><h4><tt class="docutils literal"><span class="pre">Union</span></tt><a class="headerlink" href="#id19" title="Permalink to this headline">¶</a></h4> <dl class="class"> <dt id="django.contrib.gis.db.models.Union"> <em class="property">class </em><tt class="descname">Union</tt>(<em>geo_field</em>)<a class="headerlink" href="#django.contrib.gis.db.models.Union" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <p>Returns the same as the <a class="reference internal" href="#django.contrib.gis.db.models.GeoQuerySet.union" title="django.contrib.gis.db.models.GeoQuerySet.union"><tt class="xref py py-meth docutils literal"><span class="pre">GeoQuerySet.union()</span></tt></a> aggregate method.</p> <p class="rubric">Footnotes</p> <table class="docutils footnote" frame="void" id="fnde9im" rules="none"> <colgroup><col class="label" /><col /></colgroup> <tbody valign="top"> <tr><td class="label"><a class="fn-backref" href="#id5">[1]</a></td><td><em>See</em> <a class="reference external" href="http://www.opengis.org/docs/99-049.pdf">OpenGIS Simple Feature Specification For SQL</a>, at Ch. 2.1.13.2, p. 2-13 (The Dimensionally Extended Nine-Intersection Model).</td></tr> </tbody> </table> <table class="docutils footnote" frame="void" id="fnsdorelate" rules="none"> <colgroup><col class="label" /><col /></colgroup> <tbody valign="top"> <tr><td class="label"><a class="fn-backref" href="#id6">[2]</a></td><td><em>See</em> <a class="reference external" href="http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_operat.htm#sthref845">SDO_RELATE documentation</a>, from Ch. 11 of the Oracle Spatial User’s Guide and Manual.</td></tr> </tbody> </table> <table class="docutils footnote" frame="void" id="fncovers" rules="none"> <colgroup><col class="label" /><col /></colgroup> <tbody valign="top"> <tr><td class="label">[3]</td><td><em>(<a class="fn-backref" href="#id3">1</a>, <a class="fn-backref" href="#id4">2</a>)</em> For an explanation of this routine, read <a class="reference external" href="http://lin-ear-th-inking.blogspot.com/2007/06/subtleties-of-ogc-covers-spatial.html">Quirks of the “Contains” Spatial Predicate</a> by Martin Davis (a PostGIS developer).</td></tr> </tbody> </table> <table class="docutils footnote" frame="void" id="fncontainsproperly" rules="none"> <colgroup><col class="label" /><col /></colgroup> <tbody valign="top"> <tr><td class="label"><a class="fn-backref" href="#id2">[4]</a></td><td>Refer to the PostGIS <tt class="docutils literal"><span class="pre">ST_ContainsProperly</span></tt> <a class="reference external" href="http://postgis.refractions.net/documentation/manual-1.4/ST_ContainsProperly.html">documentation</a> for more details.</td></tr> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> <div class="yui-b" id="sidebar"> <div class="sphinxsidebar"> <div class="sphinxsidebarwrapper"> <h3><a href="../../../contents.html">Table Of Contents</a></h3> <ul> <li><a class="reference internal" href="#">GeoQuerySet API Reference</a><ul> <li><a class="reference internal" href="#spatial-lookups">Spatial Lookups</a><ul> <li><a class="reference internal" href="#bbcontains">bbcontains</a></li> <li><a class="reference internal" href="#bboverlaps">bboverlaps</a></li> <li><a class="reference internal" href="#contained">contained</a></li> <li><a class="reference internal" href="#contains">contains</a></li> <li><a class="reference internal" href="#contains-properly">contains_properly</a></li> <li><a class="reference internal" href="#coveredby">coveredby</a></li> <li><a class="reference internal" href="#covers">covers</a></li> <li><a class="reference internal" href="#crosses">crosses</a></li> <li><a class="reference internal" href="#disjoint">disjoint</a></li> <li><a class="reference internal" href="#equals">equals</a></li> <li><a class="reference internal" href="#exact-same-as">exact, same_as</a></li> <li><a class="reference internal" href="#intersects">intersects</a></li> <li><a class="reference internal" href="#overlaps">overlaps</a></li> <li><a class="reference internal" href="#relate">relate</a><ul> <li><a class="reference internal" href="#postgis-spatialite">PostGIS & SpatiaLite</a></li> <li><a class="reference internal" href="#oracle">Oracle</a></li> </ul> </li> <li><a class="reference internal" href="#touches">touches</a></li> <li><a class="reference internal" href="#within">within</a></li> <li><a class="reference internal" href="#left">left</a></li> <li><a class="reference internal" href="#right">right</a></li> <li><a class="reference internal" href="#overlaps-left">overlaps_left</a></li> <li><a class="reference internal" href="#overlaps-right">overlaps_right</a></li> <li><a class="reference internal" href="#overlaps-above">overlaps_above</a></li> <li><a class="reference internal" href="#overlaps-below">overlaps_below</a></li> <li><a class="reference internal" href="#strictly-above">strictly_above</a></li> <li><a class="reference internal" href="#strictly-below">strictly_below</a></li> </ul> </li> <li><a class="reference internal" href="#distance-lookups">Distance Lookups</a><ul> <li><a class="reference internal" href="#distance-gt">distance_gt</a></li> <li><a class="reference internal" href="#distance-gte">distance_gte</a></li> <li><a class="reference internal" href="#distance-lt">distance_lt</a></li> <li><a class="reference internal" href="#distance-lte">distance_lte</a></li> <li><a class="reference internal" href="#dwithin">dwithin</a></li> </ul> </li> <li><a class="reference internal" href="#geoqueryset-methods"><tt class="docutils literal"><span class="pre">GeoQuerySet</span></tt> Methods</a><ul> <li><a class="reference internal" href="#measurement">Measurement</a><ul> <li><a class="reference internal" href="#area"><tt class="docutils literal"><span class="pre">area</span></tt></a></li> <li><a class="reference internal" href="#distance"><tt class="docutils literal"><span class="pre">distance</span></tt></a></li> <li><a class="reference internal" href="#length"><tt class="docutils literal"><span class="pre">length</span></tt></a></li> <li><a class="reference internal" href="#perimeter"><tt class="docutils literal"><span class="pre">perimeter</span></tt></a></li> </ul> </li> <li><a class="reference internal" href="#geometry-relationships">Geometry Relationships</a><ul> <li><a class="reference internal" href="#centroid"><tt class="docutils literal"><span class="pre">centroid</span></tt></a></li> <li><a class="reference internal" href="#envelope"><tt class="docutils literal"><span class="pre">envelope</span></tt></a></li> <li><a class="reference internal" href="#point-on-surface"><tt class="docutils literal"><span class="pre">point_on_surface</span></tt></a></li> </ul> </li> <li><a class="reference internal" href="#geometry-editors">Geometry Editors</a><ul> <li><a class="reference internal" href="#force-rhr"><tt class="docutils literal"><span class="pre">force_rhr</span></tt></a></li> <li><a class="reference internal" href="#reverse-geom"><tt class="docutils literal"><span class="pre">reverse_geom</span></tt></a></li> <li><a class="reference internal" href="#scale"><tt class="docutils literal"><span class="pre">scale</span></tt></a></li> <li><a class="reference internal" href="#snap-to-grid"><tt class="docutils literal"><span class="pre">snap_to_grid</span></tt></a></li> <li><a class="reference internal" href="#transform"><tt class="docutils literal"><span class="pre">transform</span></tt></a></li> <li><a class="reference internal" href="#translate"><tt class="docutils literal"><span class="pre">translate</span></tt></a></li> </ul> </li> <li><a class="reference internal" href="#geometry-operations">Geometry Operations</a><ul> <li><a class="reference internal" href="#difference"><tt class="docutils literal"><span class="pre">difference</span></tt></a></li> <li><a class="reference internal" href="#intersection"><tt class="docutils literal"><span class="pre">intersection</span></tt></a></li> <li><a class="reference internal" href="#sym-difference"><tt class="docutils literal"><span class="pre">sym_difference</span></tt></a></li> <li><a class="reference internal" href="#union"><tt class="docutils literal"><span class="pre">union</span></tt></a></li> </ul> </li> <li><a class="reference internal" href="#geometry-output">Geometry Output</a><ul> <li><a class="reference internal" href="#geohash"><tt class="docutils literal"><span class="pre">geohash</span></tt></a></li> <li><a class="reference internal" href="#geojson"><tt class="docutils literal"><span class="pre">geojson</span></tt></a></li> <li><a class="reference internal" href="#gml"><tt class="docutils literal"><span class="pre">gml</span></tt></a></li> <li><a class="reference internal" href="#kml"><tt class="docutils literal"><span class="pre">kml</span></tt></a></li> <li><a class="reference internal" href="#svg"><tt class="docutils literal"><span class="pre">svg</span></tt></a></li> </ul> </li> <li><a class="reference internal" href="#miscellaneous">Miscellaneous</a><ul> <li><a class="reference internal" href="#mem-size"><tt class="docutils literal"><span class="pre">mem_size</span></tt></a></li> <li><a class="reference internal" href="#num-geom"><tt class="docutils literal"><span class="pre">num_geom</span></tt></a></li> <li><a class="reference internal" href="#num-points"><tt class="docutils literal"><span class="pre">num_points</span></tt></a></li> </ul> </li> </ul> </li> <li><a class="reference internal" href="#spatial-aggregates">Spatial Aggregates</a><ul> <li><a class="reference internal" href="#aggregate-methods">Aggregate Methods</a><ul> <li><a class="reference internal" href="#collect"><tt class="docutils literal"><span class="pre">collect</span></tt></a></li> <li><a class="reference internal" href="#extent"><tt class="docutils literal"><span class="pre">extent</span></tt></a></li> <li><a class="reference internal" href="#extent3d"><tt class="docutils literal"><span class="pre">extent3d</span></tt></a></li> <li><a class="reference internal" href="#make-line"><tt class="docutils literal"><span class="pre">make_line</span></tt></a></li> <li><a class="reference internal" href="#unionagg"><tt class="docutils literal"><span class="pre">unionagg</span></tt></a></li> </ul> </li> <li><a class="reference internal" href="#aggregate-functions">Aggregate Functions</a><ul> <li><a class="reference internal" href="#id16"><tt class="docutils literal"><span class="pre">Collect</span></tt></a></li> <li><a class="reference internal" href="#id17"><tt class="docutils literal"><span class="pre">Extent</span></tt></a></li> <li><a class="reference internal" href="#id18"><tt class="docutils literal"><span class="pre">Extent3D</span></tt></a></li> <li><a class="reference internal" href="#makeline"><tt class="docutils literal"><span class="pre">MakeLine</span></tt></a></li> <li><a class="reference internal" href="#id19"><tt class="docutils literal"><span class="pre">Union</span></tt></a></li> </ul> </li> </ul> </li> </ul> </li> </ul> <h3>Browse</h3> <ul> <li>Prev: <a href="db-api.html">GeoDjango Database API</a></li> <li>Next: <a href="measure.html">Measurement Objects</a></li> </ul> <h3>You are here:</h3> <ul> <li> <a href="../../../index.html">Django 1.5.9 documentation</a> <ul><li><a href="../../index.html">API Reference</a> <ul><li><a href="../index.html"><tt class="docutils literal"><span class="pre">contrib</span></tt> packages</a> <ul><li><a href="index.html">GeoDjango</a> <ul><li>GeoQuerySet API Reference</li></ul> </li></ul></li></ul></li></ul> </li> </ul> <h3>This Page</h3> <ul class="this-page-menu"> <li><a href="../../../_sources/ref/contrib/gis/geoquerysets.txt" rel="nofollow">Show Source</a></li> </ul> <div id="searchbox" style="display: none"> <h3>Quick search</h3> <form class="search" action="../../../search.html" method="get"> <input type="text" name="q" /> <input type="submit" value="Go" /> <input type="hidden" name="check_keywords" value="yes" /> <input type="hidden" name="area" value="default" /> </form> <p class="searchtip" style="font-size: 90%"> Enter search terms or a module, class or function name. </p> </div> <script type="text/javascript">$('#searchbox').show(0);</script> </div> </div> <h3>Last update:</h3> <p class="topless">Aug 21, 2014</p> </div> </div> <div id="ft"> <div class="nav"> « <a href="db-api.html" title="GeoDjango Database API">previous</a> | <a href="../../index.html" title="API Reference" accesskey="U">up</a> | <a href="measure.html" title="Measurement Objects">next</a> »</div> </div> </div> <div class="clearer"></div> </div> </body> </html>