select distinct d.*, a.*, 0 as DATA_RANG,to_char(d.DATA_DATEPDEB, 'DD/MM/YYYY') as DATA_DATE_PDEB,to_char(d.DATA_DATEPFIN, 'DD/MM/YYYY') as DATA_DATE_PFIN,to_char(d.DATA_DATEDEB, 'DD/MM/YYYY') as DATA_DATE_DEB,to_char(d.DATA_DATEFIN, 'DD/MM/YYYY') as DATA_DATE_FIN,to_char(d.DATA_DATEDEB, 'HH24:MI') as DATA_HEURE_DEB,to_char(d.DATA_DATEFIN, 'HH24:MI') as DATA_HEURE_FIN,to_char(d.DATA_DATEMAJ, 'DD/MM/YYYY') as DATA_DATE_MAJ,to_char(d.DATA_DATECREA, 'DD/MM/YYYY') as DATA_DATE_CREA,to_char(d.DATA_DATEPARUTION, 'DD/MM/YYYY') as DATA_DATE_PARUTION,'1.0' as VERSION_NUMERO from V_GEDIT_ACTU_DATA d inner join IEDIT_DATA_CLASSIFICATION dc on (d.DATA_ID = dc.DATA_ID and d.CAT_ID in ( SELECT dc2.CLASSIF_ID FROM IEDIT_DATA_CLASSIFICATION dc2 WHERE dc2.DATA_ID = d.DATA_ID LIMIT 1))  left join IEDIT_PJ pj on (d.DATA_ID = pj.DATA_ID)    inner join SIT_APPLI a on d.APPLI_ID=a.APPLI_ID where d.DATA_ID=52210 and ( d.DATA_VISUEL is NULL  or d.DATA_VISUEL = ''  or d.DATA_VISUEL in ( SELECT pj2.PJ_FILE FROM IEDIT_PJ pj2 WHERE d.DATA_ID = pj2.DATA_ID and pj2.PJ_CHAMP = 'data_visuel' LIMIT 1 ))    and d.USER_ID=2 and d.RIGHT_ID>0  and d.DATA_VALIDEPUB=1 and (d.DATA_DATEPDEB <= (now() - interval '-1 hour' + interval '-1 hour') or d.DATA_DATEPDEB is null) and (d.DATA_DATEPFIN >= (now() - interval '-1 hour' + interval '-1 hour') or d.DATA_DATEPFIN is null) order by DATA_NEW desc, DATA_DATEPARUTION desc, DATA_DATEPDEB desc, DATA_DATEPFIN desc, DATA_TITRE_FR, DATA_DATEDEB, DATA_DATEFIN, DATA_DATEMAJ desc, CAT_INTITULE_FR

La Loire, de la Maine à la mer
Observations et suivis environnementaux

755m3/s

Débit de la Loire à Montjean s/L

85

Coefficient de marée

Webcam : l'estuaire en direct

1. Accueil
2. Suivis environnementaux
3. Cahier indicateurs

Cahier indicateurs / L2.C - LES PEUPLEMENTS

L2.C3 - Passage de poissons migrateurs : les Saumons (MAJ 2014)

Passage de poissons migrateurs : les Saumons

A télécharger :

• L2C3_2014.pdf

< Retourner à la liste

select distinct d.*, a.*, 0 as DATA_RANG,to_char(d.DATA_DATEPDEB, 'DD/MM/YYYY') as DATA_DATE_PDEB,to_char(d.DATA_DATEPFIN, 'DD/MM/YYYY') as DATA_DATE_PFIN,to_char(d.DATA_DATEDEB, 'DD/MM/YYYY') as DATA_DATE_DEB,to_char(d.DATA_DATEFIN, 'DD/MM/YYYY') as DATA_DATE_FIN,to_char(d.DATA_DATEDEB, 'HH24:MI') as DATA_HEURE_DEB,to_char(d.DATA_DATEFIN, 'HH24:MI') as DATA_HEURE_FIN,to_char(d.DATA_DATEMAJ, 'DD/MM/YYYY') as DATA_DATE_MAJ,to_char(d.DATA_DATECREA, 'DD/MM/YYYY') as DATA_DATE_CREA,to_char(d.DATA_DATEPARUTION, 'DD/MM/YYYY') as DATA_DATE_PARUTION,'1.0' as VERSION_NUMERO from V_GEDIT_ACTU_DATA d   inner join SIT_APPLI a on d.APPLI_ID=a.APPLI_ID where d.APPLI_ID=27   and d.USER_ID=2 and d.RIGHT_ID>0  and d.DATA_VALIDEPUB=1 order by d.DATA_RANG, DATA_DATEPDEB desc, DATA_DATEPFIN desc, DATA_TITRE_FR