[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Newbie having trouble with Multipolygon file and ST_Within
From:       Alexandre Neto <senhor.neto () gmail ! com>
Date:       2013-06-26 9:11:18
Message-ID: CA+H0G_FcqaaKPFP6389Hft7WStvc920S-k4nk=9ao+9O81RN-Q () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Hello,

I'm not sure why, but that also happens to me sometimes when I see my data
in pgadmin. Nevertheless, like you said, all geometries are shown in GIS,
and it never give me any problems at all.

Take a look at the answer for this question:

http://gis.stackexchange.com/questions/6247/some-objects-missing-after-importing-a-shp-into-postgis


Hope it helps,

Alexandre Neto

On Tue, Jun 25, 2013 at 6:44 PM, willemb <willem@pcfish.ca> wrote:

> I have imported a multipolygon shape file into postgis 2.  When I look at
> the
> table I see that only a few of the areas are showing a value in the
> geometry
> column (geom).  When I run a spatial query using something like st_within
> against another file it seems to only work on the those rows that have a
> geom.  I can't figure out how to populate the missing geometries.  What I
> don't understand is that if I use Manifold or QGIS to view the file from
> postgis all of the areas are present even though the geometries are not
> present for the vast majority of records.  Is there a hidden column?
> Clearly there is something I'm not understanding about Multipolygon files.
> 
> 
> 
> --
> View this message in context:
> http://postgis.17.x6.nabble.com/Newbie-having-trouble-with-Multipolygon-file-and-ST-Within-tp5003597.html
>  Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 


[Attachment #5 (text/html)]

<div>Hello,</div><div><br></div>I&#39;m not sure why, but that also happens to me \
sometimes when I see my data in pgadmin. Nevertheless, like you said, all geometries \
are shown in GIS, and it never give me any problems at all.<div> <br></div><div>Take \
a look at the answer for this question:</div><div><br></div><div><a \
href="http://gis.stackexchange.com/questions/6247/some-objects-missing-after-importing \
-a-shp-into-postgis">http://gis.stackexchange.com/questions/6247/some-objects-missing-after-importing-a-shp-into-postgis</a></div>
 <div><br></div><div>Hope it helps,</div><div><br></div><div>Alexandre \
Neto<br><br><div class="gmail_quote">On Tue, Jun 25, 2013 at 6:44 PM, willemb <span \
dir="ltr">&lt;<a href="mailto:willem@pcfish.ca" \
target="_blank">willem@pcfish.ca</a>&gt;</span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">I have imported a multipolygon shape file into postgis 2.  \
When I look at the<br> table I see that only a few of the areas are showing a value \
in the geometry<br> column (geom).  When I run a spatial query using something like \
st_within<br> against another file it seems to only work on the those rows that have \
a<br> geom.  I can&#39;t figure out how to populate the missing geometries.  What \
I<br> don&#39;t understand is that if I use Manifold or QGIS to view the file \
from<br> postgis all of the areas are present even though the geometries are not<br>
present for the vast majority of records.  Is there a hidden column?<br>
Clearly there is something I&#39;m not understanding about Multipolygon files.<br>
<br>
<br>
<br>
--<br>
View this message in context: <a \
href="http://postgis.17.x6.nabble.com/Newbie-having-trouble-with-Multipolygon-file-and-ST-Within-tp5003597.html" \
target="_blank">http://postgis.17.x6.nabble.com/Newbie-having-trouble-with-Multipolygon-file-and-ST-Within-tp5003597.html</a><br>


Sent from the PostGIS - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
</blockquote></div><br></div>



_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]