[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Rain sensor --- Interpolation -- RASTER -- IDW
From:       Giuseppe Broccolo <g.broccolo.7 () gmail ! com>
Date:       2020-05-02 20:22:17
Message-ID: CAFtuf8Ag5ZZpELvZe5wm99eJWW5qmfoDt+Gj=cebFwFFh19Yjg () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hi Acaymo,

In some way, it is expected: the algorithm needs to loop on all the pixels
for the interpolation,
and this can be time consuming in case of large rasters, specially if you
consider that st_invdistweight
is a function implemented in PL/pgSQL.

Anyway, did you consider to split the raster in tiles, and run the
interpolation on the single tiles?

Hope this can help,
Giuseppe.

Il giorno sab 2 mag 2020 alle ore 19:00 caymo04 <caymo04@fuerteguineo.eu>
ha scritto:

> Good afternoon everyone,
>
> I am trinig to interpolate on RASTER the no data values.
>
> We have 10 data from rain sensor and this sensor are geopositioned on the
> RASTER.
>
> How can I do the interpolation by weight in all RASTER?
>
> I tried to do with InvDistWeight4ma function but is very very very slowly.
>
> Any response will be very appreciated.
>
> Best regards and thanks you in advance.
>
> Acaymo.
>
>
>
> --
> Sent from: http://postgis.17.x6.nabble.com/PostGIS-User-f3516033.html
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

[Attachment #5 (text/html)]

<div dir="ltr"><div dir="ltr"><div>Hi Acaymo,</div><div><br></div><div>In some way, \
it is expected: the algorithm needs to loop on all the pixels for the \
interpolation,</div><div>and this can be time consuming in case of large rasters, \
specially if you consider that st_invdistweight</div><div>is a function implemented \
in PL/pgSQL.</div><div><br></div><div>Anyway, did you consider to split the raster in \
tiles, and run the interpolation on the single tiles?</div><div><br></div><div>Hope \
this can help,</div><div>Giuseppe.</div></div><br><div class="gmail_quote"><div \
dir="ltr" class="gmail_attr">Il giorno sab 2 mag 2020 alle ore 19:00 caymo04 &lt;<a \
href="mailto:caymo04@fuerteguineo.eu">caymo04@fuerteguineo.eu</a>&gt; ha \
scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Good afternoon \
everyone,<br> <br>
I am trinig to interpolate on RASTER the no data values.<br>
<br>
We have 10 data from rain sensor and this sensor are geopositioned on the<br>
RASTER.<br>
<br>
How can I do the interpolation by weight in all RASTER?<br>
<br>
I tried to do with InvDistWeight4ma function but is very very very slowly.<br>
<br>
Any response will be very appreciated. <br>
<br>
Best regards and thanks you in advance.<br>
<br>
Acaymo.<br>
<br>
<br>
<br>
--<br>
Sent from: <a href="http://postgis.17.x6.nabble.com/PostGIS-User-f3516033.html" \
rel="noreferrer" target="_blank">http://postgis.17.x6.nabble.com/PostGIS-User-f3516033.html</a><br>
 _______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div></div>



[Attachment #6 (text/plain)]

_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]