[postgis-users] Invalid Geometry Error

Darren Houston dhouston at beyondcompliance.ca
Fri Aug 26 10:38:00 PDT 2005


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-



More information about the postgis-users mailing list