Flyt strækning i 5035840:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 2.170, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 2.170 where Cracking.[Road number] = '5035840'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 2.170,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 2.170 where Guard_Rails.[Roadnumber] = '5035840'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 2.170 where Light_Poles.[Roadnumber] = '5035840'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 2.170 where Potholes.[Road number] = '5035840'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 2.170 where Reference_Poles.[Roadnumber] = '5035840'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 2.170,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 2.170 where Sensor.[Road number] = '5035840'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 2.170 where Signs.[Roadnumber] = '5035840'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 2.170 where Traffic_Lights.[Roadnumber] = '5035840'


Flyt strækning i 5038250:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 1.386, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 1.386 where Cracking.[Road number] = '5038250'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 1.386,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 1.386 where Guard_Rails.[Roadnumber] = '5038250'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 1.386 where Light_Poles.[Roadnumber] = '5038250'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 1.386 where Potholes.[Road number] = '5038250'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 1.386 where Reference_Poles.[Roadnumber] = '5038250'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 1.386,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 1.386 where Sensor.[Road number] = '5038250'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 1.386 where Signs.[Roadnumber] = '5038250'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 1.386 where Traffic_Lights.[Roadnumber] = '5038250'


Flyt strækning i 5031470:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 0.776, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 0.776 where Cracking.[Road number] = '5031470'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 0.776,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 0.776 where Guard_Rails.[Roadnumber] = '5031470'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 0.776 where Light_Poles.[Roadnumber] = '5031470'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 0.776 where Potholes.[Road number] = '5031470'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 0.776 where Reference_Poles.[Roadnumber] = '5031470'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 0.776,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 0.776 where Sensor.[Road number] = '5031470'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 0.776 where Signs.[Roadnumber] = '5031470'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 0.776 where Traffic_Lights.[Roadnumber] = '5031470'


Flyt strækning i 5391725:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 10.036, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 10.036 where Cracking.[Road number] = '5391725'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 10.036,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 10.036 where Guard_Rails.[Roadnumber] = '5391725'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 10.036 where Light_Poles.[Roadnumber] = '5391725'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 10.036 where Potholes.[Road number] = '5391725'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 10.036 where Reference_Poles.[Roadnumber] = '5391725'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 10.036,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 10.036 where Sensor.[Road number] = '5391725'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 10.036 where Signs.[Roadnumber] = '5391725'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 10.036 where Traffic_Lights.[Roadnumber] = '5391725'


Flyt strækning i 5395810:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 0.049, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 0.049 where Cracking.[Road number] = '5395810'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 0.049,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 0.049 where Guard_Rails.[Roadnumber] = '5395810'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 0.049 where Light_Poles.[Roadnumber] = '5395810'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 0.049 where Potholes.[Road number] = '5395810'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 0.049 where Reference_Poles.[Roadnumber] = '5395810'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 0.049,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 0.049 where Sensor.[Road number] = '5395810'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 0.049 where Signs.[Roadnumber] = '5395810'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 0.049 where Traffic_Lights.[Roadnumber] = '5395810'


Flyt strækning i 5390965:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 21.823, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 21.823 where Cracking.[Road number] = '5390965'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 21.823,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 21.823 where Guard_Rails.[Roadnumber] = '5390965'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 21.823 where Light_Poles.[Roadnumber] = '5390965'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 21.823 where Potholes.[Road number] = '5390965'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 21.823 where Reference_Poles.[Roadnumber] = '5390965'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 21.823,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 21.823 where Sensor.[Road number] = '5390965'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 21.823 where Signs.[Roadnumber] = '5390965'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 21.823 where Traffic_Lights.[Roadnumber] = '5390965'



Flyt strækning i 5198884:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 3.492, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 3.492 where Cracking.[Road number] = '5198884'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 3.492,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 3.492 where Guard_Rails.[Roadnumber] = '5198884'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 3.492 where Light_Poles.[Roadnumber] = '5198884'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 3.492 where Potholes.[Road number] = '5198884'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 3.492 where Reference_Poles.[Roadnumber] = '5198884'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 3.492,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 3.492 where Sensor.[Road number] = '5198884'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 3.492 where Signs.[Roadnumber] = '5198884'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 3.492 where Traffic_Lights.[Roadnumber] = '5198884'


