Ticket #1840 (closed defect: fixed)

Opened 12 months ago

Last modified 12 months ago

[raster] raster2pgsql does not tile correcly when tile-width is equal raster-width

Reported by: turbothomas Owned by: dustymugs
Priority: medium Milestone: PostGIS 2.0.1
Component: raster Version: 2.0.x
Keywords: raster2pgsql, tile_size, history Cc:

Description

I was trying to load a long thin raster using raster2pgsql. When I set the tile width to the width of the raster, changing only the height, only one tile was loaded; the rest of the raster was missing. If the tile size was smaller or bigger than the raster size, the entirer raster was loaded correctly.

Change History

  Changed 12 months ago by dustymugs

  • owner changed from mcayland to dustymugs
  • component changed from loader/dumper to raster
  • summary changed from raster2pgsql does not tile correcly when tile-width is equal raster-width to [raster] raster2pgsql does not tile correcly when tile-width is equal raster-width

follow-up: ↓ 3   Changed 12 months ago by dustymugs

Can you provide the flags and parameters you're using when calling raster2pgsql?

in reply to: ↑ 2 ; follow-up: ↓ 4   Changed 12 months ago by turbothomas

Replying to dustymugs:

Can you provide the flags and parameters you're using when calling raster2pgsql?

I was using subdataset2 (now extracted with gdal_transform -sds) from file listed in comments of #1839

raster2pgsql.exe -s 0 -I -C -M myraster.tif -F -t 392x496 mypostgisraster > raster.sql

using windows 7, 64-bit

in reply to: ↑ 3   Changed 12 months ago by turbothomas

when using -t 393x496 it works fine

  Changed 12 months ago by dustymugs

  • status changed from new to assigned

  Changed 12 months ago by dustymugs

  • status changed from assigned to closed
  • resolution set to fixed

Fixed in r9808 for 2.0.x.

  Changed 12 months ago by dustymugs

Fixed for 2.1 in r9810

  Changed 12 months ago by dustymugs

  • keywords tile_size, history added; tile_size removed
Note: See TracTickets for help on using tickets.