GPS conversie uitvoeren

-- latitude GPS

ALTER TABLE GPS DROP COLUMN gps_lat;

ALTER TABLE GPS ALTER COLUMN gps_latitude decimal(18,9);

ALTER TABLE GPS ADD gps_lat AS (gps_latitude  / 100);

-- longitude GPS

ALTER TABLE GPS DROP COLUMN gps_long;

ALTER TABLE GPS ALTER COLUMN gps_longitude decimal(18,9);

ALTER TABLE GPS ADD gps_long AS (gps_longitude  / 100);

-- latitude historie

ALTER TABLE GPSHIS DROP COLUMN gps_lat;

ALTER TABLE GPSHIS ALTER COLUMN gps_latitude decimal(18,9);

ALTER TABLE GPSHIS ADD gps_lat AS (gps_latitude  / 100);

-- longitude historie

ALTER TABLE GPSHIS DROP COLUMN gps_long;

ALTER TABLE GPSHIS ALTER COLUMN gps_longitude decimal(18,9);

ALTER TABLE GPSHIS ADD gps_long AS (gps_longitude  / 100);

-- latitude

ALTER TABLE GPSNL ALTER COLUMN gpl_latitude decimal(18,9);

-- longitude

ALTER TABLE GPSNL ALTER COLUMN gpl_longitude decimal(18,9);

-- latitude historie

ALTER TABLE GPSNLHIS ALTER COLUMN gph_latitude decimal(18,9);

-- longitude historie

ALTER TABLE GPSNLHIS ALTER COLUMN gph_longitude decimal(18,9);

-- latitude wagens

ALTER TABLE WAGENS ALTER COLUMN wag_latitude decimal(18,9);

-- longitude wagens

ALTER TABLE WAGENS ALTER COLUMN wag_longitude decimal(18,9);

-- latitude planning

ALTER TABLE PLANNING ALTER COLUMN pla_oph_latitude decimal(18,9);

ALTER TABLE PLANNING ALTER COLUMN pla_best_latitude decimal(18,9);

ALTER TABLE PLANNING ALTER COLUMN pla_tx_oph_latitude decimal(18,9);

ALTER TABLE PLANNING ALTER COLUMN pla_tx_best_latitude decimal(18,9);

ALTER TABLE PLANNING ALTER COLUMN pla_via_latitude decimal(18,9);

-- longitude planning

ALTER TABLE PLANNING ALTER COLUMN pla_oph_longitude decimal(18,9);

ALTER TABLE PLANNING ALTER COLUMN pla_best_longitude decimal(18,9);

ALTER TABLE PLANNING ALTER COLUMN pla_tx_oph_longitude decimal(18,9);

ALTER TABLE PLANNING ALTER COLUMN pla_tx_best_latitude decimal(18,9);

ALTER TABLE PLANNING ALTER COLUMN pla_via_longitude decimal(18,9);