[postgis-users] Export to SQLite RTree

[Stephen Woodbridge]

Hi Leo,

I'm not sure that you can do that directly. What I would do is dump the 
vectors and then build the rtree index. For example you should be able 
to dump the data in a form that is easy to import into sqlite or 
spatialite database, and then construct the rtree there.

Most rtree libraries have a way to build an index based on the geometry 
that they support.

-Steve

On 2/2/2015 5:02 PM, Léo Serre wrote:
> 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>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>