Hi Jonathan
Thanks for that. I found a work-around. I used a formula to grab the first X and Y from the multilinestring to create specific x and y columns, identifying the location for my text. Using this, along with the orientation column, I can now display my font singularly, but it is still part of my SQL database (i.e. - I haven't had to split out points, lines and polygons from my database). Steve From: Jonathan Moules [mailto:jonathanmou...@warwickshire.gov.uk] Sent: 10 May 2013 11:13 To: Steven Campbell Cc: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Displaying Text from OS Mastermap Hi Steve, Just a guess, but I'd imagine its the multilineStrings. The loader I use (an FME workbench) converts the text into a line, one correctly oriented and anchored for each point that was in the original dataset. As you can see from my styles and the screenshot - http://hub.qgis.org/wiki/quantum-gis/OS_Styles - QGIS didn't have an issue with this. Someone with better knowledge of QGIS labelling may be able to advise, but the other aspect is to try and load your data so its only a regular line. Jonathan On 9 May 2013 16:14, Steven Campbell <s.campb...@poole.gov.uk> wrote: Hi I was wondering if anyone could help. I have my OS Mastermap data stored in a SQL database and whilst I can style the polygons and lines, I am struggling with the text. For some reason, when I use the label option within QGIS, it is displaying the text twice, even though there is only one record/object there to represent the text. For some reason the application I have used to extract my GML into SQL has created multilinestrings for my text, but I don't know if that explains or not why I am getting duplicate text labels even though there is only one record in the database.... Any help would be greatly appreciated. Thanks Steve DISCLAIMER: This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the individual to whom it is addressed. The copyright in all documentation is the property of the Borough of Poole and this email and any documentation must not be copied or used other than as strictly necessary for the purpose of this email, without prior written consent which may be subject to conditions. Any view or opinions presented are solely those of the author and do not necessarily represent those of the Borough of Poole. The Borough of Poole reserves the right to inspect incoming and outgoing emails. If you have received this email in error please contact the sender by return and confirm that its contents have been destroyed. Telephone enquiries should be directed to the Borough switchboard on 01202 633633.
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user