[maplab-users] PostGis Problem

Levert Donovan dono78fr at yahoo.fr
Thu Jun 9 10:58:04 EDT 2005


Hello, 
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


	

	
		
_____________________________________________________________________________ 
Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, photos et vidéos ! 
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com


More information about the Maplab-users mailing list