[OSM-dev] Projection problems
Bradley Kite
bradley.kite at gmail.com
Tue Dec 16 21:52:51 GMT 2008
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>
More information about the dev
mailing list