Re: [postgis-users] PostGIS Rasters Overview Factor

[David Haynes]

You are correct overviews are powers based. Also it does not look like you
specified tile size in your raster2pgsql statement


raster2pgsql -s  -d -Y -e -I -C -F -M -t  x  -l
2,4,8,16,32

On Wed, May 10, 2017 at 11:04 AM, Osahon Oduware 
wrote:

> Hi All,
>
> I tried loading a raster with overviews using the raster2pgsql tool using
> the syntax below:
>
> raster2pgsql -s  -d -Y -e -I -C -F -M -l 2,4,8,16,32,64,128,256,512,
> 1024,2048,4096,8192,16384,32768,65536 /path/to/raster/file  |
> psql -h  -U postgres -p 5432 -d 
>
> but it gave an error message stating that the overview factor cannot be
> more than 1,000.
>
> I would like to know how the Overview-factor works. Must the value for the
> Overview-factor be in Powers of 2 (i.e. 2,4,8,16,...)?
>
> I would be glad if someone could help my understanding.
>
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[postgis-users] PostGIS Rasters Overview Factor

[Osahon Oduware]

Hi All,

I tried loading a raster with overviews using the raster2pgsql tool using
the syntax below:

raster2pgsql -s  -d -Y -e -I -C -F -M -l
2,4,8,16,32,64,128,256,512,1024,2048,4096,8192,16384,32768,65536
/path/to/raster/file  | psql -h  -U postgres -p
5432 -d 

but it gave an error message stating that the overview factor cannot be
more than 1,000.

I would like to know how the Overview-factor works. Must the value for the
Overview-factor be in Powers of 2 (i.e. 2,4,8,16,...)?

I would be glad if someone could help my understanding.
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users