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

List:       postgis-users
Subject:    [postgis-users] shp2pgsl - couldn't parse objects in geometry
From:       Stan Kim <skim () insequenceinc ! com>
Date:       2005-09-28 16:07:14
Message-ID: 433ABFB2.3090405 () insequenceinc ! com
[Download RAW message or body]

Hello,

I'm a new user and couldn't find answer to my question in archive...

I used shp2pgsql to create a .sql file.  When I attempted to load into 
PostGIS, I got the message:

psql:cities.sql:4: ERROR:  couldnt parse objects in GEOMETRY

The offendng sql statement was:

INSERT INTO "cities" 
("city_name","gmi_admin","admin_name","fips_cntry","cntry_name","status","pop_rank","pop_class","port_id",the_geom) \
 VALUES ('Drammen','NOR-BSK','Buskerud','NO','Norway','Provincial 
capital','6','50,000 to 
100,000','23780','01010000000000006066662440000000A099D94D40');

I am running with Windows installer inversion of PostgreSQL and the 
PostGIS that came with it.

Thanks for any help.
Stan


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