<!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 <hayas****@clear*****></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, "Liberation Mono", 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, "Liberation Mono", 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, "Liberation Mono", 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"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </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"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </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"> </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"> </span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", 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"> </span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </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"> </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"> </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, "Liberation Mono", 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"> .. {"_key":"http://example.org/","location":"128452975x503157902"},</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> .. {"_key":"http://example.net/","location":"128487316x502920929"}</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, "128515259x503187188", 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, "128515259x503187188", 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, "128515259x503187188", 50000)' --output_columns _key,location,_score --sortby '-geo_distance(location, "128515259x503187188")' --scorer '_score = geo_distance(location, "128515259x503187188")'</span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+.. select --table GeoSite --filter 'geo_in_circle(location, "128515259x503187188", 50000)' --output_columns _key,location,_score --sortby '-geo_distance(location, "128515259x503187188")' --scorer '_score = geo_distance(location, "128515259x503187188")'</span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>