Opened 6 years ago
Closed 6 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
Note:
See TracTickets
for help on using tickets.
fixed in the first patch in #1894