Alexander Menk <menk-you.should.remove.this.for.permanent.contact <at> mestrona.net> writes:
> > Hi! > > how can I translate the coordinate from the database to "normal" GPS > coordinates as they are used by OpenLayers etc. > > SELECT ST_Transform(lat,4326) FROM planet_osm_nodes Try: select transform(way,4326) from osm_line limit 1; If you mostly need epsg:4326 coordinates you can run osm2pgsql with -l switch. Or then you can reproject the whole table afterwards with a command like: update osm_point set way=transform(way,2393); -Jukka Rahkonen- _______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk