<div dir="ltr"><div><div><div>Hi Randal,<br><br></div><div>I believe there are a few things going on at the same time here.<br></div><div><br></div>When you did<br><br>select *, (st_dump(geom)).geom as the_geom from trgtgis.boundary;<br><br></div>you ended up with two geometry columns since trgtgis.boundary.* already have a geom column(the one with the multipolygons), (can't find a reason to it's name in qgis are both the_geom tho).<br><br></div><div>So, instead of using *, you should pick the columns one by one, leaving the original geometry column out.<br><br></div><div>Besides that, after using st_dump(), try cast it as the right geometry and CRS, otherwise QGIS might have problems in guessing. Something like this:<br><br></div><div>(st_dump(geom)).geom::geometry('POLYGON',<span class="im">26916</span>)<br><br></div><div>Finally, in order to be able open the layer in QGIS, you need a unique values primary key, and you can't use the original boundary primary key, because it has now duplicated values. You can wrap your query and had a <code class="">ROW_NUMBER() OVER() </code><code class="">as</code> <code class="">gid. </code>Something like this<code class="">:<br><br></code></div><div><br><div class=""><div class=""><code class="">WITH</code> <code class="">r </code><code class="">as</code> <code class=""><br>(<br></code><code class=""> SELECT</code></div><div class=""><code class=""> field1</code><code class="">,<br></code></div><div class=""><code class=""> field2,<br></code></div><div class=""><code class=""> field3,--<...><br></code></div><div class=""><code class=""> (</code><code class="">ST_Dump(geom)).geom::geometry('POLYGON',</code><code class=""><span class="im">26916</span>) </code><code class="">as</code> the_<code class="">geom</code></div><div class=""><code class=""> </code><code class="">FROM<br></code><code class=""> table_1</code><code class=""></code></div><code>)<br></code><code class="">SELECT</code><div class=""><code class=""> </code><code class="">ROW_NUMBER() OVER() </code><code class="">as</code> <code class="">id,</code></div><div class=""><code class=""> </code><code class="">r.*</code></div><div class=""><code class="">FROM</code> <code class="">r;<br><br><br></code></div><div class=""><code class="">Finally, if you want to skip all this, you can just select all your features in QGIS, start editing and use the (very handy cof cof) <a href="http://plugins.qgis.org/plugins/splitmultipart/">multipart split plugin</a>, it will split all your multipart polygons into single polygons in the original layer.<br><br></code></div><div class=""><code class="">Hope it helps,<br><br></code></div><div class=""><code class="">Alexandre<br></code></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jun 8, 2015 at 4:06 PM, Randal Hale <span dir="ltr"><<a href="mailto:rjhale@northrivergeographic.com" target="_blank">rjhale@northrivergeographic.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I've had one other suggestion - I'll add this to the list and see what happens. Luckily this isn't vital at the moment - so I have some time to play a bit and see what I can do better.<span class="im HOEnZb"><br>
<br>
On 06/08/2015 11:03 AM, Jeff McKenna wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 2015-06-07 11:50 AM, Randal Hale wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I'm breaking new ground and I'm pretty sure this might be a mistake on<br>
my end. I just need to understand why.<br>
<br>
I've set up a PostGIS database. I'm importing data through DB manager<br>
into my schema.<br>
<br>
I imported some parcel records and discovered that I had multipolygons.<br>
So I decided to break them up into single polygons through the psql<br>
interface:<br>
create table trgtgis.parcels as select *, (st_dump(geom)).geom as<br>
the_geom from trgtgis.boundary;<br>
<br>
When I go back to QGIS I have two tables called parcels (only one listed<br>
if I look through postgresql). One table is what I suspect to see with<br>
column called the_geom, data Type as Geometry, Spatial type of Polygon,<br>
SRID of 26916. The second parcel table is greyed out and doesn't have a<br>
spatial type or a SRID. Neither lists a primary key (I need to go back<br>
and add one) but I don't think this is the problem...I think.<br>
<br>
Screenshot:<br>
<a href="https://drive.google.com/file/d/0B8WLtz606XDdcFIxaG5fNExpMlU/view?usp=sharing" target="_blank">https://drive.google.com/file/d/0B8WLtz606XDdcFIxaG5fNExpMlU/view?usp=sharing</a> <br>
<br>
<br>
</blockquote>
<br>
Hi Randy,<br>
<br>
I've seen this issue before (QGIS listing multiple layers for one PostGIS table), but I did solve it, I just can't remember how I did that ha :)<br>
<br>
I believe one of my issues was that QGIS (and MapServer in fact) need a unique ID field, to display the data from PostGIS, so I always make sure to specify a unique ID field when creating tables for use in both QGIS and MapServer.<br>
<br>
-jeff<br>
<br>
<br>
<br>
<br>
<br>
</blockquote>
<br>
-- <br></span><span class="im HOEnZb">
-----------------<br>
Randal Hale<br>
North River Geographic Systems, Inc<br>
<a href="http://www.northrivergeographic.com" target="_blank">http://www.northrivergeographic.com</a><br>
<a href="tel:423.653.3611" value="+14236533611" target="_blank">423.653.3611</a> <a href="mailto:rjhale@northrivergeographic.com" target="_blank">rjhale@northrivergeographic.com</a><br>
twitter:rjhale <a href="http://about.me/rjhale" target="_blank">http://about.me/rjhale</a><br>
<a href="http://www.northrivergeographic.com/introduction-to-quantum-gis" target="_blank">http://www.northrivergeographic.com/introduction-to-quantum-gis</a><br>
Southeast OSGEO: <a href="http://wiki.osgeo.org/wiki/Southeast_US" target="_blank">http://wiki.osgeo.org/wiki/Southeast_US</a><br>
<br></span><div class="HOEnZb"><div class="h5">
_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
</div></div></blockquote></div><br></div>