[postgis-users] screen copy with postgis

[Olivier Leprêtre]

Hi,

 

I'm trying to do a "screen copy" from a set of polygons. So I thought that I
could use St_AsRaster and St_AsJpeg as follow, with the selection of two
poly.

 

SELECT ST_AsJPEG(ST_AsRaster(st_collect((Select geom from poly where
gid=605530),(Select geom from poly where gid=605533)),1000,1000,
ARRAY['8BUI', '8BUI', '8BUI'], ARRAY[255,255,255],
ARRAY[0,0,0],null,null,0,0,true))

 

I load the result in a C# app which is in charge to save it as a file. This
"works" but I'm loosing the boundaries (tha't to say the red lines in the
image below).

 

1)    Is there a way to keep those boundaries ?

2)    As I have other layers, like texts, will it be possible to make them
appear also, like a screen copy ?

 

In other words, more simply, am I on the right way or should I think to a
completely different solution ?

 

Thanks,

 

Olivier

 





---
L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
https://www.avast.com/antivirus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170222/829fb5ef/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 12681 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170222/829fb5ef/attachment.jpg>