<div dir="ltr"><div><div><div><div><div><div><div>I don't think there is a function to transform text into polygon<br></div>in postgis, though it can be feasible.<br><br></div>Looks like you gonna need to code a little more.<br><br></div>If you decide to stick to C#, you could use things like<br></div>dotspatial or sharpmap.<br></div>You could also just use the Npgqsl ADO connector to avoid<br></div>too many depedencies and do the math yourself. <br>Npgsql has built-in types for handling postgis geometries.<br></div></div><div class="gmail_extra"><br><div class="gmail_quote">2017-02-23 8:58 GMT+01:00 Olivier Leprêtre <span dir="ltr"><<a href="mailto:o.lepretre@gmail.com" target="_blank">o.lepretre@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div link="blue" vlink="purple" lang="FR"><div class="m_897991534009756053WordSection1"><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d" lang="EN-US">Hi,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d" lang="EN-US">Thanks for this answer Thomas, you confirm what I guessed also. Before considering this way, I had a look about attributes and didn't find how I could create raster texts layer, to display gid or other information. So I wonder if I should better not carrying on with Postgis for that but try another way...<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d">Olivier<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1f497d"><u></u> <u></u></span></p><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De :</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@<wbr>lists.osgeo.org</a>] <b>De la part de</b> Tumasgiu Rossini<br><b>Envoyé :</b> mercredi 22 février 2017 22:56<br><b>À :</b> PostGIS Users Discussion<br><b>Objet :</b> Re: [postgis-users] screen copy with postgis<u></u><u></u></span></p></div><span class=""><p class="MsoNormal"><u></u> <u></u></p><div><div><div><div><div><div><p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-US">Hi,<u></u><u></u></span></p></div><p class="MsoNormal"><span lang="EN-US">I'm not sure there is a function that can burns geometries on an existing<u></u><u></u></span></p></div><p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-US">raster.<u></u><u></u></span></p></div><p class="MsoNormal"><span lang="EN-US">So I guess you will need to create a raster for each "layer" you want to<u></u><u></u></span></p></div><p class="MsoNormal"><span lang="EN-US">draw (e.g. the polygons, the boundaries...) and merge them into a<u></u><u></u></span></p></div><p class="MsoNormal"><span lang="EN-US">final raster using st_mapalgebra.<u></u><u></u></span></p></div></span><div><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><div><span class=""><p class="MsoNormal">2017-02-22 21:48 GMT+01:00 Olivier Leprêtre <<a href="mailto:o.lepretre@gmail.com" target="_blank">o.lepretre@gmail.com</a>>:<u></u><u></u></p></span><div><div><span class=""><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US">Hi,</span><span lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US"> </span><span lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US">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.</span><span lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US"> </span><span lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US">SELECT ST_AsJPEG(ST_AsRaster(st_<wbr>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,<wbr>true))</span><span lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US"> </span><span lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US">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).</span><span lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US"> </span><span lang="EN-US"><u></u><u></u></span></p><p class="m_897991534009756053m6028859974753924749msolistparagraph"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US">1)</span><span style="font-size:7.0pt" lang="EN-US">    </span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US">Is there a way to keep those boundaries ?</span><span lang="EN-US"><u></u><u></u></span></p><p class="m_897991534009756053m6028859974753924749msolistparagraph"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US">2)</span><span style="font-size:7.0pt" lang="EN-US">    </span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US">As I have other layers, like texts, will it be possible to make them appear also, like a screen copy ?</span><span lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US"> </span><span lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US">In other words, more simply, am I on the right way or should I think to a completely different solution ?</span><span lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US"> </span><span lang="EN-US"><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US">Thanks,</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US">Olivier</span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif"" lang="EN-US"> </span><u></u><u></u></p></span><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif""><img id="m_897991534009756053m_6028859974753924749Image_x0020_1" src="cid:image001.jpg@01D28DB2.F9256BC0" alt="cid:image001.jpg@01D28DB2.F9256BC0" width="513" border="0" height="488"></span><u></u><u></u></p></div><span class=""><p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p><div class="MsoNormal" style="text-align:center" align="center"><hr style="color:#909090" noshade width="99%" size="1" align="center"></div><table class="m_897991534009756053MsoNormalTable" style="border-collapse:collapse" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td style="padding:0cm 11.25pt 0cm 6.0pt"><p class="MsoNormal"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank"><span style="text-decoration:none"><img id="m_897991534009756053_x0000_i1026" src="cid:image002.png@01D28DB3.0DF46AB0" alt="Avast logo" width="32" border="0" height="32"></span></a><u></u><u></u></p></td><td style="padding:.75pt .75pt .75pt .75pt"><p><span style="font-family:"Calibri","sans-serif";color:#3d4d5a">L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast. <br><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank">www.avast.com</a> <u></u><u></u></span></p></td></tr></tbody></table><p class="MsoNormal"><u></u> <u></u></p></span></div><span class=""><p class="MsoNormal"><span lang="EN-US"><br>______________________________<wbr>_________________<br>postgis-users mailing list<br></span><a href="mailto:postgis-users@lists.osgeo.org" target="_blank"><span lang="EN-US">postgis-users@lists.osgeo.org</span></a><span lang="EN-US"><br></span><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank"><span lang="EN-US">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</span></a><span lang="EN-US"><u></u><u></u></span></p></span></div><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p></div></div><span class="">
<br><br>
<hr style="border:none;color:#909090;background-color:#b0b0b0;height:1px;width:99%">
<table style="border-collapse:collapse;border:none">
        <tbody><tr>
                <td style="border:none;padding:0px 15px 0px 8px">
                        <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank">
                                <img src="http://static.avast.com/emails/avast-mail-stamp.png" alt="Avast logo" border="0">
                        </a>
                </td>
                <td>
                        <p style="color:#3d4d5a;font-family:"Calibri","Verdana","Arial","Helvetica";font-size:12pt">
                                L'absence de virus dans ce courrier électronique a été vérifiée par le logiciel antivirus Avast.
                                <br><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank">www.avast.com</a>
                        </p>
                </td>
        </tr>
</tbody></table>
<br>
</span></div><br>______________________________<wbr>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>