| | 1 | * The idea __here__ is to have some variables describing the variation in ''' recruitment ''' |
| | 2 | |
| | 3 | {{{ |
| | 4 | #!html |
| | 5 | <h3 style="color: #00FF00">The regional seas</h3> |
| | 6 | }}} |
| | 7 | |
| | 8 | * The sea_cd => this one is obvious, and will describe varying recruitments into the Baltic, the Mediterranean, North sea, unfortunately sea_cd is repeated and probably needs grouping with other variable [[BR]] |
| | 9 | [[Image(source:data/Docs/trac/CCM21/seaoutlets_sea_cd.jpg)]] [[BR]] |
| | 10 | This will create a new column in ccm21.seoutlets |
| | 11 | {{{ |
| | 12 | #!sql |
| | 13 | ALTER TABLE ccm21.seaoutlets ADD COLUMN area_cd character varying(3); |
| | 14 | UPDATE ccm21.seaoutlets set area_cd= system_cd||sea_cd; |
| | 15 | }}} |
| | 16 | Now that sounds much better :[[BR]] |
| | 17 | [[Image(source:data/Docs/trac/CCM21/seaoutlets_area_cd.jpg)]] |
| | 18 | {{{ |
| | 19 | #!html |
| | 20 | <h3 style="color: #00FF00">Latidunal distance to the maximum density area</h3> |
| | 21 | }}} |
| | 22 | The largest densities are found in the vendée région (source wgeel 2009) [[BR]] |
| | 23 | [[Image(source:data/Docs/trac/cpue_glass_eel.jpg)]] [[BR]] |
| | 24 | [[Image(source:data/Docs/trac/ctot_glass_eel.jpg)]] [[BR]] |
| | 25 | |
| | 26 | ["Tidal range"] |
