<html style="direction: ltr;">
<head>
<meta content="text/html; charset=windows-1255"
http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="preferred-charset"
bgcolor="#FFFFFF" text="#000000">
Hi Andre:<br>
<br>
On 09/22/2012 03:17 PM, Andre Joost wrote:
<blockquote cite="mid:k3ka9v$3ca$1@ger.gmane.org" type="cite">Am
22.09.2012 13:47, schrieb Micha Silver:
<br>
<blockquote type="cite">On 09/22/2012 10:27 AM, Andre Joost wrote:
<br>
<blockquote type="cite"> Am 22.09.2012 09:17, schrieb Johan
Nilsson:
<br>
<br>
<blockquote type="cite"> There is another thing with 'Personal
geodatabase' and that is that ESRI
<br>
don't recommend to use it in their documentation because it
slow and get
<br>
really slow if they are bigger and the absolute size are
limited.
<br>
</blockquote>
<br>
Yes, that's true. Spatial index will not be possible on MDBs
(as well as on
<br>
spataialite). But MS Access is widely spread, so a connection
would be highly
<br>
appreciated. And MDBs are easily portable (again, as well as
spatialite).
<br>
Thats a great advantage to Postgis.
<br>
<br>
</blockquote>
<br>
I'm not sure I understood your comment, but spatial indexing is
definitely
<br>
supported in Spatialite using the R*Tree structure.
<br>
</blockquote>
<br>
I referred to the spatialite 2.1 manual still first in Google
search.
<br>
<br>
</blockquote>
<br>
I learned a lot from:<br>
<a class="moz-txt-link-freetext" href="http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/rtree.html">http://www.gaia-gis.it/spatialite-3.0.0-BETA/spatialite-cookbook/html/rtree.html</a><br>
<br>
Also have a look at these blog posts:<br>
<a class="moz-txt-link-freetext" href="http://northredoubt.com/n/2012/01/18/spatialite-and-spatial-indexes/">http://northredoubt.com/n/2012/01/18/spatialite-and-spatial-indexes/</a><br>
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il/?p=1196">http://www.surfaces.co.il/?p=1196</a><br>
<br>
<blockquote cite="mid:k3ka9v$3ca$1@ger.gmane.org" type="cite">I
guess its not fully supported by the stable Qgis 1.8.0.
<br>
In DB Manager, I have an entry Spatial Index, but get an error
<br>
"no such module: VirtualSpatialIndex". Qspatialite throws an error
for the same reason, and a message "No spatial index defined".
<br>
<br>
</blockquote>
<br>
I have a feeling that QSpatialite is somewhat behind. I'm using
spatialite 3.0 with the spatialite_gui 1.5 and there you have access
to the new format for making use of spatial indexes.<br>
<br>
The problem is that, unlike PostGIS, spatial indexes are not used
automatically. After you create a spatial index on a table, you must
then construct your query to make use of it. This is certainly
non-intuitive for "normal people".<br>
<br>
Regards,<br>
Micha<br>
<br>
<br>
<br>
<blockquote cite="mid:k3ka9v$3ca$1@ger.gmane.org" type="cite">I read
that spatialitegui might solve the problem, but I want to work
inside Qgis. So still nothing for "normal" people ;-)
<br>
<br>
Using Master I get other errors about missing pyspatialite.
<br>
<br>
Gruß,
<br>
André Joost
<br>
<br>
_______________________________________________
<br>
Qgis-user mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br>
<br>
This mail was received via Mail-SeCure System.
<br>
<br>
<br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Micha Silver
GIS Consultant, Arava Development Co.
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il">http://www.surfaces.co.il</a></pre>
</body>
</html>