[postgis] inserting MultiPolygons

[jrom]

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

Hi,

Be carefull of the syntax. The coordinates couples are separated
by a coma (,) delimiter, but within a couple coordinates are separated
by a space...So it's not:

    POINT(414722.00,130160.00)
             ^^^^^^^^

    POLYGON(414699.55, 130160.43, 414701.83, 130149.90, ...)
                   ^^^^^                  ^^^^

But something like:


    POINT(414722.00 130160.00)
             ^^^^^^^^

    POLYGON(414699.55 130160.43, 414701.83 130149.90, ...)
                   ^^^^^                ^^^^^


Regards

jrom






------------------------ Yahoo! Groups Sponsor ---------------------~-->
Sponsored by VeriSign - The Value of Trust
Secure all your Web servers now - with a proven 5-part
strategy. The FREE Server Security Guide shows you how.
http://us.click.yahoo.com/iWSNbC/VdiDAA/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/