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
<[email protected]> 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
<[email protected]> 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
[email protected]
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
_______________________________________________
Qgis-user mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
