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 : >> [EMAIL PROTECTED] 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@openstreetmap.org > http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk-fr _______________________________________________ Talk-fr mailing list Talk-fr@openstreetmap.org http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk-fr