[Qgis-user] PostGIS to DXF

[Andreas Neumann]

Hi Richard,

How did you export your DXF?

There are two options:
a) Save AS (through OGR)
b) Menu Project --> Export DXF which is a native QGIS DXF export not 
using OGR.

Option b) is much more powerful and should export your label fine - not 
with all details - as QGIS labels are more powerful than DXF labels, but 
basic stuff, such as font-family, font-size, multi-line labels, etc. 
should be exported fine.

If not, please submit a bug report with some sample data.

Option a) is what was discussed here, but is much more complicated - you 
would have to create separate columns with feature styles first.

Andreas

On 09.06.2016 17:08, Richard McDonnell wrote:
> 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
>
>
> _______________________________________________
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160609/9e8c9778/attachment.html>