[postgis-users] Export to SQLite RTree

[Dave Barter]

I believe you can do this in QGIS by adding the layer from PostGIS then
exporting to  SQLLite

On Tue, Feb 3, 2015 at 2:02 AM, Stephen Woodbridge <woodbri at swoodbridge.com>
wrote:

> 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
>>
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150203/c0bd60c6/attachment.html>