back to first page [..][[BR]] 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 === [[Color(,#3849ce,gid)]]: id (corresponds to line number)[[BR]] [[Color(,#3849ce,wso1_id)]]: id of the primary catchment drained by the river segment.[[BR]] [[Color(,#3849ce,wso_id)]]: id of the Sea-outlet to which the river segment belongs.[[BR]] [[Color(,#3849ce,rvr_id)]]: reference of the name of the river to which the segment belongs (often 0)[[BR]] [[Color(,#3849ce,fromnode)]]: upstream node [[BR]] [[Color(,#3849ce,tonode)]]: downstream node[[BR]] [[Color(,#3849ce,strahler)]]: the stream order hierarchy, the sizes range from a first order stream to the largest a 11th order stream[[BR]] [[Color(,#3849ce,pfafstette)]]: Pfafstetter code (?) of the river segment and its primary catchment[[BR]] [[Color(,#3849ce,nextdownid)]]: next segment identifyer downstream points to wso_id[[BR]] [[Color(,#3849ce,longpath)]]: identifies wether the river segment is part of the longest flow path in the River Basin (sea-outlet), Y(es) or NULL[[BR]] [[Color(,#3849ce,maindrain_)]]: ?[[BR]] [[Color(,#3849ce,maindrain1)]]: ?[[BR]] [[Color(,#3849ce,length)]]: length of a river segment in meters[[BR]] [[Color(,#3849ce,cum_len)]]: cumulated length of the upstream flow network, including the river segment itself (longest route ?)-in meters[[BR]] [[Color(,#3849ce,pixels_100)]]: area directly drained by the river segment (area of the primary catchment), in 100m*100m grid-cells[[BR]] [[Color(,#3849ce,catchment_)]]: ?[[BR]] [[Color(,#3849ce,cont_pixel)]]: area upstream of the From Node drained by the river segment in 100m*100m grid-cells[[BR]] [[Color(,#3849ce,drain_km2)]]: full area drained by the river segment and upstream area - in square kilometres[[BR]] [[Color(,#3849ce,alt_gradie)]]: relief Energy of the river segment : ((Elevation at From Node-Elevation at !ToNode)/Segment Length)*100 in per cent[[BR]] [[Color(,#3849ce,burned)]]: percentage grid-cells of the river segment having a high confidence level with respect to its geographical position[[BR]] [[Color(,#3849ce,confidence)]]: percentage of grid-cells of the river segment having a high confidence level with respect to its geographical position[[BR]] [[Color(,#3849ce,window)]]: here 2003[[BR]] [[Color(,#3849ce,shape_leng)]]: segment length in metres[[BR]] [[Color(,#3849ce,the_geom)]]: the_geom [[BR]] === table rivernodes === [[Color(,#3849ce,gid)]]: id (corresponds to line number ?)[[BR]] [[Color(,#3849ce,id)]]: id of the river Basin (Seaoutlet) to which the catchment belongs [[BR]] [[Color(,#3849ce,wso_id)]]: Id of the river basin (sea outlet) to which the river node belongs [[BR]] [[Color(,#3849ce,source)]]: Type of source Y = River source, N =No not river source, M = river mouth[[BR]] [[Color(,#3849ce,len_tom)]]: Length from the node to the river mouth in meter[[BR]] [[Color(,#3849ce,num_seg)]]: Number of segments to reach the river mouth from the node [[BR]] [[Color(,#3849ce,elev)]]: Elevation at node in meter[[BR]] [[Color(,#3849ce,x_laea)]]: x re-projected to LAEA at a 1 kilometer resolution (I assume)[[BR]] [[Color(,#3849ce,y_laea)]]: ordinate re-projected to LAEA at a 1 kilometer resolution (I assume)[[BR]] [[Color(,#3849ce,"window")]]: here 2003[[BR]] === table catchments === [[Image(source:data/Docs/trac/CCM_drainage_bassins.jpg,300px)]] Two tables : Catchment_E and Catchment_W (with the version of Laurent, now just one catchment) [[Color(,#3849ce,"objectid")]]: [[BR]] [[Color(,#3849ce,"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 [[BR]] [[Color(,#3849ce,"wso_id")]]: River Bassin (sea-outlet) ID to which the catchment belongs [[BR]] [[Color(,#3849ce,"strahler")]]: strahler order of the river segment draining the catchment. If no river segment exist in the catchment, Strahler order 0 (zero) is assigned [[BR]] [[Color(,#3849ce,"feature_co")]]: [[BR]] [[Color(,#3849ce,"nextdownid")]]: [[BR]] [[Color(,#3849ce,"y_centroid")]]: [[BR]] [[Color(,#3849ce,"x_centroid")]]: [[BR]] [[Color(,#3849ce,"x_inside_L")]]: [[BR]] [[Color(,#3849ce,"Y_inside_L")]]: [[BR]] [[Color(,#3849ce,"xmax_laea")]]: [[BR]] [[Color(,#3849ce,"ymax_laea")]]: [[BR]] [[Color(,#3849ce,"area")]]: [[BR]] [[Color(,#3849ce,"area_km2")]]: area of the primary catchment in km²[[BR]] [[Color(,#3849ce,"perimeter")]]: [[BR]] [[Color(,#3849ce,"elev_min")]]: minimum elevation in the primary catchment [[BR]] [[Color(,#3849ce,"elev_max")]]: maximum elevation in the primary catchment [[BR]] [[Color(,#3849ce,"elev_mean")]]: average elevation in the primary catchment [[BR]] [[Color(,#3849ce,"elev_std")]]: standard deviation of the elevation in the primary catchment [[BR]] [[Color(,#3849ce,"slope_min")]]: minimum slope in the primary catchment [[BR]] [[Color(,#3849ce,"slope_max")]]: maximum slope in the primary catchment [[BR]] [[Color(,#3849ce,"slope_mean")]]: average slope in the primary catchment, in percent [[BR]] [[Color(,#3849ce,"slope_std")]]: standard deviation of the slope in the primary catchment [[BR]] [[Color(,#3849ce,"rain_min")]]: minimum long-term average annual precipitation in the primary catchment, in millimeters[[BR]] [[Color(,#3849ce,"rain_max")]]: maximum long-term average annual precipitation in the primary catchment, in millimeters[[BR]] [[Color(,#3849ce,"rain_mean")]]: mean long-term average annual precipitation in the primary catchment, in millimeters[[BR]] [[Color(,#3849ce,"rain_std")]]: standard deviation of the long-term average annual precipitation in the primary catchment, in millimeters[[BR]] [[Color(,#3849ce,"temp_min")]]: minimum long-term average annual temperature in the primary catchment, in degrees Celsius[[BR]] [[Color(,#3849ce,"temp_max")]]: maximum long-term average annual temperature in the primary catchment, in degrees Celsius[[BR]] [[Color(,#3849ce,"temp_mean")]]: mean long-term average annual temperature in the primary catchment, in degrees Celsius[[BR]] [[Color(,#3849ce,"temp_std")]]: standard deviation of the long-term average annual temperature in the primary catchment, in degrees Celsius[[BR]] [[Color(,#3849ce,"window")]]: the ID of the data window to which the named river belongs[[BR]] [[Color(,#3849ce,"Shape_Leng")]]: [[BR]] [[Color(,#3849ce,"Shape_Area")]]: [[BR]] == Comparison BDCarthage (green) - CCM (red) from different views == [[Image(source:data/Docs/trac/Comparaison BDCarthage CCM Vue3.jpg,600px)]] [[Image(source:data/Docs/trac/Comparaison BDCarthage CCM Vue 2.jpg,600px)]] == Comparison WFD art3 (red) - WFD art5(gray) - CCM (large light blue) from different rivers and lakes in Ireland == [[Image(source:data/Docs/trac/IEWE.jpg,600px)]] == Comparision of riversegments length CCM #32 == == Layers necessary for France == - Europe - France[[BR]] [[Image(source:data/Docs/trac/Europe-France Longueur des tronçons CCM.jpeg,450px)]][[BR]] - Loire Bretagne - Bretagne[[BR]] [[Image(source:data/Docs/trac/Loire Bretagne Longueur des tronçons CCM.jpeg,450px)]][[BR]] - Bassins français[[BR]] [[Image(source:data/Docs/trac/Longueur des tronçons CCM par bassin.jpeg,450px)]] More details on how to explore the ccm (get the upstream segments...) here ["CCM2 download and load"][[BR]]