<!DOCTYPE html>
<html>
  <head>
  </head>
  <body>
    <dl style="line-height: 1.5; margin-left: 2em">
      <dt style="clear: both; float: left; font-weight: bold; width: 8em">Author</dt>
      <dd style="margin-left: 8.5em">HAYASHI Kentaro &lt;hayas****@clear*****&gt;</dd>
      <dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt>
      <dd style="margin-left: 8.5em">2015-04-28 14:21:53 +0900 (Tue, 28 Apr 2015)</dd>
      <dt style="clear: both; float: left; font-weight: bold; width: 8em">New Revision</dt>
      <dd style="margin-left: 8.5em"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5">0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5</a></dd>
      <dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt>
      <dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, &quot;Liberation Mono&quot;, Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">doc: add Geo prefix</pre></dd>
      <dt style="clear: both; float: left; font-weight: bold; width: 8em">Modified files</dt>
      <dd style="margin-left: 8.5em">
        <ul>
          <li><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#diff-0">doc/source/tutorial/index.rst</a></li>
        </ul>
      </dd>
    </dl>

    <div class="diff-section" style="clear: both">
      <table style="border-collapse: collapse; border: 1px solid #aaa">
        <thead>
          <tr class="diff-header" style="border: 1px solid #aaa">
            <td colspan="3">
<pre style="border: 0; font-family: Consolas, Menlo, &quot;Liberation Mono&quot;, Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">  Modified: doc/source/tutorial/index.rst (+6 -4)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
            </td>
          </tr>
        </thead>
        <tbody>
          <tr>
            <th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, &quot;Liberation Mono&quot;, Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L104">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L105">105</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L106">106</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L107">107</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L108">108</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L109">109</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L110">110</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L111">111</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L112">112</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L113">113</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L114">114</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L115">115</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L116">116</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L117">117</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L118">118</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L119">119</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L120">120</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0L121">121</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
</pre>
            </th>
            <th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, &quot;Liberation Mono&quot;, Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R104">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R105">105</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R106">106</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R107">107</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R108">108</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R109">109</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R110">110</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R111">111</a></span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R112">112</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R113">113</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R114">114</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R115">115</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R116">116</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R117">117</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R118">118</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R119">119</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R120">120</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R121">121</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R122">122</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre">&nbsp;</span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga/commit/0eab8c3e92e0bfb5fb87f0ade1954887fd05a5a5#L0R123">123</a></span>
</pre>
            </th>
            <td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, &quot;Liberation Mono&quot;, Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -105,17 +105,19 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">Groonga is very fast because it use such indexes against the column which contai</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> .. groonga-command</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> .. include:: ../example/tutorial/index-6.log</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+.. table_create --name GeoSite --flags TABLE_HASH_KEY --key_type ShortText</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+.. column_create --table GeoSite --name location --type WGS84GeoPoint</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> .. table_create --name GeoIndex --flags TABLE_PAT_KEY --key_type WGS84GeoPoint</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-.. column_create --table GeoIndex --name index_point --type Site --flags COLUMN_INDEX --source location</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-.. load --table Site</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+.. column_create --table GeoIndex --name index_point --type GeoSite --flags COLUMN_INDEX --source location</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+.. load --table GeoSite</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> .. [</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ..  {&quot;_key&quot;:&quot;http://example.org/&quot;,&quot;location&quot;:&quot;128452975x503157902&quot;},</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ..  {&quot;_key&quot;:&quot;http://example.net/&quot;,&quot;location&quot;:&quot;128487316x502920929&quot;}</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> .. ]</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-.. select --table Site --filter 'geo_in_circle(location, &quot;128515259x503187188&quot;, 5000)' --output_columns _key,location</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+.. select --table GeoSite --filter 'geo_in_circle(location, &quot;128515259x503187188&quot;, 5000)' --output_columns _key,location</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> These indexes are also used when sorting the records with geo location search.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> .. groonga-command</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> .. include:: ../example/tutorial/index-7.log</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">-.. select --table Site --filter 'geo_in_circle(location, &quot;128515259x503187188&quot;, 50000)' --output_columns _key,location,_score --sortby '-geo_distance(location, &quot;128515259x503187188&quot;)' --scorer '_score = geo_distance(location, &quot;128515259x503187188&quot;)'</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+.. select --table GeoSite --filter 'geo_in_circle(location, &quot;128515259x503187188&quot;, 50000)' --output_columns _key,location,_score --sortby '-geo_distance(location, &quot;128515259x503187188&quot;)' --scorer '_score = geo_distance(location, &quot;128515259x503187188&quot;)'</span>
</pre>
            </td>
          </tr>
        </tbody>
      </table>
    </div>
  </body>
</html>