<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<p>Hi all,</p>
<p>Thanks for your replies/opinions.</p>
<p>@Richard: this message also comes up for intermediate memory layers, not only for Geopackage layers.</p>
<p>@Luigi: if I manually add "create spatial index" often, this very much "pollutes" the model. </p>
<p>I agree with Ujaval, that it would be a better user experience if QGIS would do the indexing automatically (on intermediate layers) for operations where the input doesn't have an index and the algorithm would potentially benefit from an index.</p>
<p>Next to automatic indexing I would think that "auto-repairs" for errors that processing algorithms introduce would be good to have, e.g. remove double vertices, remove empty geometries, empty holes/rings, self-intersections. etc.. If this is potentially dangerous, we can do opt-in with central threshold values, and only if the analysis is 2d only. I understand that for 3D analysis automatic cleaning is not always possible.</p>
<p>Or maybe a switch to GEOS 3.9 with the "fixed precision model" enabled would remove all these errors previously introduced by processing?</p>
<p>Greetings,</p>
<p>Andreas</p>
<p id="reply-intro">On 2020-11-26 16:24, Ujaval Gandhi wrote:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<div id="replybody1">
<div>
<div dir="ltr">+1 to have an option to generate spatial index automatically for intermediate layers. As I understand, creating index for database layers automatically may not be preferable, but it's reasonable to want this for intermediate memory layers. Since processing can already identify which operations might benefit from the index, it would be much better user experience to take care of it internally.<br clear="all" />
<div>
<div class="v1gmail_signature" dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div> </div>
<div>
<table style="border-spacing: 0px; border-collapse: collapse; color: #444444; width: 480px; font-size: 10pt; font-family: Arial,sans-serif; line-height: normal;" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="padding: 10px 0px 12px; width: 160px; vertical-align: top;" valign="top"><a style="background-color: transparent; color: #337ab7;" href="https://spatialthoughts.com/" target="_blank" rel="noopener noreferrer"><img style="border: 0px; vertical-align: middle; width: 141px; height: auto;" src="cid:16064059185fbfcf1e2b375015714197@carto.net" alt="Logo" width="141" border="0" /></a></td>
<td style="padding: 6px 0px; width: 320px;">
<table style="border-spacing: 0px; border-collapse: collapse; background-color: transparent;" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="padding: 0px; font-size: 12pt; font-family: Arial,sans-serif; font-weight: bold; color: #3d3c3f;"><span style="color: #00afef;">Ujaval Gandhi</span></td>
</tr>
<tr>
<td style="padding: 0px 0px 11px; font-size: 10pt; font-family: Arial,sans-serif; color: #3d3c3f;"><span style="color: #00afef;">Spatial Thoughts</span></td>
</tr>
<tr>
<td style="padding: 0px; font-size: 10pt; font-family: Arial,sans-serif; color: #9b9b9b;"><span>mobile: +91-8095684687</span></td>
</tr>
<tr>
<td style="padding: 0px; font-size: 10pt; font-family: Arial,sans-serif; color: #9b9b9b;"><span>email: </span><span style="color: #1793d2;"><a href="mailto:ujaval@spatialthoughts.com" rel="noreferrer">ujaval@spatialthoughts.com</a></span></td>
</tr>
<tr>
<td style="padding: 6px 0px 0px;"><span style="display: inline-block; height: 22px;"><span><a style="background-color: transparent; color: #337ab7;" href="https://www.linkedin.com/in/spatialthoughts/" target="_blank" rel="noopener noreferrer"><img style="border: 0px; vertical-align: middle; height: 20px; width: 20px;" src="cid:16064059185fbfcf1e2b375015714197@carto.net" alt="LinkedIn icon" width="23" height="23" border="0" /></a> </span><span><a style="background-color: transparent; color: #337ab7;" href="https://twitter.com/spatialthoughts" target="_blank" rel="noopener noreferrer"><img style="border: 0px; vertical-align: middle; height: 20px; width: 20px;" src="cid:16064059185fbfcf1e2b375015714197@carto.net" alt="Twitter icon" width="23" height="23" border="0" /></a> </span></span></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="padding: 8px 0px 0px; border-top: 1px solid #1793d2; width: 480px; font-family: Arial,sans-serif; color: #9b9b9b; text-align: justify;" colspan="2"> </td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br />
<div class="v1gmail_quote">
<div class="v1gmail_attr" dir="ltr">On Thu, Nov 26, 2020 at 8:26 PM Luigi Pirelli <<a href="mailto:luipir@gmail.com" rel="noreferrer">luipir@gmail.com</a>> wrote:</div>
<blockquote class="v1gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left: 1px solid #cccccc; padding-left: 1ex;">
<div dir="ltr">I've this message constantly... but usually when an intermediate layer is used in some geoprocess. So, you can just add a "create spatial index" step before the next geoprocess. Doing it automatically can be time spending. Do you really need it everytime?<br clear="all" />
<div>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<div> </div>
<div>Luigi Pirelli<br /><br />**************************************************************************************************<br />* LinkedIn: <a href="https://www.linkedin.com/in/luigipirelli" target="_blank" rel="noopener noreferrer">https://www.linkedin.com/in/luigipirelli</a><br />* Stackexchange: <a href="http://gis.stackexchange.com/users/19667/luigi-pirelli" target="_blank" rel="noopener noreferrer">http://gis.stackexchange.com/users/19667/luigi-pirelli</a><br />* GitHub: <a href="https://github.com/luipir" target="_blank" rel="noopener noreferrer">https://github.com/luipir</a><br />* Book: <a href="https://www.packtpub.com/eu/application-development/mastering-geospatial-development-qgis-3x-third-edition" target="_blank" rel="noopener noreferrer">Mastering QGIS3 - 3rd Edition</a></div>
<div>* Hire a team: <a href="http://www.qcooperative.net" target="_blank" rel="noopener noreferrer">http://www.qcooperative.net</a><br />**************************************************************************************************</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br />
<div class="v1gmail_quote">
<div class="v1gmail_attr" dir="ltr">On Mon, 23 Nov 2020 at 15:23, Andreas Neumann <<a href="mailto:andreas@qgis.org" rel="noreferrer">andreas@qgis.org</a>> wrote:</div>
<blockquote class="v1gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left: 1px solid #cccccc; padding-left: 1ex;">
<div dir="ltr">
<div>Hi,</div>
<div> </div>
<div>When running QGIS processing models, I frequently get the red warning messages:</div>
<div> </div>
<div>
<p style="margin: 0px; text-indent: 0px; white-space: pre-wrap;"><span style="color: #ff0000;">No spatial index exists for input layer, performance will be severely degraded</span></p>
<p style="margin: 0px; text-indent: 0px; white-space: pre-wrap;"><span style="color: #000000;"> </span></p>
<p style="margin: 0px; text-indent: 0px; white-space: pre-wrap;"><span style="color: #000000;">These are temporary (intermediate) geopackage files that QGIS generates during the running of the model. Is there an option that QGIS could automatically generate these spatial indexes for intermediate files?</span></p>
<p style="margin: 0px; text-indent: 0px; white-space: pre-wrap;"><span style="color: #000000;"> </span></p>
<p style="margin: 0px; text-indent: 0px; white-space: pre-wrap;"><span style="color: #000000;">Thanks,</span></p>
<p style="margin: 0px; text-indent: 0px; white-space: pre-wrap;"><span style="color: #000000;">Andreas</span></p>
</div>
<div>
<div dir="ltr">
<div dir="ltr">
<div><br />--<br />Andreas Neumann</div>
<a href="http://QGIS.ORG" target="_blank" rel="noopener noreferrer">QGIS.ORG</a> board member (treasurer)</div>
</div>
</div>
</div>
_______________________________________________<br />QGIS-Developer mailing list<br /><a href="mailto:QGIS-Developer@lists.osgeo.org" rel="noreferrer">QGIS-Developer@lists.osgeo.org</a><br />List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br />Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></blockquote>
</div>
_______________________________________________<br />QGIS-Developer mailing list<br /><a href="mailto:QGIS-Developer@lists.osgeo.org" rel="noreferrer">QGIS-Developer@lists.osgeo.org</a><br />List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a><br />Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-developer" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-developer</a></blockquote>
</div>
</div>
</div>
</blockquote>
<p><br /></p>
</body></html>