<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
You can use ST_Xmin(), ST_Xmax(), ST_YMin(), ST_YMax() to access the
box's perimeter points.<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/docs/ch06.html#id2698174">http://postgis.refractions.net/docs/ch06.html#id2698174</a><br>
<br>
<br>
ie.<br>
<tt>select ST</tt><tt>_Xmin(box), ST</tt><tt>_Xmax(box), ST</tt><tt>_Ymin(box),
ST</tt><tt>_Ymax(box) <br>
from <br>
(select 'BOX(1138702.125 1491790.5,1138720.875 1491828.625)'::box2d
as box<br>
) as foo;<br>
<br>
st_xmin | st_xmax | st_ymin | st_ymax <br>
-------------+-------------+-----------+-------------<br>
1138702.125 | 1138720.875 | 1491790.5 | 1491828.625<br>
(1 row)<br>
</tt><br>
<pre class="moz-signature" cols="72">-------------
Kevin Neufeld
Software Developer
Refractions Research Inc.
300-1207 Douglas St.
Victoria, B.C., V8W 2E7
Phone: (250) 383-3022
Email: <a class="moz-txt-link-abbreviated" href="mailto:kneufeld@refractions.net">kneufeld@refractions.net</a></pre>
<br>
<br>
Gustavo Ces wrote:
<blockquote cite="mid:003401c804e3$ffb79dd0$ba03a8c0@GUS" type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta content="MSHTML 6.00.2900.2180" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">Hi all,</font></div>
<div> </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> </div>
<div><font face="Arial" size="2">Gus</font></div>
<div> </div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>