[OSM-talk-fr] on en est où ?

[Marc Monnerat]

Bon, osm2pgsql crée deux tables pour les objets linéaires, la  
première  nommée "line", la seconde "roads". Voici ce que donne la  
même manip' sur la première table, est-ce plus plausible ?
highway=footway donne 880 km


                  highway                 |         km
-----------------------------------------+--------------------
  A86                                     |    4.3238188395111
  bridge                                  |  0.137427508325323
  bridleway                               |   58.3772189630805
  cycleway                                |   346.811709446566
  fixme                                   |   25.5403187627262
  FIXME                                   |   139.222282690137
  FIXME - unwayed segments                |   241.778121045982
  footpath                                | 0.0544104226284157
  footway                                 |   879.999127266767
  footway;cycleway                        | 0.0421756142757162
  footway; steps                          | 0.0123242584915282
  horse                                   |  0.935132385096057
  L'Haÿ-les-Roses                         | 0.0375820424590043
  mini_roundabout                         |  0.853676542098091
  minor                                   |   103.523542690037
  moterway_link                           |  0.596442906007757
  motorway                                |   19010.7462049063
  motorway_link                           |   1057.32457913354
  motorway_linkk                          | 0.0546372681891887
  motoway_link                            |  0.347447833970895
  orimary                                 | 0.0364158423547244
  Passage Perrier                         | 0.0743940525526889
  pedestrian                              |   80.4209220068461
  Pedestrian                              |  0.041469003036962
  place                                   | 0.0558316975533359
  primary                                 |   16620.7549220422
  primary_junction                        |  0.527066780120109
  primary_link                            |    101.72818527859
  primary; tertiary                       |   1.33547682892702
  primary_trunk                           |  0.217045919281989
  railway                                 |  0.341311763798125
  resdential                              |  0.696404039100516
  residential                             |   3243.02145029161
  residential_link                        |   0.17571113703289
  residential; secondary                  |   0.89084731988001
  residential; unclassified; unclassified |   1.08991142442636
  roundabout                              |  0.104493240721296
  Route Carnot                            |  0.288610787210982
  rue Henry Fontaine                      |  0.187790684236764
  secondary                               |   18619.6499600265
  secondary_link                          |   7.31601787867594
  service                                 |   455.546715866956
  stairs                                  | 0.0298751810089464
  steps                                   |   8.09821492801028
  teratiary                               |   1.17640799350018
  tertiary                                |   6597.33326748891
  Tertiary                                | 0.0338721333913796
  tertiary_link                           | 0.0176061849547566
  tertiary; unclassified                  |   1.38297061311391
  track                                   |   416.568981504397
  track                                   |  0.404643995949291
  trunk                                   |   5417.04007752813
  trunk_ling                              |  0.475093242551372
  trunk link                              |  0.365164233601121
  trunk_link                              |   361.450247335315
  trunk_trunk                             |  0.322748055114896
  unclasified                             |    0.4358580425202
  unclassifed                             |  0.346482080321269
  unclassified                            |   7554.98961369162
   unclassified                           |   0.53789281073269
  unclassified; footway                   |  0.498191690943398
  unclassified; tertiary                  |  0.143132068574005
  unknown                                 |   246.821188819693
  unordered                               |  0.157104794842674
  unsurfaced                              |   23.5770893785214
                                          |   17188.2222699531

Marc


Le 7 janv. 08 à 17:37, Axel R. a écrit :

> Thomas Walraet a écrit :
>> marc.monnerat at bluewin.ch wrote:
>>
>>> osm=# SELECT highway, sum(length(ST_Transform(way,27572))/1000) as
>>> km  FROM planet_france_roads group by highway order by highway;
>>>     highway     |        km
>>> ----------------+-------------------
>>>  footway        | 0.406733455181382
>>>
>>
>> 400m de highway=footway si je comprends bien ?
>>
>> Il y a forcement une erreur, j'en ai moi-même fait plusieurs  
>> kilomètre.
>> http://www.openstreetmap.org/? 
>> lat=48.7456&lon=-3.5481&zoom=13&layers=B0FT
>>
> Est il possible de savoir d'où vient l'erreur ? Peut-être qu'avec la
> liste des way qui ont le tag highways on devrait pouvoir trouver d'où
> vient le problème (c'est à dire en enlevant le "sum")
>
> Merci,
>
> Axel
>
>
> _______________________________________________
> Talk-fr mailing list
> Talk-fr at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk-fr