[postgis-users] shp2pgsql Null geometries

[paallen at attglobal.net]

Hi all,

I noticed that my attributes had some odd spanish
characters so I decided to only keep some numeric
fields to keep life simple.

I ran these commands
shp2pgsql -w co.shp public.co1 > co1.sql
psql -d ddh -U pallen -f co1.sql

Then I ran the following query in pgAdminIII:
select gid, objectid, "__gid", AsText(the_geom) as
thegeom from public.co1

And I noticed that many of the thegeom records
were null/blank.  What has happened?  The shape
file was cleaned first with ArcGIS 9.2.

Actually the first geometry was blank.  Looking at
it in ArcGIS it was just a simple polygon with an
island.  Are islands the problem?

I have attached an insert.sql of a problematic
record.  I have looked at it in a text editor and
all looks fine to me

thanks,

Phil
-------------- next part --------------
A non-text attachment was scrubbed...
Name: insert1.sql
Type: application/octet-stream
Size: 13771 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070220/64b9aa5c/attachment.obj>