[OSM-dev] shortest streets
emilie.laffray at gmail.com
Thu Sep 17 09:11:33 BST 2009
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.
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 195 bytes
Desc: OpenPGP digital signature
More information about the dev