[OSM-dev] Projection problems

[Bradley Kite]

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" <jburgess777 at googlemail.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20081216/f41ba85b/attachment.html>