<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Michal,<br>
<br>
you could use a combination of st_xmin, st_ymin, st_xmax and st_ymax
instead of st_extent. They will provide you with the same
coordinates as st_extent but in a numeric data type.<br>
<br>
Hope that helps,<br>
<br>
Birgit.<br>
<br>
<br>
Am 05.12.2011 12:26, schrieb Michał Drożdż:
<blockquote cite="mid:4edcaa7e4957a6.05754509@wp.pl" type="cite">
<style>blockquote {padding-left: 1ex; margin: 0px 0px 0px 0.8ex; border-left: #cccccc 1px solid;} p {margin: 0px;padding: 0px;} </style>
<p> </p>
<p>Hi List!</p>
<p>I am fresh Postgis user and have a problem with ST_EXTENT. I am
using it to get data for map.zoomToExtent in openLayers.</p>
<p> </p>
<p>The problem is that zoomToExtens takes parameters as
zoomToExtent(value,value,value,value)</p>
<p><a class="moz-txt-link-freetext" href="http://dev.openlayers.org/docs/files/OpenLayers/Map-js.html#OpenLayers.Map.zoomToExtent">http://dev.openlayers.org/docs/files/OpenLayers/Map-js.html#OpenLayers.Map.zoomToExtent</a></p>
<p> </p>
<p>from ST_EXTENT a receive WKT like this:</p>
<p>"BOX(2294970.88258299 6588308.80462897,2295532.89622321
6588616.7042758)"</p>
<p> </p>
<p>How to parse that answer to get paremeters for OpenLayers in
appropirate format?</p>
<p>I checked that OpenLayers is able to parse WKT but it is
impossible with BOX type.</p>
<p><a class="moz-txt-link-freetext" href="http://dev.openlayers.org/docs/files/OpenLayers/Format/WKT-js.html">http://dev.openlayers.org/docs/files/OpenLayers/Format/WKT-js.html</a></p>
<p> </p>
<p>Thank for help!</p>
<p>Michal</p>
<p> </p>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
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>