Hi,
I see that there are functions for raster output like
ST_AsGdalRaster(), ST_AsTiff(), ST_AsJPEG(), etc.
How can I export this to a valid rasterfile? Do I need to write my own
script or is there a trick with psql?
Here is my query:
SELECT ST_AsTiff(ST_Clip(
(SELECT ST_Union(
ST_Intersection(dtm.rast, ST_BUFFER(lieg.the_geom,-0.5))) AS raster
FROM dtm.dtmav2002 dtm, av_user.liegenschaften lieg WHERE
lieg.gru_nummer = 'B7294' AND ST_Intersects(dtm.rast, lieg.the_geom)),
(SELECT the_geom FROM av_user.liegenschaften WHERE gru_nummer =
'B7294'),true)) AS clipped_raster;
How can I output this to a tiff-file in the filesystem? I tried with
psql -d uster -U an -t -c "query as above" >test.tif
but when I open test.tif it tells me that there is no valid
tiff-header.
Any idea how can export the result of my query?
Thanks,
Andreas
--
--
Andreas Neumann
Böschacherstrasse 10A
8624 Grüt (Gossau ZH)
Switzerland
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
