Changes between Initial Version and Version 1 of Ticket #2728


Ignore:
Timestamp:
May 10, 2023, 6:39:48 AM (19 months ago)
Author:
Bang Pham Huu
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #2728

    • Property Summary FIX - scale on 3D base coverage with pyramid returns wrong result → FIX - scale on 3D base coverage with pyramid returns wrong result if expression specified in LET clause

  • Ticket #2728 – Description

    initial v1  
    2222SELECT encode((char)  ( SCALE(c_0, [0:3,0:600,0:700]) ) , "png" , "{\"geoReference\":{\"crs\":\"EPSG:3826\",\"bbox\":{\"xmin\":147522.21879115,\"ymin\":2422004.7731021,\"xmax\":351672.21879115004083,\"ymax\":2799154.7731021}},\"nodata\":[-3.4028234663852886E38]}")  FROM air_quality_monitoring_data_co_4 AS c_0
    2323}}}
     24
     25But without `LET` clause, this works fine, e.g.
     26
     27
     28{{{
     29for $co in (air_quality_monitoring_data_co)
     30
     31return encode(
     32         scale( $co[ansi(153403), X(147522.21879115:351672.21879115004083), Y(2422004.7731021:2799154.7731021)]
     33               - min($co[ansi(153403), X(147522.21879115:351672.21879115004083), Y(2422004.7731021:2799154.7731021)])
     34                , {
     35             X:"CRS:1"(0:20), Y:"CRS:1"(0:30)
     36           } ), 
     37       "png"
     38)
     39}}}
     40
     41returns rasql query:
     42
     43{{{
     44SELECT encode(SCALE(c_0[0,0:510,0:942] -  min_cells(c_0[0,0:510,0:942]) , [0:20,0:30]), "png" , "{\"geoReference\":{\"crs\":\"EPSG:3826\",\"bbox\":{\"xmin\":147522.21879115,\"ymin\":2422004.7731020999733,\"xmax\":351672.2187911500274,\"ymax\":2799154.7731021}},\"nodata\":[-3.4028234663852886E38]}")  FROM air_quality_monitoring_data_co_8 AS c_0
     45}}}