Re, > Je suis battu !
navré ;-) > ( j'ai bien lu 0.3 secondes là ??? ) > bref, génial, tu peux lancer un : > select sum(length(way)) / 1000 as kilometers,highway from planet_osm_line > group by highway ; > ? > pour comparer un peu le tout ? J'ai oublié de préciser que j'avais l'hexagone d'hier, vu qu'on en avait discuté sur irc, par ailleurs j'ai commencé la mise en place d'un serveur de stats, mais la je bloque sur la compilation de osm2pgsql ; j'ai une debian sid en local, et le serveur est en debian stable ... Ca donne ca : kilometers | highway --------------------+--------------------------- 79860.5961444945 | 0.206983014307122 | bridge 0.441121653846127 | Route Carnot 20028.2503606825 | unclassified 891.251852073688 | trunk_link 1.30197336167158 | byway 0.185185630186395 | residential; steps 0.162340073298616 | sevice 0.068868344687671 | unordered 0.127107696723781 | plaza 35370.9607753337 | primary 30.5034615709607 | construction 0.0110064072244838 | stile 174.502092558985 | minor 33.6897339554651 | fixme 0.7481296394824 | unclassified; footway 0.96584927237178 | unclassified; tertiary 1.92542665141722 | primary; tertiary 0.134702180012195 | rersidential 0.412960323558567 | viaduct 3.23753165327698 | trail 0.655975579118692 | serviced 2307.92495794237 | service 1956.64001960595 | cycleway 0.591309340228728 | track 3443.86013963051 | footway 0.048019811554643 | roundabout 34141.4113150475 | motorway 1.3732632934915 | highway_link 113.822967213848 | bridleway 1.27381591285958 | horse 0.481520443978081 | trunk_trunk 0.0997267114847283 | track;footway 387.669231792636 | pedestrian 2426.21355834042 | motorway_link 0.258670100790942 | residential_link 6.5584380252972 | A86 0.0355950361708249 | SERVICE 18.8108601805422 | residencial 0.0712205575961773 | pediestran 0.238864854049241 | boarding_ramp 0.0624810379145539 | footway;cycleway 2.09621855883614 | tertiary; unclassified 0.972829774081196 | parking 0.112699637089047 | Passage Perrier 0.821449998364207 | unclassified 1.58731665681743 | river 0.0380400052575222 | footway; steps 0.27899740918321 | Nachtweidstraße 300.658377696188 | primary_link 135.431126964116 | FIXME - unwayed segments 17.8268516990537 | secondary 79.6511309415054 | unknown 8.65190701618342 | services 0.54584562305078 | unclassifed 0.699977013376289 | trunk_ling 0.062851742127765 | Pedestrian 1.74597709882408 | highway 0.0458993420431774 | Tertiary 1.32655922450256 | unclassified; residential 0.428547072628912 | uncassified 0.904058162700087 | moterway_link 0.168098904312517 | residental 1.00704788742508 | mini_roundabout 0.385585020313978 | footpath 0.286634104174265 | rue Henry Fontaine 42.9250559952488 | steps 11440.6295668129 | trunk 1.75819382721252 | bikeway 17.1280260146573 | living_street 0.314517829965616 | primary_trunk 0.0282053275109547 | path 137.867089475303 | unsurfaced 0.34813296517774 | motorway_junction 2797.77537708535 | track 0.824104674997568 | serivce 19521.93860792 | tertiary 15873.9541884934 | residential 12.7584245600526 | secondary_link 0.0849544834954016 | tertiary_link 0.474843232073631 | pedesrian 0.276456159453751 | access 0.391060050439477 | cemetery 163.101869736102 | FIXME 46304.4400667731 | secondary 1.41607784798379 | briddleway (86 lignes) Pour le temps de calcul de cette requete, ca donne : QUERY PLAN -------------------------------------------------------------------------------------------------------------------------------- HashAggregate (cost=8286.85..8287.27 rows=24 width=800) (actual time=1593.592..1593.773 rows=86 loops=1) -> Seq Scan on planet_osm_line (cost=0.00..7374.23 rows=182523 width=800) (actual time=0.072..407.705 rows=182053 loops=1) Total runtime: 1594.001 ms Voila voila, -- Pierre _______________________________________________ Talk-fr mailing list Talk-fr@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk-fr