[postgis-users] How to re-tile a raster after union ?

Francois Hugues hugues.francois at irstea.fr
Thu Nov 1 00:23:54 PDT 2012

Thanks for your answer. I'll take a look at ST_Tile prototype.


-----Message d'origine-----
De : postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-bounces at lists.osgeo.org] De la part de Bborie Park
Envoyé : mercredi 31 octobre 2012 22:13
À : postgis-users at lists.osgeo.org
Objet : Re: [postgis-users] How to re-tile a raster after union ?


You are correct.  ST_Tile() doesn't exist in 2.0 but a prototype can be found in the raster/scripts/plpgsql directory.

You really ought to upgrade PostGIS to 2.0.1 as there were a bunch of bug fixes there.


On 10/31/2012 12:59 PM, Francois Hugues wrote:
> Hi,
> I have a tiled dem which I want to use to calculate slopes. If I want to avoid the border effect between each tile, I have to use st_union (the faster version, thanks to P. Racine).
> But, if I'm not wrong, I will obtain a single tile raster. The answer to my question is maybe so obvious that I can't see it, but how can I re-tile my raster in a new table. Is there no other way to tile than to use raster2pgsql ? I'm surprised that there is no postgis function for that so I think I may miss something.
> Thanks for your answer and advices !
> Hugues.
> PS : I'm trying to clip my raster to reduce time, but I have a problem with ST_Clip. After little googling, I saw that few people had this error but I did not find the solution. Does an upgrade should solve this issue ?
> ERROR:  rt_raster_gdal_rasterize: Unable to add band to GDALDataset
> CONTEXT:  PL/pgSQL function "st_asraster" line 26 at RETURN PL/pgSQL 
> function "st_clip" line 36 at assignment
> "POSTGIS="2.0.0 r9605" GEOS="3.3.2-CAPI-1.7.2" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8" LIBJSON="UNKNOWN" (core procs from "2.0.0rc1 r9576" need upgrade) TOPOLOGY (topology procs from "2.0.0rc1 r9576" need upgrade) RASTER (raster procs from "2.0.0rc1 r9576" need upgrade)"

Bborie Park
Center for Vectorborne Diseases
UC Davis
bkpark at ucdavis.edu
postgis-users mailing list
postgis-users at lists.osgeo.org

More information about the postgis-users mailing list