[postgis-users] Error browsing database

[Bborie Park]

On 05/24/2012 01:08 PM, Paolo Cavallini wrote:
> Il 24/05/2012 20:28, Bborie Park ha scritto:
>> Double checking your query, the table created doesn't have an "rid"
>> column and the raster column must be called "rast".  These are
>> limitations of the GDAL PostGIS Raster driver...
> OK, so now:
> 
> CREATE TABLE
> dtm_wgs84c                                                         
>  AS SELECT rid,  ST_Transform(rast,4326, 'Bilinear') AS rast
>   FROM hdr;
> 
> results in:
> 
> ERROR 1: Error, the table public.dtm_wgs84c contains tiles with
> different size, and irregular blocking is not supported yet
> 
> I suppose the transformation stretches the geometries.
> All the best.
> 

Correct.  That and when each tile is transformed, the output isn't
aligned with the rest of the transformed tiles.  There has been
discussion about adding a reference raster to ensure the transformed
tiles are aligned.

-bborie

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu