[postgis-users] Re: From box2d to bbox

[Obe, Regina]

Have you tried
 
ST_Box2d(the_geom)
 
Then you can get the minx, miny, maxx, maxy of that if you need those separately by using the following functions
 
ST_Box2d(ST_XMax(the_geom)), ST_Box2d(ST_XMin(the_geom)), ST_Box2d(ST_YMin(the_geom)), ST_Box2d(ST_YMax(the_geom))
 
- (I'm not sure how geoserver works)
 
 
Note if the above do not work you can strip off the ST_ part and should work fine.  I've found I can just take the text representation and just as easily parse out the points from that.
 
Hope that helps,
Regina
 
 


________________________________

From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Gustavo Ces
Sent: Tuesday, October 02, 2007 7:24 AM
To: PostGIS Users Discussion
Subject: [postgis-users] Re: From box2d to bbox


Uppsss
 
 
    St_bounday & St_perimeter. Sorry about the question! :(
    But the other one can be answered, any diferent way to extract geoserver-bbox from postgis features?
 
Gus

	----- Original Message ----- 
	From: Gustavo Ces <mailto:g.ces at pettra.es>  
	To: PostGIS Users Discussion <mailto:postgis-users at postgis.refractions.net>  
	Sent: Tuesday, October 02, 2007 1:04 PM
	Subject: From box2d to bbox

	Hi all,
	 
	    I´m trying to create geoserver images from postgis and need a bbox parameter to pass to geoserver.So, i need the minx,miny,maxx,maxy from the box2d of each feature. I can make the boxes but i don´t  find any functions to access to perimeter´s points. I see few point functions but only for linestrings. I supose i have to transform polygons to perimeter polylines but i don´t know how. Any idea?
	    Perhaps there is a better aproach, so any suggestion will be wellcomed :)
	 
	Gus
	 




-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071002/f1386164/attachment.html>