Opened 5 years ago

Closed 5 years ago

#1924 closed defect (fixed)

WMS: projection should be same level as scale operation

Reported by: Dimitar Misev Owned by: Bang Pham Huu
Priority: major Milestone: 9.7
Component: petascope Version: development
Keywords: Cc:
Complexity: Medium

Description

In the generated rasql, project() should be global level on the whole expression like the scale, instead of applying it to every subset in a rasql/wcps fragment.

E.g.

SELECT ENCODE( ( Scale( ( ( { (char)(project(c0[1826:2020, 1148:1277], "11.162109374999996447286321199499070644378662109375, 48.16608541994981607103909482248127460479736328125, 11.249999999999996447286321199499070644378662109375, 48.2246726505022564879254787229001522064208984375", "EPSG:4258", "EPSG:3857").0 / 9.78), (char)(project(c0[1826:2020, 1148:1277], "11.162109374999996447286321199499070644378662109375, 48.16608541994981607103909482248127460479736328125, 11.249999999999996447286321199499070644378662109375, 48.2246726505022564879254787229001522064208984375", "EPSG:4258", "EPSG:3857").1 / 17.36), (char)(project(c0[1826:2020, 1148:1277], "11.162109374999996447286321199499070644378662109375, 48.16608541994981607103909482248127460479736328125, 11.249999999999996447286321199499070644378662109375, 48.2246726505022564879254787229001522064208984375", "EPSG:4258", "EPSG:3857").2 / 5.98) } ) ), [0:255, 0:255] ) ) , "png", "{ \"nodata\" : [ 0 ] }") FROM Sentinel_2A_BY_B120803_0101_4 as c0

should be actually

SELECT ENCODE( ( Scale( project( { (char)(c0[1826:2020, 1148:1277].0 / 9.78), (char)(c0[1826:2020, 1148:1277].1 / 17.36), (char)(c0[1826:2020, 1148:1277].2 / 5.98) }, "11.162109374999996447286321199499070644378662109375, 48.16608541994981607103909482248127460479736328125, 11.249999999999996447286321199499070644378662109375, 48.2246726505022564879254787229001522064208984375", "EPSG:4258", "EPSG:3857"), [0:255, 0:255] ) ) , "png", "{ \"nodata\" : [ 0 ] }") FROM Sentinel_2A_BY_B120803_0101_4 as c0

Change History (1)

comment:1 by Bang Pham Huu, 5 years ago

Resolution: fixed
Status: newclosed

fixed in the first patch in #1894

Note: See TracTickets for help on using tickets.