[postgis-users] Invalid Geometry Error

[Jackson Luong]

nevermind my last message ... I should have looked over my coordinates 
more carefully and realized my first & last set of coordinates weren't 
the same.
it works now ... thank you (Darren)
Cheers!
-Jackson-

Jackson Luong wrote:

> 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/913911af/attachment.html>