| 18 | | |
| 19 | | {{{ |
| 20 | | #!html |
| 21 | | <h1 style="color: green">Some variables related to recruitment</h1> |
| 22 | | }}} |
| 23 | | {{{ |
| 24 | | #!html <h2 style="color: #04B404">variables coming from the ccm21.catchments</h2> |
| 25 | | }}} |
| 26 | | * strahler |
| 27 | | * area_km2 |
| 28 | | * elev_mean |
| 29 | | * slope_mean |
| 30 | | * rain_mean |
| 31 | | * temp_mean |
| 32 | | |
| 33 | | {{{ |
| 34 | | #!html |
| 35 | | <h2 style="color: #04B404">Variables coming from another calculation</h2> |
| 36 | | }}} |
| 37 | | |
| 38 | | * The idea __here__ is to have some variables describing the variation in ''' recruitment ''' |
| 39 | | |
| 40 | | {{{ |
| 41 | | #!html |
| 42 | | <h3 style="color: #00FF00">The regional seas</h3> |
| 43 | | }}} |
| 44 | | |
| 45 | | * 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]] |
| 46 | | [[Image(source:data/Docs/trac/CCM21/seaoutlets_sea_cd.jpg)]] [[BR]] |
| 47 | | This will create a new column in ccm21.seoutlets |
| 48 | | {{{ |
| 49 | | #!sql |
| 50 | | ALTER TABLE ccm21.seaoutlets ADD COLUMN area_cd character varying(3); |
| 51 | | UPDATE ccm21.seaoutlets set area_cd= system_cd||sea_cd; |
| 52 | | }}} |
| 53 | | Now that sounds much better :[[BR]] |
| 54 | | [[Image(source:data/Docs/trac/CCM21/seaoutlets_area_cd.jpg)]] |
| 55 | | {{{ |
| 56 | | #!html |
| 57 | | <h3 style="color: #00FF00">Latidunal distance to the maximum density area</h3> |
| 58 | | }}} |
| 59 | | The largest densities are found in the vendée région (source wgeel 2009) [[BR]] |
| 60 | | [[Image(source:data/Docs/trac/cpue_glass_eel.jpg)]] [[BR]] |
| 61 | | [[Image(source:data/Docs/trac/ctot_glass_eel.jpg)]] [[BR]] |
