[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] How to re-tile a raster after union ?
From:       Bborie Park <bkpark () ucdavis ! edu>
Date:       2012-10-31 21:12:41
Message-ID: 50919449.5060104 () ucdavis ! edu
[Download RAW message or body]

Francois,

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.

-bborie

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
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark@ucdavis.edu
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]