[postgis-users] Invalid Geometry Error

Jackson Luong jluong at geoarctic.com
Fri Aug 26 10:44:56 PDT 2005


Thanks Darren,

I've added the extra brackets, but now I get a "Geometry Contains 
Non-Closed Rings". hmmm ....

-Jackson-

Darren Houston wrote:

>Hello,
>
>Try 
>
>MULTIPOLYGON(((793917.91 55313182.31, 795797.70
>5513182.31, 795696.09 5511539.62, 793342.13 5511556.55, 793917.91
>5513182.31)))
>
>POLYGONS use 2 brackets.
>
>Hope this helps,
>
>Darren H.
>
>On August 26, 2005 10:25 am, Jackson Luong wrote:
>  
>
>>Hello All, I'm fairly new to PostgreSQL and PostGIS and I have a fairly
>>basic question ...
>>
>>I'm trying to Update a Geometry column with the following SQL statement,
>>but I keep getting an 'Invalid Geometry Error'
>>
>>*UPDATE "parcels" SET "the_geom" =
>>GeometryFromText('MULTIPOLYGON((793917.91 55313182.31, 795797.70
>>5513182.31, 795696.09 5511539.62, 793342.13 5511556.55, 793917.91
>>5513182.31))', 26911) WHERE "PARCEL_ID"='123456'*
>>
>>Can someone please point out the error of my ways?  Thanks in Advance ...
>>
>>-Jackson-
>>    
>>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050826/27868de0/attachment.html>


More information about the postgis-users mailing list