Vend strækning 5450315

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 3.050),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 3.050) where Cracking.[Road number] = '5450315'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 3.050),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 3.050) where Guard_Rails.[Roadnumber] = '5450315'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 3.050) where Light_Poles.[Roadnumber] = '5450315'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 3.050) where Potholes.[Road number] = '5450315'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 3.050) where Reference_Poles.[Roadnumber] = '5450315'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 3.050),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 3.050) where Sensor.[Road number] = '5450315'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 3.050) where Signs.[Roadnumber] = '5450315'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 3.050) where Traffic_Lights.[Roadnumber] = '5450315'

Vend strækning 5038090

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 0.460),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 0.460) where Cracking.[Road number] = '5038090'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 0.460),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 0.460) where Guard_Rails.[Roadnumber] = '5038090'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 0.460) where Light_Poles.[Roadnumber] = '5038090'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 0.460) where Potholes.[Road number] = '5038090'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 0.460) where Reference_Poles.[Roadnumber] = '5038090'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 0.460),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 0.460) where Sensor.[Road number] = '5038090'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 0.460) where Signs.[Roadnumber] = '5038090'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 0.460) where Traffic_Lights.[Roadnumber] = '5038090'


Vend strækning 5038090

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 0.700),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 0.700) where Cracking.[Road number] = '5038090'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 0.700),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 0.700) where Guard_Rails.[Roadnumber] = '5038090'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 0.700) where Light_Poles.[Roadnumber] = '5038090'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 0.700) where Potholes.[Road number] = '5038090'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 0.700) where Reference_Poles.[Roadnumber] = '5038090'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 0.700),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 0.700) where Sensor.[Road number] = '5038090'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 0.700) where Signs.[Roadnumber] = '5038090'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 0.700) where Traffic_Lights.[Roadnumber] = '5038090'

Vend strækning 5032750

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 3.180),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 3.180) where Cracking.[Road number] = '5032750'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 3.180),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 3.180) where Guard_Rails.[Roadnumber] = '5032750'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 3.180) where Light_Poles.[Roadnumber] = '5032750'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 3.180) where Potholes.[Road number] = '5032750'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 3.180) where Reference_Poles.[Roadnumber] = '5032750'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 3.180),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 3.180) where Sensor.[Road number] = '5032750'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 3.180) where Signs.[Roadnumber] = '5032750'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 3.180) where Traffic_Lights.[Roadnumber] = '5032750'

Vend strækning 5033310

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 2.997),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 2.997) where Cracking.[Road number] = '5033310'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 2.997),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 2.997) where Guard_Rails.[Roadnumber] = '5033310'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 2.997) where Light_Poles.[Roadnumber] = '5033310'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 2.997) where Potholes.[Road number] = '5033310'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 2.997) where Reference_Poles.[Roadnumber] = '5033310'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 2.997),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 2.997) where Sensor.[Road number] = '5033310'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 2.997) where Signs.[Roadnumber] = '5033310'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 2.997) where Traffic_Lights.[Roadnumber] = '5033310'

Vend strækning 5397400

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 5.660),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 5.660) where Cracking.[Road number] = '5397400'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 5.660),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 5.660) where Guard_Rails.[Roadnumber] = '5397400'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 5.660) where Light_Poles.[Roadnumber] = '5397400'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 5.660) where Potholes.[Road number] = '5397400'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 5.660) where Reference_Poles.[Roadnumber] = '5397400'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 5.660),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 5.660) where Sensor.[Road number] = '5397400'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 5.660) where Signs.[Roadnumber] = '5397400'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 5.660) where Traffic_Lights.[Roadnumber] = '5397400'

Vend strækning 5190850

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 1.380),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 1.380) where Cracking.[Road number] = '5190850'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 1.380),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 1.380) where Guard_Rails.[Roadnumber] = '5190850'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 1.380) where Light_Poles.[Roadnumber] = '5190850'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 1.380) where Potholes.[Road number] = '5190850'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 1.380) where Reference_Poles.[Roadnumber] = '5190850'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 1.380),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 1.380) where Sensor.[Road number] = '5190850'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 1.380) where Signs.[Roadnumber] = '5190850'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 1.380) where Traffic_Lights.[Roadnumber] = '5190850'

