<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Is the rasters in same projection (CRS) as the QGIS project ? <br>
</p>
<pre class="moz-signature" cols="72">Med venlig hilsen / Best regards
Bo Victor Thomsen</pre>
<div class="moz-cite-prefix">Den 13-12-2022 kl. 07:50 skrev Alex
German:<br>
</div>
<blockquote type="cite"
cite="mid:CADR72RYsfMuQC7Q0hQCryxF-XxKev4brm6M_TeV1JitW3bpN7g@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr"><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">I did everything as described in the documentation. </span>
<div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">raster2pgsql -I -C -e -Y -F -s 4326 -t 128x128 -l 2,4,8,16,32 "d:\Temp\060 tiff\res\t1.tif" testrastr.t1 | psql. </span>
<div><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">The download is very slow.</span><br>
</div>
</div>
<div><a href="https://youtu.be/LULngZIs4nc"
moz-do-not-send="true" class="moz-txt-link-freetext">https://youtu.be/LULngZIs4nc</a><span style="color:rgb(0,0,0);font-size:13px;white-space:pre-wrap;background-color:rgba(7,28,71,0.05)">
</span></div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">вт, 13 дек. 2022 г. в 09:45,
Regina Obe <<a href="mailto:lr@pcorp.us"
moz-do-not-send="true" class="moz-txt-link-freetext">lr@pcorp.us</a>>:<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 class="msg-2133143946329884418">
<div lang="EN-US">
<div class="m_-2133143946329884418WordSection1">
<p class="MsoNormal"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">PostGIS
raster sadly doesn’t use the pyramids in the Tifs.
Or if it does no one told me.</span></p>
<p class="MsoNormal"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">You
should build raster overviews using the raster2pgsql
–l switch. </span></p>
<p class="MsoNormal"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><a
href="https://postgis.net/docs/using_raster_dataman.html#RT_Raster_Loader"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://postgis.net/docs/using_raster_dataman.html#RT_Raster_Loader</a></span></p>
<p class="MsoNormal"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<pre><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">Doc example is this which builds a level 2 and 4 pyramid</span></pre>
<pre>raster2pgsql -I -C -e -Y -F -s 26986 -t 128x128 -l 2,4 bostonaerials2008/*.jpg aerials.boston | psql -U postgres -d gisdb -h localhost -p 5432</pre>
<p class="MsoNormal"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">QGIS
knows how to use the overviews built that way and
should be much faster to view in QGIS</span></p>
<p class="MsoNormal"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span
style="font-size:10pt;color:black">raster2pgsql -s
4326 -t 256x256 -C -I -F "d:\Temp\060
tiff\res\OCG_t1.tif" OCG_t1 -R| psql. </span></p>
<p class="MsoNormal"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<p class="MsoNormal"><span
style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"> </span></p>
<div
style="border-top:none;border-right:none;border-bottom:none;border-left:1.5pt
solid blue;padding:0in 0in 0in 4pt">
<div>
<div
style="border-right:none;border-bottom:none;border-left:none;border-top:1pt
solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b><span
style="font-size:11pt;font-family:Calibri,sans-serif">From:</span></b><span
style="font-size:11pt;font-family:Calibri,sans-serif"> postgis-users
[mailto:<a
href="mailto:postgis-users-bounces@lists.osgeo.org"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">postgis-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Alex German<br>
<b>Sent:</b> Monday, December 12, 2022 11:34
PM<br>
<b>To:</b> PostGIS Users Discussion <<a
href="mailto:postgis-users@lists.osgeo.org"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">postgis-users@lists.osgeo.org</a>><br>
<b>Subject:</b> [postgis-users] Qgis +
PostGis. Low operating speed.</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal"><span
style="font-size:10pt;color:black">Hello
everyone!</span></p>
<div>
<p class="MsoNormal"><span
style="font-size:10pt;color:black">I have a
GeoTIFF. </span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:10pt;color:black">I built the
pyramids in an external file using GDAL </span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:10pt;color:black">"gdaladdo
d:\Temp\060 tiff\res\t1.tif -r lanczos -ro 2 4
8 16 32 64 128 256 512. </span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:10pt;color:black">Uploaded to
PostGIS using </span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:10pt;color:black">raster2pgsql
-s 4326 -t 256x256 -C -I -F "d:\Temp\060
tiff\res\OCG_t1.tif" OCG_t1 -R| psql. </span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:10pt;color:black">The number
of files is more than 1000. </span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:10pt;color:black">When trying
to load tables in QGis, the loading is very
slow. </span></p>
</div>
<div>
<p class="MsoNormal"><span
style="font-size:10pt;color:black">At the same
time, downloading to QGis from files is fast.
Question. What is not configured correctly and
how to speed up the download to Qgis from
PostGIS?</span><br clear="all">
</p>
<div>
<p class="MsoNormal"> </p>
</div>
<p class="MsoNormal">-- </p>
<div>
<p class="MsoNormal">Alex German</p>
<div>
<p class="MsoNormal"> </p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">postgis-users@lists.osgeo.org</a><br>
<a
href="https://lists.osgeo.org/mailman/listinfo/postgis-users"
rel="noreferrer" target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</div>
</blockquote>
</div>
<br clear="all">
<div><br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">Алексей Герман
<div>8-905-86-00-416</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>