UPDATE cel_obs co
INNER JOIN cel_obs_etendues coe 
  ON coe.id_observation = co.id_observation
  AND cle = 'latitudeDebutRue'
SET co.latitude = coe.valeur;

UPDATE cel_obs co
INNER JOIN cel_obs_etendues coe 
  ON coe.id_observation = co.id_observation
  AND cle = 'longitudeDebutRue'
SET co.longitude = coe.valeur;
