Home
Six tables can be rendered as map, as part of their postgis geometry structure. (1) tr_countries_cou table. This table contains a column for country order which corresponds to the order which the wgeel follows to produce tables. It also contains the identification of the country as used by wgeel (ISO2-two letter names) and the ISO3 code (three letter names).
ref.tr_countries_cou
(2-3) Eel managment unit (EMU) tables. The tr_emu_emu table contains a table of all eel management units (EMUs) as extracted from the wise layer. One EMU can be part of two countries (e.g. IE_Norw) in which case two lines will be present in the emu table, one for each country. Another table the tr_emusplit_ems adds more detail, as some EMUs can flow in two differents seas, or belong to different RBDs. For instance the Atlantic and the Mediterranean. For EU countries for which a wise layer was available, those will correspond to different lines and different polygon geometries.
ref.tr_emu_emu
ref.tr_emusplit_ems
(4-5) ICES Areas (or FAO codes). The tr_faoareas was built using ICES division level, and the ref.tr_ices_ecoregions is also provided as it could provide a more suitable cut for wgeel.
ref.tr_ecoregion
ref.tr_faoarea
(6) The series. The table contains the location of sampling, indicated as points. They can be used to perform calculations such as closest area from ICES or distance to the Sargasso (shown on the figure, see view for code)
datawg.t_series_ser
The data corresponding to stock indicators, catch, aquaculture are stored in the datawg.t_eelstock_eel table. The data corresponding to data series, e.g. time series of recruitment or silver eel production are stored in the datawg.t_dataseries_dat table. The description of the series themselves (site, unit, type of effort...) are all stored in the datawg.t_series_ser table
Physical Diagram for the dbeel database