| /trunk/services/modules/0.1/sources/FloradataFormateur.php |
|---|
| 75,7 → 75,8 |
| $requete = |
| "SELECT nom_sel AS taxon, ce_zone_geo, zone_geo, station, 'floradata' AS source, ". |
| "IF({$condition}, wgs84_latitude, latitude) AS latitude, IF({$condition}, wgs84_longitude, longitude) ". |
| "AS longitude, IF({$condition}, 'COMMUNE', 'STATION') AS type_site ". |
| "AS longitude, IF({$condition}, 'commune', 'station') AS type_site, ". |
| "CONCAT(prenom_utilisateur, ' ', nom_utilisateur) AS auteur ". |
| "FROM cel_obs LEFT JOIN cel_zones_geo cz ON ce_zone_geo=id_zone_geo ". |
| "WHERE transmission=1 ". |
| $this->construireWhereCoordonneesBbox().' '. |
| /trunk/services/modules/0.1/sources/MoissonnageFormateur.php |
|---|
| 65,8 → 65,9 |
| final protected function construireRequeteWfs() { |
| $requete = |
| "SELECT nom_scientifique_complet AS taxon, lieu_station_nom AS nom, lieu_station_latitude AS latitude, ". |
| "lieu_station_longitude AS longitude, 'STATION' AS type_site, lieu_commune_code_insee AS code_insee, ". |
| "'{$this->nomSource}' AS source FROM {$this->nomSource}_tapir WHERE 1 ". |
| "lieu_station_longitude AS longitude, 'station' AS type_site, lieu_commune_code_insee AS code_insee, ". |
| "'{$this->nomSource}' AS source, observateur_nom_complet AS auteur ". |
| "FROM {$this->nomSource}_tapir WHERE 1 ". |
| $this->construireWhereCoordonneesBbox().' '. |
| $this->construireWhereNomScientifique().' '. |
| "ORDER BY lieu_station_longitude, lieu_station_latitude"; |