Vend strækning 5194850

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 1.370),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 1.370) where Cracking.[Road number] = '5194850'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 1.370),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 1.370) where Guard_Rails.[Roadnumber] = '5194850'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 1.370) where Light_Poles.[Roadnumber] = '5194850'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 1.370) where Potholes.[Road number] = '5194850'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 1.370) where Reference_Poles.[Roadnumber] = '5194850'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 1.370),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 1.370) where Sensor.[Road number] = '5194850'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 1.370) where Signs.[Roadnumber] = '5194850'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 1.370) where Traffic_Lights.[Roadnumber] = '5194850'

Vend strækning 5194845

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 0.250),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 0.250) where Cracking.[Road number] = '5194845'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 0.250),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 0.250) where Guard_Rails.[Roadnumber] = '5194845'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 0.250) where Light_Poles.[Roadnumber] = '5194845'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 0.250) where Potholes.[Road number] = '5194845'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 0.250) where Reference_Poles.[Roadnumber] = '5194845'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 0.250),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 0.250) where Sensor.[Road number] = '5194845'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 0.250) where Signs.[Roadnumber] = '5194845'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 0.250) where Traffic_Lights.[Roadnumber] = '5194845'

Vend strækning 5195681

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 6.500),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 6.500) where Cracking.[Road number] = '5195681'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 6.500),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 6.500) where Guard_Rails.[Roadnumber] = '5195681'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 6.500) where Light_Poles.[Roadnumber] = '5195681'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 6.500) where Potholes.[Road number] = '5195681'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 6.500) where Reference_Poles.[Roadnumber] = '5195681'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 6.500),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 6.500) where Sensor.[Road number] = '5195681'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 6.500) where Signs.[Roadnumber] = '5195681'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 6.500) where Traffic_Lights.[Roadnumber] = '5195681'

Vend strækning 5452685

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 3.130),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 3.130) where Cracking.[Road number] = '5452685'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 3.130),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 3.130) where Guard_Rails.[Roadnumber] = '5452685'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 3.130) where Light_Poles.[Roadnumber] = '5452685'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 3.130) where Potholes.[Road number] = '5452685'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 3.130) where Reference_Poles.[Roadnumber] = '5452685'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 3.130),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 3.130) where Sensor.[Road number] = '5452685'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 3.130) where Signs.[Roadnumber] = '5452685'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 3.130) where Traffic_Lights.[Roadnumber] = '5452685'

Vend strækning 5451161

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 0.700),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 0.700) where Cracking.[Road number] = '5451161'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 0.700),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 0.700) where Guard_Rails.[Roadnumber] = '5451161'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 0.700) where Light_Poles.[Roadnumber] = '5451161'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 0.700) where Potholes.[Road number] = '5451161'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 0.700) where Reference_Poles.[Roadnumber] = '5451161'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 0.700),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 0.700) where Sensor.[Road number] = '5451161'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 0.700) where Signs.[Roadnumber] = '5451161'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 0.700) where Traffic_Lights.[Roadnumber] = '5451161'

Vend strækning 5394585

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 1.118),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 1.118) where Cracking.[Road number] = '5394585'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 1.118),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 1.118) where Guard_Rails.[Roadnumber] = '5394585'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 1.118) where Light_Poles.[Roadnumber] = '5394585'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 1.118) where Potholes.[Road number] = '5394585'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 1.118) where Reference_Poles.[Roadnumber] = '5394585'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 1.118),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 1.118) where Sensor.[Road number] = '5394585'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 1.118) where Signs.[Roadnumber] = '5394585'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 1.118) where Traffic_Lights.[Roadnumber] = '5394585'

Vend strækning 5393300

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 0.350),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 0.350) where Cracking.[Road number] = '5393300'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 0.350),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 0.350) where Guard_Rails.[Roadnumber] = '5393300'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 0.350) where Light_Poles.[Roadnumber] = '5393300'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 0.350) where Potholes.[Road number] = '5393300'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 0.350) where Reference_Poles.[Roadnumber] = '5393300'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 0.350),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 0.350) where Sensor.[Road number] = '5393300'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 0.350) where Signs.[Roadnumber] = '5393300'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 0.350) where Traffic_Lights.[Roadnumber] = '5393300'

Vend strækning 5392202

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 0.670),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 0.670) where Cracking.[Road number] = '5392202'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 0.670),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 0.670) where Guard_Rails.[Roadnumber] = '5392202'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 0.670) where Light_Poles.[Roadnumber] = '5392202'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 0.670) where Potholes.[Road number] = '5392202'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 0.670) where Reference_Poles.[Roadnumber] = '5392202'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 0.670),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 0.670) where Sensor.[Road number] = '5392202'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 0.670) where Signs.[Roadnumber] = '5392202'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 0.670) where Traffic_Lights.[Roadnumber] = '5392202'

