[OSM-talk] OSM2PQSQL / PostGis: Coordinate Conversion

[Jukka Rahkonen]

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-