<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I am back again,<br>
Using what you said as a guide, I added a column to the table using
the following<br>
<br>
ALTER TABLE mv_lv_network_point<br>
ADD COLUMN OGR_STYLE CHARACTER VARYING(80);<br>
UPDATE mv_lv_network_point<br>
SET OGR_STYLE =
'LABEL(f:"Arial",s:{igds_text_size},a:{igds_rotation},t:{igds_text_string})'
;<br>
<br>
s:{igds_text_size} Referencing Text size column<br>
a:{igds_rotation} Referencing Rotation Column<br>
t:{igds_text_string} Referencing Text String Column,<br>
<br>
I then used the DXF Export tool, with no success.<br>
What have I done wrong? Should I be doing this as an OGR2OGR
exercise as opposed to using the Export tool?<br>
Regards,<br>
<br>
Richard.<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 09/06/2016 13:10, Heikki Vesanto
wrote:<br>
</div>
<blockquote
cite="mid:CAFTGJ2Bmnt4HJK1GLm_-_fB8o1s6-jxr0jr8j5-v7b_aFarf-g@mail.gmail.com"
type="cite">
<pre wrap="">With ogr2org (which QGIS uses for import/export), when writing a DXF
file, if you have an input point geometry, which has an OGR_STYLE
attribute, it will be written as a text geometry when opened in CAD.
This will work straight from a database as well. But there is a guide
that uses gml at:
<a class="moz-txt-link-freetext" href="http://gisforthought.com/gis-to-cad-using-ogr2ogr-part-3-point-annotation-to-text-in-cad/">http://gisforthought.com/gis-to-cad-using-ogr2ogr-part-3-point-annotation-to-text-in-cad/</a>
On Thu, Jun 9, 2016 at 12:30 PM, Richard McDonnell
<a class="moz-txt-link-rfc2396E" href="mailto:richard.mcdonnell@opw.ie"><richard.mcdonnell@opw.ie></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Afternoon all,
I would firstly like to say that the DXF Export option is great, and is a
great addition to QGIS.
I do have one problem though which you you may be able to help with.
I have a PostGIS database LineStrings and Points (Text)
What I would like to do is have the text export also, all I get when I
export the points is....Points, no text.
I would appreciate any help, I am tying to get a Map out at the moment and
would have a preference to output it via QGIS.
Regards,
Richard.
OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past
***********************************************************
Email Disclaimer: <a class="moz-txt-link-freetext" href="http://www.opw.ie/en/disclaimer/">http://www.opw.ie/en/disclaimer/</a>
_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: 01 6476543</small></small></div>
</body>
</html>