Flyt strækning i 5192516:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 7.241, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 7.241 where Cracking.[Road number] = '5192516'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 7.241,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 7.241 where Guard_Rails.[Roadnumber] = '5192516'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 7.241 where Light_Poles.[Roadnumber] = '5192516'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 7.241 where Potholes.[Road number] = '5192516'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 7.241 where Reference_Poles.[Roadnumber] = '5192516'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 7.241,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 7.241 where Sensor.[Road number] = '5192516'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 7.241 where Signs.[Roadnumber] = '5192516'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 7.241 where Traffic_Lights.[Roadnumber] = '5192516'


Flyt strækning i 5291725:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 2.398, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 2.398 where Cracking.[Road number] = '5291725'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 2.398,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 2.398 where Guard_Rails.[Roadnumber] = '5291725'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 2.398 where Light_Poles.[Roadnumber] = '5291725'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 2.398 where Potholes.[Road number] = '5291725'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 2.398 where Reference_Poles.[Roadnumber] = '5291725'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 2.398,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 2.398 where Sensor.[Road number] = '5291725'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 2.398 where Signs.[Roadnumber] = '5291725'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 2.398 where Traffic_Lights.[Roadnumber] = '5291725'



Flyt strækning i 5800594:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 15.050, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 15.050 where Cracking.[Road number] = '5800594'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 15.050,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 15.050 where Guard_Rails.[Roadnumber] = '5800594'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 15.050 where Light_Poles.[Roadnumber] = '5800594'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 15.050 where Potholes.[Road number] = '5800594'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 15.050 where Reference_Poles.[Roadnumber] = '5800594'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 15.050,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 15.050 where Sensor.[Road number] = '5800594'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 15.050 where Signs.[Roadnumber] = '5800594'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 15.050 where Traffic_Lights.[Roadnumber] = '5800594'


Flyt strækning i 5033080:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 5.551, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 5.551 where Cracking.[Road number] = '5033080'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 5.551,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 5.551 where Guard_Rails.[Roadnumber] = '5033080'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 5.551 where Light_Poles.[Roadnumber] = '5033080'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 5.551 where Potholes.[Road number] = '5033080'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 5.551 where Reference_Poles.[Roadnumber] = '5033080'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 5.551,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 5.551 where Sensor.[Road number] = '5033080'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 5.551 where Signs.[Roadnumber] = '5033080'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 5.551 where Traffic_Lights.[Roadnumber] = '5033080'


Flyt strækning i 5458610:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 1.060, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 1.060 where Cracking.[Road number] = '5458610'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 1.060,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 1.060 where Guard_Rails.[Roadnumber] = '5458610'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 1.060 where Light_Poles.[Roadnumber] = '5458610'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 1.060 where Potholes.[Road number] = '5458610'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 1.060 where Reference_Poles.[Roadnumber] = '5458610'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 1.060,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 1.060 where Sensor.[Road number] = '5458610'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 1.060 where Signs.[Roadnumber] = '5458610'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 1.060 where Traffic_Lights.[Roadnumber] = '5458610'


Flyt strækning i 5394557:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 15.641, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 15.641 where Cracking.[Road number] = '5394557'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 15.641,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 15.641 where Guard_Rails.[Roadnumber] = '5394557'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 15.641 where Light_Poles.[Roadnumber] = '5394557'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 15.641 where Potholes.[Road number] = '5394557'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 15.641 where Reference_Poles.[Roadnumber] = '5394557'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 15.641,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 15.641 where Sensor.[Road number] = '5394557'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 15.641 where Signs.[Roadnumber] = '5394557'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 15.641 where Traffic_Lights.[Roadnumber] = '5394557'


Flyt strækning i 5290790:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 3.236, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 3.236 where Cracking.[Road number] = '5290790'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 3.236,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 3.236 where Guard_Rails.[Roadnumber] = '5290790'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 3.236 where Light_Poles.[Roadnumber] = '5290790'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 3.236 where Potholes.[Road number] = '5290790'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 3.236 where Reference_Poles.[Roadnumber] = '5290790'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 3.236,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 3.236 where Sensor.[Road number] = '5290790'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 3.236 where Signs.[Roadnumber] = '5290790'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 3.236 where Traffic_Lights.[Roadnumber] = '5290790'


