wiki:CCM2 download and load

Version 22 (modified by cedric, 15 years ago) (diff)

--

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
If you don't have a login and a password create it.
And select the data you want to add. Use the projection system : ETRS 1989 LAEA

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)
and choose the "Output Folder" where the data will be stored.

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.
This process is known as "merging" within ArcGIS.

  • Tables: Rivernodes - Riversegments- Catchments
Layer RegionRivernodes
Nb of records
Riversegments
Nb of records
Catchments
Nb of records
2000North643086329865395
2001Western Islands345073240836613
2002South121630119096123104
2003West117455116764118265
2004South West963789542496826
2005Danube141112140998141216
2006Dnjepr644396401664668
2007Balticum140998138443162488
2008Scandinavia866718243396189
2009South East108279104696110005
2010Macronesia172213141771
2011Caucasus503204953450461
2012Ural331983285033470
2013Volga250212250183250291
2015Azores9449118
2016Northern Islands10858371
2017Tigris547345473054731
2018Iceland347629983662
After "Merge"
Number of record expected
Total


EUROPE


1369641 (ok)


1349292 (ok)


1409644 (ok)

The Merge tool can be found within Data Management Tools > General > Merge. Double-clicking on the tool opens up its dialog box.
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.

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)] open this file with notepad++ and copy / paste to the command batch