[Qgis-user] PostGIS to DXF

[Richard McDonnell]

I am back again,
Using what you said as a guide, I added a column to the table using the 
following

ALTER TABLE mv_lv_network_point
ADD COLUMN OGR_STYLE CHARACTER VARYING(80);
UPDATE mv_lv_network_point
SET OGR_STYLE = 
'LABEL(f:"Arial",s:{igds_text_size},a:{igds_rotation},t:{igds_text_string})' 
;

s:{igds_text_size} Referencing Text size column
a:{igds_rotation} Referencing Rotation Column
t:{igds_text_string}  Referencing Text String Column,

I then used the DXF Export tool, with no success.
What have I done wrong? Should I be doing this as an OGR2OGR exercise as 
opposed to using the Export tool?
Regards,

Richard.




On 09/06/2016 13:10, Heikki Vesanto wrote:
> 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:
>
> http://gisforthought.com/gis-to-cad-using-ogr2ogr-part-3-point-annotation-to-text-in-cad/
>
> On Thu, Jun 9, 2016 at 12:30 PM, Richard McDonnell
> <richard.mcdonnell at opw.ie> wrote:
>> 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: http://www.opw.ie/en/disclaimer/
>>
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160609/93dada8e/attachment.html>