<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:70.85pt 70.85pt 56.7pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Pascal,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Not to my knowledge. Are you proposing that raster2pgsql would generate the overviews outside of the database and then register what it generated?<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>The issue I see with that is then it would need to decide what format to store these overviews because the postgis raster format can’t exist outside of the database.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>A more common request is referencing overviews that are already built. Many external raster already have such a functionality. I think that’s a bit more involved though.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Thanks,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Regina<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> postgis-devel [mailto:postgis-devel-bounces@lists.osgeo.org] <b>On Behalf Of </b>Pascal Bircher / Netzwerk Schweizer Pärke<br><b>Sent:</b> Thursday, March 24, 2022 9:56 AM<br><b>To:</b> postgis-devel@lists.osgeo.org<br><b>Subject:</b> [postgis-devel] Is it planned that overview rasters of PostGIS rasters can be registered outside the database instead of inside<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-GB>Dear PostGIS-Developer<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB>With the raster2pgsql tool also overviews of the rasters can be loaded into the database. It should be possible to register these overviews outside the database instead of loading them into the database. The problem is that rasters with high resolutions (2m, 0.1m) need a lot of space for the overviews. Is there any development ongoing or planned in this regard?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-GB><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-GB>Kind regards<o:p></o:p></span></p><p class=MsoNormal><b><span lang=FR-CH style='font-size:10.0pt;mso-fareast-language:DE-CH'>---<o:p></o:p></span></b></p><p class=MsoNormal><b><span lang=FR-CH style='font-size:10.0pt;mso-fareast-language:DE-CH'>Pascal Bircher<o:p></o:p></span></b></p></div></div></body></html>