[Qgis-user] PostGIS to DXF

[Heikki Vesanto]

You probably want something like:
SET OGR_STYLE = 'LABEL(f:"Arial",s: ' || igds_text_size::character
varying || ' ,a: ' || igds_rotation::character varying || ' ,t: ' ||
igds_text_string || ') ';

On Thu, Jun 9, 2016 at 4:29 PM, Richard McDonnell
<richard.mcdonnell at opw.ie> wrote:
> 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