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

Bborie Park bkpark at ucdavis.edu
Mon Nov 26 08:29:23 PST 2012


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.


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
Center for Vectorborne Diseases
UC Davis
bkpark at ucdavis.edu

More information about the postgis-users mailing list