I figured out that using osmconvert/osmfilter before osm2pgsql is much quicker with turnaround time of 1 h for the whole process including analysis.
I re-ran the analysis and now we’re at 1302 streets. In the evening I will make a cron job to do daily updates at 4 AM or so 
Maybe your analysis can save some more time, if you define your 2 used functions (canonical_name and array_sort_unique) as parallel save? Especially if your tablespace is on ssd.
I will test that hopefully soon.
Meanwhile, the tool is running daily at 5:00 CEST, it takes around 1h to complete al the steps.
We have gone down to 1266 cases! 
Here is the data as overpass query extracted from the html from today. That was some manual regexp hacking to get that id list, so not an automatic task. Would be great if we could somehow get the results on a daily automatic updated map.
[out:json][timeout:95];
way(id:100250927,100250930,72091937,100403377,32652420,100403353,35840814,100870250,100870254,10123719,10123559,10123560,10123612,101797078,174465856,23452979,103287466,10137827,11128486,103341722,42839460,79797725,79797724,54676461,718309780,103626269,59550263,43941431,43941425,103693160,141278025,104198582,33196256,104226935,32520789,104226922,107582718,104226933,119303284,104226928,637018395,104226931,104226934,,104312363,104717014,104358592,231627202,104359611,104988207,101039320,105192401,342135507,105531336,676506801,681343946,105576330,105576355,105642677,105642688,106566628,546913592,107079055,181229357,107138258,4944880,107138256,4944879,692459062,446315337,25511970,107579766,264335091,320844704,107579691,107579754,107582716,104226941,107582711,104226939,107914534,54102460,107914539,108130765,32890421,107919167,108339983,187761170,2443636,110262096,110262095,110344808,28687811,109628106,111415511,356748373,356748372,111660858,618625312,59229077,39546629,111660850,112577605,13614499,112696512,116469924,116469982,35167218,11285372,60181991,60181965,114987978,119281732,122029567,115094825,39673602,115641270,32080402,11674039,13696548,117058665,129695755,117514964,376241915,24212429,376241916,24212431,117514965,29385484,117739837,230894345,118354330,610227729,118354356,11850104,11850105,662996431,118625911,491117495,698690286,698690289,698690287,698690288,118912817,118912815,246850648,119221274,222220838,119299482,119299481,119909158,135765241,135765247,454888243,454888244,120268456,120418202,33362118,120818614,120818623,110680276,120818622,110680271,120825523,292115575,120851495,41112878,141250552,120922915,328539973,342068582,281936466,29164812,342068583,121160862,172436557,24953835,184989925,172436556,121550040,375212964,121597311,112466014,121689314,131332955,122009128,122009130,122115749,122115740,122115741,122115738,122115737,122115742,118986412,122115744,122115747,122115751,,122129963,211378630,35924432,122129967,122129966,122129964,122129959,122129958,122159818,29406142,122769136,122769138,122769141,122769137,122769140,122769139,122928938,25566231,128364791,123012396,123012424,123012418,123150470,155074573,123271071,123271072,125131865,125302651,177219620,125131862,125219471,125219480,125219472,125219476,126778528,25684097,127068967,128849246,128119999,128119995,29314223,128130774,195591866,130571605,128130763,128130757,128130756,12863514,117136380,237549777,539185152,12951424,128750744,662927652,128869683,360181527,128869684,129251328,129251331,129535392,95239400,129851004,61780764,132422002,132422003,22896559,32672029,18887611,132422001,129851003,129851005,129910888,223760654,130284413,333399588,130545296,130545295,130295110,26529794,130656679,130656680,164038166,130652273,389750373,130744424,342448122,342448148,130913938,37637919,131248149,220764979,198002885,689349915,131248145,131248148,131271128,131271130,131271129,131348203,109754667,109754675,638453570,286023511,265482234,109754674,131552684,131552686,306184993,131552685,29215233,131711864,593355059,132198093,96687359,132371669,39469504,132924494,336959942,336959943,336959944,133093907,133093906,135294712,30313538,135430291,310740588,135644817,67485582,67485585,135745785,135745782,125110017,113949036,113853754,407519935,407519936,287887259,136316027,43306351,43306352,200135745,136316025,136316024,133310737,99139087,278474779,278474780,136387310,32045064,136763312,35910462,137164804,422790523,384223280,572911231,137164774,137402713,37135298,27545034,137524471,113778886,13863651,13867413,13874549,96742936,28009007,184470162,144820516,139684154,489855087,489855089,489855092,489855094,357524788,357524789,573928039,227964130,24163234,,140504094,51789888,32395239,230457746,140504095,141363566,673608441,673882153,162906208,162906209,673608437,673608442,141386754,26912762,141641980,142599118,42077176,135776746,141788918,141793848,141793992,142810462,41259254,41259252,629776449,618104157,198218885,143436281,288903447,492756129,492756068,143547242,143547247,143734197,143466458,143734189,144002649,354023866,144158291,144158290,144630323,29720537,144868509,144722455,144868510,144874067,144874068,144874065,146719675,648545802,146793540,146793564,147064406,26749182,147144521,267367662,386221595,386221594,147301633,43544593,43544594,147826162,334523587,147826163,334523586,147980008,680297065,436879801,436879800,147980009,148203578,98229053,148331085,139821998,159694868,148329858,148748849,29148525,148797096,147953261,151362632,149123916,235124886,458729001,25829642,24859516,149583690,149583691,149896907,29248483,697191240,150205069,542652067,542652064,150570665,126135456,150570667,154397354,150570666,153616770,150598610,90446568,154863150,90446563,151082072,187077774,151330862,39921234,151541254,266562524,266562529,151541253,150141303,266285906,42927146,176758497,151593790,151593789,491129593,151767087,43115803,151799616,239064219,132141994,29316754,151819882,438296642,79866747,151819883,151819881,152451609,83079771,83079768,31742176,31742177,31742178,31742179,152819071,27835615,152819072,153293203,37772991,158353592,158353595,623177297,120655645,153577832,164609282,154486185,28466621,156146920,22277969,156351998,156352014,572796774,157226257,489229045,27663945,28277428,74981463,157718335,157718336,158059755,158059754,39633056,158215476,158215475,158279047,60974008,158295212,26364877,24235279,156761237,158763159,312474696,312474705,24351663,158751645,46136434,158751648,312474693,160084549,111491147,160086735,109617289,370295405,160086750,160207231,309858490,309858489,221382421,221388438,160609603,158521437,158496846,160714298,142973715,160833713,28162264,77811084,161297774,102777686,56683761,161451837,28141841,162009843,37960219,162015025,162015024,162210127,625033797,162406463,128740048,128740049,55700227,36920546,162430177,87289485,162653961,630262416,30636135,16266501,272552624,163080021,58761710,163213869,49808766,159282017,49808765,163709799,31390462,163560979,161552857,31390461,164198425,164198435,164629500,50320622,247499923,164777213,164777212,167406918,27413294,168232816,717790734,168478056,226432809,168478055,226334585,169375744,24280474,169688488,240522263,263704620,240522264,263890887,169688487,240522318,169851921,89550886,170477715,137721289,170477713,170572744,170572745,170572746,492759263,156814376,492758306,492759261,168436234,168436634,171246845,171941555,171941549,171246844,179170682,171941545,171559461,448823936,448823935,36859862,171559466,17178700,204156525,171818457,171818379,172407547,472328323,660164756,24584650,24584651,660164748,172407552,172431491,181330305,173690513,424507007,424507009,175053873,174087063,89660883,174087067,88375111,174636150,24535781,246662558,73025987,174973136,174973127,374158143,460504773,460504777,290357051,290357053,175494214,25000423,175790442,33142891,303428534,37796494,37796495,175797571,175712368,175844403,175844402,36249913,175969945,34039960,176559880,72916188,177224137,4674353,70843061,70843075,177904424,177904425,28311121,179056571,481319234,481319230,179405081,179405076,17971492,17976746,241129872,179804285,179804283,35013145,180213055,158563848,180405114,152514473,180625482,30192380,30192384,30192385,30192386,30192387,548111589,180625481,180817975,239134789,239134788,18119242,327293367,498084902,39170807,327293366,182163396,60748399,380145739,182163401,182697008,99816216,106735920,183434783,31431367,272774154,31674813,31674817,449052053,449052054,18441008,18443448,18601848,18642390,184868806,29317010,147635184,352056863,185230290,105741867,527960232,24642233,185230291,185282154,31871008,158754249,185410592,92924808,45513475,185410593,185585522,26711097,185750318,41526621,276590754,187016818,178925422,24148266,178925421,18766718,18766652,188962223,440638325,440638326,381572753,31006602,189845649,189845659,19054801,161552825,190657720,69997709,253242112,190723189,80803755,120395061,190723176,190723192,190723178,190723185,190723190,193026231,25024800,193316388,263840819,264467317,263840818,193605224,193605222,109886470,62317240,193770655,26231560,26407008,194343930,24973894,194343932,194676871,194676872,25149007,194676873,26166167,26166453,26166452,26166450,194676874,196877468,237985171,28906237,197919331,326198851,19803245,4767084,198819277,360612107,198918638,35936536,199208452,199208450,163021171,200330330,200330329,159633424,25665078,201203858,9723585,24858352,308651512,64523653,300370641,308651447,41271098,26843940,201203864,300370642,...,203012944,233565181,380072242,380072380,8895394,203012947,203012938,24032954,203266118,203266116,27238835,27238909,80281586,27238841,27238911,224396037,27238838,27238837,80281584,203810793,203810201,203874848,203874849,203874850,316696480,203883248,203883252,203868033,42233802,203924753,488315364,203968818,25570834,25570833,55962803,203976894,31992651,293042852,4345947,20446627,21113628,204949169,80397972,235036713,27508438,94872944,204982487,48389760,205146132,83632165,206710022,241112167,241112168,207734047,26638159,20817752,386631446,92077089,92077102,209433843,209433842,209558362,27676186,210042158,210042165,23759866,210042166,210042164,210042162,210042160,234352444,234352445,211814997,211814991,211814999,211977503,29084740,211977500,89198285,212743447,174904436,212759878,502053691,220088445,129032992,151045924,213197927,34021801,23305247,39530747,23305246,113626480,39530748,113626489,213877758,213179066,213179065,28074068,215060113,80629020,506628709,51503489,216498294,130657214,217003508,324321608,217290465,9655632,25420391,218133372,218133373,217416731,186893445,23592811,52012741,217653880,326566197,679271175,29091314,217667294,213886673,217690785,657103682,217690784,436940830,436940829,657103684,436940828,436848811,257742066,217848898,217848894,38547583,565106014,38503521,293585578,217882416,217883573,217882220,217883184,217882892,217882557,46737590,215577193,21800878,233345075,21800873,233345076,233345074,218982677,671098266,218982675,219004889,4432257,4427864,219668913,35303858,220175797,220175798,220175799,586405525,38906160,221888471,13265061,222233823,214178581,222576977,24249343,27747357,33834962,223111215,221096076,223710422,223697719,26284865,26284862,50640485,24889160,25526133,22377074,22377075,223803928,223802727,223802733,223802718,224616197,24566619,224787093,172562470,172562469,172562468,224787095,224959992,28708912,342010173,224960006,225238404,384433847,225386979,687411651,687411652,687411680,349462074,687411681,196263664,687411682,22560813,228249917,22677312,232455264,232455263,227477758,248402390,375543976,375543980,117883594,22751076,424494047,227660446,130359300,40440597,22772787,278180192,22772785,22772783,22772788,294858008,228211706,327067728,411096276,327067727,411096275,411096274,411077448,228477189,36720517,228591038,42453349,228887010,228887012,22994099,26373914,256157454,22994166,35342755,23058171,23058410,126873502,588007137,231058089,23058170,23074974,259592370,259592368,23083845,22575124,23087835,23087838,106954278,23094112,90432685,90432716,23099626,32964911,156852660,231018806,231018807,23121727,23121725,23136418,38188391,23156633,23159979,32083460,32083459,23159603,23159606,23209362,40433375,23238588,338467406,218221595,218221596,352050637,352050640,618041632,23238594,23238592,23242912,317918825,23258475,51939248,132020642,119056455,23262306,102715149,23281340,48743157,233024650,131609704,308420150,23359166,23445855,233750813,37959704,23382260,202290896,23386078,33289086,526399722,526399723,9547533,526399724,9400397,526399721,234592321,245813657,514598300,132065275,245813659,23464740,23464653,234705660,27548572,158856446,234917269,118919828,23500799,23500797,235254354,235254355,40322952,23563741,155570074,31511335,689476200,23577278,23577280,235830521,235830475,27391932,236099950,28250469,23705381,268423266,27089423,28769372,23717922,23618141,23717923,237215845,35265844,23727335,25517838,23627806,237301188,237301194,38844951,237335885,35140371,110672601,35079484,237458256,297063722,23764114,23764121,23781441,431892716,238035410,40740538,238215697,519063450,23854282,71826686,23884689,22737445,238920224,134935420,238920219,42967075,134935419,23913999,28618669,23951525,23913775,239332035,23383191,160818106,160816449,23383195,239344467,8065963,25979363,239770498,239770499,23985229,23985147,240055160,31293229,30157342,24015992,24030868,24019530,10502676,237479021,226995429,24040996,24438174,509995029,240462935,200811399,319856582,200898840,24057703,24055086,240793377,240793378,242113928,43444573,24216122,4295324,242639407,26166670,242922630,59225524,33937715,238433402,243258467,533312248,533309374,100855346,243647711,31745104,28036289,24379797,30322809,24419508,107898797,107898705,24421954,12248275,12248273,24453645,24560516,24490720,24490719,24494441,24494440,24509391,24509354,24525485,74497398,24537608,25511732,443289826,24538804,24538805,108322899,24538803,24543177,34099437,155853488,34099438,411574004,34099248,24578000,150897642,24608747,495033105,485539146,27687726,36785033,367972278,127246122,27215820,27215831,27215850,24650716,344145537,24650726,24650715,541409493,24650736,541409495,246612860,56065080,246677292,47002754,44860610,44860609,44860607,44860606,44859820,542646747,550675034,47002755,550675033,...,246730018,342543154,239481792,24698435,25149148,24698436,24717180,24717170,24739452,24719397,24757193,190253375,24768897,113207554,24845915,24845916,24845987,24869304,159688425,24862991,24862999,28085780,27930212,24889585,24889553,24893276,26762365,56324203,56324193,34476824,248998120,94059410,24921125,24938073,24921126,24921127,24921119,24986977,678219222,678219221,24989407,219566987,24998230,24998451,25019079,254416470,33573440,40945069,25056825,649715781,39953136,649715777,25056874,281073017,25093067,32499132,44421302,44421299,32499135,25093100,25113614,32499134,24911695,251490546,31685356,251766493,118339531,369217110,155725112,25188943,32066902,132374791,25190048,25190047,25190511,18595161,25205917,159737373,24396668,43931317,15879736,43931316,464937698,464937699,36949092,25210253,25210274,25215462,25215460,27397261,25273958,25273696,278144075,25299719,590993106,13254811,25307905,25307912,25665518,211328581,25307884,197857889,25314104,366673317,25339550,235776839,51766440,43920523,43920519,25340617,25340618,440466305,302765088,4084881,25358475,33467613,23724102,25358476,25370819,25393334,25390919,441873918,468748157,25393364,684263582,27380809,254452862,32938333,25457693,25457747,144802276,144802278,144802284,144802286,144802287,25485263,92714238,215410421,255021981,23658417,255050530,26373894,255127275,255127276,25526097,25526096,25526098,25526100,223616744,25526106,68452656,25532161,28723173,28723172,255667468,253577720,255792780,598190405,25571968,681224172,45181836,25577344,25577345,25577343,25579730,112237904,149147474,256055078,256055076,256055080,256055081,149706026,149706025,149706023,149702703,256055074,256055075,25626986,113753891,25627002,231772210,232364020,241032455,256320203,35786964,25645001,25644999,25645002,25703267,25645359,38871434,25649301,25649297,25650226,25650225,25659490,197575755,213749223,25368153,25368789,25369325,256597976,256597977,227465370,256680712,255943303,24422551,37109135,36946881,25670130,314321516,25670487,398950902,23458817,25673042,28453342,25685482,25685484,25685485,25689460,25721543,25721542,40334367,25721889,96772202,25721541,25721890,11532681,256903009,243642261,25704761,25704765,25704767,136728138,136727414,25704769,25705458,25705449,257806001,156783663,25795321,25795320,25833103,25833105,25833104,25835162,25835161,25841085,25841086,116651216,25878168,25877975,25886850,25953508,25953585,25953696,25953697,25953698,25953700,25953780,25953833,25953834,25953835,,258958074,27994920,25947709,26963449,657266112,390866935,26011804,653789770,657293186,25947712,25955947,30478886,26000776,32976598,26066194,26027698,26070857,26070868,26071685,161470298,77693557,32146068,32209886,26071686,308885988,260845434,616093509,633930434,26123159,399187023,399187022,261268282,33608405,26134034,316123032,145086699,26136731,591016160,26157876,175920012,26203864,26203865,26203910,26318459,6958318,26333850,60973996,26360240,26360139,26370982,24526385,26481321,43269660,26482076,56184609,56184607,26485353,74057672,26506779,236144389,236144388,26507066,26530521,38628608,26532771,306166515,26532773,111599270,26530516,26541294,120520858,26552658,434742756,38123180,295735897,38122376,309367063,265908534,28911398,26616294,26616291,26622816,212789580,372451974,26629183,386197147,386197148,26657323,643295564,643295565,7851597,643295566,266667117,25812745,266684748,25516410,26714314,24611279,26715580,33127049,33127048,32854849,476281382,33127051,403512157,33127046,33127047,33127050,26770272,30893543,26775264,24486497,26790081,194541515,26793344,58643686,267971654,108052257,26809491,33625042,401649530,33625328,26809358,26832326,681345182,681345178,681345179,26837262,103561006,103561007,26837261,26837263,26841186,104676680,104676677,26841658,26841691,268606636,38616516,38616517,268843473,268843469,319228028,268843471,301852295,26970140,26970141,26996988,26996987,26996959,270150018,334000659,27017058,27017059,27022238,15563340,105053120,161292895,270282253,143272701,152695286,270271791,306687735,270555960,41528464,203132934,270566422,37992821,27072860,33855743,61694121,30503278,27074121,28194346,27111456,27111454,27111452,27143173,27020205,27020139,27149820,27150544,27153898,27380182,27205091,27205090,27205088,27215522,27543676,27543671,27233239,73316732,73316744,27244121,27244151,27257612,27257625,272987498,126212128,273011686,154353554,693093532,32273517,27306645,118818638,273138211,37455232,188941357,27329071,27329061,27351684,115375885,27373230,30716707,27393752,381543926,72370078,27395185,25488912,637961379,27395633,28358301,27409731,27409730,27410581,45736584,27423451,27423433,27436982,341144822,27443330,164876743,117493622,49782984,164876750,91598568,91598552,91598551,164876741,163303327,159245919,27445948,17688244,27446125,27447257,27452456,55001224,27473724,27578458,27474719,27474718,27474725,27474721,48347010,27486155,30571850,27510400,23746484,27515262,67566728,27550287,34325062,27568265,27568260,27570844,26976960,27571010,24250616,27585463,26020783,27779431,27585628,27665539,303159433,27590451,572494979,27597486,39394839,218079195,218079191,8891767,27598796,179416563,179411604,148761232,276003740,51771189,35979236,276452895,136550986,27646834,25646687,25646688,25646685,27663992,88537037,88537125,27764255,174709179,174709180,38127783,125012929,27782117,26446348,27820929,82249324,27923235,128195439,279447231,413153700,413153699,158397272,279881114,39700333,28072421,328748629,180137567,28143751,8040916,28174492,409550225,718932617,282070001,118922762,28216581,33481195,28270435,28216693,28216698,28243022,27376556,284262903,31098583,28243604,28133865,28248604,28248609,88709483,28252391,29242288,29242223,42654431,28252390,28252389,198352707,5217076,28268181,30759608,15078727,48073821,258976017,391075779,304970154,28046924,410625383,101292191,,28271722,28271721,28271720,282951447,282951446,283222774,61483856,28339322,118756602,118756601,28363994,28493205,28364105,32059254,28413386,89796426,28419752,38198066,28428175,527296461,37178785,4411784,28453809,417195619,200577834,28454346,28566289,285017709,26527190,285017708,28501798,445698627,28514579,225205079,28514578,285415740,128442360,28547303,28547298,460807180,28547300,28547301,28565939,28565940,285818448,33804913,24621769,24621719,221893142,28587273,25372437,25372435,28587272,28742088,28742092,28804437,28804435,28804436,28804438,288269543,26578011,288269542,28904732,24569158,24701438,28912960,30168154,28919213,28333308,28928713,28928706,28935710,28935713,289729802,668679596,32146280,668679599,28991676,28991675,29035713,197919786,29035715,290557309,289578684,289578683,35558089,29063035,198961415,29087181,613819996,613819995,319831540,281755306,22891341,28681138,226005754,29087180,319831541,30271018,290962847,198653637,90849020,26479175,29104632,255469593,32860432,198658882,28498571,29129579,223324658,29129595,29129096,29129563,29156816,29156815,29162819,24324953,37740778,24324954,67501990,291756502,129789862,292035281,386771950,386771948,386771949,170729027,29232736,29497114,293293599,85259230,560431712,293555189,38745633,680349143,192144040,192144046,37927448,192144437,293555190,293555191,192144439,,29356131,29300747,29873354,293576921,625058946,293429564,625058945,29389715,97714077,217020616,29450849,29340014,172947097,463898584,29340015,295540299,310945439,203220712,295622168,346178430,29569300,24291538,296470222,30718974,307215593,297145136,297145138,30826174,297884858,297201718,29892515,29890093,29895691,29895690,147992530,147992529,29895480,29895689,299745138,119505284,343477698,299855514,33292584,175785192,300185937,298678745,300835612,24216219,618096850,25214831,24216209,30092115,30092118,30103812,24280094,301435492,65609284,301592623,208500620,301592629,31281046,4722379,208500623,24527662,42759519,495769606,495769609,,302924383,302768465,303005530,98444572,377005734,246071679,377005732,303212866,32372648,22947450,303212867,303444249,303444250,36391007,36391006,36391008,30399194,332963852,332963851,125664838,30415884,30415885,304646687,279372521,304642486,304714880,37950140,37950136,30478884,7937082,30487538,305176847,305176848,30488914,24697525,550136595,30488913,30152156,30152157,304961530,5199383,30583060,219157703,306000359,306000363,30603527,696442311,30666575,28413859,27348461,30683503,129210990,30744060,28872332,35781819,28744838,29978553,26369099,30764693,53566742,30770736,170609022,308841810,308841811,232658861,47121261,30911529,30911516,30941007,257616433,579005039,147705843,30952659,29049460,28398616,29061801,30970541,305013076,305013078,122624881,39461484,39461485,305013085,305013084,305013082,305013081,305013079,310065815,59948884,31024191,34664232,34665249,34664225,31026046,165185419,165185420,31026043,310550384,27714729,310559597,23606811,31131043,30744046,31172338,174369532,311987443,33119538,33119593,289273182,202371695,33119597,311987442,26781479,313215139,26323661,313215140,31474851,31474850,314760301,314760303,31745659,31735087,315021558,718125503,543980814,718125501,543980815,31557035,31557034,720131213,319538053,31584807,31584806,31584812,316223847,379034683,31647496,24215522,24215521,523328764,523328762,316529501,386357435,386357436,148612595,458148025,393989469,483802415,289547977,681754291,263643908,,31739869,22584862,548947478,318027698,27584212,31814516,117184141,31845873,57735758,319645417,30888843,405011546,405011545,319686076,641162588,230556729,20621821,319710994,135903710,133675176,506765033,23494294,23693815,32098357,32098312,32098314,32098316,321206247,46507170,105692011,32127767,38123935,32133100,32201874,26706638,321351374,187976209,536930712,32206254,157506974,32253830,622036519,384533591,240776215,240776214,322696735,35266649,30389867,317066498,323059781,27443568,166174318,32335847,48133884,25376277,48133886,32351104,24148778,95202464,83203297,323994802,31322637,323994800,324004817,389459610,151404894,32436577,28530624,28530612,32492968,29254188,32492942,32492890,32436578,32438722,382482210,32478298,32428376,32428517,325048325,325048323,32548064,32548063,32548071,32566479,189724447,326005256,80134180,26468606,32645327,261009397,32645328,32767268,25363758,32767267,32813017,32753716,72400867,32870647,319252784,32897142,159047428,329343432,38694332,38694331,22388168,32941359,105035753,105035707,55920887,55920884,329525015,689621448,32068888,33002202,33189795,330090816,330090814,174599661,330097069,331106696,330180929,201270804,130995136,35262405,33042599,33042601,33061393,44653004,33061396,50212415,33119555,33119554,33119579,33119577,33119573,331370114,41279419,219167737,33183373,36372003,332516014,34961208,33287813,33287814,333399888,25742810,334141787,32278483,30156266,25367603,334142049,334372501,698267069,352037292,334372503,334372504,,334667642,121363011,33590582,33573291,25674589,33770100,33770098,33770099,33899569,33899579,674975514,33899486,26524482,33899578,339251078,331682720,669659115,339251077,331682719,669659114,33937374,43102462,33937377,25510880,377597714,33937379,43102444,340591813,42437009,42557245,341157019,694061459,34126591,438908403,34125996,34126782,34151760,34151759,34186264,34201646,498302999,34186268,34186265,34208142,25413170,25534193,34253958,257929553,34253957,34305238,34305191,34337789,152111815,343483233,35557788,34585757,34396878,34396877,34408194,49223115,49223114,49223113,206570516,34407312,34407321,34407642,34428366,106941067,28737454,106941063,160150164,160150157,28513018,3445134,236844009,3445229,345542795,31471323,34563404,41201101,346827282,352540278,34705533,50827070,34719997,52793278,34780763,34780762,712978554,34784953,72575439,34919548,568760813,34943599,41359045,61556179,34957750,33204699,34961746,187645378,35015954,22949870,35015953,35036549,34322017,350594524,615362411,303731690,303729106,451357861,350594527,350594528,350594530,350594532,469116869,,350621574,137396317,43556564,43556563,350621576,350621575,351695448,114368085,351696408,35185597,107105293,352059110,62232986,35292243,290578039,35330285,110476440,380208983,110476410,376750459,353589796,86939567,241943833,353589795,35419663,603772731,35427550,37277050,35427551,354500730,184440989,92116982,35588033,35588035,34315142,35592255,26483664,51826984,313132085,52385218,52385217,35593362,24639739,35599470,96038989,35625713,27744568,35625712,35682206,35677988,35702365,35702364,372719009,318021522,44293537,357236203,357237189,357406087,129857714,35834676,35834640,144622777,35879403,128930951,359584616,632543105,4297607,359626382,363078834,338795705,359626378,246392243,359626377,35963523,35963522,39430027,35974498,35974520,36001976,36001977,36001975,36001981,36001978,360414687,23054175,23054176,23054178,361126168,33061962,362229394,362229395,362244343,362244328,87925705,118455800,364674355,364674354,160125253,364745276,37041544,100870829,29136407,364745273,316715010,364745279,337813305,364789735,702837052,364789732,23607124,675240035,365486184,10100732,365544651,365542902,366340200,366340201,367241112,34018001,36769338,34394382,36780342,180629413,36772945,36859863,36859847,36898230,106620221,106377268,36232714,36345893,4793474,31585937,368986370,362636733,285775075,285939093,36919384,26791937,36946999,36995122,36983388,36995119,60495305,60495306,36989832,27527652,36992094,4410283,370470061,25394223,371637435,262904985,37166559,37166341,37200709,35465074,37246851,239755824,42996208,37248792,26094793,26094792,372583340,29466742,29466756,29466787,372583338,37344012,37344010,373882504,69475492,373765404,67088994,69475493,67089019,67088948,373765395,29485743,373765410,27151339,37405476,37405472,374716002,46923566,37492768,38959918,31961402,59381956,37653705,37718560,37538149,654467534,37545706,37648277,375784854,23623563,23606624,375788587,375784855,539013091,540739938,37761165,33188174,378531894,387219706,56028464,378531892,286646452,4212009,286646449,286646448,286646447,286646445,,37881904,147464288,146195080,83740473,37894533,25502574,219506484,321842449,231430696,379995326,380274615,203475913,380274618,38023946,38023944,38023941,38074867,38159053,38159052,90210607,380926623,684655085,502943608,502943607,380926624,38135162,38135161,627180879,38152057,38346996,38153177,161633437,45851328,38181085,34957354,38333634,32553956,591745365,591745366,248053180,385011481,215299021,385011484,29117891,385244706,41750173,385244708,150327843,385244707,540777525,385244709,385242876,385807069,385807903,385807904,385807905,113285261,38608054,175309658,38608053,387651624,227007042,38912643,38912642,26181569,38912644,39022792,98158688,39022793,39022794,39166165,125839815,125839813,39166167,39166376,39183556,17743035,30284382,391899691,391899695,391899699,5291775,39362324,385546047,394461950,226848685,394461951,395260160,38864246,395048508,396530949,695974288,541056520,39667360,68277647,390097523,68277644,259081152,259081151,396799887,86933883,144441446,220490676,397304204,110021620,397704336,197065842,34258489,39774030,295523625,286884081,39773863,288196902,288388027,288388026,295502966,295502963,39819105,25164050,235735381,25765411,235732601,39819104,39819106,453435341,398582942,398582941,39884063,39884062,400551719,169429629,40062976,33859364,262749961,400968185,400968186,40107323,26621694,401416158,119253686,25690344,401948417,66866137,23374197,66866138,660251145,401948764,401948414,40195535,90442575,90442554,19637944,40300520,544210313,544210312,403510359,403510429,403510483,40459471,154609308,24778532,155014376,404740924,136017091,405501075,40744331,406035343,659378263,25522959,27584695,225560282,40608164,319162050,40609037,360594828,38958588,38958584,4074477,23511492,53323935,4073212,407586572,136454984,407586571,148651112,40816264,40816245,226930495,40816250,40839250,230512110,40839248,196541380,25588536,230512109,40896351,76561034,41018079,30075055,411096277,313645583,413067398,130787315,41416422,29260948,109651000,414843762,415848647,41486240,334943208,334943209,437137283,29005066,41504419,475664016,171985314,41569538,41569533,41569534,41569535,41601966,37005508,41602286,156068308,41603623,102780857,23387444,22338280,22338208,22338205,41624746,138925672,41624749,417461412,55700333,42309168,420049760,420050475,420050404,420335412,421448872,26140731,26240370,26240373,26240374,18440294,26240377,26240378,42202434,284051856,42202435,360613759,422491864,31529189,42314187,24626944,61041223,180530965,180530964,423616426,404740925,4243625,24377689,42488348,42488349,42604776,158835776,426299513,156513394,575303837,426299603,49153606,42713234,42713061,44832631,35398867,42855660,79328679,42860010,88694600,428873495,34927111,237743040,237743041,42922475,45399016,225886002,42304995,217982220,42922477,429639278,222049746,222195374,430094943,54639402,430763645,129890844,129890845,430927314,24227466,43102561,43102560,43102559,43102565,43102564,43102566,43102562,43102567,43102563,43111621,43111620,57889723,431278965,438970672,431278972,442406277,431441538,186524064,188338628,694098948,96630125,43178937,60690071,432212631,115715597,43266619,43266618,4328141,47478573,43287242,221987314,43376840,40471849,188355821,43582712,43582710,43582709,43727946,78303591,437877959,459247271,459247268,459247266,437877960,614819954,437981725,95828064,345054261,361000876,95828065,281509623,278473341,437981723,16578142,278387357,,438970668,439053735,438983290,290067601,43904620,39488768,439060090,439060089,55038443,55038447,43920479,18642973,277785645,44110356,44151693,441141491,90038528,441941482,441168492,108561427,441285642,4390249,441738672,441738669,441738670,442293926,4427771,443085434,104125468,44333640,24271617,45455048,44333641,44333642,443735333,188172051,188172490,86134908,455565016,144131764,182159959,4446318,483268725,446254046,99456258,4462889,469515770,43838343,478527449,44703295,44702132,44703226,44919638,98115242,98115243,449688081,205454222,45073971,35590207,41779163,451730698,673512294,125820512,667681829,667681827,667681826,667681824,451730697,449007871,96000297,,453415593,147520531,147520533,4566708,143076534,4566705,4566702,457941322,60770843,45818338,527959411,45851323,188622778,45851321,460328123,384957161,332965777,157881305,460615440,35596564,461163612,32675341,142643221,461552810,188634080,464809233,27565469,466742173,466742175,466742174,10588518,467738985,84053510,469555732,326331419,469555735,4704226,4704221,4704225,4704220,4704230,4704227,471406596,471406601,675586603,178542896,703490584,667548592,178542898,129953793,181883321,667549064,,4717096,365070166,472058064,400740507,234427464,398786104,398786103,476950168,398786096,234377516,36243669,36244176,,472493921,208570139,164339036,164339079,164339090,164339029,208570138,47280487,45196372,47307837,606511479,47387184,548237903,475385414,475385415,47641411,31433541,47774365,210294775,47461727,25798511,47461706,47461723,47848205,47848199,25774345,47848206,25206588,25398942,47848207,32990945,478672722,27567841,253167387,253167386,253167390,8058308,4796482,10196357,708651566,48462624,48462637,247291446,261369801,247291447,48462640,486698569,41311746,41311466,41418356,41418357,543048019,543048018,486698571,318210196,633014447,,486833472,106669910,486833471,48716896,94574795,94574800,48798349,27139712,27473734,48798350,489082091,96742415,253470024,147061278,34879674,489654330,505404752,49023694,49023693,490779437,489138734,49166573,95781686,52563275,27128766,27128806,491802036,491802038,491802037,49192054,49192055,95395555,32297105,4922753,458591491,458591492,458592024,194795796,10048094,492754027,492754028,42601369,494020506,325463698,150750427,495717897,82088420,63204265,82088400,7705353,7705343,63204267,451440788,497415426,497415427,330594940,92292210,92292100,497415430,78194755,49834424,27566441,498593136,24731555,49978426,361532412,361532411,44643287,44643288,258787151,258739147,258695225,50220157,3809806,503505664,503505662,439457581,189605327,50389537,95987148,50389538,50389532,95987146,50414549,574627752,574627751,49906253,209078964,266312298,266312297,48098268,48098965,51734830,,50438400,591739240,291508983,591739241,147241478,5202297,147241482,591739238,591739242,38610953,,505810505,464231403,26823935,50730856,561529880,508004575,516178405,50800537,176235252,50800527,508422844,24621184,5090180,29091203,29054229,29052719,649278715,47063813,648880289,51012441,453743603,453743602,51027444,5109188,3501453,5109336,5109198,51367331,639789314,515003441,60234663,208450992,515027825,152018452,515219666,515218938,51678312,173301265,51686758,101400054,517182780,517182777,5173293,60086917,52059543,237687408,49357169,240300055,37611384,52340828,574448838,443322591,443322592,52340818,52393105,63973530,29453937,52491482,192726577,52492315,52491477,526011217,24660846,52887839,261100332,97197314,52924857,123815701,54245296,53020946,52924851,31113371,123815700,53049339,237851940,237851939,49749460,53170291,40127910,40127911,533233754,229379203,533563183,35875574,534126766,189930741,189930742,534133294,534133296,536435394,225211433,38551850,53799583,4447610,309710038,41452246,4447609,541065067,541621415,541065065,54200028,132023167,543954367,534221910,26461757,533424879,144469200,534221909,54413032,29432108,54413033,29432111,54442037,54439796,544637509,544637511,191379665,547627487,54564401,146627867,381453455,54616672,54618055,54794005,61842995,549499432,549499434,550263858,550263855,550263859,550263856,550263860,552668279,103640307,552979509,25164486,554642881,66969691,555439873,28991666,28991665,705241446,556320117,32098310,129933847,356367480,32098308,32098306,55697472,42771261,55697471,143183493,55792251,55792252,55823079,7975164,4515490,55936883,279458056,39817881,55936876,560401013,69671968,56122476,56185028,561487655,41184544,270200186,41186525,41184543,56296163,253534865,58489165,564353673,138480467,260611952,564389653,410834287,564389654,56672305,56672306,245554757,568338101,568338099,573822403,445810383,445867160,576485168,310982560,57738679,9206565,356667364,377352105,27681837,580235120,179119774,580235117,179393460,109206589,5811436,5811437,706151171,581810895,34569919,34570598,490685801,586335691,435610628,533471450,58659727,30445211,586684481,109270375,58707163,159244014,159243999,159243973,58706990,588445057,53137990,35772494,629542318,23107420,314700816,25191475,588779293,588778712,24911211,588778710,25420990,588778711,58961390,242102191,58961572,591639875,144790395,144790394,131961326,251959212,591767440,25048232,5941969,341816686,341816541,5942842,477296876,107708790,59527647,59527646,59529235,22938644,59529240,59529239,59543802,374920413,374920412,48902741,59642304,23987095,5985292,5985296,293467416,598614587,281412414,60046083,60039535,60049032,24998390,60049031,24998382,60139756,137756594,60195782,56137367,60224729,4815828,604012040,430762890,22535147,672946660,210943811,610852624,22535483,430758915,22535140,220075099,60665295,319231430,612792926,30099680,613469464,61315105,23682939,61318495,64971742,614776994,34870223,616760618,32145964,206292298,617660367,617587916,26210470,617587915,673959208,617834972,67390525,29976548,61832525,61832524,24221084,62028965,364433776,13869492,147754426,62213497,62213498,62232055,30049065,622888663,337980525,622888668,62742138,122321215,28218870,628398390,122134773,628398384,628398395,549968282,31094469,628398392,631572258,173078445,633887239,667211917,635031864,25162952,35607280,635032028,6360519,6360472,6362624,194961577,63818419,63818403,638512303,5150012,46848371,640141180,95788247,308359783,640402238,47445414,644863965,123750776,218925104,645059179,6280197,404868168,404868170,82805951,645059177,645283402,123168772,64602175,486794940,64745381,92836905,647491423,656084690,93228286,64963340,177478125,177478126,661165931,658021801,194017409,34521976,663031667,219954262,663031668,663539241,33117524,664516607,137541293,665026995,95253955,665026996,665026994,666379046,666379045,33771925,666379047,242304383,66693490,231522878,231522879,66693456,231522880,66748486,158315084,158315083,668149102,170398708,401165904,105314459,668149103,668898100,34118302,668898103,26028233,26977783,66942275,48925754,66964267,25542069,66985287,102996697,66989418,89578587,671559113,480728705,23113902,556241693,23113900,671827075,366569149,480728702,67229655,197025851,179050463,38870315,206273766,185487612,22982417,35028277,67327597,67327593,442442712,6737804,28957243,29402585,316491029,37827164,674644414,36912566,36912568,36912567,675481052,541378911,24524655,541378910,675481050,541378912,6781488,6781486,679800792,87576394,67997644,67997620,67997661,67997561,67997752,680703752,26223529,572272486,120309866,681255729,322782556,144753348,144753346,51944900,682846931,30130262,645225733,28054987,68339332,68542438,68542433,68542426,68339334,683703742,28236116,671216828,671216832,671216823,683860710,72307282,683860709,623454177,68491567,227832372,35108417,69469021,35108422,80378259,227832580,30825568,685824836,30548866,361256915,686869863,239556652,42861214,684864779,684864777,68699070,493919877,173930563,499389023,68711148,37284856,68758216,27332492,82731984,68758240,68758232,68758228,68758220,68758204,68758193,689966859,689966854,7752723,7752712,691090731,60725201,691895395,28977481,24746222,692765627,692765620,692765625,24773671,69766114,25063249,25063245,698951332,651696057,93769548,699261558,5245563,699261562,69992423,34075887,700275076,23053458,700852495,200752259,200752261,19049726,172284953,700933756,25367776,232278576,70321439,70321442,61120100,29233245,176375772,61120103,61120097,274190513,144098120,70383743,414501109,177086863,414501111,414501113,414501114,649530394,235292215,235291454,649530395,704292674,637509479,637509480,539990531,345210520,704501861,704501860,704501859,704501858,704501857,70535864,34283114,705953997,661373561,550725248,706686463,25160544,709286137,23926476,23926475,439114053,709286145,712431230,234132085,173930591,204737510,176816639,173930545,71354820,8496270,71354828,71359453,71359469,71405575,41497798,41497797,71497466,71497465,71331350,717907046,685104493,712117389,712126545,71965544,71965541,366273370,357277800,489276039,28408116,72036436,147858376,286295861,72612756,201275883,80992974,39633830,316761239,74126406,74126401,74195639,143614276,164599868,143614275,75113197,27014749,75441757,59619219,75561453,80509881,76117469,26546146,76117465,76484300,76484288,76484276,55335086,7762365,389276740,311310699,7762338,7766643,7766642,78217950,39359537,95405407,78217967,42687469,78447167,26133948,78533289,27141999,27142000,79094274,113612228,79141241,79141274,26960153,79271584,45248534,7973269,101503354,80306916,80306933,80516029,207808246,207808244,80727368,80727349,80727386,80751447,40525904,8090315,529696880,262255404,80915573,28539497,28539496,32029010,8094108,172689853,172689854,8109358,27253259,27253257,82255695,557604027,24287304,28424298,82771390,265271465,265271472,83043731,37541052,58287085,24210354,83194057,83194502,83194070,83194066,85442954,396549476,396549474,396551493,85442919,85547720,81873905,85716265,85716262,85711950,85711949,85711947,257833790,8584625,303340982,23895064,23895071,23895075,23895076,303440833,85892263,135202948,399638319,85892269,85892276,86144285,86144388,8616276,37291018,8658322,720213707,720213708,87275039,29295316,87358594,133616229,26989728,87599075,25428779,8760698,85334822,85334820,353671717,87973766,29207211,87983520,25521939,150185897,150185899,88604844,88604987,303377936,88692037,88692044,88692016,8877572,552989562,325063751,89999710,89999503,90485320,27916273,541378744,91712796,26123227,92205336,67604463,66155241,92644062,270555389,92879180,639424121,192355772,192355768,92879181,136904282,91735181,93344225,93344220,93402704,28228058,93477363,645538979,140860432,9359996,4902526,23886306,93663059,175386667,93703025,93703033,93703032,93760844,614565880,211076659,38958624,93760873,93760868,93786455,384920471,94153476,694346941,94162750,118812473,334333199,94448097,23918508,249213416,23918507,249213415,23911597,41956115,27742052,122551546,241897174,94579274,223450999,94835875,26125280,95370386,42673036,95511028,95511029,95990484,503191388,70761323,126559426,97084249,35992708,98237906,100026126,98356980,98356994,99228831,173522022,40898206,99347913,275426257,348393793,148111333,99425484,99425543,44394517,44394516,74564688,278833443,383057170,99425385,99466908,627548225,99481272,156212751,288903818,99552252,402767976,99586927,24390506,99845024,99845035,99845029);
out body;
>;
out skel qt;
I rewrote my tool to fetch RicoElectrico’s html page (thanks), run Klumbumbus overpass query (thanks) and upload a geojson.
It’s now running as a daily cron job too.
Updated link see above.
Thanks to all - I eliminated a few more …
Same here - thanks!
One error class I was particulary able to find and fix in my armchair with this approach was names with whitespace at the end. Also strange accents (“Âuf dem Kampe”) and obvious spelling errors (“Friedhofs weg”, “Hinter der schule”).
Many other mismatches need on the ground verification.
Thanks also from me! Some I could fix.
I agree, some are easy to fix from home, others really need on the ground check, of which a few are maybe more than just wrong writing.
Danke an Wulf4096 et. al. für die tolle Visualisierung
Thanks. Great.
Thanks all, we’re now down to 1070 streets that need checking. So 300 are already fixed
But yesterday it was 1068, so someone broke 2 street names…
Did you see many false positives when fixing names? Is there a legitimate case where such streets indeed shall be named differently? In Poland I’d say yes (rarely though), but only because I discard given names and person titles. For Germany, I only remove letter case, diacritics, punctuation and whitespace before comparison.
Hallo,
ich hab mir mal die Karte von wulf angesehen. Es gibt dabei z.B. in Essen einen “bemängelten” Straßennamen. Er wird bemängelt weil er in zwei Schreibweisen erfasst ist.
Zum Ersten St.Annental - ohne Leerzeichen zwischen dem Punkt und dem großen A.
Zum Zweiten St. Annental mit Leerzeichen zwischen dem Punkt und dem großen A.
Also habe ich mal ein wenig gesucht welche Schreibweise denn nun richtig ist und somit getaggt werden sollte. Zuerst mal im amtlichen Stadtplan der Stadt Essen ins Suchhfeld beide Schreibweisen eingegeben.
Ohne Leerzeichen = Treffer werden angezeigt.
Mit Leezeichen = keine Treffer.
Der Vollständigkeithalber nocheinmal in das amtliche Straßenverzeichnis der Stadt geguckt. Hier gibt es die Straße im Gegensatz zum Stadtplan nur mit Leerzeichen…
Da das aber beides vermutlich keine zulässigen Quellen für OSM sind hab ich mir die Straßenschilder vor Ort angesehen. Hier wird die Straße mit Leerzeichen geschrieben. Also ist das ja der Name der getaggt werden muss.
Dummerwiese wurde aber bei einem von vier oder mehr aufgehängten Straßenschildern das St. “vergessen”. Auf diesem einen Schild steht also nur Annental anstatt St. Annental.
Da wir aber das mappen, was man vor Ort sieht würde ich der Schreibweise auf den Straßenschildern den Vorrang geben.
Das sollte nur mal als Beispiel dienen wie schwer es manchmal werden kann den “richtigen” Namen zu finden.
Bei diesem Beispiel werde ich jetzt aber einheitlich auf “St. Annental mit Leerzeichen” ändern da ich das fehlende St. als “Verschreiber” des Schildermachers werte.
Hello Rico! Thanks for the map, seems good to detect issues.
A possible false positive I’ve encountered near me:
https://www.openstreetmap.org/way/51367331 (this shows up as wrong on the map)
https://www.openstreetmap.org/way/639789314
I only live near there, but it would still be a detour, so I’m not sure if I can revisit it soonish.
Just want to say that hyphens possibly make for false positives.
Hallo blaubaer11,
als gebürtigem Essener ist mir noch ein krasserer Fall aufgefallen: thyssenkrupp Allee.
Ungewöhnlich ist die Kleinschreibung und die Getrenntschreibung des Straßennamens, z.B. im
Impressum der Firma
Stadtplan und Mietspiegel der Stadt Essen: ThyssenKrupp Allee
Kannst du mal gelegentlich nachsehen, wie es vor Ort aussieht?
Gruß
Reinhard
Könnte etwas dauern, aber werde ich machen…
An alle Fleißigen hier:
Ich hoffe ja, dass ihr bei Berichtigung eines Straßennamens an sich auch nebenbei prüft, ob es zu der Straße auch noch Gebäude mit Adressen, somit addr:street=… gibt, welche zu berichtigen wären.
Am besten kann man das in JOSM mit dem Kartenstil “Coloured Streets” optisch kontrollieren. Ruhig mal ausprobieren …
Denn ansonsten müsste es ja bei ungeänderten addr:street-Objekten massenhaft neue Treffer bei OSM-Suspects geben, oder?
…hat früher geklappt wie erwartet. Die vor Ort befindlichen Straßenschilder zeigen: ThyssenKrupp Allee. Also habe ich die Abweichler in osm auf diese Schreibweise geändert. Ein bißchen komisch ist allerdings, das innerstättische Hinweisschilder, also die rechteckigen, weißen Schilder mit der richtungsweisenden Spitze es so schreiben: thyssenkrupp Allee. Aber
auf den für osm ausschlaggebenden Straßenschilder steht´s wie oben angegeben.
http://81.190.124.187:31337/QA_map/mismatched_street_names_de.html
Now we’re under 800 streets (784, to be precise) - congrats to everyone
Can you elaborate what makes it a false positive? From what I can see they’re in the same village.
For Poland - we have a register called TERYT with all administrative entities, towns and villages, and street names. While Polish OSM street naming convention deviates sometimes from TERYT (which itself is not consistent - it’s as recorded by acts of municipal law), one can easily find false positives within a single village/town, because there would be two distinct entries. If none, it’s expected that there’s one street name in OSM even if there are different spellings on the ground, because reasonably thinking they represent the same entity (but anybody is free to put alternative spellings in alt_name).
If anybody has nothing to map because of the lockdown, here’s a new address of the tool (dreaded ISP changed IP with the new contract :/).
http://81.190.82.62:31337/QA_map/mismatched_street_names_de.html
As always, feedback (mainly regarding validator logic) is appreciated. I’m surprised this tool didn’t get traction here, so I guess there’s something about German street naming / OSM conventions I am missing.
Hi RicoElectrico.
GREAT, everything seams to be solved in Germany (0 rows)
yesterday we had abbout 77x rows …
Is the script not working ?
I think, still enough work to do 
Greeting derBeKri
Hi BeKri, not sure what went wrong but now it’s fine. Looks like OSM file conversion exited with an error. Thanks for spotting the issue.
An interesting find: https://www.openstreetmap.org/way/541065065