[postgis] inserting MultiPolygons

[bouabdaddy]

Hi,

can anyone help me with the follwoing, I'm trying to insert the 
following data into one of my tables in Postgresql:

INSERT INTO 
	GEOM_SITE_BOUNDARY (Boundary_id, External_Boundary, 
Site_Centroid)
	VALUES (3456000011,GeometryFromText('MULTIPOLYGON((414699.55, 
130160.43, 414701.83, 130149.90,
	414729.20, 130155.70, 414729.20, 130155.70, 414733.25, 
130149.80,
	414735.10, 130140.90, 414743.75, 130142.70, 414740.60, 
130158.15,
	414742.15, 130158.50, 414739.65, 130169.25, 414728.05, 
130166.65,
	414727.77, 130167.93, 414724.52, 130167.19, 414717.65, 
130165.63,
	414717.85, 130164.45, 414699.55, 
130160.43))',128),GeometryFromText('POINT(414722.00,130160.00)',64));


I think I have created the tables and columns correctly I used the 
following sql:

CREATE TABLE SITE_BOUNDARY (
	Boundary_id 		DOUBLE PRECISION NOT NULL
	CONSTRAINT PK_SITE_BOUNDARY PRIMARY KEY,
	External_Boundary 	POLYGON[] NOT NULL,
	Site_Centroid 		POINT NOT NULL
);

CREATE TABLE GEOM_SITE_BOUNDARY (
	Boundary_id 		DOUBLE PRECISION NOT NULL
	CONSTRAINT PK_GEOM_SITE_BOUNDARIES PRIMARY KEY
);

but I get this error when I try to insert the data.


ERROR:  couldnt parse object in GEOMETRY

Regards Ismail


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Sponsored by VeriSign - The Value of Trust
Do you need to encrypt all your online transactions? Find
the perfect solution in this FREE Guide from VeriSign.
http://us.click.yahoo.com/jWSNbC/UdiDAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/