[postgis-users] Export to SQLite RTree

[Léo Serre]

Hello world

I'm working on how to display speed limit on a screen using
microcontroler and OpenStreetMap database.

I need to export my data in postGIS to a file format where I can access
easily to the RTree index.
I think it is possible to export a postGIS database to SQLite file, but
I need to have the index.

Example, for each bounding box, I need :
 * ID of childs
 * Min / Max Long / Lat
And for the last level of bbox, I need the list of ways inside.

In my database, I have only one table containing a list of "ways" with :
 * One ID
 * List of points
 * OpenStreetMap tags (useless because already filtered)

How can I export that to an RTree model ?

Léo

P.S. Example of database content :
https://admin.lstronic.com/owncloud/public.php?service=files&t=846a108f6ed700b18e4a2e4401a6870e

-- 
LSTRONIC logo

Léo SERRE
/LSTRONIC Founder/
mail  leo at lstronic.com <mailto:leo at lstronic.com>
website  lstronic.com <http://lstronic.com>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150202/dfdb6d7c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: edigfbde.png
Type: image/png
Size: 2842 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150202/dfdb6d7c/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: egaghagj.png
Type: image/png
Size: 297 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150202/dfdb6d7c/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cjdebffc.png
Type: image/png
Size: 150 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150202/dfdb6d7c/attachment-0002.png>