• The idea here is to have some variables describing the variation in recruitment

The regional seas

• 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
  
  

This will create a new column in ccm21.seoutlets

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 :

• For France A4=Channel
• A1 = Atlantique (but be aware it is also Ireland north) and Iceland
• M2 mediterranean
• M4 =adriatic sea

  Latidunal distance to the maximum density area

The largest densities are found in the vendée région (source wgeel 2009)

-- 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

Tidal Range

Tidal range