[postgis] Inserting MultiPolygons

[bouabdaddy]

Hi all,

I'm still having trouble inserting the data I've been talking about.
I made the chages dave suggested about the srid to -1...but I still 
get the same error....

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

SELECT
AddGeometryColumn
('land_use','GEOM_SITE_BOUNDARY','External_Boundary',-
1,'MULTIPOLYGON',2);

SELECT
AddGeometryColumn('land_use','GEOM_SITE_BOUNDARY','Site_Centroid',-
1,'POINT',0);


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));

very atuck!!!!
any more ideas anyone?

Thanks 

Ismail





------------------------ Yahoo! Groups Sponsor ---------------------~-->
Tiny Wireless Camera under $80!
Order Now! FREE VCR Commander!
Click Here - Only 1 Day Left!
http://us.click.yahoo.com/nuyOHD/7.PDAA/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/