[postgis-users] [postgis] Optimal tile size for Raster

2013-12-04 Thread Heng Zhi Feng (zh...@hsr.ch)
Hello, I am having to import Raster (.tiff) into Postgres using the raster2pgsql tool. The raster used is 12MB in size and the Postgres version is 9.1 on Ubuntu 13.10. The virtual machine has the following hardware specs. - 17408 Memory - 4 Processors - 16GB HDD

Re: [postgis-users] [postgis] Optimal tile size for Raster

2013-12-04 Thread Pierre Racine
) Sent: Wednesday, December 04, 2013 10:56 AM To: postgis-users@lists.osgeo.org Subject: [postgis-users] [postgis] Optimal tile size for Raster Hello, I am having to import Raster (.tiff) into Postgres using the raster2pgsql tool. The raster used is 12MB in size and the Postgres version

Re: [postgis-users] [postgis] Optimal tile size for Raster

2013-12-04 Thread Heng Zhi Feng (zh...@hsr.ch)
2013 17:43 To: PostGIS Users Discussion Subject: Re: [postgis-users] [postgis] Optimal tile size for Raster You are getting fast result because you are not operating at the pixel level. Only at the raster extent level (converted to geometry). A more usual query would be to intersect a raster

Re: [postgis-users] [postgis] Optimal tile size for Raster

2013-12-04 Thread Pierre Racine
: Wednesday, December 04, 2013 12:07 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] [postgis] Optimal tile size for Raster Hi Pierre, Thanks for the suggestion. But how could I get a geometry table in Postgres that is sure to intersect the raster image? The reason why I

Re: [postgis-users] [postgis] Optimal tile size for Raster

2013-12-04 Thread Heng Zhi Feng (zh...@hsr.ch)
2013 18:31 To: PostGIS Users Discussion Subject: Re: [postgis-users] [postgis] Optimal tile size for Raster I guess maybe you are only looking at PostGIS for its capacity to deal with raster in the database. You have to know that rasters and geometries are located in space (georeferenced) and might