Custom Query (2765 matches)

1. Configure rasdaman with postgresql backend (instead of sqlite)
   • cmake ... -DDEFAULT_BASEDB=postgresql
2. Build with make/make install
   • it may require fixing compilation in *.pgc files in rel* source directories
   • especially with axis names, see changeset:7a60837d3bb57f799abb064e0470d0e39afba2f5 which only updates the sqlite *.sc files and not *.pgc
3. Initialize db with create_db.sh and update_db.sh
   • check ​this first
4. Run systemtest and fix possible issues

This query below works with 25 = ... on rgb collection

rasql -q 'SELECT ENCODE( ( Scale( ( ( case when 25 = ( extend(shift(project(c0, "6.92725,51.92725,7.838375,52.83837499999999", "EPSG:4326", "6.92725,51.92725,7.838375,52.838375", "EPSG:4326", 0.002, 0.002), [0,0]), [0:455,0:455]) )[53:402,53:402] then {255c, 255c, 255c} when 18 > ( extend(shift(project(c0, "6.92725,51.92725,7.838375,52.83837499999999", "EPSG:4326", "6.92725,51.92725,7.838375,52.838375", "EPSG:4326", 0.002, 0.002), [0,0]), [0:455,0:455]) )[53:402,53:402].1 then {0c, 0c, 255c} when 23 > ( extend(shift(project(c0, "6.92725,51.92725,7.838375,52.83837499999999", "EPSG:4326", "6.92725,51.92725,7.838375,52.838375", "EPSG:4326", 0.002, 0.002), [0,0]), [0:455,0:455]) )[53:402,53:402].2 then {255c, 255c, 0c} when 30 > ( extend(shift(project(c0, "6.92725,51.92725,7.838375,52.83837499999999", "EPSG:4326", "6.92725,51.92725,7.838375,52.838375", "EPSG:4326", 0.002, 0.002), [0,0]), [0:455,0:455]) )[53:402,53:402].0 then {255c, 140c, 0c} else {255c, 0c, 0c} end ) ), [0:255, 0:255] ) ) , "png", "{ \"nodata\" : [ 0 ] }") FROM test_rgb AS c0'

But this one with 25 > ... does not work

asql -q 'SELECT ENCODE( ( Scale( ( ( case when 25 > ( extend(shift(project(c0, "6.92725,51.92725,7.838375,52.83837499999999", "EPSG:4326", "6.92725,51.92725,7.838375,52.838375", "EPSG:4326", 0.002, 0.002), [0,0]), [0:455,0:455]) )[53:402,53:402] then {255c, 255c, 255c} when 18 > ( extend(shift(project(c0, "6.92725,51.92725,7.838375,52.83837499999999", "EPSG:4326", "6.92725,51.92725,7.838375,52.838375", "EPSG:4326", 0.002, 0.002), [0,0]), [0:455,0:455]) )[53:402,53:402].1 then {0c, 0c, 255c} when 23 > ( extend(shift(project(c0, "6.92725,51.92725,7.838375,52.83837499999999", "EPSG:4326", "6.92725,51.92725,7.838375,52.838375", "EPSG:4326", 0.002, 0.002), [0,0]), [0:455,0:455]) )[53:402,53:402].2 then {255c, 255c, 0c} when 30 > ( extend(shift(project(c0, "6.92725,51.92725,7.838375,52.83837499999999", "EPSG:4326", "6.92725,51.92725,7.838375,52.838375", "EPSG:4326", 0.002, 0.002), [0,0]), [0:455,0:455]) )[53:402,53:402].0 then {255c, 140c, 0c} else {255c, 0c, 0c} end ) ), [0:255, 0:255] ) ) , "png", "{ \"nodata\" : [ 0 ] }") FROM test_rgb AS c0'

with error

Executing retrieval query... rasdaman error 455: Execution error 455 in line 1, column 42, 
near token >: Operation not supported on operand of complex type.

test_rgb collection has 3 bands, with c.3 it is error

 rasql -q 'select c.3 + c.2 from test_rgb as c'
rasql: rasdaman query tool v1.0, rasdaman 10.0.0.
Opening database RASBASE at 127.0.0.1:7001... ok.

Executing retrieval query... 

but the error is hard to understand

rasdaman error 2003: Internal error: Entry in user defined type out of bounds.