select 
  ds.structurepk,
  ds."type" as type_etablissement,
  ds.no_uai,
  ds."name" as nom_etablissement,
  ds.address1 as adress,
  ds.zipcode,
  ds.city,
  da."name" as academie,
  ds.longitude,
  ds.latitude,
  dp.nom_courant as protocole,
  o.observationpk,
  o."date"
from observations o 
left join zones_changes zc on zc.zonechangepk  = o.zonechangefk 
left join dico_protocoles dp on o.protocolefk = dp.protocolepk 
left join zones z on z.zonepk = zc.zonefk 
left join dico_structures ds on z.structurefk = ds.structurepk
left join dico_academies da on ds.academiefk = da.academiepk 