| Line 92... |
Line 92... |
| 92 |
$this->remplirChpCoordonnees($table, $placette);
|
92 |
$this->remplirChpCoordonnees($table, $placette);
|
| 93 |
}
|
93 |
}
|
| 94 |
}
|
94 |
}
|
| Line 95... |
Line 95... |
| 95 |
|
95 |
|
| 96 |
private function creerVueTapir() {
|
96 |
private function creerVueTapir() {
|
| 97 |
$requete = "DROP VIEW ifn_tapir; CREATE VIEW ifn_tapir AS ".
|
97 |
$requete = "DROP VIEW IF EXISTS ifn_tapir; CREATE VIEW ifn_tapir AS ".
|
| 98 |
"SELECT f.idp as observation_id, b.nom_sci as nom_scientifique_complet, b.num_nom, ".
|
98 |
"SELECT f.idp as observation_id, b.nom_sci as nom_scientifique_complet, b.num_nom, ".
|
| 99 |
" fo.lieu_commune_code_insee, fo.lieu_station_latitude, fo.lieu_station_longitude,".
|
99 |
" fo.lieu_commune_code_insee, fo.lieu_station_latitude, fo.lieu_station_longitude,".
|
| 100 |
" 'WGS84' AS geodeticDatum, e.dateeco as observation_date, '' AS observateur_nom_complet".
|
100 |
" 'WGS84' AS geodeticDatum, e.dateeco as observation_date, '' AS observateur_nom_complet".
|
| 101 |
" FROM `bdtfx_v2_02` b, ifn_flore f, ifn_ecologie e, ifn_placettes_foret fo".
|
101 |
" FROM `bdtfx_v2_02` b, ifn_flore f, ifn_ecologie e, ifn_placettes_foret fo".
|