Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix mistaken latitude values in the examples in the RTree documentation. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
3af544a1b7f47710515bc40cf4549d6d |
| User & Date: | drh 2012-12-12 14:45:30 |
Context
|
2012-12-12
| ||
| 15:33 | Remove references to GIFs used for rounded corners. Rounded corners have not used those GIFs since check-in [2912fc93f779] on 2012-09-04. (check-in: 708a9a33a8 user: drh tags: trunk) | |
| 14:45 | Fix mistaken latitude values in the examples in the RTree documentation. (check-in: 3af544a1b7 user: drh tags: trunk) | |
| 14:44 | Update the changelog with the sha1 and source-id for 3715. (check-in: acbd6231fa user: dan tags: trunk) | |
Changes
Changes to pages/rtree.in.
126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 |
R*Tree index, we can do something like this:
</p>
<blockquote><pre>
INSERT INTO demo_index VALUES(
1, -- Primary key
-80.7749, -80.7747, -- Longitude range
30.3776, 30.3778 -- Latitude range
);
INSERT INTO demo_index VALUES(
2,
-81.0, -79.6,
35.0, 36.2
);
</pre></blockquote>)^
<p>
The entries above might represent (for example) a bounding box around
the offices for SQLite.org and bounding box around the
12th Congressional District of North Carolina in which SQLite.org is located.
</p>
<h3>3.3 Querying An R*Tree Index</h3>
<p>
^Any valid query will work against an R*Tree index. But the R*Tree
implementation is designed to make two kinds of queries especially
|
| | | > |
126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 |
R*Tree index, we can do something like this:
</p>
<blockquote><pre>
INSERT INTO demo_index VALUES(
1, -- Primary key
-80.7749, -80.7747, -- Longitude range
33.3776, 35.3778 -- Latitude range
);
INSERT INTO demo_index VALUES(
2,
-81.0, -79.6,
35.0, 36.2
);
</pre></blockquote>)^
<p>
The entries above might represent (for example) a bounding box around
the main office for SQLite.org and bounding box around the
12th Congressional District of North Carolina (prior to the 2011
redistricting) in which SQLite.org was located.
</p>
<h3>3.3 Querying An R*Tree Index</h3>
<p>
^Any valid query will work against an R*Tree index. But the R*Tree
implementation is designed to make two kinds of queries especially
|