[OSM-talk] get latitude / longitude of points?

[Torsten Mohr]

Hi,

i'm not sure what is the best way, Mapnik or plain postgresql, maybe somebody
can give me a hint?

I'd like to get the coordinates of a point, e.g. Berlin or another city.  In 
postgres i can do:

psql -d gis
select * from planet_osm_point where name = 'Berlin';

Now several data are shown.  Which of them are the coordinates?

And even more important, how do i convert it to latitude / longitude (in 
fractions, don't need minutes and seconds).

Or is there a more convenient way in Mapnik available?


Thanks for any hints,
Torsten.