Opened 17 months ago
Last modified 16 months ago
#2750 reopened defect
FIX - rasql OVERLAY returns incorrect results
Reported by: | Bang Pham Huu | Owned by: | |
---|---|---|---|
Priority: | major | Milestone: | 10.2 |
Component: | server | Version: | 10.2 |
Keywords: | Cc: | ||
Complexity: | Medium |
Description (last modified by )
`Import the two coverages (provided by OGC CITE WMS 1.3.0 tests) in attachment:
Buildings
: two small pink rectangles at the top rightMapNeatline
: the dark-red rectangle which coversBuildings
then check the query (WMS from OGC CITE:
layers=Buildings,MapNeatline
, hence rasqlBuildings OVERLAY MapNeatline
):
rasql -q 'SELECT ENCODE( ( ( EXTEND ( scale( scale( scale( ( ( c0[0:894,0:814] ) ), [0:799, 0:399] ) [0:799, 0:399], [0:399, 0:199] ), [0:67, 0:61] ), [-230:169, -39:160] ) ) ) OVERLAY ( ( EXTEND ( scale( scale( scale( ( ( c1[0:894,0:814] ) ), [0:799, 0:320] ) [0:799, 61:259], [0:399, 0:199] ), [0:352, 0:199] ), [-23:376, 0:199] ) ) ) , "png", "{}") FROM Buildings AS c0, MapNeatline AS c1' --out file
Attachments (2)
Change History (13)
by , 17 months ago
Attachment: | rasql_community.png added |
---|
comment:1 by , 17 months ago
Description: | modified (diff) |
---|---|
Owner: | set to |
Status: | new → assigned |
comment:3 by , 17 months ago
Description: | modified (diff) |
---|---|
Status: | assigned → reopened |
comment:4 by , 17 months ago
Description: | modified (diff) |
---|
comment:5 by , 16 months ago
Owner: | changed from | to
---|---|
Status: | reopened → assigned |
comment:6 by , 16 months ago
Owner: | changed from | to
---|
by , 16 months ago
Attachment: | temp_ingredients.zip added |
---|
comment:7 by , 16 months ago
Owner: | changed from | to
---|
tiff files are added to http://rasdaman.org/attachment/ticket/2750/temp_ingredients.zip
comment:8 by , 16 months ago
Owner: | changed from | to
---|
comment:9 by , 16 months ago
Resolution: | → invalid |
---|---|
Status: | assigned → closed |
The query is wrong: it should be map overlay buildings
- to put the buildings on top of map. But the query in this ticket is buildings overlay map
.
comment:10 by , 16 months ago
Resolution: | invalid |
---|---|
Status: | closed → reopened |
@Dimitar: this ticket is not wrong, you misunderstood about it.
comment:11 by , 16 months ago
Indeed the generated rasql is correct, I suspect scale or extend do not copy the null values - or some other issue.
comment:12 by , 16 months ago
The null values in the json files are 0 which is incorrect. These files have mostly "255 255 255 0"
as value = null value. So the null set should be [255,0].
Unfortunately it doesn't seem to work well.
rasql -q 'select count_cells(c0 is null) from MapNeatline as c0' --out string Result element 1: { 0, 0, 0, 0 }
This should print some non-zero values. There's probably a bug in evaluating operations on composite arrays with null values.
The attached ingredients don't work, please fix them first.