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'