Stephan Knauss wrote: > So could you specify a better projection that would be equidistant? The > data here uses 900913. > Would 4326 be equidistant? > > I wouldn't use 4326 to determine a distance. You may want to use a tool to calculate an UTM zone for each streets you are measuring to have a real distance in meters. > Then it could read like this: > select osm_id, length(st_transform(way,4326)) as length from > planet_osm_roads order by length asc limit 10 > > ST_Length always returns a distance in the unit of the SRID. > Is there a difference between st_length() and length()? They both return > the same values (at least for 900913). > > They are the same. ST_Length is just the standard name.
Emilie Laffray
signature.asc
Description: OpenPGP digital signature
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
