select
  oa.observationfk,
  y.x->'label' "label",
  y.x->'value' "value"
from observations_abondances oa ,
lateral (select json_array_elements(oa.environnement_sauvages::json) x) y
