CCM – EDA

Context Navigation

Version 46 (modified by celine, 15 years ago) (diff)
--

back to first page ..
back to Gis Structures

Describing the CCM layers

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

source:data/Docs/trac/CCM21/seaoutlets_sea_cd_europe.png

source:data/Docs/trac/CCM21/seaoutlets_system_cd.png

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: