Custom Query (2765 matches)

SELECT encode(clip( c, POLYGON((99999888 -10000009)) ), "image/png") FROM test_mr AS c

 [INFO] - 2019-04-18 09:46:29,266: Request: 'SELECT encode(clip( c, POLYGON((99999888 -10000009)) ), "image/png") FROM test_mr AS c'... parsing... checking semantics... evaluating... [ERROR] - 2019-04-18 09:46:29,267, qlparser/qtgeometryop.cc:75: The polygon is degenerate (its vertices are colinear).

Error: 501 Error: The polygon must be 2D and be defined by vertices in a 2D grid.
[ERROR] - 2019-04-18 09:46:29,267, server/rasserver_main.cc:165: Interrupted by signal SIGSEGV (Invalid memory access at address 0x65)

Importing two images from a directory (using the -d option), seems to mess up the X dimension (and also the Y doesn't seem right).

I believe this was working fine before the 0.5 patch. I looked at the patch but can't figure out what could be the problem. Any ideas Alex?

$ rasql -q 'select sdom(c) from pan as c' --out string
rasql: rasdaman query tool v1.0, rasdaman v8 -- generated on 01.03.2012 22:47:21.
opening database RASBASE at localhost:7001...ok
Executing retrieval query...ok
Query result collection has 1 element(s):
  Result element 1: [-2147483648:12318,-2147483648:14552]
rasql done.

file 1:

Driver: GTiff/GeoTIFF
Size is 12319, 14553
Coordinate System is:
PROJCS["unnamed",
    GEOGCS["GRS 1980(IUGG, 1980)",
        DATUM["unknown",
            SPHEROID["GRS80",6378137,298.257222101]],
        PRIMEM["Greenwich",0],
        UNIT["degree",0.0174532925199433]],
    PROJECTION["Lambert_Azimuthal_Equal_Area"],
    PARAMETER["latitude_of_center",52],
    PARAMETER["longitude_of_center",10],
    PARAMETER["false_easting",4321000],
    PARAMETER["false_northing",3210000],
    UNIT["metre",1,
        AUTHORITY["EPSG","9001"]]]
Origin = (4278064.000000000000000,1995080.000000000000000)
Pixel Size = (1.000000000000000,-1.000000000000000)
Metadata:
  AREA_OR_POINT=Area
Image Structure Metadata:
  INTERLEAVE=BAND
Corner Coordinates:
Upper Left  ( 4278064.000, 1995080.000) (  9d29'29.33"E, 41d 3'13.98"N)
Lower Left  ( 4278064.000, 1980527.000) (  9d29'33.16"E, 40d55'20.15"N)
Upper Right ( 4290383.000, 1995080.000) (  9d38'14.57"E, 41d 3'16.29"N)
Lower Right ( 4290383.000, 1980527.000) (  9d38'17.30"E, 40d55'22.45"N)
Center      ( 4284223.500, 1987803.500) (  9d33'53.59"E, 40d59'18.32"N)
Band 1 Block=12319x1 Type=UInt16, ColorInterp=Gray
  Overviews: 6160x7277, 3080x3639, 1540x1820, 770x910, 385x455, 193x228

file 2:

Driver: GTiff/GeoTIFF
Size is 12704, 14958
Coordinate System is:
PROJCS["unnamed",
    GEOGCS["GRS 1980(IUGG, 1980)",
        DATUM["unknown",
            SPHEROID["GRS80",6378137,298.257222101]],
        PRIMEM["Greenwich",0],
        UNIT["degree",0.0174532925199433]],
    PROJECTION["Lambert_Azimuthal_Equal_Area"],
    PARAMETER["latitude_of_center",52],
    PARAMETER["longitude_of_center",10],
    PARAMETER["false_easting",4321000],
    PARAMETER["false_northing",3210000],
    UNIT["metre",1,
        AUTHORITY["EPSG","9001"]]]
Origin = (4840632.000000000000000,2274320.000000000000000)
Pixel Size = (1.000000000000000,-1.000000000000000)
Metadata:
  AREA_OR_POINT=Area
Image Structure Metadata:
  INTERLEAVE=BAND
Corner Coordinates:
Upper Left  ( 4840632.000, 2274320.000) ( 16d24'13.58"E, 43d22'39.24"N)
Lower Left  ( 4840632.000, 2259362.000) ( 16d23'20.64"E, 43d14'35.23"N)
Upper Right ( 4853336.000, 2274320.000) ( 16d33'34.81"E, 43d22'3.65"N)
Lower Right ( 4853336.000, 2259362.000) ( 16d32'40.60"E, 43d13'59.73"N)
Center      ( 4846984.000, 2266841.000) ( 16d28'27.39"E, 43d18'19.58"N)
Band 1 Block=12704x1 Type=UInt16, ColorInterp=Gray
  Overviews: 6352x7479, 3176x3740, 1588x1870, 794x935, 397x468, 199x234

petascopedb is going to apply some modification in its tables structure: rasimport will need to correctly fill out the metadata of the imported collections.