<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hello world<br>
<br>
I'm working on how to display speed limit on a screen using
microcontroler and OpenStreetMap database.<br>
<br>
I need to export my data in postGIS to a file format where I can
access easily to the RTree index.<br>
I think it is possible to export a postGIS database to SQLite file,
but I need to have the index.<br>
<br>
Example, for each bounding box, I need :<br>
* ID of childs<br>
* Min / Max Long / Lat<br>
And for the last level of bbox, I need the list of ways inside.<br>
<br>
In my database, I have only one table containing a list of "ways"
with :<br>
* One ID<br>
* List of points<br>
* OpenStreetMap tags (useless because already filtered)<br>
<br>
How can I export that to an RTree model ?<br>
<br>
Léo<br>
<br>
P.S. Example of database content : <a
href="https://admin.lstronic.com/owncloud/public.php?service=files&t=846a108f6ed700b18e4a2e4401a6870e">https://admin.lstronic.com/owncloud/public.php?service=files&t=846a108f6ed700b18e4a2e4401a6870e</a><br>
<br>
<div class="moz-signature">-- <br>
<div id="sig"><img style="float: left; margin-right: 10px;"
src="cid:part2.00000901.01080706@lstronic.com" alt="LSTRONIC
logo">
<p style="font-family: 'Open Sans', Ubuntu, 'Liberation Sans',
Arial, sans-serif, sans; font-weight: lighter; font-size:
14px;">Léo SERRE<br>
<em>LSTRONIC Founder</em><br style="margin-bottom: 10px;">
<img style="vertical-align: middle;"
src="cid:part3.04010108.07040903@lstronic.com" alt="mail"> <a
style="color: inherit; text-decoration: none; border-bottom:
1px dashed #ff5200;" href="mailto:leo@lstronic.com">leo@lstronic.com</a><br>
<img style="vertical-align: middle;"
src="cid:part5.06030902.04010000@lstronic.com" alt="website"> <a
style="color: inherit; text-decoration: none; border-bottom:
1px dashed #ff5200;" href="http://lstronic.com">lstronic.com</a></p>
</div>
</div>
</body>
</html>