Opened 6 years ago

Closed 6 years ago

Last modified 6 years ago

#1840 closed defect (fixed)

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

Reported by: turbothomas Owned by: Bborie Park
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 (8)

comment:1 Changed 6 years ago by Bborie Park

Component: loader/dumperraster
Owner: changed from mcayland to Bborie Park
Summary: raster2pgsql does not tile correcly when tile-width is equal raster-width[raster] raster2pgsql does not tile correcly when tile-width is equal raster-width

comment:2 Changed 6 years ago by Bborie Park

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

comment:3 in reply to:  2 ; Changed 6 years 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

comment:4 in reply to:  3 Changed 6 years ago by turbothomas

when using -t 393x496 it works fine

comment:5 Changed 6 years ago by Bborie Park

Status: newassigned

comment:6 Changed 6 years ago by Bborie Park

Resolution: fixed
Status: assignedclosed

Fixed in r9808 for 2.0.x.

comment:7 Changed 6 years ago by Bborie Park

Fixed for 2.1 in r9810

comment:8 Changed 6 years ago by Bborie Park

Keywords: history added
Note: See TracTickets for help on using tickets.