Vend strækning 5397821

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 0.560),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 0.560) where Cracking.[Road number] = '5397821'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 0.560),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 0.560) where Guard_Rails.[Roadnumber] = '5397821'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 0.560) where Light_Poles.[Roadnumber] = '5397821'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 0.560) where Potholes.[Road number] = '5397821'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 0.560) where Reference_Poles.[Roadnumber] = '5397821'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 0.560),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 0.560) where Sensor.[Road number] = '5397821'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 0.560) where Signs.[Roadnumber] = '5397821'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 0.560) where Traffic_Lights.[Roadnumber] = '5397821'

Vend strækning 5293650

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 6.671),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 6.671) where Cracking.[Road number] = '5293650'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 6.671),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 6.671) where Guard_Rails.[Roadnumber] = '5293650'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 6.671) where Light_Poles.[Roadnumber] = '5293650'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 6.671) where Potholes.[Road number] = '5293650'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 6.671) where Reference_Poles.[Roadnumber] = '5293650'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 6.671),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 6.671) where Sensor.[Road number] = '5293650'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 6.671) where Signs.[Roadnumber] = '5293650'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 6.671) where Traffic_Lights.[Roadnumber] = '5293650'

Vend strækning 5399470

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 5.240),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 5.240) where Cracking.[Road number] = '5399470'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 5.240),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 5.240) where Guard_Rails.[Roadnumber] = '5399470'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 5.240) where Light_Poles.[Roadnumber] = '5399470'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 5.240) where Potholes.[Road number] = '5399470'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 5.240) where Reference_Poles.[Roadnumber] = '5399470'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 5.240),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 5.240) where Sensor.[Road number] = '5399470'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 5.240) where Signs.[Roadnumber] = '5399470'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 5.240) where Traffic_Lights.[Roadnumber] = '5399470'

Vend strækning 5394135

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 2.640),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 2.640) where Cracking.[Road number] = '5394135'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 2.640),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 2.640) where Guard_Rails.[Roadnumber] = '5394135'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 2.640) where Light_Poles.[Roadnumber] = '5394135'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 2.640) where Potholes.[Road number] = '5394135'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 2.640) where Reference_Poles.[Roadnumber] = '5394135'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 2.640),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 2.640) where Sensor.[Road number] = '5394135'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 2.640) where Signs.[Roadnumber] = '5394135'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 2.640) where Traffic_Lights.[Roadnumber] = '5394135'

Vend strækning 5397192

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 0.430),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 0.430) where Cracking.[Road number] = '5397192'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 0.430),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 0.430) where Guard_Rails.[Roadnumber] = '5397192'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 0.430) where Light_Poles.[Roadnumber] = '5397192'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 0.430) where Potholes.[Road number] = '5397192'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 0.430) where Reference_Poles.[Roadnumber] = '5397192'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 0.430),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 0.430) where Sensor.[Road number] = '5397192'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 0.430) where Signs.[Roadnumber] = '5397192'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 0.430) where Traffic_Lights.[Roadnumber] = '5397192'

Vend strækning 5398920

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 1.050),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 1.050) where Cracking.[Road number] = '5398920'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 1.050),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 1.050) where Guard_Rails.[Roadnumber] = '5398920'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 1.050) where Light_Poles.[Roadnumber] = '5398920'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 1.050) where Potholes.[Road number] = '5398920'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 1.050) where Reference_Poles.[Roadnumber] = '5398920'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 1.050),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 1.050) where Sensor.[Road number] = '5398920'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 1.050) where Signs.[Roadnumber] = '5398920'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 1.050) where Traffic_Lights.[Roadnumber] = '5398920'

Vend strækning 0500548

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 3.335),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 3.335) where Cracking.[Road number] = '0500548'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 3.335),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 3.335) where Guard_Rails.[Roadnumber] = '0500548'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 3.335) where Light_Poles.[Roadnumber] = '0500548'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 3.335) where Potholes.[Road number] = '0500548'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 3.335) where Reference_Poles.[Roadnumber] = '0500548'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 3.335),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 3.335) where Sensor.[Road number] = '0500548'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 3.335) where Signs.[Roadnumber] = '0500548'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 3.335) where Traffic_Lights.[Roadnumber] = '0500548'

