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

[Milo van der Linden]

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 at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/talk
>
>