[postgis] Inserting MultiPolygons

[bouabdaddy]

Hi,

thanks to everyone who replied to my mail...

I think that I maight have included some code that wasn't relevant.

This is the SQL I use to create the table and columns 

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

This works fine.

I have changed the format of my insert statements in accordance to 
your suggestions, but I stiil get the following error.

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

psql:GEOM_INSERTS.txt:8: ERROR:  couldnt parse object in GEOMETRY

Can anyone help?

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/