* The idea __here__ is to have some variables describing the variation in ''' recruitment '''

{{{
#!html
<h3 style="color: #00FF00">The regional seas</h3>
}}} 

 * 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]]
 [[Image(source:data/Docs/trac/CCM21/seaoutlets_sea_cd.jpg)]] [[BR]]
This will create a new column in ccm21.seoutlets
{{{
#!sql
ALTER TABLE ccm21.seaoutlets ADD COLUMN area_cd character varying(3);
UPDATE ccm21.seaoutlets set area_cd= system_cd||sea_cd;
}}}
Now that sounds much better :[[BR]]
[[Image(source:data/Docs/trac/CCM21/seaoutlets_area_cd.jpg)]]
 * For France A4=Channel
 * A1 = Atlantic (but be aware it is also Ireland north) and Iceland
 * M2 = Mediterranean
 * M4 = Adriatic Sea
 * A5 = North Sea

Some area_cd are not determinate (in red)[[BR]]
[[Image(source:data/Docs/trac/CCM21/Seaoutlets_area_cd_null.jpg,600px)]] 

{{{
#!html
<h3 style="color: #00FF00">Latidunal distance to the maximum density area</h3>
}}} 
The largest densities are found in the vendée région (source wgeel 2009) [[BR]]
[[Image(source:data/Docs/trac/cpue_glass_eel.jpg)]] [[BR]]
[[Image(source:data/Docs/trac/ctot_glass_eel.jpg)]] [[BR]]
{{{
#!sql
-- distance Y à l'embouchure de la sèvre Niortaise
SELECT ST_Y(the_geom) from ccm21.rivernodes where gid=267104 --2641850
SELECT ST_Y(the_geom)- 2641850 AS difflat from ccm21.rivernodes where len_tom=0
}}}
{{{
#!html
<h3 style="color: #00FF00">Tidal Range</h3>
}}} 

["Tidal range"]