[OSM-dev] Ways

[Stephan Knauss]

On 11.08.2011 19:29, ant wrote:
> So have they been removed from the database then? Or could remnants of
> that still exist in recent planet files?

we had a similar discussion a while ago. I had deleted all ways with 
zero nodes in 2280280. But nothing prevents it from happening again.

you might want to take a closer look at the following single-node roads

115480503;"{927077425}";"{highway,service}";f
65066578;"{165341975}";"{tiger:zip_right,93117,tiger:zip_left,93117,tiger:tlid,108600206:108658882:108658883:108600207:108637755:108637756:108694096:108694097:108616067:108658910:108658911,tiger:source,tiger_import_dch_v0.6_20070809,tiger:separated,no,tiger:reviewed,no,tiger:name_type,Ave,tiger:name_base,Hollister,tiger:county,"Santa 
Barbara, CA",tiger:cfcc,A41,name,"Hollister Avenue",highway,secondary}";f
120625379;"{1156695728}";"{boundary,administrative,admin_level,9}";f
121986178;"{248112130}";"{ref,N5,oneway,yes,name,"Grand Trunk 
Road",highway,trunk}";f
114673790;"{1298398898}";"{leisure,playground}";f
91926284;"{232729117}";"";f
31431630;"{31036070}";"{oneway,yes,lanes,2,highway,unclassified}";f
37523138;"{27271476}";"{postal_code,14467,name,Charlottenstraße,highway,residential}";f
40678595;"{426710103}";"{highway,residential}";f
57040799;"{561295573}";"";f
28067272;"{301680368}";"{name,Kartuska,highway,tertiary}";f
5928641;"{1357781627}";"{name,"Station Road",maxspeed,"30 
mph",highway,tertiary}";f
5931991;"{21746898}";"{name,"Saint Mary's 
Lane",layer,1,highway,tertiary,bridge,yes}";f
62221337;"{301685715}";"{highway,residential}";f
4077762;"{282699168}";"{oneway,yes,name,"Kings 
Road",junction,roundabout,highway,secondary}";f
23575904;"{60299249}";"{ref,A8,highway,motorway}";f
30130443;"{332028756}";"{building,yes,addr:housenumber,38}";f
62396944;"{301974494}";"{highway,cycleway,foot,yes}";f
25943351;"{60429906}";"{name,Gonzagagasse,maxspeed,30,highway,residential}";f
35323821;"{413584590}";"{oneway,yes,name,Werdertorgasse,maxspeed,30,highway,residential,cycleway,opposite}";f
118338387;"{1274530387}";"{highway,unclassified}";f
7391156;"{45799341}";"{name,Vrouwenakker,maxspeed,50,highway,primary}";f
7391168;"{45801307}";"{ref,N231,name,"Bioklandse 
Weg",maxspeed,50,highway,primary}";f
7367843;"{45816994}";"{name,Amstelstraat,highway,unclassified}";f
91958189;"{370154083}";"{ref,"Y 611",name,Trafikgatan,highway,secondary}";f
122190885;"{1366136899}";"{building,yes}";f
33922842;"{53358969}";"{name,"Oyther 
Straße",highway,secondary,fixme,"ungenaue Grenze, bitte verifizieren 
und 
korrigieren",cycleway,track,boundary,administrative,bicycle,yes,admin_level,10}";f
120547409;"{598559738}";"{ref,BR040,name,BR-040,layer,1,highway,trunk,bridge,yes}";f
29722147;"{327434089}";"{service,parking_aisle,highway,service}";f
29722148;"{327434097}";"{service,parking_aisle,highway,service}";f
26957057;"{250222271}";"{tunnel,no,railway,subway,layer,2}";f
41887875;"{184669859}";"{tiger:zip_right,49048,tiger:zip_left_1,49001,tiger:zip_left,49048,tiger:upload_uuid,bulk_upload.pl-1429abda-2e4b-4944-a220-d33e611e51f2,tiger:tlid,12232005,tiger:source,tiger_import_dch_v0.6_20070813,tiger:separated,no,tiger:reviewed,no,tiger:name_type,Hwy,tiger:name_base_1,"State 
Highway 96",tiger:name_base,King,tiger:county,"Kalamazoo, 
MI",tiger:cfcc,A31,ref,"BL I-94",name,"King Hwy",highway,primary}";f
103157010;"{164426180}";"{maxspeed,10,highway,residential}";f
112511879;"{1278585509}";"";f
120839657;"{1353931007}";"{width,4,oneway,yes,name,Noordstraat,highway,residential}";f
36956223;"{429711325}";"{name,"GR 6",highway,path}";f
120948653;"{250584632}";"{name,"Rostocker 
Heide",landuse,forest,addr:street,"Warnemünder 
Straße",addr:postcode,18146,addr:country,DE,addr:city,Rostock-Markgrafenheide}";f
30248773;"{361756}";"{ref,"B 
2",name,Bodenseestraße,maxspeed,50,highway,primary}";f
11846706;"{106305180}";"{railway,rail}";f
13330920;"{1316706198}";"{tiger:zip_right,92802,tiger:zip_left,92802,tiger:upload_uuid,bulk_upload.pl-96b38365-dd2d-4eab-8ec1-33441607e7c5,tiger:tlid,144254323:144254324:144254334,tiger:source,tiger_import_dch_v0.6_20070809,tiger:separated,no,tiger:name_type,Ave,tiger:name_direction_prefix,S,tiger:name_base,Manchester,tiger:county,"Orange, 
CA",tiger:cfcc,A41,oneway,yes,name,"Disney Way",highway,secondary}";f
122302406;"{423176408}";"{psv,designated,motorcycle,no,motorcar,no,highway,unclassified,hgv,no,bicycle,no}";f
121932324;"{1363705874}";"{name,"Howdens Hill",highway,tertiary}";f
52737109;"{334244148}";"{uploaded_by,"Wolfgang W. 
Wasserburger",plan_at:acad_id,wz2464,name,Schubertgasse,is_in,"Weiz,Weiz,Steiermark,Österreich,Europe",highway,residential,fixme,"check 
import",at:maxspeed,Ortsgebiet,addr:postcode,8160}";f
52737110;"{348228707}";"{name,Schubertgasse,is_in,"Weiz,Weiz,Steiermark,Österreich,Europe",highway,residential,addr:postcode,8160}";f
24574031;"{1368371931}";"{oneway,yes,name,Remízková,highway,residential}";f
39665829;"{415334903}";"{ref,"D 
39",highway,secondary,bridge,yes,boundary,administrative,admin_level,8}";f
118600200;"{1333624963}";"";f
82698598;"{104977310}";"{ref,C-2,oneway,yes,old_name,"William Cameron 
Forbes",name,"Arsenio H. Lacson 
Avenue",maxspeed,60,lit,yes,history,"retrieved using undelete JOSM 
plugin",highway,primary}";f
63211839;"{784697789}";"{highway,service}";f
95603454;"{1108566827}";"{highway,road}";f
122619547;"{1369664588}";"";f
122620104;"{1369668541}";"";f
122620310;"{1369671101}";"";f
122620311;"{1369671103}";"";f
122621126;"{1369679016}";"";f
122621462;"{1369684883}";"";f
122622623;"{1369688986}";"";f
122622628;"{1369689055}";"";f
122622630;"{1369689046}";"";f
122623301;"{1369694879}";"";f
122624740;"{1369710666}";"{name,"Via Umberto I",highway,unclassified}";f
122624742;"{1369710682}";"";f
122628782;"{1369740255}";"";f
122621069;"{1369090402}";"{building,yes,addr:street,Poststraße,addr:postcode,25926,addr:housenumber,7}";f
122624918;"{1369713573}";"{sport,cricket}";f
9351363;"{70749664}";"{tiger:upload_uuid,bulk_upload.pl-88e62f7e-4d2c-4233-92a8-e54f4ba8210a,tiger:tlid,65485687,tiger:source,tiger_import_dch_v0.6_20070809,tiger:separated,no,tiger:reviewed,no,tiger:county,"Jones, 
GA",tiger:cfcc,A41,highway,residential}";f
9352185;"{70759483}";"{tiger:upload_uuid,bulk_upload.pl-88e62f7e-4d2c-4233-92a8-e54f4ba8210a,tiger:tlid,65485708,tiger:source,tiger_import_dch_v0.6_20070809,tiger:separated,no,tiger:reviewed,no,tiger:county,"Jones, 
GA",tiger:cfcc,A41,highway,residential}";f
19352443;"{1369834849}";"{oneway,yes,name,"Gooding 
Drive",highway,primary}";f
30046640;"{330922263}";"{source_ref,"gps survey",ref,A487,highway,trunk}";f
33723718;"{287934174}";"{surface,paved,highway,cycleway}";f
51415422;"{656351644}";"{tracktype,grade2,surface,gravel,highway,track}";f
56312355;"{706252200}";"{ref,"L 3199",highway,secondary}";f
59991507;"{706252542}";"{ref,"L 3199",highway,secondary}";f
62062500;"{155020732}";"{highway,footway}";f
69414637;"{831394177}";"{ref,"L 
3179",name,Spessart-Höhenstraße,highway,secondary}";f
69632277;"{710334239}";"{name,Friedrich-Hornfeck-Straße,highway,residential}";f
93349030;"{32881148}";"{ref,A5153,oneway,yes,layer,1,highway,primary,bridge,yes}";f
97645770;"{1130448170}";"{highway,residential}";f
109153204;"{1241290567}";"{width,1.0m,surface,paved,motor_vehicle,no,highway,path,foot,yes,bicycle,yes,access,yes}";f
120578684;"{773944031}";"";f
122632900;"{1369776967}";"";f
122633053;"{1369779466}";"";f
122633926;"{1369787454}";"";f
122639009;"{1369831400}";"";f
122641125;"{308893701}";"{ref,A5,oneway,yes,highway,primary}";f
122641164;"{1369839301}";"";f
122648978;"{1369873535}";"";f
122648996;"{1369871010}";"{landuse,forest}";f
122649135;"{249620566}";"{highway,residential}";f
122649232;"{1369875762}";"{addr:housenumber,7}";f
122649234;"{1369875766}";"";f
122649831;"{1369876798}";"{bridge,Bing}";f
122650248;"{1369879849}";"";f
122651044;"{1369881977}";"{highway,residential}";f
122652375;"{1369895057}";"";f
122652376;"{1369895041}";"";f
122652377;"{1369895052}";"";f
122652378;"{1369895044}";"";f
122652379;"{1369895054}";"";f
122652380;"{1369895046}";"";f
122653359;"{1369903438}";"";f
122654295;"{1369926218}";"";f
122658280;"{1369936200}";"";f
122660222;"{1369954442}";"";f
122661833;"{1369980943}";"";f
122661834;"{1369980947}";"";f
122669331;"{1370054594}";"";f
122671039;"{1370078458}";"";f
122672918;"{1370096593}";"";f
122672943;"{1370096639}";"";f
122648998;"{1369871002}";"{landuse,forest}";f