| Line 96... |
Line 96... |
| 96 |
private function creerVueTapir() {
|
96 |
private function creerVueTapir() {
|
| 97 |
$requete = "DROP VIEW IF EXISTS 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_01` b, ifn_flore f, ifn_ecologie e, ifn_placettes_foret fo".
|
| 102 |
" WHERE f.idp = e.idp".
|
102 |
" WHERE f.idp = e.idp".
|
| 103 |
" AND e.idp = fo.idp".
|
103 |
" AND e.idp = fo.idp".
|
| 104 |
" AND b.cd_ref = f.cd_ref";
|
104 |
" AND b.cd_nom = f.cd_ref";
|
| 105 |
$this->getBdd()->requeter($requete);
|
105 |
$this->getBdd()->requeter($requete);
|
| 106 |
}
|
106 |
}
|
| Line 107... |
Line 107... |
| 107 |
|
107 |
|
| 108 |
private function ajouterTupleEfloreOntologies(){ // pour la légende
|
108 |
private function ajouterTupleEfloreOntologies(){ // pour la légende
|