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
