[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