<p>Only its actually an sqlite database (<a href="http://trac.openstreetmap.org/ticket/1371">http://trac.openstreetmap.org/ticket/1371</a>) so I'm having to do everything in the application.</p>
<p>Now that I've been pointed in the right direction I will see how I get on tomorrow.</p>
<p>Many thanks once again.<br>
--<br>
Brad</p>
<p><blockquote>On 16 Dec 2008, 9:18 PM, "Jon Burgess" <<a href="mailto:jburgess777@googlemail.com">jburgess777@googlemail.com</a>> wrote:<br><br><p><font color="#500050">On Tue, 2008-12-16 at 16:56 +0000, Bradley Kite wrote:
> The Lat/Long I am using is (bounding box ar...</font></p>A different approach is to add the projection into postgis[1] and then<br>
get it to perform the translation for you.<br>
<br>
gis=> select astext(transform(setSRID('BOX3D(-0.90362548828125 51.38892310050485,-0.90087890625 51.38720911696496)'::box3d,4326),900913));<br>
<br>
astext<br>
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
 POLYGON((-100591.129223292 6690074.46363176,-100591.129223292<br>
6690380.30887971,-100285.381110152 6690380.30887971,-100285.381110152<br>
6690074.46363176,-100591.129223292 6690074.46363176))<br>
(1 row)<br>
<br>
Or combine into a query:<br>
<br>
gis=> select osm_id,name,highway from planet_osm_line where way &&<br>
transform(setSRID('BOX3D(-0.90362548828125 51.38892310050485,-0.90087890625 51.38720911696496)'::box3d,4326),900913);<br>
<br>
  osm_id  |            name             |   highway<br>
----------+-----------------------------+--------------<br>
  4680773 | Whitewater Stream           |<br>
  4413806 | Langley Common Road         | tertiary<br>
   -29509 | Round Berkshire Cycle Route |<br>
 28628603 | Baird Road                  | unclassified<br>
  4413805 |                             | primary<br>
  4413804 |                             | primary<br>
 28320636 | Baird Road                  | unclassified<br>
 28334054 | Bramshill Road              | unclassified<br>
 28320706 | Valon Road                  | residential<br>
 28371170 | Valon Road                  | residential<br>
 28371187 | Valon Road                  | residential<br>
 28379459 | Hill Road                   | residential<br>
<br>
        Jon<br>
<br>
1: <a href="http://wiki.openstreetmap.org/wiki/Mercator#PostGIS_.2F_SQL" target="_blank">http://wiki.openstreetmap.org/wiki/Mercator#PostGIS_.2F_SQL</a><br>
<br>
<br>
<br>
</blockquote></p>