[OSM-dev] shortest streets

Stephan Knauss osm at stephans-server.de
Thu Sep 17 00:08:22 BST 2009


yummy goop wrote:
> How can I search OSM for:
> - the shortest streets in my city/country/planet


something like this?

select osm_id, st_length(way) as length from planet_osm_roads order by 
length asc limit 10

31970890;0.00747434498740587
32782134;0.0100000000093132
29014067;0.0199999995529652
29058352;0.0199999997764806
28726755;0.0200000000040745
29014076;0.0200000000186265
6477976;0.022360680212323
29058350;0.0299999995529632
32969614;0.0316227758948597
27320124;0.0316227758948597


Stephan




More information about the dev mailing list