<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2>Slight correction - I had a typo on my minmax
calls.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2>If you just want the <FONT color=#000000>
minx,miny,maxx,maxy </FONT> you can do</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2>ST_XMin(the_geom) as minx, <SPAN
class=757052113-02102007><FONT face=Arial color=#0000ff size=2>ST_YMin(the_geom)
as miny, <SPAN class=757052113-02102007><FONT face=Arial color=#0000ff
size=2>ST_XMax(the_geom) As maxx, <SPAN
class=757052113-02102007><FONT face=Arial color=#0000ff
size=2>ST_YMax(the_geom) As
maxy</FONT></SPAN></FONT></SPAN></FONT></SPAN></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2><SPAN
class=757052113-02102007></SPAN></FONT></SPAN></FONT></SPAN></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2><SPAN
class=757052113-02102007></SPAN></FONT></SPAN></FONT></SPAN></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=757052113-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Obe,
Regina<BR><B>Sent:</B> Tuesday, October 02, 2007 9:07 AM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> RE: [postgis-users] Re: From box2d to
bbox<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007>Have you tried</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007>ST_Box2d(the_geom)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=249410113-02102007>Then
you can get the minx, miny, maxx, maxy of that if you need those separately by
using the following functions</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007>ST_Box2d(ST_XMax(the_geom)), <SPAN
class=249410113-02102007>ST_Box2d(ST_XMin(the_geom)), <SPAN
class=249410113-02102007>ST_Box2d(ST_YMin(the_geom)), <SPAN
class=249410113-02102007>ST_Box2d(ST_YMax(the_geom))</SPAN></SPAN></SPAN></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=249410113-02102007>- (I'm
not sure how geoserver works)</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=249410113-02102007>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.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=249410113-02102007>Hope
that helps,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007>Regina</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=249410113-02102007> </DIV>
<DIV dir=ltr align=left><BR></DIV></SPAN></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Gustavo Ces<BR><B>Sent:</B> Tuesday, October 02, 2007 7:24 AM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> [postgis-users] Re: From box2d to
bbox<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=Arial size=2>Uppsss</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> St_bounday & St_perimeter.
Sorry about the question! :(</FONT></DIV>
<DIV><FONT face=Arial size=2> But the other one can be
answered, any diferent way to extract geoserver-bbox from postgis
features?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Gus</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=g.ces@pettra.es href="mailto:g.ces@pettra.es">Gustavo Ces</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">PostGIS Users
Discussion</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, October 02, 2007 1:04
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> From box2d to bbox</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hi all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> 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?</FONT></DIV>
<DIV><FONT face=Arial size=2> Perhaps there is a better
aproach, so any suggestion will be wellcomed :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Gus</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BLOCKQUOTE>
<P>
<HR SIZE=1>
<P></P>
<P><STRONG>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.
</STRONG></P></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
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.
</STRONG></P></BODY></HTML>