[Qgis-user] displaying a layer from SQL

[McDonaldR]

Hi Steve

Can you create two views in the database from the source tables - one for points and one for polygons?

Cheers

Ross

From: qgis-user-bounces at lists.osgeo.org [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Steven Campbell
Sent: 02 June 2014 15:18
To: qgis-user at lists.osgeo.org
Subject: [Qgis-user] displaying a layer from SQL

Hi

Does anyone know if it is possible to a layer in QGIS, coming from a SQL database, that contains both point and polygon data? At the minute it brings in all the data, but only displays the polygon data, not the point data.

Any help would be greatly appreciated.

Thanks

Steve

Steve Campbell | GIS Manager
Corporate Strategy and Communications
Borough of Poole | Civic Centre | Poole BH15 2RU
Tel: 01202 633 362
Email: s.campbell at poole.gov.uk<mailto:s.campbell at poole.gov.uk>
Website:www.boroughofpoole.com<http://www.boroughofpoole.com/>
Think Green! Please Recycle

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.'
 
This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons.  Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20140602/2f85f5e3/attachment.html>