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 |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
3af544a1b7f47710515bc40cf4549d6d |
User & Date: | drh 2012-12-12 14:45:30.963 |
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 | 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 | | | | > | 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 |
︙ | ︙ |