[postgis-users] Re: From box2d to bbox

[Obe, Regina]

Slight correction - I had a typo on my minmax calls.
 
If you just want the  minx,miny,maxx,maxy  you can do
 
ST_XMin(the_geom) as minx, ST_YMin(the_geom) as miny, ST_XMax(the_geom)  As maxx,  ST_YMax(the_geom)  As maxy
 
 
 
 

________________________________

From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Obe, Regina
Sent: Tuesday, October 02, 2007 9:07 AM
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Re: From box2d to bbox


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. 




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