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