Flyt strækning i 5292600:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 7.900, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 7.900 where Cracking.[Road number] = '5292600'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 7.900,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 7.900 where Guard_Rails.[Roadnumber] = '5292600'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 7.900 where Light_Poles.[Roadnumber] = '5292600'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 7.900 where Potholes.[Road number] = '5292600'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 7.900 where Reference_Poles.[Roadnumber] = '5292600'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 7.900,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 7.900 where Sensor.[Road number] = '5292600'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 7.900 where Signs.[Roadnumber] = '5292600'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 7.900 where Traffic_Lights.[Roadnumber] = '5292600'


Flyt strækning i 5292780:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 15.582, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 15.582 where Cracking.[Road number] = '5292780'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 15.582,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 15.582 where Guard_Rails.[Roadnumber] = '5292780'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 15.582 where Light_Poles.[Roadnumber] = '5292780'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 15.582 where Potholes.[Road number] = '5292780'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 15.582 where Reference_Poles.[Roadnumber] = '5292780'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 15.582,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 15.582 where Sensor.[Road number] = '5292780'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 15.582 where Signs.[Roadnumber] = '5292780'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 15.582 where Traffic_Lights.[Roadnumber] = '5292780'


Flyt strækning i 5294675:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 16.745, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 16.745 where Cracking.[Road number] = '5294675'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 16.745,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 16.745 where Guard_Rails.[Roadnumber] = '5294675'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 16.745 where Light_Poles.[Roadnumber] = '5294675'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 16.745 where Potholes.[Road number] = '5294675'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 16.745 where Reference_Poles.[Roadnumber] = '5294675'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 16.745,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 16.745 where Sensor.[Road number] = '5294675'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 16.745 where Signs.[Roadnumber] = '5294675'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 16.745 where Traffic_Lights.[Roadnumber] = '5294675'


Flyt strækning i 5454949:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 0.990, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 0.990 where Cracking.[Road number] = '5454949'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 0.990,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 0.990 where Guard_Rails.[Roadnumber] = '5454949'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 0.990 where Light_Poles.[Roadnumber] = '5454949'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 0.990 where Potholes.[Road number] = '5454949'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 0.990 where Reference_Poles.[Roadnumber] = '5454949'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 0.990,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 0.990 where Sensor.[Road number] = '5454949'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 0.990 where Signs.[Roadnumber] = '5454949'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 0.990 where Traffic_Lights.[Roadnumber] = '5454949'


Flyt strækning i 5295910:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 5.269, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 5.269 where Cracking.[Road number] = '5295910'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 5.269,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 5.269 where Guard_Rails.[Roadnumber] = '5295910'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 5.269 where Light_Poles.[Roadnumber] = '5295910'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 5.269 where Potholes.[Road number] = '5295910'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 5.269 where Reference_Poles.[Roadnumber] = '5295910'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 5.269,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 5.269 where Sensor.[Road number] = '5295910'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 5.269 where Signs.[Roadnumber] = '5295910'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 5.269 where Traffic_Lights.[Roadnumber] = '5295910'


Flyt strækning i 5452929:

update Cracking set Cracking.[From Reference Point] = Cracking.[From Reference Point] + 12.092, Cracking.[To Reference Point] = Cracking.[To Reference Point] + 12.092 where Cracking.[Road number] = '5452929'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = Guard_Rails.[FromReferencePoint] + 12.092,Guard_Rails.[ToReferencePoint] = Guard_Rails.[ToReferencePoint] + 12.092 where Guard_Rails.[Roadnumber] = '5452929'

update Light_Poles set Light_Poles.[ReferencePoint] = Light_Poles.[ReferencePoint] + 12.092 where Light_Poles.[Roadnumber] = '5452929'

update Potholes set Potholes.[Reference Point] = Potholes.[Reference Point] + 12.092 where Potholes.[Road number] = '5452929'

update Reference_Poles set Reference_Poles.[ReferencePoint] = Reference_Poles.[ReferencePoint] + 12.092 where Reference_Poles.[Roadnumber] = '5452929'

update Sensor set Sensor.[From Reference Point] = Sensor.[From Reference Point] + 12.092,Sensor.[To Reference Point] = Sensor.[To Reference Point] + 12.092 where Sensor.[Road number] = '5452929'

update Signs set Signs.[ReferencePoint] = Signs.[ReferencePoint] + 12.092 where Signs.[Roadnumber] = '5452929'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = Traffic_Lights.[ReferencePoint] + 12.092 where Traffic_Lights.[Roadnumber] = '5452929'