[postgis-users] Invalid Geometry Error

[Chip Masters]

Your outer polygon ring is not closed. It looks like a
typo in the last coordinate below. '5513182.31' should
be '55313182.31'

MULTIPOLYGON(((793917.91 55313182.31, 795797.70
5513182.31, 795696.09 5511539.62, 793342.13
5511556.55, 793917.91 5513182.31)))


Chip

--- Jackson Luong <jluong at geoarctic.com> 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
> >
> 
> > _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
>
http://postgis.refractions.net/mailman/listinfo/postgis-users
> 





		
__________________________________ 
Yahoo! Mail 
Stay connected, organized, and protected. Take the tour: 
http://tour.mail.yahoo.com/mailtour.html