[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