[postgis-users] Posgist raster overviews created with bicubic resampling

[Bborie Park]

Davor,

Please file a ticket regarding raster2pgsql.  Any solution would not
be available in 2.0 as I don't believe VRTs permit any other
resampling method other than nearest neighbor and so would require
raster2pgsql to use a solution without VRTs.

Though you could do a combination of ST_Resample(ST_Union()) in the
database, that itself may have memory issues (run out of memory)
depending on how big the unioned raster is.

-bborie

On Sat, Nov 24, 2012 at 6:36 AM, Davor Racic <davor.racic at gmail.com> wrote:
> I could use gdal_retile to create out of db tiles, and then import them as
> overviews, but i want to do the job through st_resample.
>
>
> 2012/11/24 Davor Racic <davor.racic at gmail.com>
>>
>> Hi everyone!
>>
>> I'm PostGIS newbie, and I have a question. I'm trying to import a great
>> amount of 6000x4000 (511x512 tiles, EPSG:3765) geotiff aerial images into
>> PostGIS database. I have also created overviews (2-20). Everything work
>> perfect, but... As i can see they are created with the nearest neighbor
>> resampling method by default, but I want them to be created with bicubic
>> resampling method because they will not be used for any kind of spatial
>> analysis, only as a map background (geoserver+openlayers). Is it somehow
>> possible with raster2pgsql? How can I do this with ST_resample after
>> importing rasters with overviews. Any ideas?
>>
>> Thanks in advance
>> Davor
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



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