Vend strækning 5450808

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 1.960),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 1.960) where Cracking.[Road number] = '5450808'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 1.960),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 1.960) where Guard_Rails.[Roadnumber] = '5450808'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 1.960) where Light_Poles.[Roadnumber] = '5450808'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 1.960) where Potholes.[Road number] = '5450808'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 1.960) where Reference_Poles.[Roadnumber] = '5450808'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 1.960),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 1.960) where Sensor.[Road number] = '5450808'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 1.960) where Signs.[Roadnumber] = '5450808'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 1.960) where Traffic_Lights.[Roadnumber] = '5450808'

Vend strækning 5455022

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 0.620),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 0.620) where Cracking.[Road number] = '5455022'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 0.620),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 0.620) where Guard_Rails.[Roadnumber] = '5455022'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 0.620) where Light_Poles.[Roadnumber] = '5455022'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 0.620) where Potholes.[Road number] = '5455022'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 0.620) where Reference_Poles.[Roadnumber] = '5455022'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 0.620),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 0.620) where Sensor.[Road number] = '5455022'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 0.620) where Signs.[Roadnumber] = '5455022'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 0.620) where Traffic_Lights.[Roadnumber] = '5455022'

Vend strækning 5454985

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 0.410),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 0.410) where Cracking.[Road number] = '5454985'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 0.410),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 0.410) where Guard_Rails.[Roadnumber] = '5454985'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 0.410) where Light_Poles.[Roadnumber] = '5454985'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 0.410) where Potholes.[Road number] = '5454985'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 0.410) where Reference_Poles.[Roadnumber] = '5454985'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 0.410),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 0.410) where Sensor.[Road number] = '5454985'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 0.410) where Signs.[Roadnumber] = '5454985'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 0.410) where Traffic_Lights.[Roadnumber] = '5454985'

Vend strækning 5292790

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 0.550),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 0.550) where Cracking.[Road number] = '5292790'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 0.550),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 0.550) where Guard_Rails.[Roadnumber] = '5292790'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 0.550) where Light_Poles.[Roadnumber] = '5292790'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 0.550) where Potholes.[Road number] = '5292790'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 0.550) where Reference_Poles.[Roadnumber] = '5292790'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 0.550),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 0.550) where Sensor.[Road number] = '5292790'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 0.550) where Signs.[Roadnumber] = '5292790'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 0.550) where Traffic_Lights.[Roadnumber] = '5292790'

Vend strækning 5455782

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 3.023),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 3.023) where Cracking.[Road number] = '5455782'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 3.023),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 3.023) where Guard_Rails.[Roadnumber] = '5455782'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 3.023) where Light_Poles.[Roadnumber] = '5455782'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 3.023) where Potholes.[Road number] = '5455782'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 3.023) where Reference_Poles.[Roadnumber] = '5455782'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 3.023),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 3.023) where Sensor.[Road number] = '5455782'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 3.023) where Signs.[Roadnumber] = '5455782'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 3.023) where Traffic_Lights.[Roadnumber] = '5455782'

Vend strækning 5451590

update Cracking set Cracking.[From Reference Point] = ABS(Cracking.[From Reference Point] - 1.570),Cracking.[To Reference Point] = ABS(Cracking.[To Reference Point] - 1.570) where Cracking.[Road number] = '5451590'

update Guard_Rails set Guard_Rails.[FromReferencePoint] = ABS(Guard_Rails.[FromReferencePoint] - 1.570),Guard_Rails.[ToReferencePoint] = ABS(Guard_Rails.[ToReferencePoint] - 1.570) where Guard_Rails.[Roadnumber] = '5451590'

update Light_Poles set Light_Poles.[ReferencePoint] = ABS(Light_Poles.[ReferencePoint] - 1.570) where Light_Poles.[Roadnumber] = '5451590'

update Potholes set Potholes.[Reference Point] = ABS(Potholes.[Reference Point] - 1.570) where Potholes.[Road number] = '5451590'

update Reference_Poles set Reference_Poles.[ReferencePoint] = ABS(Reference_Poles.[ReferencePoint] - 1.570) where Reference_Poles.[Roadnumber] = '5451590'

update Sensor set Sensor.[From Reference Point] = ABS(Sensor.[From Reference Point] - 1.570),Sensor.[To Reference Point] = ABS(Sensor.[To Reference Point] - 1.570) where Sensor.[Road number] = '5451590'

update Signs set Signs.[ReferencePoint] = ABS(Signs.[ReferencePoint] - 1.570) where Signs.[Roadnumber] = '5451590'

update Traffic_Lights set Traffic_Lights.[ReferencePoint] = ABS(Traffic_Lights.[ReferencePoint] - 1.570) where Traffic_Lights.[Roadnumber] = '5451590'