On Mon, 2010-11-01 at 09:21 +0100, Torsten Mohr wrote:
> Hello,
>
> i once got a hint on this mailing list to use a query like this to get the
> lat/lon of the world capitals:
>
> A)
> select st_X(wayLL), st_Y(wayLL), name from (select
> ST_AsText(ST_Transform(way,4326)) as wayLL, name from pla
Hello,
i once got a hint on this mailing list to use a query like this to get the
lat/lon of the world capitals:
A)
select st_X(wayLL), st_Y(wayLL), name from (select
ST_AsText(ST_Transform(way,4326)) as wayLL, name from planet_osm_point where
capital='yes') as foo limit 5;
B)
Based on that h
2 matches
Mail list logo