| 90,9 → 90,9 |
|---|
| $colonnes = $this->bdd->recupererTous($requete_colonnes); |
| foreach ($colonnes as $colonne) { |
| echo "Suppression des vides dans la colonne ".$colonne['column_name']." ..."; |
| $dsl = array( 'nom_sel_nn', 'nom_ret_nn', 'nt'); |
| $dsl = array( 'transmission', 'altitude'); |
| if (isset($dsl[$colonne['column_name']])) { |
| $requete = "UPDATE cel_obs SET ".$colonne['column_name']." = NULL WHERE ".$colonne['column_name']."= '' OR ".$colonne['column_name']." = 0"; |
| $requete = "UPDATE cel_obs SET ".$colonne['column_name']." = NULL WHERE ".$colonne['column_name']."= ''"; |
| } else { |
| $requete = "UPDATE cel_obs SET ".$colonne['column_name']." = NULL WHERE ".$colonne['column_name']."= '' OR ".$colonne['column_name']." IN ('INSEE-C:', '0000-00-00 00:00:00', '0.00000')"; |
| } |
| 129,9 → 129,13 |
|---|
| $this->bdd->requeter($requete); |
| $requete = "UPDATE cel_obs SET nom_referentiel = NULL WHERE nom_sel_nn = '' or nom_sel_nn = '0'"; |
| $this->bdd->requeter($requete); |
| $requete = "UPDATE cel_obs SET nom_referentiel = 'APD' WHERE nom_referentiel like 'bdtao%'"; |
| $this->bdd->requeter($requete); |
| $requete = "UPDATE cel_obs SET nom_referentiel = 'BDTFX' WHERE nom_referentiel like 'bdnff%'"; |
| $this->bdd->requeter($requete); |
| echo "effectuée \n"; |
| } |
| $requete_verif = "SELECT nom_referentiel FROM cel_obs WHERE nom_referentiel NOT IN ('".implode("', '", $referentiels)."')"; |
| $requete_verif = "SELECT nom_referentiel FROM cel_obs WHERE nom_referentiel NOT IN ('".implode("', '", $referentiels)."', 'autre')"; |
| $verif = $this->bdd->recupererTous($requete_verif); |
| if ($verif != array()) print_r($verif); |
| } |
| 140,6 → 144,8 |
|---|
| echo "Uniformisation du geodatum"; |
| $requete = "UPDATE cel_obs SET geodatum = 'wgs84' WHERE (latitude IS NOT NULL or latitude != '0.00000') AND geodatum = ''"; |
| $this->bdd->requeter($requete); |
| $requete = "UPDATE cel_obs SET geodatum = NULL WHERE (latitude IS NULL or latitude == '0.00000')"; |
| $this->bdd->requeter($requete); |
| echo "effectuée \n"; |
| } |
| } |