Skip to content
Cédric Briand edited this page Mar 9, 2017 · 22 revisions

Tables and maps

Four tables can be rendered as map, as part of their postgis geometry structure. The first is the 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). map of countries sorted by order as used by wgeel

The second and third are the tables for the emus. 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 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.

The tr_emusplit_ems showing divisions (in Red) in some of the emus

Data structure

physical diagram v1.0

Clone this wiki locally