<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
FYI,</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Satellite SAR data from companies like Umbra , <a href="https://registry.opendata.aws/umbra-open-data/" id="LPlnk191810">
https://registry.opendata.aws/umbra-open-data/</a> , is delivered with cells oriented at an angle to the North direction of the projection. </div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Doug</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Frank Gevaerts <frank.gevaerts@fks.be><br>
<b>Sent:</b> Wednesday, February 26, 2025 8:10 AM<br>
<b>To:</b> Paul Ramsey <pramsey@cleverelephant.ca><br>
<b>Cc:</b> PostGIS Users Discussion <postgis-users@lists.osgeo.org><br>
<b>Subject:</b> [EXTERNAL] Re: Performance(?) issues with ST_Reskew() (on rasters)</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText"><br>
<br>
This email has been received from outside of DOI - Use caution before clicking on links, opening attachments, or responding.<br>
<br>
<br>
<br>
It seems to work for small enough sizes, yes.<br>
<br>
I'm kind of new to rasters in general, so I'm not at all sure of the details either, but the idea of the skew parameters is to support rotated rasters (i.e. rasters that aren't exactly aligned north/south, or I guess more specifically, not aligned to the CRS).<br>
Rotation is specified using skew values and not an angle, which I think is more general in that (I think) it also supports non-rectangular grids.<br>
<br>
For me the diagrams on <a href="https://en.wikipedia.org/wiki/World_file">https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fen.wikipedia.org%2Fwiki%2FWorld_file&data=05%7C02%7CDoug_Newcomb%40fws.gov%7C83d5b2bd7c0942d84be008dd5666fc9e%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C638761722502022396%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=aEPcWk%2FLmByQt5skByl0lJiB6FXUDgxeDSzareT3VP0%3D&reserved=0</a>
helped a lot to understand what's going on. This is linked to from the documentation of ST_SetSkew(), but not ST_Reskew() or ST_Resample(). Maybe some documentation work is needed there, I'll see if I can find time to help out with that)<br>
<br>
Meanwhile I've also figured out that I probably need ST_Resample() with non-zero skew values instead of ST_Reskew() because I also need to adjust the scale numbers if I want to keep the same pixel size (Pythagoras is meddling with this). It looks like ST_Resample()
has the same infinite loop issue as ST_Reskew() though, and I'm not actually seeing anything ST_Reskew() does that ST_Resample() with skew parameters can not do so I'm guessing they use the same underlying code.<br>
<br>
Frank<br>
<br>
On Tue, Feb 25, 2025 at 09:01:30AM -0800, Paul Ramsey wrote:<br>
> Did it (modulo the failure case) work?<br>
> I’m stuck because I cannot even quite figure out what the function does. Presumably it has utility, but exactly what utility I don’t yet know.<br>
><br>
> > On Feb 25, 2025, at 4:13 AM, Frank Gevaerts <frank.gevaerts@fks.be> wrote:<br>
> ><br>
> > ST_ReSkew seemed to me to be the easiest (and fastest) way to get the data in that form, so it was the first approach to try.<br>
><br>
<br>
--<br>
Frank Gevaerts frank.gevaerts@fks.be<br>
fks bvba - Formal and Knowledge Systems <a href="http://www.fks.be/">https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.fks.be%2F&data=05%7C02%7CDoug_Newcomb%40fws.gov%7C83d5b2bd7c0942d84be008dd5666fc9e%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C638761722502041265%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=ebdrW1vRkftWKuUaAY%2FKZ8zGKDJ2%2FoLrFEfnq%2Fa6CW0%3D&reserved=0</a><br>
Grote Baan 79 Tel: ++32-(0)11-21 49 11<br>
B-3511 KURINGEN-HASSELT Fax: ++32-(0)11-22 04 19<br>
</div>
</span></font></div>
</body>
</html>