<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="using-spatial-indexes">
      </a>
      13.4.11 Using Spatial Indexes
     </h3>
    </div>
   </div>
  </div>
  <p>
   The optimizer investigates whether available spatial indexes can
        be involved in the search for queries that use a function such
        as
   <a class="link" href="spatial-relation-functions-mbr.html#function_mbrcontains">
    <code class="literal">
     MBRContains()
    </code>
   </a>
   or
   <a class="link" href="spatial-relation-functions-mbr.html#function_mbrwithin">
    <code class="literal">
     MBRWithin()
    </code>
   </a>
   in the
   <code class="literal">
    WHERE
   </code>
   clause. The following query finds all
        objects that are in the given rectangle:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa34248895"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> <span class="token variable">@poly</span> <span class="token operator">=</span>
<span class="token prompt">    -&gt;</span> <span class="token string">'Polygon((30000 15000,
                 31000 15000,
                 31000 16000,
                 30000 16000,
                 30000 15000))'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> fid<span class="token punctuation">,</span><span class="token function">ST_AsText</span><span class="token punctuation">(</span>g<span class="token punctuation">)</span> <span class="token keyword">FROM</span> geom <span class="token keyword">WHERE</span>
<span class="token prompt">    -&gt;</span> <span class="token function">MBRContains</span><span class="token punctuation">(</span><span class="token function">ST_GeomFromText</span><span class="token punctuation">(</span><span class="token variable">@poly</span><span class="token punctuation">)</span><span class="token punctuation">,</span>g<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> fid <span class="token punctuation">|</span> ST_AsText(g)                                                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span>  21 <span class="token punctuation">|</span> LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  22 <span class="token punctuation">|</span> LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  23 <span class="token punctuation">|</span> LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  24 <span class="token punctuation">|</span> LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  25 <span class="token punctuation">|</span> LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882. ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  26 <span class="token punctuation">|</span> LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> 249 <span class="token punctuation">|</span> LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946. ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   1 <span class="token punctuation">|</span> LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136. ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   2 <span class="token punctuation">|</span> LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   3 <span class="token punctuation">|</span> LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,3016 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   4 <span class="token punctuation">|</span> LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   5 <span class="token punctuation">|</span> LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   6 <span class="token punctuation">|</span> LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,3024 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   7 <span class="token punctuation">|</span> LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  10 <span class="token punctuation">|</span> LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  11 <span class="token punctuation">|</span> LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  13 <span class="token punctuation">|</span> LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,3011 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> 154 <span class="token punctuation">|</span> LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> 155 <span class="token punctuation">|</span> LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> 157 <span class="token punctuation">|</span> LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">20 rows in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   Use
   <a class="link" href="explain.html" title="15.8.2 EXPLAIN Statement">
    <code class="literal">
     EXPLAIN
    </code>
   </a>
   to check the way this
        query is executed:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa74894485"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> <span class="token variable">@poly</span> <span class="token operator">=</span>
<span class="token prompt">    -&gt;</span> <span class="token string">'Polygon((30000 15000,
                 31000 15000,
                 31000 16000,
                 30000 16000,
                 30000 15000))'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">EXPLAIN</span> <span class="token keyword">SELECT</span> fid<span class="token punctuation">,</span><span class="token function">ST_AsText</span><span class="token punctuation">(</span>g<span class="token punctuation">)</span> <span class="token keyword">FROM</span> geom <span class="token keyword">WHERE</span>
<span class="token prompt">    -&gt;</span> <span class="token function">MBRContains</span><span class="token punctuation">(</span><span class="token function">ST_GeomFromText</span><span class="token punctuation">(</span><span class="token variable">@poly</span><span class="token punctuation">)</span><span class="token punctuation">,</span>g<span class="token punctuation">)</span>\G
<span class="token output"><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
           id<span class="token punctuation">:</span> 1
  select_type<span class="token punctuation">:</span> SIMPLE
        table<span class="token punctuation">:</span> geom
         type<span class="token punctuation">:</span> range
possible_keys<span class="token punctuation">:</span> g
          key<span class="token punctuation">:</span> g
      key_len<span class="token punctuation">:</span> 32
          ref<span class="token punctuation">:</span> NULL
         rows<span class="token punctuation">:</span> 50
        Extra<span class="token punctuation">:</span> Using where
</span><span class="token output">1 row in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   Check what would happen without a spatial index:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa62945334"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> <span class="token variable">@poly</span> <span class="token operator">=</span>
<span class="token prompt">    -&gt;</span> <span class="token string">'Polygon((30000 15000,
                 31000 15000,
                 31000 16000,
                 30000 16000,
                 30000 15000))'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">EXPLAIN</span> <span class="token keyword">SELECT</span> fid<span class="token punctuation">,</span><span class="token function">ST_AsText</span><span class="token punctuation">(</span>g<span class="token punctuation">)</span> <span class="token keyword">FROM</span> g <span class="token keyword">IGNORE</span> <span class="token keyword">INDEX</span> <span class="token punctuation">(</span>g<span class="token punctuation">)</span> <span class="token keyword">WHERE</span>
