Opened 12 years ago

Last modified 12 years ago

#4568 closed defect

Gdaladdo behaves badly with multitable rasterlite DB — at Initial Version

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

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 (0)

Note: See TracTickets for help on using tickets.