= CCM2 download and load =

== Download on ccm on the web site ==
You can download the CCM2 Data at :  http://ccm.jrc.ec.europa.eu/php/index.php?action=view&id=24 [[BR]]
If you don't have a login and a password create it.[[BR]]
And select the data you want to add. Use the projection system : ETRS 1989 LAEA[[BR]]

== Change the format with !ArcGis ==

In !ArcCatalog, open the data (for example CCM21_LAEA_RiverBasins\ccm21\LAEA_RiverBasins.gdb) and clic rigth on LAEA_RiverBasins.gdb > Export > To Shapefile (multiple)[[BR]]
and choose the "Output Folder" where the data will be stored.[[BR]]

Unzip the folder.

== Append the different shape files ==
We have obtained shapefiles from different sources, folder (http://ccm.jrc.ec.europa.eu/images/CCM2_Windows2b.JPG), and it's easier to combine them into one single shapefile for ease of analysis and mapping.[[BR]]
This process is known as "merging" within ArcGIS.[[BR]]

 * Tables: Rivernodes - Riversegments- Catchments
||Layer|| Region||Rivernodes[[BR]] Nb of records||Riversegments[[BR]] Nb of records||Catchments[[BR]] Nb of records||
||2000||North||64308||63298||65395||
||2001||Western Islands||34507||32408||36613||
||2002||South||121630||119096||123104||
||2003||West||117455||116764||118265||
||2004||South West||96378||95424||96826||
||2005||Danube||141112||140998||141216||
||2006||Dnjepr||64439||64016||64668||
||2007||Balticum||140998||138443||162488||
||2008||Scandinavia||86671||82433||96189||
||2009||South East||108279||104696||110005||
||2010||Macronesia||1722||1314||1771||
||2011||Caucasus||50320||49534||50461||
||2012||Ural||33198||32850||33470||
||2013||Volga||250212||250183||250291||
||2015||Azores||94||49||118||
||2016||Northern Islands||108||58||371||
||2017||Tigris||54734||54730||54731||
||2018||Iceland||3476||2998||3662||
||After "Merge"[[BR]] Number of record expected[[BR]]Total||[[BR]][[BR]]EUROPE||[[BR]][[BR]]1369641 (ok)||[[BR]][[BR]]1349292 (ok)||[[BR]][[BR]]1409644 (ok)||

The Merge tool can be found within Data Management Tools > General > Merge. Double-clicking on the tool opens up its dialog box.[[BR]]
The input datasets are those shapefiles which you wish to merge together. Select the different shapefiles as you wish as long as they are all of the same data type. 
Add Rivernodes in : CCM21_LAEA_window2000\ccm21\LAEA_W2000.gdb\RIVERNODES  (from CCM21_LAEA_window2000  to CCM21_LAEA_window2018)

And specify a location and name for the output file which will be created : CCM2\RIVERNODES_Merge.[[BR]]

You must do the same thing with "Rivernodes", "Riversegments", "Catchments".[[BR]]



== Add data into Postgres ==


See ["CookBook shptopostgres"] the same procedure was applied to obtain
{{{
}}}
Which can be downloaded at source:trunk/EDACCM/ccm21_build.bat [[BR]] open this file with notepad++ and copy / paste to the command batch