<span class="token prompt">    -&gt;</span> <span class="token function">MBRContains</span><span class="token punctuation">(</span><span class="token function">ST_GeomFromText</span><span class="token punctuation">(</span><span class="token variable">@poly</span><span class="token punctuation">)</span><span class="token punctuation">,</span>g<span class="token punctuation">)</span>\G
<span class="token output"><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
           id<span class="token punctuation">:</span> 1
  select_type<span class="token punctuation">:</span> SIMPLE
        table<span class="token punctuation">:</span> geom
         type<span class="token punctuation">:</span> ALL
possible_keys<span class="token punctuation">:</span> NULL
          key<span class="token punctuation">:</span> NULL
      key_len<span class="token punctuation">:</span> NULL
          ref<span class="token punctuation">:</span> NULL
         rows<span class="token punctuation">:</span> 32376
        Extra<span class="token punctuation">:</span> Using where
</span><span class="token output">1 row in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   Executing the
   <a class="link" href="select.html" title="15.2.13 SELECT Statement">
    <code class="literal">
     SELECT
    </code>
   </a>
   statement
        without the spatial index yields the same result but causes the
        execution time to rise from 0.00 seconds to 0.46 seconds:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa49300592"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token prompt">mysql&gt;</span> <span class="token keyword">SET</span> <span class="token variable">@poly</span> <span class="token operator">=</span>
<span class="token prompt">    -&gt;</span> <span class="token string">'Polygon((30000 15000,
                 31000 15000,
                 31000 16000,
                 30000 16000,
                 30000 15000))'</span><span class="token punctuation">;</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> fid<span class="token punctuation">,</span><span class="token function">ST_AsText</span><span class="token punctuation">(</span>g<span class="token punctuation">)</span> <span class="token keyword">FROM</span> geom <span class="token keyword">IGNORE</span> <span class="token keyword">INDEX</span> <span class="token punctuation">(</span>g<span class="token punctuation">)</span> <span class="token keyword">WHERE</span>
<span class="token prompt">    -&gt;</span> <span class="token function">MBRContains</span><span class="token punctuation">(</span><span class="token function">ST_GeomFromText</span><span class="token punctuation">(</span><span class="token variable">@poly</span><span class="token punctuation">)</span><span class="token punctuation">,</span>g<span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> fid <span class="token punctuation">|</span> ST_AsText(g)                                                  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span>   1 <span class="token punctuation">|</span> LINESTRING(30250.4 15129.2,30248.8 15138.4,30238.2 15136. ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   2 <span class="token punctuation">|</span> LINESTRING(30220.2 15122.8,30217.2 15137.8,30207.6 15136, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   3 <span class="token punctuation">|</span> LINESTRING(30179 15114.4,30176.6 15129.4,30167 15128,3016 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   4 <span class="token punctuation">|</span> LINESTRING(30155.2 15121.4,30140.4 15118.6,30142 15109,30 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   5 <span class="token punctuation">|</span> LINESTRING(30192.4 15085,30177.6 15082.2,30179.2 15072.4, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   6 <span class="token punctuation">|</span> LINESTRING(30244 15087,30229 15086.2,30229.4 15076.4,3024 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   7 <span class="token punctuation">|</span> LINESTRING(30200.6 15059.4,30185.6 15058.6,30186 15048.8, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  10 <span class="token punctuation">|</span> LINESTRING(30179.6 15017.8,30181 15002.8,30190.8 15003.6, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  11 <span class="token punctuation">|</span> LINESTRING(30154.2 15000.4,30168.6 15004.8,30166 15014.2, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  13 <span class="token punctuation">|</span> LINESTRING(30105 15065.8,30108.4 15050.8,30118 15053,3011 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  21 <span class="token punctuation">|</span> LINESTRING(30350.4 15828.8,30350.6 15845,30333.8 15845,30 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  22 <span class="token punctuation">|</span> LINESTRING(30350.6 15871.4,30350.6 15887.8,30334 15887.8, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  23 <span class="token punctuation">|</span> LINESTRING(30350.6 15914.2,30350.6 15930.4,30334 15930.4, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  24 <span class="token punctuation">|</span> LINESTRING(30290.2 15823,30290.2 15839.4,30273.4 15839.4, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  25 <span class="token punctuation">|</span> LINESTRING(30291.4 15866.2,30291.6 15882.4,30274.8 15882. ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>  26 <span class="token punctuation">|</span> LINESTRING(30291.6 15918.2,30291.6 15934.4,30275 15934.4, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> 154 <span class="token punctuation">|</span> LINESTRING(30276.2 15143.8,30261.4 15141,30263 15131.4,30 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> 155 <span class="token punctuation">|</span> LINESTRING(30269.8 15084,30269.4 15093.4,30258.6 15093,30 ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> 157 <span class="token punctuation">|</span> LINESTRING(30128.2 15011,30113.2 15010.2,30113.6 15000.4, ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> 249 <span class="token punctuation">|</span> LINESTRING(30337.8 15938.6,30337.8 15946.8,30320.4 15946. ... <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output">20 rows in set (0.46 sec)</span></code></pre>
  </div>
 </div>
 <br/>
</div>
