[postgis-users] shp2pgsl - couldn't parse objects in geometry

Stan Kim skim at insequenceinc.com
Wed Sep 28 09:07:14 PDT 2005


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




More information about the postgis-users mailing list