[OSM-dev] shortest streets

Lennard ldp at xs4all.nl
Thu Sep 17 00:23:18 BST 2009


Stephan Knauss wrote:

> something like this?
> 
> select osm_id, st_length(way) as length from planet_osm_roads order by 
> length asc limit 10

Something, but not exactly that. ST_Length(way) is in projected meters, 
which varies with latitude.

-- 
Lennard




More information about the dev mailing list