Opened 12 years ago

Closed 12 years ago

#4568 closed defect (fixed)

Gdaladdo behaves badly with multitable rasterlite DB

Reported by: Jukka Rahkonen Owned by: warmerdam
Priority: normal Milestone: 1.9.1
Component: GDAL_Raster Version: unspecified
Severity: normal Keywords: rasterlite overviews
Cc:

Description (last modified by Even Rouault)

Tested with GDAL 1.9.0, gdal_translate and gdaladdo. Gdaladdo seems to make something wrong with rasterlite databases which contain several raster tables.

The following example is using 3 tables, one of them having a different native resolution but the error happens also with only two tables and both having the same pixel size. Error is not only with gdalinfo, Quantum GIS also opens the second and third table as they had the bigger, faulty pixel size.

Building rasterlite DB from 3 originals
=======================================
gdal_translate -of rasterlite -a_srs epsg:2393 18m.tif
rasterlite:multitest.sqlite,table=raster_1
Input file size is 4000, 4000

gdal_translate -of rasterlite -a_srs epsg:2393 18n.tif
rasterlite:multitest.sqlite,table=raster_2
Input file size is 4000, 4000

gdal_translate -of rasterlite -a_srs epsg:2393 18mb.tif
rasterlite:multitest.sqlite,table=raster_3
Input file size is 2000, 2000

Check gdalinfo; everything OK 
=============================
gdalinfo rasterlite:multitest.sqlite,table=raster_1
Driver: Rasterlite/Rasterlite
Files: multitest.sqlite
Size is 4000, 4000
Origin = (3180000.000000000000000,6640000.000000000000000)
Pixel Size = (20.000000000000000,-20.000000000000000)

gdalinfo rasterlite:multitest.sqlite,table=raster_2
Driver: Rasterlite/Rasterlite
Files: multitest.sqlite
Size is 4000, 4000
Origin = (3260000.000000000000000,6640000.000000000000000)
Pixel Size = (20.000000000000000,-20.000000000000000)

gdalinfo rasterlite:multitest.sqlite,table=raster_3
Driver: Rasterlite/Rasterlite
Files: multitest.sqlite
Size is 2000, 2000
Origin = (3180000.000000000000000,6640000.000000000000000)
Pixel Size = (40.000000000000000,-40.000000000000000)

Add overviews
=============

gdaladdo rasterlite:multitest.sqlite,table=raster_1 2 4 8
0...10...20...30...40...50...60...70...80...90...100 - done.
0...10...20...30...40...50...60...70...80...90...100 - done.
0...10...20...30...40...50...60...70...80...90...100 - done.

gdaladdo rasterlite:multitest.sqlite,table=raster_2 2 4 8
0...10...20...30...40...50...60...70...80...90...100 - done.
0...10...20...30...40...50...60...70...80...90...100 - done.
0...10...20...30...40...50...60...70...80...90...100 - done.

gdaladdo rasterlite:multitest.sqlite,table=raster_3 2 4 8
0...10...20...30...40...50...60...70...80...90...100 - done.
0...10...20...30...40...50...60...70...80...90...100 - done.

Check gdalinfo; all but first table have wrong pixel size
=========================================================

gdalinfo rasterlite:multitest.sqlite,table=raster_1
Driver: Rasterlite/Rasterlite
Files: multitest.sqlite
Size is 4000, 4000
Origin = (3180000.000000000000000,6640000.000000000000000)
Pixel Size = (20.000000000000000,-20.000000000000000)

gdalinfo rasterlite:multitest.sqlite,table=raster_2
Driver: Rasterlite/Rasterlite
Files: multitest.sqlite
Size is 4000, 4000
Origin = (3260000.000000000000000,6640000.000000000000000)
Pixel Size = (40.000000000000000,-40.000000000000000)

gdalinfo rasterlite:multitest.sqlite,table=raster_3
Driver: Rasterlite/Rasterlite
Files: multitest.sqlite
Size is 2000, 2000
Origin = (3180000.000000000000000,6640000.000000000000000)
Pixel Size = (80.000000000000000,-80.000000000000000)

Change History (2)

comment:1 by Even Rouault, 12 years ago

Description: modified (diff)

comment:2 by Even Rouault, 12 years ago

Component: defaultGDAL_Raster
Keywords: rasterlite overviews added
Milestone: 1.9.1
Resolution: fixed
Status: newclosed

Fixed in trunk (r24127) and in branches/1.9 (r24128)

Note: See TracTickets for help on using tickets.