[OSM-talk-fr] Statistiques OSM france

[Pierre Mauduit]

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