[postgis-users] Postgis Problem

Levert Donovan dono78fr at yahoo.fr
Fri Jun 10 01:28:15 PDT 2005


Hello, 
I am using Postgis Database for on
Postgresql-server-7.4.6 on Debian, 
I would like to convert the tutorial demo, example
popplace.shp to a sql file for postgis.
I have convert the file, to popplace.sql

The postgis database works fine, but, when I want
insert popplace.sql data, I have this error :
	ERROR:  couldnt parse objects in GEOMETRY


This insert request doesn't works
INSERT INTO "popplace"
("area","perimeter","popplace_","popplace_i","unique_key","name","name_e","name_f","unique_key__8","unique_key__9","reg_code","nts50","lat","long","sgc_code","capital","pop_range","the_geom")
VALUES
('0.000','0.000','2','1','AAKDE','Hopedale',NULL,NULL,NULL,NULL,'10','013N08','552800','601300','1010048','0','2','0101000000000000406B423F4100000020B2883341');

But, if I remove the last column "the_geom", it's
works fine
INSERT INTO "popplace"
("area","perimeter","popplace_","popplace_i","unique_key","name","name_e","name_f","unique_key__8","unique_key__9","reg_code","nts50","lat","long","sgc_code","capital","pop_range")
VALUES
('0.000','0.000','2','1','AAKDE','Hopedale',NULL,NULL,NULL,NULL,'10','013N08','552800','601300','1010048','0','2');
 


Do you know if the column "the_geom" is essential, or
do know how can I solve this error ?

Best Regards
Donovan LEVERT


	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com



More information about the postgis-users mailing list