http://postgis.refractions.net/documentation/manual-svn/ST_X.html http://postgis.refractions.net/documentation/manual-svn/ST_Y.html
select st_X(st_transform(way,4326)), st_Y(st_transform(way,4326)) from planet_osm_point where ... 4326 is the coordinate-system number for wgs84, change it to fit your needs. In general you can find postgis documentation at: http://postgis.refractions.net/documentation/ Kind regards, Milo van der Linden Torsten Mohr wrote: > 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. > > _______________________________________________ > talk mailing list > talk@openstreetmap.org > http://lists.openstreetmap.org/listinfo/talk > > _______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk
