[Qgis-user] PostGIS to DXF

[Richard McDonnell]

I think I know what is going wrong, what I am getting is

LABEL(f:"Arial",s:{igds_text_size},a:{igds_rotation},t:{igds_text_string})

in the Column, its my SQL thats wrong!
I will look into it.
Thanks again,

Richard.



On 09/06/2016 16:23, Heikki Vesanto wrote:
> Technically it should work with the export.
>
> In you table does the "OGR_STYLE" column look correct, something like:
> LABEL(f:"Arial",s:10,a:20,t:"My text label")
>
> For each row.
>
> Also are you opening the dxf file in CAD? It will still appear as
> points in QGIS. The text is a CAD feature. Try DWG TrueView
> http://www.autodesk.com/products/dwg/viewers.
>
> -Heikki
>
> On Thu, Jun 9, 2016 at 4:08 PM, Richard McDonnell
> <richard.mcdonnell at opw.ie> 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

-- 
*_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/075cfc1b/attachment.html>