Try select astxt(the_geom) as wkt from mytable where ...
kusum wrote: > this feature also uses points for a polygon and the problem is I have > geometry of polygon and not the x y cordinates. > Please suggest any function if there in postgres to convert the goemetry > field to cordinates or any other method in openlayers if exists to highlight > polygon using goemetry. > > -------------------------------------------------- > From: "Eric Lemoine" <[EMAIL PROTECTED]> > Sent: Monday, March 17, 2008 3:30 PM > To: "kusum" <[EMAIL PROTECTED]> > Cc: <[email protected]> > Subject: Re: [OpenLayers-Users] How to get information on clicking on a > polygon > >> On Mon, Mar 17, 2008 at 8:07 AM, kusum <[EMAIL PROTECTED]> wrote: >>> Hi Eric >>> >>> Thanks for replying back. >>> I am able to fetch information from database. But the problem is that I >>> am >>> not able to highlight the polygon on map. >>> To highlight it on map I need all the points in it. But the database I >>> have >>> in postgresql has field goem and I am not getting how to convert the >>> goem >>> field into coordinates so that I can get points to highlight the polygon >>> on >>> map. >>> >>> Please suggest any function if there in postgres to convert the goemetry >>> field to cordinates or any other method if exists to highlight polygon >>> using >>> goemetry. >> You have multiple solutions. One simple solution involves having the >> server send the wkt string and use OpenLayers.Format.WKT to parse that >> string. >> >> -- >> Eric > > > _______________________________________________ > Users mailing list > [email protected] > http://openlayers.org/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://openlayers.org/mailman/listinfo/users
