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 <[email protected]> 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 > <[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
