back to first page ..
back to Gis Structures

Describing the CCM layers

​http://ccm.jrc.ec.europa.eu/php/index.php?action=view&id=23

To download and load the data into postgreSQL you must follow CCM2 download and load

table riversegments

gid: id (corresponds to line number)
wso1_id: id of the primary catchment drained by the river segment.
wso_id: id of the Sea-outlet to which the river segment belongs.
rvr_id: reference of the name of the river to which the segment belongs (often 0)
fromnode: upstream node
tonode: downstream node
strahler: the stream order hierarchy, the sizes range from a first order stream to the largest a 11th order stream
pfafstette: Pfafstetter code (?) of the river segment and its primary catchment
nextdownid: next segment identifyer downstream points to wso_id
longpath: identifies wether the river segment is part of the longest flow path in the River Basin (sea-outlet), Y(es) or NULL
maindrain_: ?
maindrain1: ?
length: length of a river segment in meters
cum_len: cumulated length of the upstream flow network, including the river segment itself (longest route ?)-in meters
pixels_100: area directly drained by the river segment (area of the primary catchment), in 100m*100m grid-cells
catchment_: ?
cont_pixel: area upstream of the From Node drained by the river segment in 100m*100m grid-cells
drain_km2: full area drained by the river segment and upstream area - in square kilometres
alt_gradie: relief Energy of the river segment : ((Elevation at From Node-Elevation at ToNode)/Segment Length)*100 in per cent
burned: percentage grid-cells of the river segment having a high confidence level with respect to its geographical position
confidence: percentage of grid-cells of the river segment having a high confidence level with respect to its geographical position
window: here 2003
shape_leng: segment length in metres
the_geom: the_geom

table rivernodes

gid: id (corresponds to line number ?)
id: id of the river Basin (Seaoutlet) to which the catchment belongs
wso_id: Id of the river basin (sea outlet) to which the river node belongs
source: Type of source Y = River source, N =No not river source, M = river mouth
len_tom: Length from the node to the river mouth in meter
num_seg: Number of segments to reach the river mouth from the node
elev: Elevation at node in meter
x_laea: x re-projected to LAEA at a 1 kilometer resolution (I assume)
y_laea: ordinate re-projected to LAEA at a 1 kilometer resolution (I assume)
window: here 2003

table seaoutlets

sea_cd: 1 (North Atlantic Sea, Caspian Sea), 2 (Mediterranean West, Persian Gulf), 4 (Celtic Sea Channel, Mediterranean East), 5 (Black Sea), 6 (Baltic Sea), 7 (Barents Sea East), 8 (Barents Sea West), 9 (White Sea)
system_cd: A,C,H,I,J,M,N,Q,S,T,V,Z

table catchments

Two tables : Catchment_E and Catchment_W (with the version of Laurent, now just one catchment)

objectid:
wso1_id, wso2_id...wso11_id: id of the Primary catchment (wso1-id) and of all higher order catchment to which the primary catchement belongs. wso1_id=-9999 : inclusions due to a lake, wso1_id=0 : inclusion due to the Sea
wso_id: River Bassin (sea-outlet) ID to which the catchment belongs
strahler: strahler order of the river segment draining the catchment. If no river segment exist in the catchment, Strahler order 0 (zero) is assigned
feature_co:
nextdownid:
y_centroid:
x_centroid:
x_inside_L:
Y_inside_L:
xmax_laea:
ymax_laea:
area:
area_km2: area of the primary catchment in km²
perimeter:
elev_min: minimum elevation in the primary catchment
elev_max: maximum elevation in the primary catchment
elev_mean: average elevation in the primary catchment
elev_std: standard deviation of the elevation in the primary catchment
slope_min: minimum slope in the primary catchment
slope_max: maximum slope in the primary catchment
slope_mean: average slope in the primary catchment, in percent
slope_std: standard deviation of the slope in the primary catchment
rain_min: minimum long-term average annual precipitation in the primary catchment, in millimeters
rain_max: maximum long-term average annual precipitation in the primary catchment, in millimeters
rain_mean: mean long-term average annual precipitation in the primary catchment, in millimeters
rain_std: standard deviation of the long-term average annual precipitation in the primary catchment, in millimeters
temp_min: minimum long-term average annual temperature in the primary catchment, in degrees Celsius
temp_max: maximum long-term average annual temperature in the primary catchment, in degrees Celsius
temp_mean: mean long-term average annual temperature in the primary catchment, in degrees Celsius
temp_std: standard deviation of the long-term average annual temperature in the primary catchment, in degrees Celsius
window: the ID of the data window to which the named river belongs
Shape_Leng:
Shape_Area:

Comparison BDCarthage (green) - CCM (red) from different views

Comparison WFD art3 (red) - WFD art5(gray) - CCM (large light blue) from different rivers and lakes in Ireland

Comparision of riversegments length CCM #32

Layers necessary for France

• Europe - France
  

• Loire Bretagne - Bretagne
  

• Bassins français
  

More details on how to explore the ccm (get the upstream segments...) here CCM2 download and load

Some links
​http://ccm.jrc.ec.europa.eu/php/index.php?action=view&id=23
​http://edo.jrc.ec.europa.eu/php/index.php?action=view&id=42

De Jager, A.L., Vogt, J.V. (2010). Development and demonstration of a structured hydrological feature coding system for Europe , Hydrological Sciences Journal, 55, 5, 661, Taylor and Francis
​http://www.informaworld.com/smpp/section?content=a923839709&fulltext=713240928

Vogt, J.V. et al. (2007). A pan-European River and Catchment Database. EC-JRC (Report EUR 22920 EN) Luxembourg, 120 p.
​http://ccm.jrc.ec.europa.eu/documents/CCM2-Report_EUR-22920-EN_2007_STD.pdf[[BR]]

Vogt, J.V. et al. (2007). Developing a pan-European Data Base of Drainage Networks and Catchment Boundaries from a 100 Metre DEM. Proceedings AGILE International Conference, May 2007.
​http://ccm.jrc.ec.europa.eu/documents/JVogt_etal_AGILE2007.pdf

Vogt, J.V., E. Rimaviciute, A de Jager (2008). CCM 2.1 Release Notes.
​http://ccm.jrc.ec.europa.eu/documents/JVogt_etal_CCM21.pdf