<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi,<br>
<br>
if your polygons and multi-polygons are in the same table first of
all, as you indicated, try to create polygon and multi-polygon
views. But if you want to edit the data, then better is to keep
polygons in one table and multi-polygons in another.<br>
One more thing - check if the polygons and multi-polygons are
valid.<br>
<br>
Regards,<br>
<br>
On 2013.04.10. 18:51, Steven Campbell wrote:<br>
</div>
<blockquote
cite="mid:BCD91869E1F4724AA09DF95E8E69A51002FF0150@BOPMAIL.poole.gov.uk"
type="cite">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 12 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Arial","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Hi<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">I
hope someone can help, I have a layer in a sql database that
contains both polygons and multi-polygons. I am trying to
bring this in to QGIS. I can connect without a problem but
only a few of the polygons are appearing, can anyone help
explain where I might be going wrong? I’m pretty new to QGIS
(only been using for a couple of days) – would I have to
create views of my singular layer on SQL (one with polygons
and one with the multi-polygons) for the application to
bring all that data in?<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Any
help would be greatly received.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Thanks<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Steve<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif""><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Steve
Campbell<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">GIS
Manager<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Corporate
Strategy and Communications<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Borough
of Poole | Civic Centre | Poole BH15 2RU<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Tel:
01202 633 362<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Email:
<a moz-do-not-send="true"
href="mailto:s.campbell@poole.gov.uk">s.campbell@poole.gov.uk</a><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Arial","sans-serif"">Website:<a
moz-do-not-send="true"
href="http://www.boroughofpoole.com/">www.boroughofpoole.com</a><o:p></o:p></span></p>
<p class="MsoNormal"><b><i><span
style="font-family:"Arial","sans-serif";color:#00B050">Think
Green! Please Recycle<o:p></o:p></span></i></b></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p>DISCLAIMER:<br>
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.
<br>
</p>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Pēteris Brūns
SunGIS
+371 26336691
<a class="moz-txt-link-abbreviated" href="mailto:pb@sungis.lv">pb@sungis.lv</a></pre>
</body>
</html>