/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"; |