[postgis-users] shp2pgsql Null geometries
paallen at attglobal.net
paallen at attglobal.net
Tue Feb 20 09:27:52 PST 2007
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>
More information about the postgis-users
mailing list