[Routing] "Connected Nodes"

Sascha Silbe sascha-ml-gis-osm-routing at silbe.org
Mon Oct 8 21:35:38 BST 2007


On Mon, Oct 08, 2007 at 10:18:18PM +0200, Sascha Silbe wrote:

> The kind of information you seem to be after (<n> longest ways etc.) 
> is easier to determine using an SQL database, though.
I should have had a longer look at your script before writing my reply. 
:)

Let the database do the work, don't transfer data to your script unless 
absolutely necessary.
To find the 10 longest ways, do something like this (depending on your 
database schema):

select wayid, count(segmentidx) from ways group by wayid order by 
count(segmentidx) desc limit 10;


CU Sascha

-- 
http://sascha.silbe.org/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/routing/attachments/20071008/e96ab2dc/attachment.pgp>


More information about the Routing mailing list