Rettelse 5033360: update Cracking set Cracking.[Road number] = '0500304' where Cracking.[Road number] = '5033360' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500304' where "Guard Rails".[Roadnumber] = '5033360' update "Light Poles" set "Light Poles".[Roadnumber] = '0500304' where "Light Poles".[Roadnumber] = '5033360' update Potholes set Potholes.[Road number] = '0500304'where Potholes.[Road number] = '5033360' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500304'where "Reference Poles".[Roadnumber] = '5033360' update Sensor set Sensor.[Road number] = '0500304'where Sensor.[Road number] = '5033360' update Signs set Signs.[Roadnumber] = '0500304'where Signs.[Roadnumber] = '5033360' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500304'where "Traffic Lights".[Roadnumber] = '5033360' Rettelse 5035840: update Cracking set Cracking.[Road number] = '0500523' where Cracking.[Road number] = '5035840' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500523' where "Guard Rails".[Roadnumber] = '5035840' update "Light Poles" set "Light Poles".[Roadnumber] = '0500523' where "Light Poles".[Roadnumber] = '5035840' update Potholes set Potholes.[Road number] = '0500523'where Potholes.[Road number] = '5035840' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500523'where "Reference Poles".[Roadnumber] = '5035840' update Sensor set Sensor.[Road number] = '0500523'where Sensor.[Road number] = '5035840' update Signs set Signs.[Roadnumber] = '0500523'where Signs.[Roadnumber] = '5035840' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500523'where "Traffic Lights".[Roadnumber] = '50358' Rettelse 5038250: update Cracking set Cracking.[Road number] = '0500303' where Cracking.[Road number] = '5038250' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500303' where "Guard Rails".[Roadnumber] = '5038250' update "Light Poles" set "Light Poles".[Roadnumber] = '0500303' where "Light Poles".[Roadnumber] = '5038250' update Potholes set Potholes.[Road number] = '0500303'where Potholes.[Road number] = '5038250' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500303'where "Reference Poles".[Roadnumber] = '5038250' update Sensor set Sensor.[Road number] = '0500303'where Sensor.[Road number] = '5038250' update Signs set Signs.[Roadnumber] = '0500303'where Signs.[Roadnumber] = '5038250' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500303'where "Traffic Lights".[Roadnumber] = '5038250' Rettelse 5031445: update Cracking set Cracking.[Road number] = '5800352' where Cracking.[Road number] = '5031445' update "Guard Rails" set "Guard Rails".[Roadnumber] = '5800352' where "Guard Rails".[Roadnumber] = '5031445' update "Light Poles" set "Light Poles".[Roadnumber] = '5800352' where "Light Poles".[Roadnumber] = '5031445' update Potholes set Potholes.[Road number] = '5800352'where Potholes.[Road number] = '5031445' update "Reference Poles" set "Reference Poles".[Roadnumber] = '5800352'where "Reference Poles".[Roadnumber] = '5031445' update Sensor set Sensor.[Road number] = '5800352'where Sensor.[Road number] = '5031445' update Signs set Signs.[Roadnumber] = '5800352'where Signs.[Roadnumber] = '5031445' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '5800352'where "Traffic Lights".[Roadnumber] = '5031445' Rettelse 5033770: update Cracking set Cracking.[Road number] = '5454090' where Cracking.[Road number] = '5033770' update "Guard Rails" set "Guard Rails".[Roadnumber] = '5454090' where "Guard Rails".[Roadnumber] = '5033770' update "Light Poles" set "Light Poles".[Roadnumber] = '5454090' where "Light Poles".[Roadnumber] = '5033770' update Potholes set Potholes.[Road number] = '5454090'where Potholes.[Road number] = '5033770' update "Reference Poles" set "Reference Poles".[Roadnumber] = '5454090'where "Reference Poles".[Roadnumber] = '5033770' update Sensor set Sensor.[Road number] = '5454090'where Sensor.[Road number] = '5033770' update Signs set Signs.[Roadnumber] = '5454090'where Signs.[Roadnumber] = '5033770' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '5454090'where "Traffic Lights".[Roadnumber] = '5033770' Rettelse 5031610: update Cracking set Cracking.[Road number] = '0500305' where Cracking.[Road number] = '5031610' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500305' where "Guard Rails".[Roadnumber] = '5031610' update "Light Poles" set "Light Poles".[Roadnumber] = '0500305' where "Light Poles".[Roadnumber] = '5031610' update Potholes set Potholes.[Road number] = '0500305'where Potholes.[Road number] = '5031610' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500305'where "Reference Poles".[Roadnumber] = '5031610' update Sensor set Sensor.[Road number] = '0500305'where Sensor.[Road number] = '5031610' update Signs set Signs.[Roadnumber] = '0500305'where Signs.[Roadnumber] = '5031610' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500305'where "Traffic Lights".[Roadnumber] = '5031610' Rettelse 5037700: update Cracking set Cracking.[Road number] = '0500316' where Cracking.[Road number] = '5037700' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500316' where "Guard Rails".[Roadnumber] = '5037700' update "Light Poles" set "Light Poles".[Roadnumber] = '0500316' where "Light Poles".[Roadnumber] = '5037700' update Potholes set Potholes.[Road number] = '0500316'where Potholes.[Road number] = '5037700' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500316'where "Reference Poles".[Roadnumber] = '5037700' update Sensor set Sensor.[Road number] = '0500316'where Sensor.[Road number] = '5037700' update Signs set Signs.[Roadnumber] = '0500316'where Signs.[Roadnumber] = '5037700' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500316'where "Traffic Lights".[Roadnumber] = '5037700' Rettelse 5038640: update Cracking set Cracking.[Road number] = '0500317' where Cracking.[Road number] = '5038640' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500317' where "Guard Rails".[Roadnumber] = '5038640' update "Light Poles" set "Light Poles".[Roadnumber] = '0500317' where "Light Poles".[Roadnumber] = '5038640' update Potholes set Potholes.[Road number] = '0500317'where Potholes.[Road number] = '5038640' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500317'where "Reference Poles".[Roadnumber] = '5038640' update Sensor set Sensor.[Road number] = '0500317'where Sensor.[Road number] = '5038640' update Signs set Signs.[Roadnumber] = '0500317'where Signs.[Roadnumber] = '5038640' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500317'where "Traffic Lights".[Roadnumber] = '5038640' Rettelse 5031470: update Cracking set Cracking.[Road number] = '0500564' where Cracking.[Road number] = '5031470' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500564' where "Guard Rails".[Roadnumber] = '5031470' update "Light Poles" set "Light Poles".[Roadnumber] = '0500564' where "Light Poles".[Roadnumber] = '5031470' update Potholes set Potholes.[Road number] = '0500564'where Potholes.[Road number] = '5031470' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500564'where "Reference Poles".[Roadnumber] = '5031470' update Sensor set Sensor.[Road number] = '0500564'where Sensor.[Road number] = '5031470' update Signs set Signs.[Roadnumber] = '0500564'where Signs.[Roadnumber] = '5031470' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500564'where "Traffic Lights".[Roadnumber] = '5031470' Rettelse 5039850: update Cracking set Cracking.[Road number] = '0500520' where Cracking.[Road number] = '5039850' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500520' where "Guard Rails".[Roadnumber] = '5039850' update "Light Poles" set "Light Poles".[Roadnumber] = '0500520' where "Light Poles".[Roadnumber] = '5039850' update Potholes set Potholes.[Road number] = '0500520'where Potholes.[Road number] = '5039850' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500520'where "Reference Poles".[Roadnumber] = '5039850' update Sensor set Sensor.[Road number] = '0500520'where Sensor.[Road number] = '5039850' update Signs set Signs.[Roadnumber] = '0500520'where Signs.[Roadnumber] = '5039850' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500520'where "Traffic Lights".[Roadnumber] = '5039850' Rettelse 5391725: update Cracking set Cracking.[Road number] = '0500552' where Cracking.[Road number] = '5391725' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500552' where "Guard Rails".[Roadnumber] = '5391725' update "Light Poles" set "Light Poles".[Roadnumber] = '0500552' where "Light Poles".[Roadnumber] = '5391725' update Potholes set Potholes.[Road number] = '0500552'where Potholes.[Road number] = '5391725' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500552'where "Reference Poles".[Roadnumber] = '5391725' update Sensor set Sensor.[Road number] = '0500552'where Sensor.[Road number] = '5391725' update Signs set Signs.[Roadnumber] = '0500552'where Signs.[Roadnumber] = '5391725' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500552'where "Traffic Lights".[Roadnumber] = '5391725' Rettelse 5395810: update Cracking set Cracking.[Road number] = '0500553' where Cracking.[Road number] = '5395810' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500553' where "Guard Rails".[Roadnumber] = '5395810' update "Light Poles" set "Light Poles".[Roadnumber] = '0500553' where "Light Poles".[Roadnumber] = '5395810' update Potholes set Potholes.[Road number] = '0500553'where Potholes.[Road number] = '5395810' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500553'where "Reference Poles".[Roadnumber] = '5395810' update Sensor set Sensor.[Road number] = '0500553'where Sensor.[Road number] = '5395810' update Signs set Signs.[Roadnumber] = '0500553'where Signs.[Roadnumber] = '5395810' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500553'where "Traffic Lights".[Roadnumber] = '5395810' Rettelse 5390965: update Cracking set Cracking.[Road number] = '0500552' where Cracking.[Road number] = '5390965' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500552' where "Guard Rails".[Roadnumber] = '5390965' update "Light Poles" set "Light Poles".[Roadnumber] = '0500552' where "Light Poles".[Roadnumber] = '5390965' update Potholes set Potholes.[Road number] = '0500552'where Potholes.[Road number] = '5390965' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500552'where "Reference Poles".[Roadnumber] = '5390965' update Sensor set Sensor.[Road number] = '0500552'where Sensor.[Road number] = '5390965' update Signs set Signs.[Roadnumber] = '0500552'where Signs.[Roadnumber] = '5390965' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500552'where "Traffic Lights".[Roadnumber] = '5390965' Rettelse 5391708: NAVN ÆNDRET MANUELT?!?!? #update Cracking set Cracking.[Road number] = '0500317' where Cracking.[Road number] = '5391708' #update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500317' where "Guard Rails".[Roadnumber] = '5391708' #update "Light Poles" set "Light Poles".[Roadnumber] = '0500317' where "Light Poles".[Roadnumber] = '5391708' #update Potholes set Potholes.[Road number] = '0500317'where Potholes.[Road number] = '5391708' #update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500317'where "Reference Poles".[Roadnumber] = '5391708' #update Sensor set Sensor.[Road number] = '0500317'where Sensor.[Road number] = '5391708' #update Signs set Signs.[Roadnumber] = '0500317'where Signs.[Roadnumber] = '5391708' #update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500317'where "Traffic Lights".[Roadnumber] = '5391708' Rettelse 5198884: update Cracking set Cracking.[Road number] = '0500561' where Cracking.[Road number] = '5198884' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500561' where "Guard Rails".[Roadnumber] = '5198884' update "Light Poles" set "Light Poles".[Roadnumber] = '0500561' where "Light Poles".[Roadnumber] = '5198884' update Potholes set Potholes.[Road number] = '0500561'where Potholes.[Road number] = '5198884' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500561'where "Reference Poles".[Roadnumber] = '5198884' update Sensor set Sensor.[Road number] = '0500561'where Sensor.[Road number] = '5198884' update Signs set Signs.[Roadnumber] = '0500561'where Signs.[Roadnumber] = '5198884' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500561'where "Traffic Lights".[Roadnumber] = '5198884' Rettelse 5192516: update Cracking set Cracking.[Road number] = '0500515' where Cracking.[Road number] = '5192516' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500515' where "Guard Rails".[Roadnumber] = '5192516' update "Light Poles" set "Light Poles".[Roadnumber] = '0500515' where "Light Poles".[Roadnumber] = '5192516' update Potholes set Potholes.[Road number] = '0500515'where Potholes.[Road number] = '5192516' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500515'where "Reference Poles".[Roadnumber] = '5192516' update Sensor set Sensor.[Road number] = '0500515'where Sensor.[Road number] = '5192516' update Signs set Signs.[Roadnumber] = '0500515'where Signs.[Roadnumber] = '5192516' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500515'where "Traffic Lights".[Roadnumber] = '5192516' Rettelse 5291725: update Cracking set Cracking.[Road number] = '0500520' where Cracking.[Road number] = '5291725' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500520' where "Guard Rails".[Roadnumber] = '5291725' update "Light Poles" set "Light Poles".[Roadnumber] = '0500520' where "Light Poles".[Roadnumber] = '5291725' update Potholes set Potholes.[Road number] = '0500520'where Potholes.[Road number] = '5291725' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500520'where "Reference Poles".[Roadnumber] = '5291725' update Sensor set Sensor.[Road number] = '0500520'where Sensor.[Road number] = '5291725' update Signs set Signs.[Roadnumber] = '0500520'where Signs.[Roadnumber] = '5291725' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500520'where "Traffic Lights".[Roadnumber] = '5291725' Rettelse 5391708: update Cracking set Cracking.[Road number] = '0500520' where Cracking.[Road number] = '5391708' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500520' where "Guard Rails".[Roadnumber] = '5391708' update "Light Poles" set "Light Poles".[Roadnumber] = '0500520' where "Light Poles".[Roadnumber] = '5391708' update Potholes set Potholes.[Road number] = '0500520'where Potholes.[Road number] = '5391708' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500520'where "Reference Poles".[Roadnumber] = '5391708' update Sensor set Sensor.[Road number] = '0500520'where Sensor.[Road number] = '5391708' update Signs set Signs.[Roadnumber] = '0500520'where Signs.[Roadnumber] = '5391708' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500520'where "Traffic Lights".[Roadnumber] = '5391708' Rettelse 5190333: update Cracking set Cracking.[Road number] = '0500562' where Cracking.[Road number] = '5190333' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500562' where "Guard Rails".[Roadnumber] = '5190333' update "Light Poles" set "Light Poles".[Roadnumber] = '0500562' where "Light Poles".[Roadnumber] = '5190333' update Potholes set Potholes.[Road number] = '0500562'where Potholes.[Road number] = '5190333' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500562'where "Reference Poles".[Roadnumber] = '5190333' update Sensor set Sensor.[Road number] = '0500562'where Sensor.[Road number] = '5190333' update Signs set Signs.[Roadnumber] = '0500562'where Signs.[Roadnumber] = '5190333' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500562'where "Traffic Lights".[Roadnumber] = '5190333' Rettelse 5197464: update Cracking set Cracking.[Road number] = '0500556' where Cracking.[Road number] = '5197464' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500556' where "Guard Rails".[Roadnumber] = '5197464' update "Light Poles" set "Light Poles".[Roadnumber] = '0500556' where "Light Poles".[Roadnumber] = '5197464' update Potholes set Potholes.[Road number] = '0500556'where Potholes.[Road number] = '5197464' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500556'where "Reference Poles".[Roadnumber] = '5197464' update Sensor set Sensor.[Road number] = '0500556'where Sensor.[Road number] = '5197464' update Signs set Signs.[Roadnumber] = '0500556'where Signs.[Roadnumber] = '5197464' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500556'where "Traffic Lights".[Roadnumber] = '5197464' Rettelse 5800594: update Cracking set Cracking.[Road number] = '0500501' where Cracking.[Road number] = '5800594' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500501' where "Guard Rails".[Roadnumber] = '5800594' update "Light Poles" set "Light Poles".[Roadnumber] = '0500501' where "Light Poles".[Roadnumber] = '5800594' update Potholes set Potholes.[Road number] = '0500501'where Potholes.[Road number] = '5800594' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500501'where "Reference Poles".[Roadnumber] = '5800594' update Sensor set Sensor.[Road number] = '0500501'where Sensor.[Road number] = '5800594' update Signs set Signs.[Roadnumber] = '0500501'where Signs.[Roadnumber] = '5800594' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500501'where "Traffic Lights".[Roadnumber] = '5800594' Rettelse 5458610: update Cracking set Cracking.[Road number] = '0500522' where Cracking.[Road number] = '5458610' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500522' where "Guard Rails".[Roadnumber] = '5458610' update "Light Poles" set "Light Poles".[Roadnumber] = '0500522' where "Light Poles".[Roadnumber] = '5458610' update Potholes set Potholes.[Road number] = '0500522'where Potholes.[Road number] = '5458610' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500522'where "Reference Poles".[Roadnumber] = '5458610' update Sensor set Sensor.[Road number] = '0500522'where Sensor.[Road number] = '5458610' update Signs set Signs.[Roadnumber] = '0500522'where Signs.[Roadnumber] = '5458610' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500522'where "Traffic Lights".[Roadnumber] = '5458610' Rettelse 5398380: update Cracking set Cracking.[Road number] = '0500514' where Cracking.[Road number] = '5398380' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500514' where "Guard Rails".[Roadnumber] = '5398380' update "Light Poles" set "Light Poles".[Roadnumber] = '0500514' where "Light Poles".[Roadnumber] = '5398380' update Potholes set Potholes.[Road number] = '0500514'where Potholes.[Road number] = '5398380' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500514'where "Reference Poles".[Roadnumber] = '5398380' update Sensor set Sensor.[Road number] = '0500514'where Sensor.[Road number] = '5398380' update Signs set Signs.[Roadnumber] = '0500514'where Signs.[Roadnumber] = '5398380' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500514'where "Traffic Lights".[Roadnumber] = '5398380' Rettelse 5393915: update Cracking set Cracking.[Road number] = '0500550' where Cracking.[Road number] = '5393915' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500550' where "Guard Rails".[Roadnumber] = '5393915' update "Light Poles" set "Light Poles".[Roadnumber] = '0500550' where "Light Poles".[Roadnumber] = '5393915' update Potholes set Potholes.[Road number] = '0500550'where Potholes.[Road number] = '5393915' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500550'where "Reference Poles".[Roadnumber] = '5393915' update Sensor set Sensor.[Road number] = '0500550'where Sensor.[Road number] = '5393915' update Signs set Signs.[Roadnumber] = '0500550'where Signs.[Roadnumber] = '5393915' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500550'where "Traffic Lights".[Roadnumber] = '5393915' Rettelse 5293260: update Cracking set Cracking.[Road number] = '0500554' where Cracking.[Road number] = '5293260' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500554' where "Guard Rails".[Roadnumber] = '5293260' update "Light Poles" set "Light Poles".[Roadnumber] = '0500554' where "Light Poles".[Roadnumber] = '5293260' update Potholes set Potholes.[Road number] = '0500554'where Potholes.[Road number] = '5293260' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500554'where "Reference Poles".[Roadnumber] = '5293260' update Sensor set Sensor.[Road number] = '0500554'where Sensor.[Road number] = '5293260' update Signs set Signs.[Roadnumber] = '0500554'where Signs.[Roadnumber] = '5293260' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500554'where "Traffic Lights".[Roadnumber] = '5293260' Rettelse 5450740: update Cracking set Cracking.[Road number] = '0500555' where Cracking.[Road number] = '5450740' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500555' where "Guard Rails".[Roadnumber] = '5450740' update "Light Poles" set "Light Poles".[Roadnumber] = '0500555' where "Light Poles".[Roadnumber] = '5450740' update Potholes set Potholes.[Road number] = '0500555'where Potholes.[Road number] = '5450740' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500555'where "Reference Poles".[Roadnumber] = '5450740' update Sensor set Sensor.[Road number] = '0500555'where Sensor.[Road number] = '5450740' update Signs set Signs.[Roadnumber] = '0500555'where Signs.[Roadnumber] = '5450740' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500555'where "Traffic Lights".[Roadnumber] = '5450740' Rettelse 5290790: update Cracking set Cracking.[Road number] = '0500555' where Cracking.[Road number] = '5290790' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500555' where "Guard Rails".[Roadnumber] = '5290790' update "Light Poles" set "Light Poles".[Roadnumber] = '0500555' where "Light Poles".[Roadnumber] = '5290790' update Potholes set Potholes.[Road number] = '0500555'where Potholes.[Road number] = '5290790' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500555'where "Reference Poles".[Roadnumber] = '5290790' update Sensor set Sensor.[Road number] = '0500555'where Sensor.[Road number] = '5290790' update Signs set Signs.[Roadnumber] = '0500555'where Signs.[Roadnumber] = '5290790' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500555'where "Traffic Lights".[Roadnumber] = '5290790' Rettelse 5292600: update Cracking set Cracking.[Road number] = '0500513' where Cracking.[Road number] = '5292600' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500513' where "Guard Rails".[Roadnumber] = '5292600' update "Light Poles" set "Light Poles".[Roadnumber] = '0500513' where "Light Poles".[Roadnumber] = '5292600' update Potholes set Potholes.[Road number] = '0500513'where Potholes.[Road number] = '5292600' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500513'where "Reference Poles".[Roadnumber] = '5292600' update Sensor set Sensor.[Road number] = '0500513'where Sensor.[Road number] = '5292600' update Signs set Signs.[Roadnumber] = '0500513'where Signs.[Roadnumber] = '5292600' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500513'where "Traffic Lights".[Roadnumber] = '5292600' Rettelse 5292780: update Cracking set Cracking.[Road number] = '0500513' where Cracking.[Road number] = '5292780' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500513' where "Guard Rails".[Roadnumber] = '5292780' update "Light Poles" set "Light Poles".[Roadnumber] = '0500513' where "Light Poles".[Roadnumber] = '5292780' update Potholes set Potholes.[Road number] = '0500513'where Potholes.[Road number] = '5292780' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500513'where "Reference Poles".[Roadnumber] = '5292780' update Sensor set Sensor.[Road number] = '0500513'where Sensor.[Road number] = '5292780' update Signs set Signs.[Roadnumber] = '0500513'where Signs.[Roadnumber] = '5292780' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500513'where "Traffic Lights".[Roadnumber] = '5292780' Rettelse 5294675: update Cracking set Cracking.[Road number] = '0500513' where Cracking.[Road number] = '5294675' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500513' where "Guard Rails".[Roadnumber] = '5294675' update "Light Poles" set "Light Poles".[Roadnumber] = '0500513' where "Light Poles".[Roadnumber] = '5294675' update Potholes set Potholes.[Road number] = '0500513'where Potholes.[Road number] = '5294675' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500513'where "Reference Poles".[Roadnumber] = '5294675' update Sensor set Sensor.[Road number] = '0500513'where Sensor.[Road number] = '5294675' update Signs set Signs.[Roadnumber] = '0500513'where Signs.[Roadnumber] = '5294675' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500513'where "Traffic Lights".[Roadnumber] = '5294675' Rettelse 5295890: update Cracking set Cracking.[Road number] = '0500548' where Cracking.[Road number] = '5295890' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500548' where "Guard Rails".[Roadnumber] = '5295890' update "Light Poles" set "Light Poles".[Roadnumber] = '0500548' where "Light Poles".[Roadnumber] = '5295890' update Potholes set Potholes.[Road number] = '0500548'where Potholes.[Road number] = '5295890' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500548'where "Reference Poles".[Roadnumber] = '5295890' update Sensor set Sensor.[Road number] = '0500548'where Sensor.[Road number] = '5295890' update Signs set Signs.[Roadnumber] = '0500548'where Signs.[Roadnumber] = '5295890' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500548'where "Traffic Lights".[Roadnumber] = '5295890' Rettelse 5454949: update Cracking set Cracking.[Road number] = '0500577' where Cracking.[Road number] = '5454949' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500577' where "Guard Rails".[Roadnumber] = '5454949' update "Light Poles" set "Light Poles".[Roadnumber] = '0500577' where "Light Poles".[Roadnumber] = '5454949' update Potholes set Potholes.[Road number] = '0500577'where Potholes.[Road number] = '5454949' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500577'where "Reference Poles".[Roadnumber] = '5454949' update Sensor set Sensor.[Road number] = '0500577'where Sensor.[Road number] = '5454949' update Signs set Signs.[Roadnumber] = '0500577'where Signs.[Roadnumber] = '5454949' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500577'where "Traffic Lights".[Roadnumber] = '5454949' Rettelse 5295910: update Cracking set Cracking.[Road number] = '0500324' where Cracking.[Road number] = '5295910' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500324' where "Guard Rails".[Roadnumber] = '5295910' update "Light Poles" set "Light Poles".[Roadnumber] = '0500324' where "Light Poles".[Roadnumber] = '5295910' update Potholes set Potholes.[Road number] = '0500324'where Potholes.[Road number] = '5295910' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500324'where "Reference Poles".[Roadnumber] = '5295910' update Sensor set Sensor.[Road number] = '0500324'where Sensor.[Road number] = '5295910' update Signs set Signs.[Roadnumber] = '0500324'where Signs.[Roadnumber] = '5295910' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500324'where "Traffic Lights".[Roadnumber] = '5295910' Rettelse 5452929: update Cracking set Cracking.[Road number] = '0500519' where Cracking.[Road number] = '5452929' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500519' where "Guard Rails".[Roadnumber] = '5452929' update "Light Poles" set "Light Poles".[Roadnumber] = '0500519' where "Light Poles".[Roadnumber] = '5452929' update Potholes set Potholes.[Road number] = '0500519'where Potholes.[Road number] = '5452929' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500519'where "Reference Poles".[Roadnumber] = '5452929' update Sensor set Sensor.[Road number] = '0500519'where Sensor.[Road number] = '5452929' update Signs set Signs.[Roadnumber] = '0500519'where Signs.[Roadnumber] = '5452929' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500519'where "Traffic Lights".[Roadnumber] = '5452929' Rettelse 5455731: update Cracking set Cracking.[Road number] = '0500519' where Cracking.[Road number] = '5455731' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500519' where "Guard Rails".[Roadnumber] = '5455731' update "Light Poles" set "Light Poles".[Roadnumber] = '0500519' where "Light Poles".[Roadnumber] = '5455731' update Potholes set Potholes.[Road number] = '0500519'where Potholes.[Road number] = '5455731' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500519'where "Reference Poles".[Roadnumber] = '5455731' update Sensor set Sensor.[Road number] = '0500519'where Sensor.[Road number] = '5455731' update Signs set Signs.[Roadnumber] = '0500519'where Signs.[Roadnumber] = '5455731' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500519'where "Traffic Lights".[Roadnumber] = '5455731' Rettelse 5454368: update Cracking set Cracking.[Road number] = '0500519' where Cracking.[Road number] = '5454368' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500519' where "Guard Rails".[Roadnumber] = '5454368' update "Light Poles" set "Light Poles".[Roadnumber] = '0500519' where "Light Poles".[Roadnumber] = '5454368' update Potholes set Potholes.[Road number] = '0500519'where Potholes.[Road number] = '5454368' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500519'where "Reference Poles".[Roadnumber] = '5454368' update Sensor set Sensor.[Road number] = '0500519'where Sensor.[Road number] = '5454368' update Signs set Signs.[Roadnumber] = '0500519'where Signs.[Roadnumber] = '5454368' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500519'where "Traffic Lights".[Roadnumber] = '5454368' Rettelse 5452903: update Cracking set Cracking.[Road number] = '0500519' where Cracking.[Road number] = '5452903' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500519' where "Guard Rails".[Roadnumber] = '5452903' update "Light Poles" set "Light Poles".[Roadnumber] = '0500519' where "Light Poles".[Roadnumber] = '5452903' update Potholes set Potholes.[Road number] = '0500519'where Potholes.[Road number] = '5452903' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500519'where "Reference Poles".[Roadnumber] = '5452903' update Sensor set Sensor.[Road number] = '0500519'where Sensor.[Road number] = '5452903' update Signs set Signs.[Roadnumber] = '0500519'where Signs.[Roadnumber] = '5452903' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500519'where "Traffic Lights".[Roadnumber] = '5452903' Rettelse 5456868: update Cracking set Cracking.[Road number] = '0500519' where Cracking.[Road number] = '5456868' update "Guard Rails" set "Guard Rails".[Roadnumber] = '0500519' where "Guard Rails".[Roadnumber] = '5456868' update "Light Poles" set "Light Poles".[Roadnumber] = '0500519' where "Light Poles".[Roadnumber] = '5456868' update Potholes set Potholes.[Road number] = '0500519'where Potholes.[Road number] = '5456868' update "Reference Poles" set "Reference Poles".[Roadnumber] = '0500519'where "Reference Poles".[Roadnumber] = '5456868' update Sensor set Sensor.[Road number] = '0500519'where Sensor.[Road number] = '5456868' update Signs set Signs.[Roadnumber] = '0500519'where Signs.[Roadnumber] = '5456868' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '0500519'where "Traffic Lights".[Roadnumber] = '5456868' Rettelse 5454696: update Cracking set Cracking.[Road number] = '5454671' where Cracking.[Road number] = '5454696' update "Guard Rails" set "Guard Rails".[Roadnumber] = '5454671' where "Guard Rails".[Roadnumber] = '5454696' update "Light Poles" set "Light Poles".[Roadnumber] = '5454671' where "Light Poles".[Roadnumber] = '5454696' update Potholes set Potholes.[Road number] = '5454671'where Potholes.[Road number] = '5454696' update "Reference Poles" set "Reference Poles".[Roadnumber] = '5454671'where "Reference Poles".[Roadnumber] = '5454696' update Sensor set Sensor.[Road number] = '5454671'where Sensor.[Road number] = '5454696' update Signs set Signs.[Roadnumber] = '5454671'where Signs.[Roadnumber] = '5454696' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '5454671'where "Traffic Lights".[Roadnumber] = '5454696' Rettelse 5037450: update Cracking set Cracking.[Road number] = '5297028' where Cracking.[Road number] = '5037450' update "Guard Rails" set "Guard Rails".[Roadnumber] = '5297028' where "Guard Rails".[Roadnumber] = '5037450' update "Light Poles" set "Light Poles".[Roadnumber] = '5297028' where "Light Poles".[Roadnumber] = '5037450' update Potholes set Potholes.[Road number] = '5297028'where Potholes.[Road number] = '5037450' update "Reference Poles" set "Reference Poles".[Roadnumber] = '5297028'where "Reference Poles".[Roadnumber] = '5037450' update Sensor set Sensor.[Road number] = '5297028'where Sensor.[Road number] = '5037450' update Signs set Signs.[Roadnumber] = '5297028'where Signs.[Roadnumber] = '5037450' update "Traffic Lights" set "Traffic Lights".[Roadnumber] = '5297028'where "Traffic Lights".[Roadnumber] = '5037450'