<div dir="ltr"><div dir="ltr">Dennis and list;<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jan 12, 2023 at 8:45 AM Dennis Burgess via QGIS-User <<a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div>
<div lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:12pt;color:rgb(153,51,102)">But looking to only display what is on the customer screen. We should never get the 50 meg poly..
</span></p><div style="border-color:rgb(225,225,225) currentcolor currentcolor;border-style:solid none none;border-width:1pt medium medium;padding:3pt 0in 0in"><p class="MsoNormal"><a href="mailto:qgis-user@lists.osgeo.org" target="_blank"></a><br>
<b>Subject:</b> RE: Looking for application/server etc<u></u><u></u></p>
</div>
<p></p></div></div></div></blockquote><div>[stuff deleted] <br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div lang="EN-US"><div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)" lang="EN-IE">PostGIS with Geometry Index’s?!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(31,73,125)" lang="EN-IE">Set up Styles with Zoom Levels so as when zoomed in to 1:5000, that’s the only time you have full LOD</span></p></div></div></div></blockquote><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div lang="EN-US"><div><p class="MsoNormal"><span style="color:rgb(31,73,125)" lang="EN-IE"><u></u><u></u></span></p>
<p class="MsoNormal" style="line-height:11.25pt"><span style="color:rgb(31,73,125)" lang="EN-IE"> [stuff deleted]</span><span style="font-size:9pt;font-family:"Arial",sans-serif;color:rgb(0,77,68)"></span></p><p class="MsoNormal" style="line-height:11.25pt"><span style="font-size:9pt;font-family:"Arial",sans-serif;color:rgb(0,77,68)"><a href="https://www.opw.ie/en/disclaimer/" target="_blank"></a></span></p></div></div></div></blockquote><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div lang="EN-US"><div><p class="MsoNormal" style="line-height:11.25pt"><span style="font-size:9pt;font-family:"Arial",sans-serif;color:rgb(0,77,68)">
<u></u><u></u></span></p><table style="width:315pt" width="420" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="width:315pt;padding:0in 0in 4.5pt" width="420">
</td>
</tr>
</tbody>
</table>
<div style="border-color:currentcolor currentcolor currentcolor blue;border-style:none none none solid;border-width:medium medium medium 1.5pt;padding:0in 0in 0in 4pt">
<div>
<div style="border-color:rgb(225,225,225) currentcolor currentcolor;border-style:solid none none;border-width:1pt medium medium;padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> QGIS-User <<a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@lists.osgeo.org</a>>
<b>On Behalf Of </b>Dennis Burgess via QGIS-User<br>
<b>Sent:</b> 12 January 2023 15:43<br>
<b>To:</b> <a href="mailto:qgis-user@lists.osgeo.org" target="_blank">qgis-user@lists.osgeo.org</a><br>
<b>Subject:</b> [Qgis-user] Looking for application/server etc<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-IE"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt">Looking for something that can take a HUGE, say a 50-75 meg mutli-polygon (multi-state etc.), that has detail level down to 1meter, then parse it and display it within 1meg on top of mapping systems in a web
browser ? Options? Not to mention, we have a few thousand of these so we need to be able to call the mapping for any one of them. We also need it to simplify it i.e. maybe deliver a max a 1 meg to the customer.. if they zoom out we want to make it simpler
to deliver something to the customer.. I’m sure there is a way of doing this..
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:12pt">I’m sure there is an application, server, something that can do this automatically.. <br></span></p><p class="MsoNormal"><span style="font-size:12pt"><br></span></p></div></div></div></div></blockquote><div><br></div><div>Dennis, do you mean your object of interest is a MULTIPOLYGON? Because if so, your bounding box, and therefore your spatial index, is going to bound the entire polygon, and that's going to limit any kind of efficiency as you zoom in.</div><div><br></div><div>You might consider splitting your MULTIPOLYGON into POLYGONs. That way each POLYGON will have its own bounding box and therefore your spatial indexing scheme will have the chance to be more efficient. But of course you have to watch out for polygons like the Mississippi River.</div><div><br></div><div>This article might help <a href="https://www.alibabacloud.com/blog/postgresql-how-to-optimize-spatial-index-based-query-performance-for-multipolygon-data_597324" target="_blank">https://www.alibabacloud.com/blog/postgresql-how-to-optimize-spatial-index-based-query-performance-for-multipolygon-data_597324</a></div><div><br></div><div>I agree with Richard; PostGIS provides nice geometry indexing. Probably other database managers do as well.</div><div><br></div><div>I'm not certain that I follow what you are doing precisely, but one kind of architecture would be to have your database within PostgreSQL / PostGIS, being accessed by QGIS server and delivered to your clients that way.</div><div><br></div><div>The QGIS server guide is here <a href="https://docs.qgis.org/3.22/en/docs/server_manual/index.html" target="_blank">https://docs.qgis.org/3.22/en/docs/server_manual/index.html</a></div><div><br></div><div>The PostGIS manual is here <a href="https://postgis.net/documentation/">https://postgis.net/documentation/</a></div><div><br></div><div>There are many, many resources available to learn PostGIS. From personal experience I know this is a good one <a href="https://www.manning.com/books/postgis-in-action-third-edition">https://www.manning.com/books/postgis-in-action-third-edition</a></div></div><br>-- <br><div dir="ltr"><div dir="ltr">Chris Hermansen · clhermansen "at" gmail "dot" com<br><br>C'est ma façon de parler.</div></div></div>