I use the PostGIS-build-in raster2pgsql to load SAGA-raster into the db. I tried to grid them into 100x100-tiles, just as seen in the code:
/usr/lib/postgresql/9.2/bin/raster2pgsql -s 32632 -a -F -Y ~/Desktop/examplerast.sdat -t 100x100 import.exampletable | psql testrun -h localhost -p 5432 -U dbmaster
The strange thing is, that tiles in PostgreSQL/PostGIS have doubled dimensions: 200x200; as can be seen here:
select st_asewkt(st_envelope(rast)) from grids.exampletable limit 1;
SRID=32632;POLYGON((589203.15 5954785.35,589203.15 5954787.35,589205.15 5954787.35,589205.15 5954785.35,589203.15 5954785.35)) (1 row)
In order to achieve the desired 100x100-tiles I have to load them with a dimension
Why this doubling of dimensions? How to get rid of it? Thanks in advance!